explain.depesz.com

PostgreSQL's explain analyze made readable

Result: PDe5

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 20,466.277 ↓ 0.0 0 1

Sort (cost=2,426,541.110..2,426,594.130 rows=21,208 width=239) (actual time=20,466.277..20,466.277 rows=0 loops=1)

  • Sort Key: (five_zulu() zulu_quebec (?)), juliet_alpha.seven_sierra11
  • Sort Method: quicksort Memory: 25kB
2. 5.301 20,466.273 ↓ 0.0 0 1

Merge Join (cost=2,416,330.460..2,425,017.070 rows=21,208 width=239) (actual time=20,466.273..20,466.273 rows=0 loops=1)

  • Merge Cond: (((('oscar_yankee'::text || (four_delta.zulu_golf_oscar)::text)) = juliet_alpha.seven_sierra3) AND (four_delta.seven_golf = juliet_alpha.seven_sierra5))
3. 0.011 20,289.350 ↑ 149,242.6 5 1

Sort (cost=2,398,327.300..2,400,192.840 rows=746,213 width=138) (actual time=20,289.350..20,289.350 rows=5 loops=1)

  • Sort Key: (('oscar_yankee'::text || (four_delta.zulu_golf_oscar)::text)), four_delta.seven_golf
  • Sort Method: quicksort Memory: 25kB
4. 183.263 20,289.339 ↑ 149,242.6 5 1

Hash Join (cost=2,105,404.270..2,325,537.110 rows=746,213 width=138) (actual time=19,741.710..20,289.339 rows=5 loops=1)

  • Hash Cond: (four_delta.juliet_two = (lima.lima)::numeric)
5. 1,118.859 20,106.045 ↑ 1.2 1,233,763 1

Unique (cost=2,105,399.770..2,295,684.080 rows=1,492,426 width=672) (actual time=17,917.455..20,106.045 rows=1,233,763 loops=1)

6. 9,008.845 18,987.186 ↑ 1.2 1,233,763 1

Sort (cost=2,105,399.770..2,109,130.830 rows=1,492,426 width=672) (actual time=17,917.454..18,987.186 rows=1,233,763 loops=1)

  • Sort Key: four_delta.six, four_delta.juliet_charlie, four_delta.india, four_delta.foxtrot, four_delta.echo_hotel, four_delta.three (...)
  • Sort Method: external merge Disk: 425728kB
7. 116.082 9,978.341 ↑ 1.2 1,233,763 1

Append (cost=1,386,000.990..1,508,564.240 rows=1,492,426 width=672) (actual time=8,673.687..9,978.341 rows=1,233,763 loops=1)

8. 0.139 8,673.996 ↑ 1,191.7 217 1

Subquery Scan on four_delta (cost=1,386,000.990..1,423,497.700 rows=258,598 width=1,252) (actual time=8,673.687..8,673.996 rows=217 loops=1)

9. 0.155 8,673.857 ↑ 1,191.7 217 1

Unique (cost=1,386,000.990..1,420,911.720 rows=258,598 width=358) (actual time=8,673.685..8,673.857 rows=217 loops=1)

10. 0.614 8,673.702 ↑ 1,191.7 217 1

Sort (cost=1,386,000.990..1,386,647.490 rows=258,598 width=358) (actual time=8,673.685..8,673.702 rows=217 loops=1)

  • Sort Key: alpha.six, alpha.juliet_charlie, alpha.india, alpha.foxtrot, alpha.echo_hotel, alpha.tango, alpha.xray_papa, alpha.zulu_golf_romeo, alpha.juliet_two, (papa_zulu(('four_uniform'::text || xray_yankee(five_zulu() zulu_quebec (?), 'romeo_uniform'::text)), 'five_echo'::text)), (...)
  • Sort Method: quicksort Memory: 136kB
11. 0.027 8,673.088 ↑ 1,191.7 217 1

Append (cost=668,356.660..1,362,752.580 rows=258,598 width=358) (actual time=4,336.432..8,673.088 rows=217 loops=1)

12. 1.492 4,338.776 ↑ 917.0 141 1

WindowAgg (cost=668,356.660..680,083.300 rows=129,299 width=359) (actual time=4,336.432..4,338.776 rows=141 loops=1)

