explain.depesz.com

A tool for finding a real cause for slow queries.

Result: aot

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# 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)