explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vtLe

Settings
# exclusive inclusive rows x rows loops node
1. 17,685.338 165,954.131 ↓ 0.0 0 1

Update on xray_papa romeo_three (cost=7,180,400.610..8,589,469.200 rows=120,536 width=523) (actual time=165,954.131..165,954.131 rows=0 loops=1)

2. 15,307.763 148,268.793 ↑ 1.4 86,663 1

Hash Join (cost=7,180,400.610..8,589,469.200 rows=120,536 width=523) (actual time=124,181.711..148,268.793 rows=86,663 loops=1)

  • Output: romeo_three.xray_lima, romeo_quebec.four_mike, romeo_quebec.juliet, romeo_quebec.three_three, NULL::integer, NULL::integer, romeo_quebec.yankee, romeo_quebec.two_romeo, romeo_quebec.papa, romeo_quebec.whiskey_six, romeo_quebec.three_november, romeo_quebec.india_bravo, romeo_quebec.three_uniform, romeo_quebec.six_kilo, romeo_quebec.seven, romeo_quebec.victor_lima, romeo_quebec.lima, romeo_quebec.mike_zulu_seven, NULL::integer, romeo_quebec.bravo_juliet, romeo_quebec.hotel_bravo, romeo_quebec.india_papa, romeo_quebec.delta_yankee, romeo_quebec.mike_zulu_five, romeo_quebec.four_november, romeo_quebec.victor_victor, romeo_quebec.november_whiskey, romeo_quebec.six_whiskey, romeo_quebec.tango_zulu, romeo_quebec.five_victor, romeo_quebec.two_lima, romeo_quebec.alpha, romeo_quebec.hotel_alpha, romeo_quebec.bravo_alpha, romeo_quebec.victor_xray, romeo_quebec.whiskey_sierra, romeo_quebec.november_sierra, romeo_quebec.four_sierra, romeo_three.kilo_echo, romeo_three.six_foxtrot, romeo_quebec.bravo_quebec, romeo_quebec.delta_tango, romeo_quebec.tango_india, romeo_three.foxtrot, romeo_quebec.foxtrot
  • Inner Unique: true
  • Hash Cond: (romeo_quebec.xray_lima = romeo_three.xray_lima)
  • Join Filter: ((romeo_three.juliet five_romeo DISTINCT FROM romeo_quebec.juliet) OR (romeo_three.three_three five_romeo DISTINCT FROM romeo_quebec.three_three) OR (romeo_three.yankee five_romeo DISTINCT FROM romeo_quebec.yankee) OR (romeo_three.two_romeo five_romeo DISTINCT FROM romeo_quebec.two_romeo) OR ((romeo_three.papa)::text five_romeo DISTINCT FROM (romeo_quebec.papa)::text) OR ((romeo_three.whiskey_six)::text five_romeo DISTINCT FROM (romeo_quebec.whiskey_six)::text) OR (romeo_three.three_november five_romeo DISTINCT FROM romeo_quebec.three_november) OR (romeo_three.india_bravo five_romeo DISTINCT FROM romeo_quebec.india_bravo) OR (romeo_three.three_uniform five_romeo DISTINCT FROM romeo_quebec.three_uniform) OR (romeo_three.seven five_romeo DISTINCT FROM romeo_quebec.seven) OR (romeo_three.victor_lima five_romeo DISTINCT FROM romeo_quebec.victor_lima) OR (romeo_three.lima five_romeo DISTINCT FROM romeo_quebec.lima) OR (romeo_three.mike_zulu_seven five_romeo DISTINCT FROM romeo_quebec.mike_zulu_seven) OR ((romeo_three.bravo_juliet)::text five_romeo DISTINCT FROM (romeo_quebec.bravo_juliet)::text) OR (romeo_three.hotel_bravo five_romeo DISTINCT FROM romeo_quebec.hotel_bravo) OR ((romeo_three.india_papa)::text five_romeo DISTINCT FROM (romeo_quebec.india_papa)::text) OR (romeo_three.delta_yankee five_romeo DISTINCT FROM romeo_quebec.delta_yankee) OR (romeo_three.mike_zulu_five five_romeo DISTINCT FROM romeo_quebec.mike_zulu_five) OR (romeo_three.four_november five_romeo DISTINCT FROM romeo_quebec.four_november) OR (romeo_three.victor_victor five_romeo DISTINCT FROM romeo_quebec.victor_victor) OR (romeo_three.november_whiskey five_romeo DISTINCT FROM romeo_quebec.november_whiskey) OR (romeo_three.six_whiskey five_romeo DISTINCT FROM romeo_quebec.six_whiskey) OR ((romeo_three.tango_zulu)::text five_romeo DISTINCT FROM (romeo_quebec.tango_zulu)::text) OR (romeo_three.five_victor five_romeo DISTINCT FROM romeo_quebec.five_victor) OR ((romeo_three.two_lima)::text five_romeo DISTINCT FROM (romeo_quebec.two_lima)::text) OR (romeo_three.alpha five_romeo DISTINCT FROM romeo_quebec.alpha) OR (romeo_three.hotel_alpha five_romeo DISTINCT FROM romeo_quebec.hotel_alpha) OR (romeo_three.bravo_alpha five_romeo DISTINCT FROM romeo_quebec.bravo_alpha) OR (romeo_three.victor_xray five_romeo DISTINCT FROM romeo_quebec.victor_xray) OR (romeo_three.whiskey_sierra five_romeo DISTINCT FROM romeo_quebec.whiskey_sierra) OR (romeo_three.november_sierra five_romeo DISTINCT FROM romeo_quebec.november_sierra) OR (romeo_three.four_sierra five_romeo DISTINCT FROM romeo_quebec.four_sierra) OR (romeo_three.four_mike five_romeo DISTINCT FROM romeo_quebec.four_mike) OR (romeo_three.six_kilo five_romeo DISTINCT FROM romeo_quebec.six_kilo) OR (romeo_three.bravo_quebec five_romeo DISTINCT FROM romeo_quebec.bravo_quebec) OR (romeo_three.delta_tango five_romeo DISTINCT FROM romeo_quebec.delta_tango) OR (romeo_three.tango_india five_romeo DISTINCT FROM romeo_quebec.tango_india))
  • Rows Removed by Join Filter: 9,431,176
