explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JVxn

Settings
# exclusive inclusive rows x rows loops node
1. 16,697.954 12,422,900.337 ↓ 0.0 0 1

Update on xray_papa romeo_three (cost=5,831,491.550..7,428,707.350 rows=120,536 width=523) (actual time=12,422,900.337..12,422,900.337 rows=0 loops=1)

2. 20,147.171 12,406,202.383 ↑ 1.4 86,663 1

Merge Join (cost=5,831,491.550..7,428,707.350 rows=120,536 width=523) (actual time=121,944.122..12,406,202.383 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
  • Merge Cond: (romeo_three.xray_lima = romeo_quebec.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. 12,354,593.205 12,354,593.205 ↑ 1.0 9,517,839 1

Index Scan using india_four on xray_papa romeo_three (cost=0.570..302,404,355.440 rows=9,680,745 width=273) (actual time=99,112.377..12,354,593.205 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
  • Filter: (romeo_three.juliet = ANY ('kilo_lima'::integer[]))
  • Rows Removed by Filter: 769,791,484
4. 7,968.342 31,462.007 ↑ 1.0 9,616,269 1

Materialize (cost=2,807,219.470..2,855,692.460 rows=9,694,598 width=489) (actual time=19,432.549..31,462.007 rows=9,616,269 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
5. 14,702.579 23,493.665 ↑ 1.0 9,616,269 1

Sort (cost=2,807,219.470..2,831,455.960 rows=9,694,598 width=489) (actual time=19,432.537..23,493.665 rows=9,616,269 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
  • Sort Key: romeo_quebec.xray_lima
  • Sort Method: quicksort Memory: 3,487,473kB
6. 8,791.086 8,791.086 ↑ 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.023..8,791.086 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
Planning time : 4.454 ms
Execution time : 12,438,992.607 ms