explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qFoE

Settings
# exclusive inclusive rows x rows loops node
1. 2,857.955 2,068,854.502 ↑ 5.0 35,070 1

Subquery Scan on hotel (cost=62,292,593.900..63,793,522.840 rows=176,528 width=824) (actual time=1,906,787.755..2,068,854.502 rows=35,070 loops=1)

  • Filter: (hotel.oscar = 1)
  • Rows Removed by Filter: 47060682
2. 38,930.868 2,065,996.547 ↓ 1.3 47,095,752 1

WindowAgg (cost=62,292,593.900..63,351,761.630 rows=35,305,591 width=1,024) (actual time=1,906,746.989..2,065,996.547 rows=47,095,752 loops=1)

3. 815,681.735 2,027,065.679 ↓ 1.3 47,095,752 1

Sort (cost=62,292,593.900..62,380,857.880 rows=35,305,591 width=1,016) (actual time=1,906,745.731..2,027,065.679 rows=47,095,752 loops=1)

  • Sort Key: (lima(quebec_sierra.quebec_kilo, ''whiskey''::text))
  • Sort Method: external merge Disk: 17637608kB
4. 10,856.800 1,211,383.944 ↓ 1.3 47,095,752 1

Subquery Scan on quebec_sierra (cost=10,658,015.140..26,491,347.050 rows=35,305,591 width=1,016) (actual time=453,957.915..1,211,383.944 rows=47,095,752 loops=1)

5. 3,856.977 1,200,527.144 ↓ 1.3 47,095,752 1

Append (cost=10,658,015.140..26,138,291.140 rows=35,305,591 width=824) (actual time=453,957.907..1,200,527.144 rows=47,095,752 loops=1)

6. 8,005.191 600,310.857 ↓ 2.0 23,530,929 1

Subquery Scan on victor (cost=10,658,015.140..12,382,108.900 rows=11,890,431 width=472) (actual time=453,957.906..600,310.857 rows=23,530,929 loops=1)

7. 11,166.452 592,305.666 ↓ 2.0 23,530,929 1

Gather (cost=10,658,015.140..12,203,752.430 rows=11,890,431 width=472) (actual time=453,957.896..592,305.666 rows=23,530,929 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
8. 42,439.444 581,139.214 ↓ 1.6 7,843,643 3

Merge Join (cost=10,657,015.140..11,013,709.330 rows=4,954,346 width=472) (actual time=452,253.983..581,139.214 rows=7,843,643 loops=3)

  • Merge Cond: ((quebec_three.quebec_kilo = five.quebec_kilo) AND (quebec_three.foxtrot = five.foxtrot))
9. 122,639.314 149,053.394 ↑ 1.3 7,853,069 3

Sort (cost=5,880,010.270..5,904,690.380 rows=9,872,041 width=464) (actual time=129,868.672..149,053.394 rows=7,853,069 loops=3)

  • Sort Key: quebec_three.quebec_kilo, quebec_three.foxtrot
  • Sort Method: external merge Disk: 2006016kB
10. 26,414.080 26,414.080 ↑ 1.3 7,853,069 3

Parallel Seq Scan on bravo quebec_three (cost=0.000..2,674,846.510 rows=9,872,041 width=464) (actual time=0.880..26,414.080 rows=7,853,069 loops=3)

  • Filter: (golf = 'juliet_charlie'::date)
11. 2,492.796 389,646.376 ↓ 1.0 23,431,587 3

Materialize (cost=4,775,983.680..4,893,059.480 rows=23,415,160 width=78) (actual time=322,385.271..389,646.376 rows=23,431,587 loops=3)

12. 380,980.042 387,153.580 ↑ 1.0 23,398,716 3

Sort (cost=4,775,983.680..4,834,521.580 rows=23,415,160 width=78) (actual time=322,385.264..387,153.580 rows=23,398,716 loops=3)

  • Sort Key: five.quebec_kilo, five.foxtrot
  • Sort Method: external merge Disk: 2045088kB
13. 6,173.538 6,173.538 ↑ 1.0 23,398,717 3

Seq Scan on four five (cost=0.000..869,437.600 rows=23,415,160 width=78) (actual time=0.346..6,173.538 rows=23,398,717 loops=3)

14. 4,631.165 596,359.310 ↓ 1.0 23,564,823 1

Subquery Scan on echo (cost=10,469,690.420..13,756,182.240 rows=23,415,160 width=525) (actual time=455,002.164..596,359.310 rows=23,564,823 loops=1)

15. 188.258 591,728.145 ↓ 1.0 23,564,823 1

Gather (cost=10,469,690.420..13,287,879.040 rows=23,415,160 width=509) (actual time=455,002.158..591,728.145 rows=23,564,823 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
16. 44,241.450 591,539.887 ↑ 1.2 7,854,941 3

Merge Left Join (cost=10,468,690.420..10,877,068.830 rows=9,756,317 width=509) (actual time=464,044.310..591,539.887 rows=7,854,941 loops=3)

  • Merge Cond: ((mike1.quebec_kilo = bravo.quebec_kilo) AND (mike1.foxtrot = bravo.foxtrot))
17. 124,910.141 127,653.289 ↑ 1.3 7,799,572 3

Sort (cost=3,666,184.380..3,690,575.180 rows=9,756,317 width=405) (actual time=108,900.452..127,653.289 rows=7,799,572 loops=3)

  • Sort Key: mike1.quebec_kilo, mike1.foxtrot
  • Sort Method: external merge Disk: 1494800kB
18. 2,743.148 2,743.148 ↑ 1.3 7,799,572 3

Parallel Seq Scan on four juliet_xray (cost=0.000..732,849.170 rows=9,756,317 width=405) (actual time=0.202..2,743.148 rows=7,799,572 loops=3)

19. 2,582.944 419,645.148 ↑ 1.0 23,559,208 3

Materialize (cost=6,802,506.040..6,920,970.530 rows=23,692,898 width=78) (actual time=355,143.826..419,645.148 rows=23,559,208 loops=3)

20. 370,990.059 417,062.204 ↑ 1.0 23,559,208 3

Sort (cost=6,802,506.040..6,861,738.280 rows=23,692,898 width=78) (actual time=355,143.533..417,062.204 rows=23,559,208 loops=3)

  • Sort Key: bravo.quebec_kilo, bravo.foxtrot
  • Sort Method: external merge Disk: 2059528kB
21. 46,072.145 46,072.145 ↑ 1.0 23,559,208 3

Seq Scan on bravo (cost=0.000..2,847,607.230 rows=23,692,898 width=78) (actual time=2.814..46,072.145 rows=23,559,208 loops=3)

  • Filter: (golf = 'juliet_charlie'::date)
Planning time : 3.398 ms
Execution time : 2,070,640.837 ms