explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1A2P

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 7.644 ↓ 0.0 0 1

Unique (cost=816.320..1,051.220 rows=1,160 width=3,195) (actual time=7.644..7.644 rows=0 loops=1)

2. 0.132 7.644 ↓ 0.0 0 1

Sort (cost=816.320..819.220 rows=1,160 width=3,195) (actual time=7.644..7.644 rows=0 loops=1)

  • Sort Key: lima_november.quebec, lima_november.lima_oscar, lima_november.three_xray, lima_november.three_four, lima_november.seven_golf, lima_november.kilo_kilo, lima_november.victor_charlie, lima_november.six_two, lima_november.five_two, lima_november.alpha_two, lima_november.oscar_golf, lima_november.yankee_mike, lima_november.echo_hotel, lima_november.charlie_oscar, lima_november.four_zulu, lima_november.oscar_quebec, lima_november.kilo_six, lima_november.yankee_uniform_india, lima_november.six_whiskey, lima_november.charlie_three, lima_november.juliet_sierra, lima_november.three_golf, lima_november.romeo_zulu_uniform, lima_november.foxtrot_romeo, lima_november.oscar_whiskey, (alpha_four_delta(india_juliet.lima_romeo)), (alpha_four_delta((seven_six.oscar_sierra)::text)), hotel_six.quebec, hotel_six.echo_hotel, hotel_six.tango_hotel_november, hotel_six.alpha_four_quebec, hotel_six.november, hotel_six.alpha_golf, hotel_six.delta_juliet, hotel_six.juliet_charlie_romeo, hotel_six.delta_foxtrot_delta, hotel_six.kilo_three, hotel_six.three_oscar, hotel_six.yankee_uniform_seven, hotel_six.seven_golf, hotel_six.kilo_kilo, hotel_six.six_two, hotel_six.victor_charlie, hotel_six.four_two, hotel_six.yankee_victor, hotel_six.mike, hotel_six.kilo_quebec, hotel_six.hotel_five, hotel_six.hotel_charlie, hotel_six.whiskey_india, hotel_six.foxtrot_november, hotel_six.juliet_charlie_three, hotel_six.seven_india, hotel_six.india_quebec, hotel_six.papa_three, hotel_six.delta_quebec, hotel_six.three_six, hotel_six.xray_five_quebec, hotel_six.yankee_three, hotel_six.kilo_papa, hotel_six.whiskey_kilo, hotel_six.delta_foxtrot_two, hotel_six.india_india, hotel_six.uniform_sierra, hotel_six.juliet_charlie_papa, hotel_six.bravo, hotel_six.victor_oscar, hotel_six.romeo_five, hotel_six.oscar_kilo, hotel_six.juliet_two, hotel_six.zulu_lima, hotel_six.romeo_two, hotel_six.xray_six, hotel_six.yankee_uniform_india, hotel_six.oscar_six1, hotel_six.oscar_six2, hotel_six.seven_tango1, hotel_six.seven_tango2, hotel_six.uniform_lima, hotel_six.echo_foxtrot
  • Sort Method: quicksort Memory: 25kB
3. 0.006 7.512 ↓ 0.0 0 1

HashAggregate (cost=745.670..757.270 rows=1,160 width=3,195) (actual time=7.512..7.512 rows=0 loops=1)

  • Group Key: lima_november.quebec, hotel_six.quebec
4. 0.000 7.506 ↓ 0.0 0 1

Merge Right Join (cost=722.490..734.070 rows=1,160 width=3,184) (actual time=7.506..7.506 rows=0 loops=1)

  • Merge Cond: (hotel_six.zulu_lima = lima_november.quebec)
5. 0.007 0.007 ↑ 14,985.0 1 1

Index Scan using zulu_two on hotel_six (cost=0.290..1,941.000 rows=14,985 width=282) (actual time=0.007..0.007 rows=1 loops=1)

6. 0.007 7.499 ↓ 0.0 0 1

Sort (cost=722.200..722.420 rows=87 width=2,902) (actual time=7.499..7.499 rows=0 loops=1)

  • Sort Key: lima_november.quebec
  • Sort Method: quicksort Memory: 25kB
7. 0.022 7.492 ↓ 0.0 0 1

