explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pJUX : No Covering Index

Settings
# exclusive inclusive rows x rows loops node
1. 200.261 8,350.818 ↑ 4.0 250,001 1

Unique (cost=808,480.87..820,980.88 rows=1,000,001 width=123) (actual time=7,601.621..8,350.818 rows=250,001 loops=1)

2. 1,553.575 8,150.557 ↑ 1.0 1,000,001 1

Sort (cost=808,480.87..810,980.87 rows=1,000,001 width=123) (actual time=7,601.619..8,150.557 rows=1,000,001 loops=1)

  • Sort Key: c1, (first_value(c2) OVER (?)), (first_value(c3) OVER (?)), (first_value(c4) OVER (?))
  • Sort Method: external merge Disk: 59,640kB
3. 690.658 6,596.982 ↑ 1.0 1,000,001 1

WindowAgg (cost=558,937.90..578,937.92 rows=1,000,001 width=123) (actual time=5,319.682..6,596.982 rows=1,000,001 loops=1)

4. 1,451.880 5,906.324 ↑ 1.0 1,000,001 1

Sort (cost=558,937.90..561,437.90 rows=1,000,001 width=91) (actual time=5,319.665..5,906.324 rows=1,000,001 loops=1)

  • Sort Key: c1, c4
  • Sort Method: external merge Disk: 52,912kB
5. 623.282 4,454.444 ↑ 1.0 1,000,001 1

WindowAgg (cost=336,736.93..356,736.95 rows=1,000,001 width=91) (actual time=3,290.839..4,454.444 rows=1,000,001 loops=1)

6. 1,410.626 3,831.162 ↑ 1.0 1,000,001 1

Sort (cost=336,736.93..339,236.93 rows=1,000,001 width=59) (actual time=3,290.811..3,831.162 rows=1,000,001 loops=1)

  • Sort Key: c1, c3
  • Sort Method: external merge Disk: 46,176kB
7. 588.159 2,420.536 ↑ 1.0 1,000,001 1

WindowAgg (cost=141,877.96..161,877.98 rows=1,000,001 width=59) (actual time=1,360.842..2,420.536 rows=1,000,001 loops=1)

8. 1,655.499 1,832.377 ↑ 1.0 1,000,001 1

Sort (cost=141,877.96..144,377.96 rows=1,000,001 width=27) (actual time=1,360.827..1,832.377 rows=1,000,001 loops=1)

  • Sort Key: c1, c2
  • Sort Method: external merge Disk: 39,424kB
9. 176.878 176.878 ↑ 1.0 1,000,001 1

Seq Scan on t (cost=0.00..18,294.01 rows=1,000,001 width=27) (actual time=0.009..176.878 rows=1,000,001 loops=1)

Planning time : 0.142 ms
Execution time : 8,406.608 ms