explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HdXn

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

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

  • 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. 0.000 0.000 ↓ 0.0

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

  • 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.000 0.000 ↓ 0.0

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

  • Hash Cond: (yankee_hotel.five = six.five)
4. 0.000 0.000 ↓ 0.0

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

  • Hash Cond: (yankee_hotel.yankee_quebec = sierra_delta.quebec_seven)
5. 0.000 0.000 ↓ 0.0

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

6. 0.000 0.000 ↓ 0.0

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

7. 0.000 0.000 ↓ 0.0

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

  • Hash Cond: (hotel_charlie.yankee_quebec = sierra_delta.quebec_seven)
8. 0.000 0.000 ↓ 0.0

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

9. 0.000 0.000 ↓ 0.0

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

10. 0.000 0.000 ↓ 0.0

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

11. 0.000 0.000 ↓ 0.0

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

12. 0.000 0.000 ↓ 0.0

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

13. 0.000 0.000 ↓ 0.0

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

14. 0.000 0.000 ↓ 0.0

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