13. 0.762 4,337.284 ↑ 917.0 141 1

Merge Join (cost=668,356.660..672,002.110 rows=129,299 width=359) (actual time=4,336.367..4,337.284 rows=141 loops=1)

  • Merge Cond: ((kilo.bravo = uniform_delta1.bravo) AND (kilo.papa_oscar = (((uniform_delta1.romeo_hotel || 'victor'::text) || uniform_delta1.uniform_whiskey))))
14. 0.060 2,231.282 ↑ 2,181.4 27 1

Sort (cost=279,988.180..280,135.420 rows=58,898 width=261) (actual time=2,231.279..2,231.282 rows=27 loops=1)

  • Sort Key: kilo.bravo, kilo.papa_oscar
  • Sort Method: quicksort Memory: 33kB
15. 228.648 2,231.222 ↑ 2,181.4 27 1

Hash Join (cost=132,026.700..275,321.710 rows=58,898 width=261) (actual time=2,002.424..2,231.222 rows=27 loops=1)

  • Hash Cond: ((kilo.mike_tango = alpha.seven_sierra1) AND (kilo.xray_juliet = ((alpha.oscar_bravo || 'victor'::text) || alpha.oscar_four)))
16. 0.306 0.306 ↓ 1.0 2,073 1

Seq Scan on four_juliet kilo (cost=0.000..52.710 rows=2,071 width=40) (actual time=0.009..0.306 rows=2,073 loops=1)

17. 1,286.848 2,002.268 ↑ 1.0 1,233,546 1

Hash (cost=70,142.280..70,142.280 rows=1,233,828 width=257) (actual time=2,002.268..2,002.268 rows=1,233,546 loops=1)

  • Buckets: 65536 Batches: 4 Memory Usage: 84624kB
18. 715.420 715.420 ↑ 1.0 1,233,546 1

Seq Scan on papa_xray alpha (cost=0.000..70,142.280 rows=1,233,828 width=257) (actual time=0.008..715.420 rows=1,233,546 loops=1)

19. 1.656 2,105.240 ↑ 20.6 4,272 1

Sort (cost=388,368.480..388,588.010 rows=87,812 width=120) (actual time=2,105.079..2,105.240 rows=4,272 loops=1)

  • Sort Key: uniform_delta1.bravo, (((uniform_delta1.romeo_hotel || 'victor'::text) || uniform_delta1.uniform_whiskey))
  • Sort Method: quicksort Memory: 786kB
20. 0.806 2,103.584 ↑ 20.8 4,223 1

Subquery Scan on mike_quebec (cost=379,401.940..381,158.180 rows=87,812 width=120) (actual time=2,101.988..2,103.584 rows=4,223 loops=1)

21. 2.906 2,102.778 ↑ 20.8 4,223 1

HashAggregate (cost=379,401.940..380,280.060 rows=87,812 width=70) (actual time=2,101.984..2,102.778 rows=4,223 loops=1)

22. 0.285 2,099.872 ↑ 20.8 4,224 1

Append (cost=88,649.700..377,645.700 rows=87,812 width=70) (actual time=1,044.321..2,099.872 rows=4,224 loops=1)

23. 0.490 1,044.867 ↑ 477.2 92 1

Hash Join (cost=88,649.700..188,383.790 rows=43,906 width=69) (actual time=1,044.320..1,044.867 rows=92 loops=1)

  • Hash Cond: ((kilo.bravo = alpha.seven_sierra1) AND (kilo.papa_oscar = ((alpha.oscar_bravo || 'victor'::text) || alpha.oscar_four)))
24. 0.172 0.172 ↓ 1.0 2,073 1

Seq Scan on four_juliet kilo (cost=0.000..52.710 rows=2,071 width=30) (actual time=0.012..0.172 rows=2,073 loops=1)

25. 441.748 1,044.205 ↑ 1.0 1,233,546 1

