explain.depesz.com

PostgreSQL's explain analyze made readable

Result: MhC

Settings
# exclusive inclusive rows x rows loops node
1. 2.919 29.432 ↑ 1.3 695 1

HashAggregate (cost=1,640.63..1,649.51 rows=888 width=333) (actual time=28.404..29.432 rows=695 loops=1)

  • Group Key: six.five, six.kilo_kilo, six.uniform_juliet, six.yankee_delta, six.alpha_india, six.juliet_seven, six.juliet_juliet, yankee_hotel.yankee_quebec, yankee_hotel.five, yankee_hotel.foxtrot_romeo, yankee_hotel.seven_whiskey, yankee_hotel.foxtrot_whiskey, yankee_hotel.uniform_romeo_lima, yankee_hotel.four, yankee_hotel.oscar_six, yankee_hotel.quebec_kilo, sierra_delta.quebec_seven, sierra_delta.victor, kilo_six.yankee_quebec, kilo_six.five, kilo_six.three_six, kilo_six.kilo_quebec, kilo_six.india_alpha, kilo_six.three_sierra, kilo_six.mike_six, kilo_six.romeo_uniform, kilo_six.uniform_sierra, kilo_six.sierra_charlie, kilo_six.three_victor, kilo_six.romeo_victor, kilo_six.two, kilo_six.yankee_yankee, kilo_six.hotel_sierra, kilo_six.xray_three, kilo_six.hotel_delta, kilo_six.alpha_november, kilo_six.november_juliet, kilo_six.sierra_foxtrot, kilo_six.foxtrot_victor, kilo_six.seven_mike, kilo_six.hotel_xray, kilo_six.tango_victor, kilo_six.yankee_echo, kilo_six.india_three, kilo_six.oscar_charlie, hotel_charlie.yankee_quebec, hotel_charlie.delta_six, hotel_charlie.mike_kilo, hotel_charlie.uniform_romeo_xray, hotel_charlie.alpha_mike, hotel_charlie.echo_whiskey, hotel_charlie.juliet_mike, hotel_charlie.papa, hotel_charlie.three_tango, hotel_charlie.november_five, hotel_charlie.echo_foxtrot, hotel_charlie.tango_mike, hotel_charlie.echo_tango
2. 2.363 26.513 ↑ 1.3 695 1

Hash Left Join (cost=570.38..1,511.87 rows=888 width=333) (actual time=22.684..26.513 rows=695 loops=1)

  • Hash Cond: ((yankee_hotel.yankee_quebec = kilo_six.yankee_quebec) AND ((oscar_delta(yankee_hotel.five, 'mike_zulu'::character varying))::text = (oscar_delta(kilo_six.five, 'mike_zulu'::character varying))::text))
3. 0.610 1.958 ↑ 1.0 695 1

Hash Left Join (cost=28.01..64.07 rows=695 width=217) (actual time=0.466..1.958 rows=695 loops=1)

  • Hash Cond: (yankee_hotel.five = six.five)
4. 0.741 1.029 ↑ 1.0 695 1

Hash Left Join (cost=4.66..31.17 rows=695 width=185) (actual time=0.143..1.029 rows=695 loops=1)

  • Hash Cond: (yankee_hotel.yankee_quebec = sierra_delta.quebec_seven)
5. 0.155 0.155 ↑ 1.0 695 1

Seq Scan on uniform_india yankee_hotel (cost=0.00..16.95 rows=695 width=74) (actual time=0.005..0.155 rows=695 loops=1)

6. 0.034 0.133 ↑ 1.0 58 1

Hash (cost=3.93..3.93 rows=58 width=111) (actual time=0.133..0.133 rows=58 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 16kB
7. 0.061 0.099 ↑ 1.0 58 1

Hash Right Join (cost=2.31..3.93 rows=58 width=111) (actual time=0.045..0.099 rows=58 loops=1)

  • Hash Cond: (hotel_charlie.yankee_quebec = sierra_delta.quebec_seven)
8. 0.010 0.010 ↑ 1.0 49 1

Seq Scan on mike_mike hotel_charlie (cost=0.00..1.49 rows=49 width=98) (actual time=0.003..0.010 rows=49 loops=1)

9. 0.017 0.028 ↑ 1.0 58 1

Hash (cost=1.58..1.58 rows=58 width=13) (actual time=0.028..0.028 rows=58 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 11kB
10. 0.011 0.011 ↑ 1.0 58 1

Seq Scan on alpha_uniform sierra_delta (cost=0.00..1.58 rows=58 width=13) (actual time=0.003..0.011 rows=58 loops=1)

11. 0.193 0.319 ↑ 1.0 771 1

Hash (cost=13.71..13.71 rows=771 width=32) (actual time=0.319..0.319 rows=771 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 54kB
12. 0.126 0.126 ↑ 1.0 771 1

Seq Scan on delta_november six (cost=0.00..13.71 rows=771 width=32) (actual time=0.006..0.126 rows=771 loops=1)

13. 19.139 22.192 ↑ 1.0 14,135 1

Hash (cost=330.35..330.35 rows=14,135 width=116) (actual time=22.192..22.192 rows=14,135 loops=1)

  • Buckets: 16,384 Batches: 1 Memory Usage: 1,659kB
14. 3.053 3.053 ↑ 1.0 14,135 1

Seq Scan on xray_kilo kilo_six (cost=0.00..330.35 rows=14,135 width=116) (actual time=0.008..3.053 rows=14,135 loops=1)

Planning time : 6.239 ms
Execution time : 29.739 ms