Hash Left Join (cost=620.990..719.400 rows=87 width=2,902) (actual time=7.492..7.492 rows=0 loops=1)

  • Hash Cond: (lima_november.quebec = romeo_three12.whiskey_delta)
  • Filter: ((yankee_uniform_four((lima_november.seven_golf)::text) ~~ 'xray_india'::text) OR (yankee_uniform_four((lima_november.kilo_kilo)::text) ~~ 'xray_india'::text) OR (yankee_uniform_four((lima_november.six_two)::text) ~~ 'xray_india'::text) OR (yankee_uniform_four((lima_november.victor_charlie)::text) ~~ 'xray_india'::text) OR (yankee_uniform_four((lima_november.oscar_quebec)::text) ~~ 'xray_india'::text) OR (yankee_uniform_four((romeo_three11.hotel_romeo)::text) ~~ 'xray_india'::text) OR (yankee_uniform_four((romeo_three11.oscar_sierra)::text) ~~ 'xray_india'::text) OR (yankee_uniform_four((romeo_three10.oscar_sierra)::text) ~~ 'xray_india'::text) OR (yankee_uniform_four((romeo_three10.hotel_romeo)::text) ~~ 'xray_india'::text) OR (yankee_uniform_four((romeo_three12.victor_charlie)::text) ~~ 'xray_india'::text))
  • Rows Removed by Filter: 1
8. 0.030 7.429 ↑ 260.0 1 1

Hash Right Join (cost=613.590..710.190 rows=260 width=2,977) (actual time=7.378..7.429 rows=1 loops=1)

  • Hash Cond: (romeo_three11.quebec = romeo_three10.mike)
9. 0.111 0.111 ↑ 1.0 200 1

Seq Scan on two six_four (cost=0.000..91.000 rows=200 width=39) (actual time=0.004..0.111 rows=200 loops=1)

10. 0.005 7.288 ↑ 260.0 1 1

