explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fGRr

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 16,839.505 ↓ 0.0 0 1

Sort (cost=1,274,121.530..1,274,165.370 rows=17,534 width=239) (actual time=16,839.505..16,839.505 rows=0 loops=1)

  • Sort Key: (five_zulu() zulu_quebec (?)), juliet_alpha.seven_sierra11
  • Sort Method: quicksort Memory: 25kB
2. 5.231 16,839.499 ↓ 0.0 0 1

Merge Join (cost=1,265,537.730..1,272,885.570 rows=17,534 width=239) (actual time=16,839.499..16,839.499 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.010 16,687.857 ↑ 616,929.0 1 1

Sort (cost=1,247,534.570..1,249,076.890 rows=616,929 width=138) (actual time=16,687.856..16,687.857 rows=1 loops=1)

  • Sort Key: (('oscar_yankee'::text || (four_delta.zulu_golf_oscar)::text)), four_delta.seven_golf
  • Sort Method: quicksort Memory: 25kB
4. 192.661 16,687.847 ↑ 616,929.0 1 1

Hash Join (cost=1,006,208.150..1,188,202.210 rows=616,929 width=138) (actual time=16,144.906..16,687.847 rows=1 loops=1)

  • Hash Cond: (four_delta.juliet_two = (lima.lima)::numeric)
5. 1,124.928 16,495.161 ↑ 1.0 1,233,759 1

Unique (cost=1,006,203.650..1,163,520.550 rows=1,233,858 width=550) (actual time=14,310.886..16,495.161 rows=1,233,759 loops=1)

6. 8,925.052 15,370.233 ↑ 1.0 1,233,759 1

Sort (cost=1,006,203.650..1,009,288.300 rows=1,233,858 width=550) (actual time=14,310.884..15,370.233 rows=1,233,759 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. 111.376 6,445.181 ↑ 1.0 1,233,759 1

Append (cost=495,238.430..577,723.640 rows=1,233,858 width=550) (actual time=5,142.791..6,445.181 rows=1,233,759 loops=1)

8. 0.110 5,143.050 ↓ 7.1 213 1

Subquery Scan on four_delta (cost=495,238.430..495,242.780 rows=30 width=1,252) (actual time=5,142.790..5,143.050 rows=213 loops=1)

9. 0.133 5,142.940 ↓ 7.1 213 1

Unique (cost=495,238.430..495,242.480 rows=30 width=358) (actual time=5,142.788..5,142.940 rows=213 loops=1)

10. 0.725 5,142.807 ↓ 7.1 213 1

Sort (cost=495,238.430..495,238.510 rows=30 width=358) (actual time=5,142.787..5,142.807 rows=213 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: 134kB
11. 0.031 5,142.082 ↓ 7.1 213 1

Append (cost=165,137.050..495,237.700 rows=30 width=358) (actual time=2,108.576..5,142.082 rows=213 loops=1)

12. 1.762 2,566.681 ↓ 9.1 137 1

WindowAgg (cost=165,137.050..247,618.700 rows=15 width=359) (actual time=2,108.575..2,566.681 rows=137 loops=1)

13. 243.601 2,564.919 ↓ 9.1 137 1

Hash Join (cost=165,137.050..247,617.760 rows=15 width=359) (actual time=2,108.496..2,564.919 rows=137 loops=1)

  • Hash Cond: ((alpha.seven_sierra1 = kilo.mike) AND (((alpha.oscar_bravo || 'victor'::text) || alpha.oscar_four) = kilo.xray_juliet))
14. 667.244 667.244 ↑ 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.018..667.244 rows=1,233,546 loops=1)

15. 0.093 1,654.074 ↓ 147.0 147 1

Hash (cost=165,137.040..165,137.040 rows=1 width=143) (actual time=1,654.074..1,654.074 rows=147 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 16kB
16. 0.106 1,653.981 ↓ 147.0 147 1

Hash Join (cost=165,103.900..165,137.040 rows=1 width=143) (actual time=1,653.853..1,653.981 rows=147 loops=1)

  • Hash Cond: ((alpha.seven_sierra1 = kilo.bravo) AND (((alpha.oscar_bravo || 'victor'::text) || alpha.oscar_four) = kilo.papa_oscar))
17. 0.212 1,653.795 ↑ 7.5 147 1

HashAggregate (cost=165,071.030..165,082.070 rows=1,104 width=70) (actual time=1,653.753..1,653.795 rows=147 loops=1)

18. 0.025 1,653.583 ↑ 7.5 148 1

Append (cost=32.880..165,048.950 rows=1,104 width=70) (actual time=390.595..1,653.583 rows=148 loops=1)

19. 240.956 841.761 ↑ 6.1 90 1

Hash Join (cost=32.880..82,518.960 rows=552 width=69) (actual time=390.595..841.761 rows=90 loops=1)

  • Hash Cond: ((alpha.seven_sierra1 = kilo.bravo) AND (((alpha.oscar_bravo || 'victor'::text) || alpha.oscar_four) = kilo.papa_oscar))
20. 600.764 600.764 ↑ 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.004..600.764 rows=1,233,546 loops=1)

21. 0.018 0.041 ↑ 1.0 35 1

Hash (cost=32.350..32.350 rows=35 width=29) (actual time=0.041..0.041 rows=35 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 3kB
22. 0.023 0.023 ↑ 1.0 35 1

Seq Scan on four_juliet kilo (cost=0.000..32.350 rows=35 width=29) (actual time=0.002..0.023 rows=35 loops=1)

23. 246.385 811.797 ↑ 9.5 58 1

Hash Join (cost=32.880..82,518.960 rows=552 width=71) (actual time=407.308..811.797 rows=58 loops=1)

  • Hash Cond: ((alpha.seven_sierra1 = kilo.bravo) AND (((alpha.romeo_hotel || 'victor'::text) || alpha.uniform) = kilo.papa_oscar))
24. 565.380 565.380 ↑ 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..565.380 rows=1,233,546 loops=1)

25. 0.011 0.032 ↑ 1.0 35 1

Hash (cost=32.350..32.350 rows=35 width=29) (actual time=0.032..0.032 rows=35 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 3kB
26. 0.021 0.021 ↑ 1.0 35 1

Seq Scan on four_juliet kilo (cost=0.000..32.350 rows=35 width=29) (actual time=0.003..0.021 rows=35 loops=1)

27. 0.022 0.080 ↑ 1.0 35 1

Hash (cost=32.350..32.350 rows=35 width=44) (actual time=0.080..0.080 rows=35 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 3kB
28. 0.058 0.058 ↑ 1.0 35 1

Seq Scan on four_juliet kilo (cost=0.000..32.350 rows=35 width=44) (actual time=0.012..0.058 rows=35 loops=1)

29. 1.212 2,575.370 ↓ 5.1 76 1

WindowAgg (cost=165,137.050..247,618.700 rows=15 width=357) (actual time=2,116.028..2,575.370 rows=76 loops=1)

30. 251.738 2,574.158 ↓ 5.1 76 1

Hash Join (cost=165,137.050..247,617.760 rows=15 width=357) (actual time=2,115.952..2,574.158 rows=76 loops=1)

  • Hash Cond: ((alpha.seven_sierra1 = kilo.mike) AND (((alpha.romeo_hotel || 'victor'::text) || alpha.uniform) = kilo.xray_juliet))
31. 664.821 664.821 ↑ 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.002..664.821 rows=1,233,546 loops=1)

32. 0.045 1,657.599 ↓ 147.0 147 1

Hash (cost=165,137.040..165,137.040 rows=1 width=143) (actual time=1,657.599..1,657.599 rows=147 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 16kB
33. 0.113 1,657.554 ↓ 147.0 147 1

Hash Join (cost=165,103.900..165,137.040 rows=1 width=143) (actual time=1,657.420..1,657.554 rows=147 loops=1)

  • Hash Cond: ((alpha.seven_sierra1 = kilo.bravo) AND (((alpha.oscar_bravo || 'victor'::text) || alpha.oscar_four) = kilo.papa_oscar))
34. 0.182 1,657.407 ↑ 7.5 147 1

HashAggregate (cost=165,071.030..165,082.070 rows=1,104 width=70) (actual time=1,657.373..1,657.407 rows=147 loops=1)

35. 0.021 1,657.225 ↑ 7.5 148 1

Append (cost=32.880..165,048.950 rows=1,104 width=70) (actual time=375.512..1,657.225 rows=148 loops=1)

36. 241.837 826.475 ↑ 6.1 90 1

Hash Join (cost=32.880..82,518.960 rows=552 width=69) (actual time=375.512..826.475 rows=90 loops=1)

  • Hash Cond: ((alpha.seven_sierra1 = kilo.bravo) AND (((alpha.oscar_bravo || 'victor'::text) || alpha.oscar_four) = kilo.papa_oscar))
37. 584.622 584.622 ↑ 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.001..584.622 rows=1,233,546 loops=1)

38. 0.006 0.016 ↑ 1.0 35 1

Hash (cost=32.350..32.350 rows=35 width=29) (actual time=0.016..0.016 rows=35 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 3kB
39. 0.010 0.010 ↑ 1.0 35 1

Seq Scan on four_juliet kilo (cost=0.000..32.350 rows=35 width=29) (actual time=0.001..0.010 rows=35 loops=1)

40. 251.959 830.729 ↑ 9.5 58 1

Hash Join (cost=32.880..82,518.960 rows=552 width=71) (actual time=428.094..830.729 rows=58 loops=1)

  • Hash Cond: ((alpha.seven_sierra1 = kilo.bravo) AND (((alpha.romeo_hotel || 'victor'::text) || alpha.uniform) = kilo.papa_oscar))
41. 578.738 578.738 ↑ 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..578.738 rows=1,233,546 loops=1)

42. 0.006 0.032 ↑ 1.0 35 1

Hash (cost=32.350..32.350 rows=35 width=29) (actual time=0.032..0.032 rows=35 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 3kB
43. 0.026 0.026 ↑ 1.0 35 1

Seq Scan on four_juliet kilo (cost=0.000..32.350 rows=35 width=29) (actual time=0.003..0.026 rows=35 loops=1)

44. 0.010 0.034 ↑ 1.0 35 1

Hash (cost=32.350..32.350 rows=35 width=44) (actual time=0.034..0.034 rows=35 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 3kB
45. 0.024 0.024 ↑ 1.0 35 1

Seq Scan on four_juliet kilo (cost=0.000..32.350 rows=35 width=44) (actual time=0.004..0.024 rows=35 loops=1)

46. 405.615 1,190.755 ↑ 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.014..1,190.755 rows=1,233,546 loops=1)

47. 785.140 785.140 ↑ 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.004..785.140 rows=1,233,546 loops=1)

48. 0.006 0.025 ↑ 100.0 1 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
49. 0.007 0.019 ↑ 100.0 1 1

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

50. 0.012 0.012 ↑ 100.0 1 1

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

51. 120.136 146.411 ↑ 2.7 35,212 1

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

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

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