Hash (cost=70,142.280..70,142.280 rows=1,233,828 width=61) (actual time=1,044.205..1,044.205 rows=1,233,546 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 118001kB
26. 602.457 602.457 ↑ 1.0 1,233,546 1

Seq Scan on papa_xray alpha (cost=0.000..70,142.280 rows=1,233,828 width=61) (actual time=0.006..602.457 rows=1,233,546 loops=1)

27. 1.999 1,054.720 ↑ 10.6 4,132 1

Hash Join (cost=88,649.700..188,383.790 rows=43,906 width=71) (actual time=1,052.638..1,054.720 rows=4,132 loops=1)

  • Hash Cond: ((kilo.bravo = alpha.seven_sierra1) AND (kilo.papa_oscar = ((alpha.romeo_hotel || 'victor'::text) || alpha.uniform_whiskey)))
28. 0.209 0.209 ↓ 1.0 2,073 1

Seq Scan on four_juliet kilo (cost=0.000..52.710 rows=2,071 width=30) (actual time=0.002..0.209 rows=2,073 loops=1)

29. 467.068 1,052.512 ↑ 1.0 1,233,546 1

Hash (cost=70,142.280..70,142.280 rows=1,233,828 width=63) (actual time=1,052.512..1,052.512 rows=1,233,546 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 120590kB
30. 585.444 585.444 ↑ 1.0 1,233,546 1

Seq Scan on papa_xray alpha (cost=0.000..70,142.280 rows=1,233,828 width=63) (actual time=0.003..585.444 rows=1,233,546 loops=1)

31. 0.777 4,334.285 ↑ 1,701.3 76 1

WindowAgg (cost=668,356.660..680,083.300 rows=129,299 width=357) (actual time=4,332.700..4,334.285 rows=76 loops=1)

32. 0.704 4,333.508 ↑ 1,701.3 76 1

Merge Join (cost=668,356.660..672,002.110 rows=129,299 width=357) (actual time=4,332.634..4,333.508 rows=76 loops=1)

  • Merge Cond: ((kilo.bravo = uniform_delta1.bravo) AND (kilo.papa_oscar = (((uniform_delta1.romeo_hotel || 'victor'::text) || uniform_delta1.uniform_whiskey))))
33. 0.052 2,226.808 ↑ 3,099.9 19 1

Sort (cost=279,988.180..280,135.420 rows=58,898 width=259) (actual time=2,226.805..2,226.808 rows=19 loops=1)

  • Sort Key: kilo.bravo, kilo.papa_oscar
  • Sort Method: quicksort Memory: 31kB
34. 228.595 2,226.756 ↑ 3,099.9 19 1

Hash Join (cost=132,026.700..275,321.710 rows=58,898 width=259) (actual time=1,997.991..2,226.756 rows=19 loops=1)

  • Hash Cond: ((kilo.mike_tango = alpha.seven_sierra1) AND (kilo.xray_juliet = ((alpha.romeo_hotel || 'victor'::text) || alpha.uniform_whiskey)))
35. 0.299 0.299 ↓ 1.0 2,073 1

Seq Scan on four_juliet kilo (cost=0.000..52.710 rows=2,071 width=40) (actual time=0.004..0.299 rows=2,073 loops=1)

36. 1,281.575 1,997.862 ↑ 1.0 1,233,546 1

Hash (cost=70,142.280..70,142.280 rows=1,233,828 width=257) (actual time=1,997.862..1,997.862 rows=1,233,546 loops=1)

  • Buckets: 65536 Batches: 4 Memory Usage: 84541kB
37. 716.287 716.287 ↑ 1.0 1,233,546 1

Seq Scan on papa_xray alpha (cost=0.000..70,142.280 rows=1,233,828 width=257) (actual time=0.004..716.287 rows=1,233,546 loops=1)

38. 1.996 2,105.996 ↑ 20.8 4,214 1

Sort (cost=388,368.480..388,588.010 rows=87,812 width=120) (actual time=2,105.822..2,105.996 rows=4,214 loops=1)

  • Sort Key: uniform_delta1.bravo, (((uniform_delta1.romeo_hotel || 'victor'::text) || uniform_delta1.uniform_whiskey))
  • Sort Method: quicksort Memory: 786kB
39. 0.830 2,104.000 ↑ 20.8 4,223 1

Subquery Scan on mike_quebec (cost=379,401.940..381,158.180 rows=87,812 width=120) (actual time=2,102.471..2,104.000 rows=4,223 loops=1)

40. 2.823 2,103.170 ↑ 20.8 4,223 1

HashAggregate (cost=379,401.940..380,280.060 rows=87,812 width=70) (actual time=2,102.466..2,103.170 rows=4,223 loops=1)

41. 0.298 2,100.347 ↑ 20.8 4,224 1

Append (cost=88,649.700..377,645.700 rows=87,812 width=70) (actual time=1,048.049..2,100.347 rows=4,224 loops=1)

42. 0.523 1,048.600 ↑ 477.2 92 1

Hash Join (cost=88,649.700..188,383.790 rows=43,906 width=69) (actual time=1,048.049..1,048.600 rows=92 loops=1)

  • Hash Cond: ((kilo.bravo = alpha.seven_sierra1) AND (kilo.papa_oscar = ((alpha.oscar_bravo || 'victor'::text) || alpha.oscar_four)))
43. 0.142 0.142 ↓ 1.0 2,073 1

Seq Scan on four_juliet kilo (cost=0.000..52.710 rows=2,071 width=30) (actual time=0.011..0.142 rows=2,073 loops=1)

44. 446.813 1,047.935 ↑ 1.0 1,233,546 1

Hash (cost=70,142.280..70,142.280 rows=1,233,828 width=61) (actual time=1,047.935..1,047.935 rows=1,233,546 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 118001kB
45. 601.122 601.122 ↑ 1.0 1,233,546 1

Seq Scan on papa_xray alpha (cost=0.000..70,142.280 rows=1,233,828 width=61) (actual time=0.007..601.122 rows=1,233,546 loops=1)

46. 2.219 1,051.449 ↑ 10.6 4,132 1

Hash Join (cost=88,649.700..188,383.790 rows=43,906 width=71) (actual time=1,049.175..1,051.449 rows=4,132 loops=1)

  • Hash Cond: ((kilo.bravo = alpha.seven_sierra1) AND (kilo.papa_oscar = ((alpha.romeo_hotel || 'victor'::text) || alpha.uniform_whiskey)))
47. 0.158 0.158 ↓ 1.0 2,073 1

Seq Scan on four_juliet kilo (cost=0.000..52.710 rows=2,071 width=30) (actual time=0.001..0.158 rows=2,073 loops=1)

48. 461.300 1,049.072 ↑ 1.0 1,233,546 1

Hash (cost=70,142.280..70,142.280 rows=1,233,828 width=63) (actual time=1,049.072..1,049.072 rows=1,233,546 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 120590kB
49. 587.772 587.772 ↑ 1.0 1,233,546 1

Seq Scan on papa_xray alpha (cost=0.000..70,142.280 rows=1,233,828 width=63) (actual time=0.002..587.772 rows=1,233,546 loops=1)

50. 390.889 1,188.263 ↑ 1.0 1,233,546 1

Subquery Scan on echo_uniform (cost=0.000..82,480.560 rows=1,233,828 width=550) (actual time=0.008..1,188.263 rows=1,233,546 loops=1)

51. 797.374 797.374 ↑ 1.0 1,233,546 1

Seq Scan on papa_xray (cost=0.000..70,142.280 rows=1,233,828 width=550) (actual time=0.005..797.374 rows=1,233,546 loops=1)

52. 0.008 0.031 ↑ 20.0 5 1

Hash (cost=3.250..3.250 rows=100 width=12) (actual time=0.031..0.031 rows=5 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
53. 0.009 0.023 ↑ 20.0 5 1

WindowAgg (cost=0.000..2.250 rows=100 width=4) (actual time=0.018..0.023 rows=5 loops=1)

54. 0.014 0.014 ↑ 20.0 5 1

Function Scan on lima (cost=0.000..1.000 rows=100 width=4) (actual time=0.013..0.014 rows=5 loops=1)

55. 126.460 171.622 ↑ 2.7 35,212 1

Sort (cost=18,003.160..18,243.010 rows=95,938 width=143) (actual time=170.062..171.622 rows=35,212 loops=1)

  • Sort Key: juliet_alpha.seven_sierra3, juliet_alpha.seven_sierra5
  • Sort Method: quicksort Memory: 28139kB
56. 45.162 45.162 ↑ 1.0 94,407 1

Seq Scan on juliet_alpha (cost=0.000..10,064.380 rows=95,938 width=143) (actual time=0.025..45.162 rows=94,407 loops=1)