explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mPl

Settings
# exclusive inclusive rows x rows loops node
1. 22.870 2,366.587 ↑ 3.3 128 1

Subquery Scan on zulu_two (cost=71,357.040..87,575.620 rows=427 width=216) (actual time=1,672.361..2,366.587 rows=128 loops=1)

  • Filter: (zulu_two.victor_yankee = 980)
  • Rows Removed by Filter: 412029
2. 380.996 2,343.717 ↓ 4.8 412,157 1

WindowAgg (cost=71,357.040..86,507.090 rows=85,482 width=257) (actual time=1,603.331..2,343.717 rows=412,157 loops=1)

3. 186.477 1,962.721 ↓ 4.8 412,157 1

Group (cost=71,357.040..82,874.110 rows=85,482 width=198) (actual time=1,603.319..1,962.721 rows=412,157 loops=1)

  • Group Key: foxtrot_two.quebec, charlie_delta.india_november, five_india.quebec, tango.quebec, india_three.november_lima, india_alpha.india_november, juliet_four.quebec, oscar_papa.uniform_juliet, seven.delta, foxtrot_yankee.quebec, oscar_papa.november_lima, juliet_xray.quebec
4. 65.361 1,776.244 ↓ 5.8 412,157 1

Gather Merge (cost=71,357.040..80,737.030 rows=71,236 width=198) (actual time=1,603.316..1,776.244 rows=412,157 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
5. 102.739 1,710.883 ↓ 3.9 137,386 3 / 3

Group (cost=70,357.020..71,514.600 rows=35,618 width=198) (actual time=1,574.295..1,710.883 rows=137,386 loops=3)

  • Group Key: foxtrot_two.quebec, charlie_delta.india_november, five_india.quebec, tango.quebec, india_three.november_lima, india_alpha.india_november, juliet_four.quebec, oscar_papa.uniform_juliet, seven.delta, foxtrot_yankee.quebec, oscar_papa.november_lima, juliet_xray.quebec
6. 209.157 1,608.144 ↓ 3.9 137,386 3 / 3

Sort (cost=70,357.020..70,446.060 rows=35,618 width=198) (actual time=1,574.291..1,608.144 rows=137,386 loops=3)

  • Sort Key: foxtrot_two.quebec DESC, charlie_delta.india_november, five_india.quebec, tango.quebec, india_three.november_lima, india_alpha.india_november, juliet_four.quebec, oscar_papa.uniform_juliet, seven.delta, foxtrot_yankee.quebec, oscar_papa.november_lima, juliet_xray.quebec
  • Sort Method: external merge Disk: 30312kB
  • Worker 0: Sort Method: external merge Disk: 30840kB
  • Worker 1: Sort Method: external merge Disk: 28000kB
7. 33.982 1,398.987 ↓ 3.9 137,386 3 / 3

Hash Left Join (cost=43,714.280..64,255.240 rows=35,618 width=198) (actual time=776.944..1,398.987 rows=137,386 loops=3)

  • Hash Cond: (foxtrot_two.four = charlie_delta.quebec)
8. 35.365 1,362.826 ↓ 3.9 137,386 3 / 3

Parallel Hash Left Join (cost=43,342.590..63,790.010 rows=35,618 width=197) (actual time=774.731..1,362.826 rows=137,386 loops=3)

  • Hash Cond: (foxtrot_two.quebec = juliet_xray.charlie_lima)
9. 31.439 1,320.101 ↓ 3.9 137,254 3 / 3

Hash Left Join (cost=41,434.460..61,203.060 rows=35,618 width=189) (actual time=767.228..1,320.101 rows=137,254 loops=3)

  • Hash Cond: (tango.four = india_alpha.quebec)
10. 33.424 1,286.052 ↓ 3.9 137,254 3 / 3

Hash Left Join (cost=41,062.770..60,737.820 rows=35,618 width=188) (actual time=764.599..1,286.052 rows=137,254 loops=3)

  • Hash Cond: (five_india.whiskey = oscar_papa.quebec)
11. 52.680 1,250.746 ↓ 3.9 137,254 3 / 3

Parallel Hash Left Join (cost=40,770.360..60,351.850 rows=35,618 width=178) (actual time=762.701..1,250.746 rows=137,254 loops=3)

  • Hash Cond: (tango.quebec = juliet_four.charlie_six)
12. 129.466 1,174.558 ↓ 3.8 134,965 3 / 3

Nested Loop Left Join (cost=36,027.260..55,457.530 rows=35,618 width=153) (actual time=738.909..1,174.558 rows=134,965 loops=3)

  • Filter: (five_india.three five_romeo NULL)
  • Rows Removed by Filter: 2249
13. 70.179 907.878 ↓ 3.8 137,214 3 / 3

Merge Join (cost=36,026.840..37,500.040 rows=36,467 width=133) (actual time=738.865..907.878 rows=137,214 loops=3)

  • Merge Cond: (foxtrot_two.quebec = tango.charlie_lima)
14. 28.679 45.070 ↑ 1.3 72,353 3 / 3

Sort (cost=18,178.720..18,404.840 rows=90,445 width=40) (actual time=38.715..45.070 rows=72,353 loops=3)

  • Sort Key: foxtrot_two.quebec
  • Sort Method: external merge Disk: 4048kB
  • Worker 0: Sort Method: external merge Disk: 3592kB
  • Worker 1: Sort Method: external merge Disk: 3584kB
15. 16.391 16.391 ↑ 1.2 72,356 3 / 3

Parallel Seq Scan on charlie_three foxtrot_two (cost=0.000..8,258.450 rows=90,445 width=40) (actual time=0.021..16.391 rows=72,356 loops=3)

16. 36.579 792.629 ↓ 4.7 411,643 3 / 3

Materialize (cost=17,848.080..18,285.680 rows=87,521 width=101) (actual time=700.119..792.629 rows=411,643 loops=3)

17. 251.052 756.050 ↓ 4.7 411,643 3 / 3

Sort (cost=17,848.080..18,066.880 rows=87,521 width=101) (actual time=700.115..756.050 rows=411,643 loops=3)

  • Sort Key: tango.charlie_lima
  • Sort Method: external merge Disk: 50328kB
  • Worker 0: Sort Method: external merge Disk: 50328kB
  • Worker 1: Sort Method: external merge Disk: 50328kB
18. 113.759 504.998 ↓ 4.7 411,643 3 / 3

Nested Loop (cost=472.270..5,875.770 rows=87,521 width=101) (actual time=2.751..504.998 rows=411,643 loops=3)

  • Join Filter: (foxtrot_yankee.victor_zulu = tango.victor_zulu)
19. 0.830 8.007 ↓ 7.0 998 3 / 3

Hash Join (cost=471.840..854.830 rows=142 width=85) (actual time=2.706..8.007 rows=998 loops=3)

  • Hash Cond: (seven.quebec = foxtrot_yankee.victor_zulu)
20. 2.779 6.576 ↑ 1.0 1,447 3 / 3

Hash Join (cost=373.030..749.120 rows=1,459 width=31) (actual time=2.097..6.576 rows=1,447 loops=3)

  • Hash Cond: (seven.hotel = india_three.quebec)
21. 1.716 1.716 ↑ 1.0 10,383 3 / 3

Seq Scan on november_uniform seven (cost=0.000..348.830 rows=10,383 width=17) (actual time=0.006..1.716 rows=10,383 loops=3)

22. 0.162 2.081 ↑ 1.0 1,339 3 / 3

Hash (cost=356.290..356.290 rows=1,339 width=30) (actual time=2.081..2.081 rows=1,339 loops=3)

  • Buckets: 2048 Batches: 1 Memory Usage: 105kB
23. 1.919 1.919 ↑ 1.0 1,339 3 / 3

Seq Scan on golf_november india_three (cost=0.000..356.290 rows=1,339 width=30) (actual time=0.009..1.919 rows=1,339 loops=3)

  • Filter: mike_tango
  • Rows Removed by Filter: 8190
24. 0.129 0.601 ↑ 1.0 1,014 3 / 3

Hash (cost=86.140..86.140 rows=1,014 width=54) (actual time=0.601..0.601 rows=1,014 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 102kB
25. 0.472 0.472 ↑ 1.0 1,014 3 / 3

Seq Scan on papa foxtrot_yankee (cost=0.000..86.140 rows=1,014 width=54) (actual time=0.027..0.472 rows=1,014 loops=3)

26. 383.232 383.232 ↑ 1.5 412 2,994 / 3

Index Scan using charlie_quebec on mike_juliet tango (cost=0.430..27.680 rows=614 width=40) (actual time=0.005..0.384 rows=412 loops=2,994)

  • Index Cond: (victor_zulu = seven.quebec)
27. 137.214 137.214 ↑ 1.0 1 411,643 / 3

Index Scan using oscar_three on victor_xray five_india (cost=0.420..0.480 rows=1 width=36) (actual time=0.001..0.001 rows=1 loops=411,643)

  • Index Cond: (tango.five_november = quebec)
28. 11.725 23.508 ↑ 1.8 46,932 3 / 3

Parallel Hash (cost=3,704.710..3,704.710 rows=83,071 width=33) (actual time=23.508..23.508 rows=46,932 loops=3)

  • Buckets: 262144 Batches: 1 Memory Usage: 11776kB
29. 11.783 11.783 ↑ 1.8 46,932 3 / 3

Parallel Seq Scan on zulu_xray juliet_four (cost=0.000..3,704.710 rows=83,071 width=33) (actual time=0.020..11.783 rows=46,932 loops=3)

30. 0.607 1.882 ↑ 1.0 5,707 3 / 3

Hash (cost=221.070..221.070 rows=5,707 width=26) (actual time=1.881..1.882 rows=5,707 loops=3)

  • Buckets: 8192 Batches: 1 Memory Usage: 413kB
31. 1.275 1.275 ↑ 1.0 5,707 3 / 3

Seq Scan on uniform_foxtrot oscar_papa (cost=0.000..221.070 rows=5,707 width=26) (actual time=0.007..1.275 rows=5,707 loops=3)

32. 1.068 2.610 ↑ 1.0 9,764 3 / 3

Hash (cost=249.640..249.640 rows=9,764 width=17) (actual time=2.610..2.610 rows=9,764 loops=3)

  • Buckets: 16384 Batches: 1 Memory Usage: 635kB
33. 1.542 1.542 ↑ 1.0 9,764 3 / 3

Seq Scan on echo india_alpha (cost=0.000..249.640 rows=9,764 width=17) (actual time=0.011..1.542 rows=9,764 loops=3)

34. 3.544 7.360 ↑ 1.8 19,169 3 / 3

Parallel Hash (cost=1,485.280..1,485.280 rows=33,828 width=16) (actual time=7.360..7.360 rows=19,169 loops=3)

  • Buckets: 65536 Batches: 1 Memory Usage: 3264kB
35. 3.816 3.816 ↑ 1.8 19,169 3 / 3

Parallel Seq Scan on golf_bravo juliet_xray (cost=0.000..1,485.280 rows=33,828 width=16) (actual time=0.015..3.816 rows=19,169 loops=3)

36. 1.055 2.179 ↑ 1.0 9,764 3 / 3

Hash (cost=249.640..249.640 rows=9,764 width=17) (actual time=2.179..2.179 rows=9,764 loops=3)

  • Buckets: 16384 Batches: 1 Memory Usage: 635kB
37. 1.124 1.124 ↑ 1.0 9,764 3 / 3

Seq Scan on echo charlie_delta (cost=0.000..249.640 rows=9,764 width=17) (actual time=0.003..1.124 rows=9,764 loops=3)

Planning time : 12.356 ms
Execution time : 2,386.823 ms