set mem_limit=10gb; SELECT *
FROM   (SELECT *, Rank()
                 OVER(
                   ORDER BY  l_orderkey) AS rank
        FROM   lineitem) a
WHERE  rank < 10;


    Query Timeline: 30m46s
       - Query submitted: 76.882us (76.882us)
       - Planning finished: 5s580ms (5s580ms)
       - Submit for admission: 5s580ms (118.125us)
       - Completed admission: 5s580ms (53.031us)
       - Ready to start on 1 backends: 5s580ms (87.704us)
       - All 1 execution backends (2 fragment instances) started: 5s581ms (786.867us)
       - Rows available: 10m47s (10m42s)
       - First row fetched: 10m48s (604.565ms)
       - Unregister query: 30m46s (19m58s)
 BlockMgr:
         - BlockWritesOutstanding: 0 (0)
         - BlocksCreated: 11.63K (11631)
         - BlocksRecycled: 14.67K (14673)
         - BufferedPins: 934 (934)
         - MaxBlockSize: 8.00 MB (8388608)
         - MemoryLimit: 8.00 GB (8589934592)
         - PeakMemoryUsage: 8.00 GB (8589934592)
         - ScratchBytesRead: 82.83 GB (88935454261)
         - ScratchBytesWritten: 82.83 GB (88935454261)
         - ScratchFileUsedBytes: 82.85 GB (88961191552)
         - ScratchReads: 10.61K (10611)
         - ScratchWrites: 10.61K (10611)
         - TotalBufferWaitTime: 5m52s
         - TotalEncryptionTime: 0.000ns
         - TotalReadBlockTime: 11m43sa

        SORT_NODE (id=1):(Total: 23m43s, non-child: 23m12s, % non-child: 97.84%)
          ExecOption: Codegen Enabled
           - NumRowsPerRun: (Avg: 30.00M (30000966) ; Min: 9.60M (9595091) ; Max: 31.86M (31856885) ; Number of samples: 12)
           - InMemorySortTime: 2m9s
           - InitialRunsCreated: 12 (12)
           - MergeGetNext: 13m1s
           - MergeGetNextBatch: 11m54s
           - PeakMemoryUsage: 7.98 GB (8573429767)
           - RowsReturned: 360.01M (360011594)
           - RowsReturnedRate: 252.88 K/sec
           - SortDataSize: 90.12 GB (96765718386)
           - SpilledRuns: 13 (13)
           - TotalMergesPerformed: 1 (1)