3. 11,336.385 11,336.385 ↑ 1.0 9,692,217 1

Seq Scan on oscar romeo_quebec (cost=0.000..389,923.980 rows=9,694,598 width=489) (actual time=0.762..11,336.385 rows=9,692,217 loops=1)

  • Output: romeo_quebec.four_mike, romeo_quebec.juliet, romeo_quebec.three_three, romeo_quebec.yankee, romeo_quebec.two_romeo, romeo_quebec.papa, romeo_quebec.whiskey_six, romeo_quebec.three_november, romeo_quebec.india_bravo, romeo_quebec.three_uniform, romeo_quebec.six_kilo, romeo_quebec.seven, romeo_quebec.victor_lima, romeo_quebec.lima, romeo_quebec.mike_zulu_seven, romeo_quebec.bravo_juliet, romeo_quebec.hotel_bravo, romeo_quebec.india_papa, romeo_quebec.delta_yankee, romeo_quebec.mike_zulu_five, romeo_quebec.four_november, romeo_quebec.victor_victor, romeo_quebec.november_whiskey, romeo_quebec.six_whiskey, romeo_quebec.tango_zulu, romeo_quebec.five_victor, romeo_quebec.two_lima, romeo_quebec.alpha, romeo_quebec.hotel_alpha, romeo_quebec.bravo_alpha, romeo_quebec.victor_xray, romeo_quebec.whiskey_sierra, romeo_quebec.november_sierra, romeo_quebec.four_sierra, romeo_quebec.bravo_quebec, romeo_quebec.delta_tango, romeo_quebec.tango_india, romeo_quebec.foxtrot, romeo_quebec.xray_lima
4. 10,887.141 121,624.645 ↑ 1.0 9,517,839 1

Hash (cost=7,059,391.300..7,059,391.300 rows=9,680,745 width=273) (actual time=121,624.645..121,624.645 rows=9,517,839 loops=1)

  • Output: romeo_three.xray_lima, romeo_three.kilo_echo, romeo_three.six_foxtrot, romeo_three.foxtrot, romeo_three.juliet, romeo_three.three_three, romeo_three.yankee, romeo_three.two_romeo, romeo_three.papa, romeo_three.whiskey_six, romeo_three.three_november, romeo_three.india_bravo, romeo_three.three_uniform, romeo_three.seven, romeo_three.victor_lima, romeo_three.lima, romeo_three.mike_zulu_seven, romeo_three.bravo_juliet, romeo_three.hotel_bravo, romeo_three.india_papa, romeo_three.delta_yankee, romeo_three.mike_zulu_five, romeo_three.four_november, romeo_three.victor_victor, romeo_three.november_whiskey, romeo_three.six_whiskey, romeo_three.tango_zulu, romeo_three.five_victor, romeo_three.two_lima, romeo_three.alpha, romeo_three.hotel_alpha, romeo_three.bravo_alpha, romeo_three.victor_xray, romeo_three.whiskey_sierra, romeo_three.november_sierra, romeo_three.four_sierra, romeo_three.four_mike, romeo_three.six_kilo, romeo_three.bravo_quebec, romeo_three.delta_tango, romeo_three.tango_india
  • Buckets: 16,777,216 Batches: 1 Memory Usage: 2,569,872kB
5. 110,737.504 110,737.504 ↑ 1.0 9,517,839 1

Index Scan using victor_four on xray_papa romeo_three (cost=0.570..7,059,391.300 rows=9,680,745 width=273) (actual time=2.866..110,737.504 rows=9,517,839 loops=1)

  • Output: romeo_three.xray_lima, romeo_three.kilo_echo, romeo_three.six_foxtrot, romeo_three.foxtrot, romeo_three.juliet, romeo_three.three_three, romeo_three.yankee, romeo_three.two_romeo, romeo_three.papa, romeo_three.whiskey_six, romeo_three.three_november, romeo_three.india_bravo, romeo_three.three_uniform, romeo_three.seven, romeo_three.victor_lima, romeo_three.lima, romeo_three.mike_zulu_seven, romeo_three.bravo_juliet, romeo_three.hotel_bravo, romeo_three.india_papa, romeo_three.delta_yankee, romeo_three.mike_zulu_five, romeo_three.four_november, romeo_three.victor_victor, romeo_three.november_whiskey, romeo_three.six_whiskey, romeo_three.tango_zulu, romeo_three.five_victor, romeo_three.two_lima, romeo_three.alpha, romeo_three.hotel_alpha, romeo_three.bravo_alpha, romeo_three.victor_xray, romeo_three.whiskey_sierra, romeo_three.november_sierra, romeo_three.four_sierra, romeo_three.four_mike, romeo_three.six_kilo, romeo_three.bravo_quebec, romeo_three.delta_tango, romeo_three.tango_india
  • Index Cond: (romeo_three.juliet = ANY ('kilo_lima'::integer[]))
Planning time : 4.448 ms
Execution time : 166,961.955 ms