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. 21,914.244 21,914.244 ↓ 2.9 2,123,655 1

CTE Scan on numbered (cost=450,693.32..500,342.07 rows=735,537 width=52) (actual time=17,803.640..21,914.244 rows=2,123,655 loops=1)

  • Filter: (rowno <= 5)
  • Rows Removed by Filter: 82956
2.          

CTE numbered

3. 1,106.950 20,773.791 ↑ 1.0 2,206,611 1

WindowAgg (cost=406,561.10..450,693.32 rows=2,206,611 width=24) (actual time=17,803.629..20,773.791 rows=2,206,611 loops=1)

4. 19,458.108 19,666.841 ↑ 1.0 2,206,611 1

Sort (cost=406,561.10..412,077.63 rows=2,206,611 width=24) (actual time=17,803.613..19,666.841 rows=2,206,611 loops=1)

  • Sort Key: test.username, test.some_ts
  • Sort Method: external merge Disk: 81960kB
5. 208.733 208.733 ↑ 1.0 2,206,611 1

Seq Scan on test (cost=0.00..38,292.11 rows=2,206,611 width=24) (actual time=0.007..208.733 rows=2,206,611 loops=1)