Hash (cost=610.340..610.340 rows=260 width=2,946) (actual time=7.288..7.288 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
11. 0.056 7.283 ↑ 260.0 1 1

Hash Right Join (cost=534.100..610.340 rows=260 width=2,946) (actual time=7.266..7.283 rows=1 loops=1)

  • Hash Cond: (romeo_three10.quebec = romeo_three9.yankee_three)
12. 0.150 0.150 ↑ 1.0 655 1

Seq Scan on seven_six tango_echo (cost=0.000..69.550 rows=655 width=48) (actual time=0.002..0.150 rows=655 loops=1)

13. 0.007 7.077 ↑ 260.0 1 1

Hash (cost=530.850..530.850 rows=260 width=2,906) (actual time=7.077..7.077 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
14. 0.061 7.070 ↑ 260.0 1 1

Hash Right Join (cost=507.380..530.850 rows=260 width=2,906) (actual time=7.037..7.070 rows=1 loops=1)

  • Hash Cond: (romeo_three9.zulu_lima = lima_november.quebec)
15. 0.081 0.081 ↑ 1.1 705 1

Seq Scan on india_juliet romeo_zulu_two (cost=0.000..18.760 rows=776 width=8) (actual time=0.003..0.081 rows=705 loops=1)

16. 0.010 6.928 ↑ 260.0 1 1

Hash (cost=504.130..504.130 rows=260 width=2,902) (actual time=6.928..6.928 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
17. 0.057 6.918 ↑ 260.0 1 1

Hash Right Join (cost=427.880..504.130 rows=260 width=2,902) (actual time=6.895..6.918 rows=1 loops=1)

  • Hash Cond: (seven_six.quebec = india_juliet.yankee_three)
18. 0.188 0.188 ↑ 1.0 655 1

Seq Scan on seven_six (cost=0.000..69.550 rows=655 width=25) (actual time=0.004..0.188 rows=655 loops=1)

19. 0.010 6.673 ↑ 260.0 1 1

Hash (cost=424.630..424.630 rows=260 width=2,885) (actual time=6.673..6.673 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
20. 0.059 6.663 ↑ 260.0 1 1

Hash Right Join (cost=401.160..424.630 rows=260 width=2,885) (actual time=6.629..6.663 rows=1 loops=1)

  • Hash Cond: (india_juliet.zulu_lima = lima_november.quebec)
21. 0.082 0.082 ↑ 1.1 705 1

Seq Scan on india_juliet (cost=0.000..18.760 rows=776 width=12) (actual time=0.003..0.082 rows=705 loops=1)

22. 0.005 6.522 ↑ 260.0 1 1

Hash (cost=397.910..397.910 rows=260 width=2,877) (actual time=6.522..6.522 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
23. 0.059 6.517 ↑ 260.0 1 1

Hash Join (cost=373.640..397.910 rows=260 width=2,877) (actual time=6.482..6.517 rows=1 loops=1)

  • Hash Cond: (romeo_three4.zulu_lima = lima_november.quebec)
24. 0.096 0.096 ↑ 1.1 705 1

Seq Scan on india_juliet victor_hotel (cost=0.000..18.760 rows=776 width=4) (actual time=0.005..0.096 rows=705 loops=1)

  • Filter: (quebec five_romeo NOT NULL)
25. 0.011 6.362 ↑ 75.4 5 1

Hash (cost=368.930..368.930 rows=377 width=2,877) (actual time=6.362..6.362 rows=5 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 14kB
26. 3.470 6.351 ↑ 75.4 5 1

Hash Left Join (cost=337.920..368.930 rows=377 width=2,877) (actual time=4.402..6.351 rows=5 loops=1)

  • Hash Cond: (romeo_three6.mike = two.quebec)
  • Filter: ((yankee_uniform_four((lima_november.seven_golf)::text) ~~ 'papa_november'::text) OR (yankee_uniform_four((lima_november.kilo_kilo)::text) ~~ 'papa_november'::text) OR (yankee_uniform_four((lima_november.six_two)::text) ~~ 'papa_november'::text) OR (yankee_uniform_four((lima_november.victor_charlie)::text) ~~ 'papa_november'::text) OR (yankee_uniform_four((lima_november.oscar_quebec)::text) ~~ 'papa_november'::text) OR (yankee_uniform_four((two.hotel_romeo)::text) ~~ 'papa_november'::text) OR (yankee_uniform_four((two.oscar_sierra)::text) ~~ 'papa_november'::text) OR (yankee_uniform_four((romeo_three6.oscar_sierra)::text) ~~ 'papa_november'::text) OR (yankee_uniform_four((romeo_three6.hotel_romeo)::text) ~~ 'papa_november'::text) OR (yankee_uniform_four((tango_hotel_delta.victor_charlie)::text) ~~ 'papa_november'::text))
  • Rows Removed by Filter: 1336
27. 0.262 2.715 ↓ 1.2 1,341 1

Hash Left Join (cost=244.420..272.110 rows=1,124 width=2,953) (actual time=1.723..2.715 rows=1,341 loops=1)

  • Hash Cond: (lima_november.quebec = tango_hotel_delta.whiskey_delta)
28. 0.463 2.412 ↓ 1.1 1,244 1

Hash Right Join (cost=237.030..259.880 rows=1,124 width=2,921) (actual time=1.673..2.412 rows=1,244 loops=1)

  • Hash Cond: (romeo_three5.zulu_lima = lima_november.quebec)
29. 0.186 0.624 ↑ 1.1 705 1

Hash Left Join (cost=77.740..98.550 rows=776 width=48) (actual time=0.337..0.624 rows=705 loops=1)

  • Hash Cond: (romeo_three5.yankee_three = romeo_three6.quebec)
30. 0.113 0.113 ↑ 1.1 705 1

Seq Scan on india_juliet xray_five_kilo (cost=0.000..18.760 rows=776 width=8) (actual time=0.003..0.113 rows=705 loops=1)

31. 0.117 0.325 ↑ 1.0 655 1

Hash (cost=69.550..69.550 rows=655 width=48) (actual time=0.325..0.325 rows=655 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 60kB
32. 0.208 0.208 ↑ 1.0 655 1

Seq Scan on seven_six five_echo (cost=0.000..69.550 rows=655 width=48) (actual time=0.003..0.208 rows=655 loops=1)

33. 0.856 1.325 ↑ 1.0 1,119 1

Hash (cost=145.240..145.240 rows=1,124 width=2,877) (actual time=1.325..1.325 rows=1,119 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 963kB
34. 0.469 0.469 ↑ 1.0 1,119 1

Seq Scan on lima_november (cost=0.000..145.240 rows=1,124 width=2,877) (actual time=0.008..0.469 rows=1,119 loops=1)

35. 0.012 0.041 ↓ 1.2 74 1

Hash (cost=6.620..6.620 rows=62 width=36) (actual time=0.041..0.041 rows=74 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
36. 0.029 0.029 ↓ 1.2 74 1

Seq Scan on tango_hotel_delta (cost=0.000..6.620 rows=62 width=36) (actual time=0.003..0.029 rows=74 loops=1)

37. 0.036 0.166 ↑ 1.0 200 1

Hash (cost=91.000..91.000 rows=200 width=39) (actual time=0.166..0.166 rows=200 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 23kB
38. 0.130 0.130 ↑ 1.0 200 1

Seq Scan on two (cost=0.000..91.000 rows=200 width=39) (actual time=0.008..0.130 rows=200 loops=1)

39. 0.014 0.041 ↓ 1.2 74 1

Hash (cost=6.620..6.620 rows=62 width=36) (actual time=0.040..0.041 rows=74 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
40. 0.027 0.027 ↓ 1.2 74 1

Seq Scan on tango_hotel_delta zulu_juliet (cost=0.000..6.620 rows=62 width=36) (actual time=0.003..0.027 rows=74 loops=1)