#	exclusive	inclusive	rows x	rows	loops	node
1.	21914.244	21914.244	↓ 2.9	2123655	1	→ CTE Scan on numbered (cost=450693.32..500342.07 rows=735537 width=52) (actual time=17803.640..21914.244 rows=2123655 loops=1) Filter: (rowno <= 5) Rows Removed by Filter: 82956
2.						CTE numbered
3.	1106.950	20773.791	↑ 1.0	2206611	1	→ WindowAgg (cost=406561.10..450693.32 rows=2206611 width=24) (actual time=17803.629..20773.791 rows=2206611 loops=1)
4.	19458.108	19666.841	↑ 1.0	2206611	1	→ Sort (cost=406561.10..412077.63 rows=2206611 width=24) (actual time=17803.613..19666.841 rows=2206611 loops=1) Sort Key: test.username, test.some_ts Sort Method: external merge Disk: 81960kB
5.	208.733	208.733	↑ 1.0	2206611	1	→ Seq Scan on test (cost=0.00..38292.11 rows=2206611 width=24) (actual time=0.007..208.733 rows=2206611 loops=1)

                                                             QUERY PLAN
âââââââââââââââââââââââââââââââââââââââââââââââââââââââââââââââââââââââââââââââââââââââââââââââââââââââââââââââââââââââââââââââââââââ
 CTE Scan on numbered  (cost=450693.32..500342.07 rows=735537 width=52) (actual time=17803.640..21914.244 rows=2123655 loops=1)
   Filter: (rowno <= 5)
   Rows Removed by Filter: 82956
   CTE numbered
     ->  WindowAgg  (cost=406561.10..450693.32 rows=2206611 width=24) (actual time=17803.629..20773.791 rows=2206611 loops=1)
           ->  Sort  (cost=406561.10..412077.63 rows=2206611 width=24) (actual time=17803.613..19666.841 rows=2206611 loops=1)
                 Sort Key: test.username, test.some_ts
                 Sort Method: external merge  Disk: 81960kB
                 ->  Seq Scan on test  (cost=0.00..38292.11 rows=2206611 width=24) (actual time=0.007..208.733 rows=2206611 loops=1)
 Total runtime: 22044.126 ms

Per node type stats

node type	count	sum of times	% of query
CTE Scan	1	21914.244 ms	100.0 %
Seq Scan	1	208.733 ms	1.0 %
Sort	1	19458.108 ms	88.8 %
WindowAgg	1	1106.950 ms	5.1 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
test	1	208.733 ms	1.0 %
Seq Scan	1	208.733 ms	100.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: aot

Colorize:

Columns visibility:

Per node type stats

Per table stats