explain.depesz.com

PostgreSQL's explain analyze made readable

Result: X3k3 : Without Src Id Order by

Settings
# exclusive inclusive rows x rows loops node
1. 6,756.033 46,359.398 ↑ 1.0 10,000,002 1

WindowAgg (cost=4,391,434.22..4,616,434.26 rows=10,000,002 width=89) (actual time=37,534.703..46,359.398 rows=10,000,002 loops=1)

2. 13,865.406 39,603.365 ↑ 1.0 10,000,002 1

Sort (cost=4,391,434.22..4,416,434.22 rows=10,000,002 width=61) (actual time=37,534.679..39,603.365 rows=10,000,002 loops=1)

  • Sort Key: perf_entity_id, b_sourceid, attr_ranking1
  • Sort Method: external merge Disk: 447,968kB
3. 5,572.880 25,737.959 ↑ 1.0 10,000,002 1

WindowAgg (cost=2,301,805.10..2,476,805.14 rows=10,000,002 width=61) (actual time=17,837.637..25,737.959 rows=10,000,002 loops=1)

4. 10,546.498 20,165.079 ↑ 1.0 10,000,002 1

Sort (cost=2,301,805.10..2,326,805.11 rows=10,000,002 width=29) (actual time=17,837.617..20,165.079 rows=10,000,002 loops=1)

  • Sort Key: perf_entity_id
  • Sort Method: external merge Disk: 408,800kB
5. 9,618.581 9,618.581 ↑ 1.0 10,000,002 1

Seq Scan on mi_perf_entity s2 (cost=0.00..660,610.02 rows=10,000,002 width=29) (actual time=0.027..9,618.581 rows=10,000,002 loops=1)

Planning time : 1.259 ms
Execution time : 46,957.644 ms