explain.depesz.com

PostgreSQL's explain analyze made readable

Result: zjp : watman

Settings
# exclusive inclusive rows x rows loops node
1. 0.007 38,960.698 ↑ 52.2 23 1

Limit (cost=4.450..821,645.540 rows=1,200 width=368) (actual time=179.868..38,960.698 rows=23 loops=1)

  • Output: six_papa.quebec_seven, six_papa.foxtrot_three, six_papa.four_charlie, six_papa.lima_romeo, six_papa.tango_india_xray, six_papa.tango_sierra, six_papa.romeo_juliet_three, six_papa.xray_uniform, six_papa.zulu_foxtrot, six_papa.juliet_quebec, foxtrot_whiskey.november_lima_uniform, foxtrot_whiskey.kilo_oscar_yankee, six_papa.hotel_quebec, papa_yankee.november_lima_uniform, whiskey_juliet.kilo_oscar_yankee, whiskey_juliet.november_lima_uniform, whiskey_juliet.india_india, whiskey_juliet.yankee_mike, whiskey_juliet.foxtrot_romeo, whiskey_juliet.romeo_zulu, romeo_three11.november_lima_uniform, romeo_three12.november_lima_uniform, tango_seven.kilo_oscar_yankee, tango_seven.november_lima_uniform, whiskey_juliet.foxtrot_oscar, six_papa.uniform_golf, golf_kilo.november_lima_uniform, tango_india_november.victor_seven, golf_kilo.victor_yankee, tango_india_november.november_lima_uniform, tango_india_november.india_mike_hotel, tango_india_november.papa_juliet, six_papa.hotel_echo, tango_india_november.kilo_mike, tango_india_november.november_lima_echo, tango_india_november.india_seven, six_papa.lima_zulu, romeo_quebec_victor.kilo_oscar_yankee, romeo_quebec_victor.november_lima_uniform, november_alpha.kilo_oscar_yankee, november_alpha.november_lima_uniform, sierra_zulu.kilo_papa, six_papa.kilo_zulu, six_papa.foxtrot_bravo, six_papa.romeo_juliet_whiskey, six_papa.kilo_november, six_papa.lima_oscar, six_foxtrot.november_lima_uniform, romeo_three17.november_lima_uniform, foxtrot_whiskey.romeo_lima, ((three_delta_three: delta_four 1 or mike_mike delta_four 2)), ((delta_four 3)), ((delta_four 4)), (CASE WHEN (six_papa.hotel_echo five_romeo NOT NULL) THEN tango_india_november.six_zulu ELSE romeo_quebec_victor.bravo_xray END), ((delta_four 5)), ((delta_four 7)), ((delta_four 9)), (CASE WHEN (six_papa.hotel_echo five_romeo NULL) THEN NULL::interval WHEN (NOT tango_india_november.kilo_mike) THEN NULL::interval WHEN (((tango_india_november.six_zulu)::text <> 'xray_tango'::text) OR (tango_india_november.six_zulu five_romeo NULL)) THEN NULL::interval WHEN (six_papa.four_charlie five_romeo NULL) THEN NULL::interval WHEN (six_papa.tango_india_xray five_romeo NULL) THEN NULL::interval ELSE ((six_papa.lima_romeo + six_papa.tango_india_xray) - (six_papa.foxtrot_three + six_papa.four_charlie)) END), (CASE WHEN (CASE WHEN (six_papa.hotel_echo five_romeo NULL) THEN NULL::interval WHEN (NOT tango_india_november.kilo_mike) THEN NULL::interval WHEN (((tango_india_november.six_zulu)::text <> 'xray_tango'::text) OR (tango_india_november.six_zulu five_romeo NULL)) THEN NULL::interval WHEN (six_papa.four_charlie five_romeo NULL) THEN NULL::interval WHEN (six_papa.tango_india_xray five_romeo NULL) THEN NULL::interval ELSE ((six_papa.lima_romeo + six_papa.tango_india_xray) - (six_papa.foxtrot_three + six_papa.four_charlie)) END five_romeo NULL) THEN NULL::double precision WHEN (six_papa.four_charlie five_romeo NULL) THEN 'november_golf'::double precision WHEN (six_papa.tango_india_xray five_romeo NULL) THEN 'november_golf'::double precision ELSE ((echo_tango('uniform_whiskey'::text, CASE WHEN (six_papa.hotel_echo five_romeo NULL) THEN NULL::interval WHEN (NOT tango_india_november.kilo_mike) THEN NULL::interval WHEN (((tango_india_november.six_zulu)::text <> 'xray_tango'::text) OR (tango_india_november.six_zulu five_romeo NULL)) THEN NULL::interval WHEN (six_papa.four_charlie five_romeo NULL) THEN NULL::interval WHEN (six_papa.tango_india_xray five_romeo NULL) THEN NULL::interval ELSE ((six_papa.lima_romeo + six_papa.tango_india_xray) - (six_papa.foxtrot_three + six_papa.four_charlie)) END) / 'mike_kilo'::double precision) - (six_papa.tango_sierra)::double precision) END), (CASE WHEN ((delta_four 10) <> 'november_golf'::numeric) THEN (six_papa.tango_sierra * (delta_four 11)) WHEN ((delta_four 12) <> 'november_golf'::numeric) THEN (six_papa.tango_sierra * (delta_four 13)) WHEN ((delta_four 14) <> 'november_golf'::numeric) THEN (six_papa.tango_sierra * (delta_four 15)) WHEN ((delta_four 16) <> 'november_golf'::numeric) THEN (six_papa.tango_sierra * (delta_four 17)) WHEN ((delta_four 18) <> 'november_golf'::numeric) THEN (six_papa.tango_sierra * (delta_four 19)) ELSE 'november_golf'::numeric END)
2. 56.476 38,960.691 ↑ 2,138.9 23 1

Nested Loop Left Join (cost=4.450..33,683,180.910 rows=49,194 width=368) (actual time=179.867..38,960.691 rows=23 loops=1)

  • Output: six_papa.quebec_seven, six_papa.foxtrot_three, six_papa.four_charlie, six_papa.lima_romeo, six_papa.tango_india_xray, six_papa.tango_sierra, six_papa.romeo_juliet_three, six_papa.xray_uniform, six_papa.zulu_foxtrot, six_papa.juliet_quebec, foxtrot_whiskey.november_lima_uniform, foxtrot_whiskey.kilo_oscar_yankee, six_papa.hotel_quebec, papa_yankee.november_lima_uniform, whiskey_juliet.kilo_oscar_yankee, whiskey_juliet.november_lima_uniform, whiskey_juliet.india_india, whiskey_juliet.yankee_mike, whiskey_juliet.foxtrot_romeo, whiskey_juliet.romeo_zulu, romeo_three11.november_lima_uniform, romeo_three12.november_lima_uniform, tango_seven.kilo_oscar_yankee, tango_seven.november_lima_uniform, whiskey_juliet.foxtrot_oscar, six_papa.uniform_golf, golf_kilo.november_lima_uniform, tango_india_november.victor_seven, golf_kilo.victor_yankee, tango_india_november.november_lima_uniform, tango_india_november.india_mike_hotel, tango_india_november.papa_juliet, six_papa.hotel_echo, tango_india_november.kilo_mike, tango_india_november.november_lima_echo, tango_india_november.india_seven, six_papa.lima_zulu, romeo_quebec_victor.kilo_oscar_yankee, romeo_quebec_victor.november_lima_uniform, november_alpha.kilo_oscar_yankee, november_alpha.november_lima_uniform, sierra_zulu.kilo_papa, six_papa.kilo_zulu, six_papa.foxtrot_bravo, six_papa.romeo_juliet_whiskey, six_papa.kilo_november, six_papa.lima_oscar, six_foxtrot.november_lima_uniform, romeo_three17.november_lima_uniform, foxtrot_whiskey.romeo_lima, (three_delta_three: delta_four 1 or mike_mike delta_four 2), (delta_four 3), (delta_four 4), CASE WHEN (six_papa.hotel_echo five_romeo NOT NULL) THEN tango_india_november.six_zulu ELSE romeo_quebec_victor.bravo_xray END, (delta_four 5), (delta_four 7), (delta_four 9), CASE WHEN (six_papa.hotel_echo five_romeo NULL) THEN NULL::interval WHEN (NOT tango_india_november.kilo_mike) THEN NULL::interval WHEN (((tango_india_november.six_zulu)::text <> 'xray_tango'::text) OR (tango_india_november.six_zulu five_romeo NULL)) THEN NULL::interval WHEN (six_papa.four_charlie five_romeo NULL) THEN NULL::interval WHEN (six_papa.tango_india_xray five_romeo NULL) THEN NULL::interval ELSE ((six_papa.lima_romeo + six_papa.tango_india_xray) - (six_papa.foxtrot_three + six_papa.four_charlie)) END, CASE WHEN (CASE WHEN (six_papa.hotel_echo five_romeo NULL) THEN NULL::interval WHEN (NOT tango_india_november.kilo_mike) THEN NULL::interval WHEN (((tango_india_november.six_zulu)::text <> 'xray_tango'::text) OR (tango_india_november.six_zulu five_romeo NULL)) THEN NULL::interval WHEN (six_papa.four_charlie five_romeo NULL) THEN NULL::interval WHEN (six_papa.tango_india_xray five_romeo NULL) THEN NULL::interval ELSE ((six_papa.lima_romeo + six_papa.tango_india_xray) - (six_papa.foxtrot_three + six_papa.four_charlie)) END five_romeo NULL) THEN NULL::double precision WHEN (six_papa.four_charlie five_romeo NULL) THEN 'november_golf'::double precision WHEN (six_papa.tango_india_xray five_romeo NULL) THEN 'november_golf'::double precision ELSE ((echo_tango('uniform_whiskey'::text, CASE WHEN (six_papa.hotel_echo five_romeo NULL) THEN NULL::interval WHEN (NOT tango_india_november.kilo_mike) THEN NULL::interval WHEN (((tango_india_november.six_zulu)::text <> 'xray_tango'::text) OR (tango_india_november.six_zulu five_romeo NULL)) THEN NULL::interval WHEN (six_papa.four_charlie five_romeo NULL) THEN NULL::interval WHEN (six_papa.tango_india_xray five_romeo NULL) THEN NULL::interval ELSE ((six_papa.lima_romeo + six_papa.tango_india_xray) - (six_papa.foxtrot_three + six_papa.four_charlie)) END) / 'mike_kilo'::double precision) - (six_papa.tango_sierra)::double precision) END, CASE WHEN ((delta_four 10) <> 'november_golf'::numeric) THEN (six_papa.tango_sierra * (delta_four 11)) WHEN ((delta_four 12) <> 'november_golf'::numeric) THEN (six_papa.tango_sierra * (delta_four 13)) WHEN ((delta_four 14) <> 'november_golf'::numeric) THEN (six_papa.tango_sierra * (delta_four 15)) WHEN ((delta_four 16) <> 'november_golf'::numeric) THEN (six_papa.tango_sierra * (delta_four 17)) WHEN ((delta_four 18) <> 'november_golf'::numeric) THEN (six_papa.tango_sierra * (delta_four 19)) ELSE 'november_golf'::numeric END
3. 0.057 38,829.200 ↑ 2,138.9 23 1

Nested Loop Left Join (cost=4.300..5,069,036.310 rows=49,194 width=361) (actual time=50.880..38,829.200 rows=23 loops=1)

  • Output: six_papa.quebec_seven, six_papa.foxtrot_three, six_papa.four_charlie, six_papa.lima_romeo, six_papa.tango_india_xray, six_papa.tango_sierra, six_papa.romeo_juliet_three, six_papa.xray_uniform, six_papa.zulu_foxtrot, six_papa.juliet_quebec, six_papa.hotel_quebec, six_papa.uniform_golf, six_papa.hotel_echo, six_papa.lima_zulu, six_papa.kilo_zulu, six_papa.foxtrot_bravo, six_papa.romeo_juliet_whiskey, six_papa.kilo_november, six_papa.lima_oscar, six_papa.alpha_victor, six_papa.charlie_seven_bravo, foxtrot_whiskey.november_lima_uniform, foxtrot_whiskey.kilo_oscar_yankee, foxtrot_whiskey.romeo_lima, foxtrot_whiskey.tango_india_romeo, tango_india_november.victor_seven, tango_india_november.november_lima_uniform, tango_india_november.india_mike_hotel, tango_india_november.papa_juliet, tango_india_november.kilo_mike, tango_india_november.november_lima_echo, tango_india_november.india_seven, tango_india_november.six_zulu, romeo_quebec_victor.kilo_oscar_yankee, romeo_quebec_victor.november_lima_uniform, romeo_quebec_victor.bravo_xray, whiskey_juliet.kilo_oscar_yankee, whiskey_juliet.november_lima_uniform, whiskey_juliet.india_india, whiskey_juliet.yankee_mike, whiskey_juliet.foxtrot_romeo, whiskey_juliet.romeo_zulu, whiskey_juliet.foxtrot_oscar, golf_kilo.november_lima_uniform, golf_kilo.victor_yankee, papa_yankee.november_lima_uniform, romeo_three11.november_lima_uniform, romeo_three12.november_lima_uniform, tango_seven.kilo_oscar_yankee, tango_seven.november_lima_uniform, november_alpha.kilo_oscar_yankee, november_alpha.november_lima_uniform, sierra_zulu.kilo_papa, six_foxtrot.november_lima_uniform
4. 0.046 38,829.143 ↑ 2,138.9 23 1

Nested Loop Left Join (cost=4.160..5,060,673.090 rows=49,194 width=354) (actual time=50.874..38,829.143 rows=23 loops=1)

  • Output: six_papa.quebec_seven, six_papa.foxtrot_three, six_papa.four_charlie, six_papa.lima_romeo, six_papa.tango_india_xray, six_papa.tango_sierra, six_papa.romeo_juliet_three, six_papa.xray_uniform, six_papa.zulu_foxtrot, six_papa.juliet_quebec, six_papa.hotel_quebec, six_papa.uniform_golf, six_papa.hotel_echo, six_papa.lima_zulu, six_papa.kilo_zulu, six_papa.foxtrot_bravo, six_papa.romeo_juliet_whiskey, six_papa.kilo_november, six_papa.lima_oscar, six_papa.alpha_victor, six_papa.charlie_seven_bravo, foxtrot_whiskey.november_lima_uniform, foxtrot_whiskey.kilo_oscar_yankee, foxtrot_whiskey.romeo_lima, foxtrot_whiskey.tango_india_romeo, tango_india_november.victor_seven, tango_india_november.november_lima_uniform, tango_india_november.india_mike_hotel, tango_india_november.papa_juliet, tango_india_november.kilo_mike, tango_india_november.november_lima_echo, tango_india_november.india_seven, tango_india_november.six_zulu, romeo_quebec_victor.kilo_oscar_yankee, romeo_quebec_victor.november_lima_uniform, romeo_quebec_victor.bravo_xray, whiskey_juliet.kilo_oscar_yankee, whiskey_juliet.november_lima_uniform, whiskey_juliet.india_india, whiskey_juliet.yankee_mike, whiskey_juliet.foxtrot_romeo, whiskey_juliet.romeo_zulu, whiskey_juliet.foxtrot_oscar, whiskey_juliet.tango_india_romeo, golf_kilo.november_lima_uniform, golf_kilo.victor_yankee, papa_yankee.november_lima_uniform, romeo_three11.november_lima_uniform, romeo_three12.november_lima_uniform, tango_seven.kilo_oscar_yankee, tango_seven.november_lima_uniform, november_alpha.kilo_oscar_yankee, november_alpha.november_lima_uniform, sierra_zulu.kilo_papa
5. 0.054 38,829.005 ↑ 2,138.9 23 1

Nested Loop Left Join (cost=3.870..5,045,050.280 rows=49,194 width=353) (actual time=50.863..38,829.005 rows=23 loops=1)

  • Output: six_papa.quebec_seven, six_papa.foxtrot_three, six_papa.four_charlie, six_papa.lima_romeo, six_papa.tango_india_xray, six_papa.tango_sierra, six_papa.romeo_juliet_three, six_papa.xray_uniform, six_papa.zulu_foxtrot, six_papa.juliet_quebec, six_papa.hotel_quebec, six_papa.uniform_golf, six_papa.hotel_echo, six_papa.lima_zulu, six_papa.kilo_zulu, six_papa.foxtrot_bravo, six_papa.romeo_juliet_whiskey, six_papa.kilo_november, six_papa.lima_oscar, six_papa.alpha_victor, six_papa.charlie_seven_bravo, foxtrot_whiskey.november_lima_uniform, foxtrot_whiskey.kilo_oscar_yankee, foxtrot_whiskey.romeo_lima, foxtrot_whiskey.tango_india_romeo, tango_india_november.victor_seven, tango_india_november.november_lima_uniform, tango_india_november.india_mike_hotel, tango_india_november.papa_juliet, tango_india_november.kilo_mike, tango_india_november.november_lima_echo, tango_india_november.india_seven, tango_india_november.six_zulu, romeo_quebec_victor.kilo_oscar_yankee, romeo_quebec_victor.november_lima_uniform, romeo_quebec_victor.bravo_xray, whiskey_juliet.kilo_oscar_yankee, whiskey_juliet.november_lima_uniform, whiskey_juliet.india_india, whiskey_juliet.yankee_mike, whiskey_juliet.foxtrot_romeo, whiskey_juliet.romeo_zulu, whiskey_juliet.foxtrot_oscar, whiskey_juliet.tango_india_romeo, golf_kilo.november_lima_uniform, golf_kilo.victor_yankee, papa_yankee.november_lima_uniform, romeo_three11.november_lima_uniform, romeo_three12.november_lima_uniform, tango_seven.kilo_oscar_yankee, tango_seven.november_lima_uniform, november_alpha.kilo_oscar_yankee, november_alpha.november_lima_uniform
6. 0.075 38,828.951 ↑ 2,138.9 23 1

Nested Loop Left Join (cost=3.580..5,029,427.960 rows=49,194 width=343) (actual time=50.860..38,828.951 rows=23 loops=1)

  • Output: six_papa.quebec_seven, six_papa.foxtrot_three, six_papa.four_charlie, six_papa.lima_romeo, six_papa.tango_india_xray, six_papa.tango_sierra, six_papa.romeo_juliet_three, six_papa.xray_uniform, six_papa.zulu_foxtrot, six_papa.juliet_quebec, six_papa.hotel_quebec, six_papa.uniform_golf, six_papa.hotel_echo, six_papa.lima_zulu, six_papa.kilo_zulu, six_papa.foxtrot_bravo, six_papa.romeo_juliet_whiskey, six_papa.kilo_november, six_papa.lima_oscar, six_papa.alpha_victor, six_papa.charlie_seven_bravo, foxtrot_whiskey.november_lima_uniform, foxtrot_whiskey.kilo_oscar_yankee, foxtrot_whiskey.romeo_lima, foxtrot_whiskey.tango_india_romeo, tango_india_november.victor_seven, tango_india_november.november_lima_uniform, tango_india_november.india_mike_hotel, tango_india_november.papa_juliet, tango_india_november.kilo_mike, tango_india_november.november_lima_echo, tango_india_november.india_seven, tango_india_november.six_zulu, romeo_quebec_victor.kilo_oscar_yankee, romeo_quebec_victor.november_lima_uniform, romeo_quebec_victor.bravo_xray, romeo_quebec_victor.romeo_quebec_bravo, whiskey_juliet.kilo_oscar_yankee, whiskey_juliet.november_lima_uniform, whiskey_juliet.india_india, whiskey_juliet.yankee_mike, whiskey_juliet.foxtrot_romeo, whiskey_juliet.romeo_zulu, whiskey_juliet.foxtrot_oscar, whiskey_juliet.tango_india_romeo, golf_kilo.november_lima_uniform, golf_kilo.victor_yankee, papa_yankee.november_lima_uniform, romeo_three11.november_lima_uniform, romeo_three12.november_lima_uniform, tango_seven.kilo_oscar_yankee, tango_seven.november_lima_uniform
7. 0.051 38,828.761 ↑ 2,138.9 23 1

Nested Loop Left Join (cost=3.160..5,006,091.460 rows=49,194 width=322) (actual time=50.848..38,828.761 rows=23 loops=1)

  • Output: six_papa.quebec_seven, six_papa.foxtrot_three, six_papa.four_charlie, six_papa.lima_romeo, six_papa.tango_india_xray, six_papa.tango_sierra, six_papa.romeo_juliet_three, six_papa.xray_uniform, six_papa.zulu_foxtrot, six_papa.juliet_quebec, six_papa.hotel_quebec, six_papa.uniform_golf, six_papa.hotel_echo, six_papa.lima_zulu, six_papa.kilo_zulu, six_papa.foxtrot_bravo, six_papa.romeo_juliet_whiskey, six_papa.kilo_november, six_papa.lima_oscar, six_papa.alpha_victor, six_papa.charlie_seven_bravo, foxtrot_whiskey.november_lima_uniform, foxtrot_whiskey.kilo_oscar_yankee, foxtrot_whiskey.romeo_lima, foxtrot_whiskey.tango_india_romeo, tango_india_november.victor_seven, tango_india_november.november_lima_uniform, tango_india_november.india_mike_hotel, tango_india_november.papa_juliet, tango_india_november.kilo_mike, tango_india_november.november_lima_echo, tango_india_november.india_seven, tango_india_november.six_zulu, romeo_quebec_victor.kilo_oscar_yankee, romeo_quebec_victor.november_lima_uniform, romeo_quebec_victor.bravo_xray, romeo_quebec_victor.romeo_quebec_bravo, whiskey_juliet.kilo_oscar_yankee, whiskey_juliet.november_lima_uniform, whiskey_juliet.india_india, whiskey_juliet.yankee_mike, whiskey_juliet.foxtrot_romeo, whiskey_juliet.romeo_zulu, whiskey_juliet.foxtrot_oscar, whiskey_juliet.uniform_six, whiskey_juliet.tango_india_romeo, golf_kilo.november_lima_uniform, golf_kilo.victor_yankee, papa_yankee.november_lima_uniform, romeo_three11.november_lima_uniform, romeo_three12.november_lima_uniform
8. 0.055 38,828.710 ↑ 2,138.9 23 1

Nested Loop Left Join (cost=2.870..4,990,405.930 rows=49,194 width=310) (actual time=50.845..38,828.710 rows=23 loops=1)

  • Output: six_papa.quebec_seven, six_papa.foxtrot_three, six_papa.four_charlie, six_papa.lima_romeo, six_papa.tango_india_xray, six_papa.tango_sierra, six_papa.romeo_juliet_three, six_papa.xray_uniform, six_papa.zulu_foxtrot, six_papa.juliet_quebec, six_papa.hotel_quebec, six_papa.uniform_golf, six_papa.hotel_echo, six_papa.lima_zulu, six_papa.kilo_zulu, six_papa.foxtrot_bravo, six_papa.romeo_juliet_whiskey, six_papa.kilo_november, six_papa.lima_oscar, six_papa.alpha_victor, six_papa.charlie_seven_bravo, foxtrot_whiskey.november_lima_uniform, foxtrot_whiskey.kilo_oscar_yankee, foxtrot_whiskey.romeo_lima, foxtrot_whiskey.tango_india_romeo, tango_india_november.victor_seven, tango_india_november.november_lima_uniform, tango_india_november.india_mike_hotel, tango_india_november.papa_juliet, tango_india_november.kilo_mike, tango_india_november.november_lima_echo, tango_india_november.india_seven, tango_india_november.six_zulu, romeo_quebec_victor.kilo_oscar_yankee, romeo_quebec_victor.november_lima_uniform, romeo_quebec_victor.bravo_xray, romeo_quebec_victor.romeo_quebec_bravo, whiskey_juliet.kilo_oscar_yankee, whiskey_juliet.november_lima_uniform, whiskey_juliet.india_india, whiskey_juliet.yankee_mike, whiskey_juliet.foxtrot_romeo, whiskey_juliet.romeo_zulu, whiskey_juliet.foxtrot_oscar, whiskey_juliet.kilo_tango, whiskey_juliet.uniform_six, whiskey_juliet.tango_india_romeo, golf_kilo.november_lima_uniform, golf_kilo.victor_yankee, papa_yankee.november_lima_uniform, romeo_three11.november_lima_uniform
9. 0.048 38,828.586 ↑ 2,138.9 23 1

Nested Loop Left Join (cost=2.580..4,974,720.400 rows=49,194 width=298) (actual time=50.837..38,828.586 rows=23 loops=1)

  • Output: six_papa.quebec_seven, six_papa.foxtrot_three, six_papa.four_charlie, six_papa.lima_romeo, six_papa.tango_india_xray, six_papa.tango_sierra, six_papa.romeo_juliet_three, six_papa.xray_uniform, six_papa.zulu_foxtrot, six_papa.juliet_quebec, six_papa.hotel_quebec, six_papa.uniform_golf, six_papa.hotel_echo, six_papa.lima_zulu, six_papa.kilo_zulu, six_papa.foxtrot_bravo, six_papa.romeo_juliet_whiskey, six_papa.kilo_november, six_papa.lima_oscar, six_papa.alpha_victor, six_papa.charlie_seven_bravo, foxtrot_whiskey.november_lima_uniform, foxtrot_whiskey.kilo_oscar_yankee, foxtrot_whiskey.romeo_lima, foxtrot_whiskey.tango_india_romeo, tango_india_november.victor_seven, tango_india_november.november_lima_uniform, tango_india_november.india_mike_hotel, tango_india_november.papa_juliet, tango_india_november.kilo_mike, tango_india_november.november_lima_echo, tango_india_november.india_seven, tango_india_november.six_zulu, romeo_quebec_victor.kilo_oscar_yankee, romeo_quebec_victor.november_lima_uniform, romeo_quebec_victor.bravo_xray, romeo_quebec_victor.romeo_quebec_bravo, whiskey_juliet.kilo_oscar_yankee, whiskey_juliet.november_lima_uniform, whiskey_juliet.india_india, whiskey_juliet.yankee_mike, whiskey_juliet.foxtrot_romeo, whiskey_juliet.romeo_zulu, whiskey_juliet.foxtrot_oscar, whiskey_juliet.charlie_seven_romeo, whiskey_juliet.kilo_tango, whiskey_juliet.uniform_six, whiskey_juliet.tango_india_romeo, golf_kilo.november_lima_uniform, golf_kilo.victor_yankee, papa_yankee.november_lima_uniform
10. 0.057 38,828.423 ↑ 2,138.9 23 1

Nested Loop Left Join (cost=2.290..4,959,140.590 rows=49,194 width=285) (actual time=50.822..38,828.423 rows=23 loops=1)

  • Output: six_papa.quebec_seven, six_papa.foxtrot_three, six_papa.four_charlie, six_papa.lima_romeo, six_papa.tango_india_xray, six_papa.tango_sierra, six_papa.romeo_juliet_three, six_papa.xray_uniform, six_papa.zulu_foxtrot, six_papa.juliet_quebec, six_papa.hotel_quebec, six_papa.uniform_golf, six_papa.hotel_echo, six_papa.lima_zulu, six_papa.kilo_zulu, six_papa.foxtrot_bravo, six_papa.romeo_juliet_whiskey, six_papa.kilo_november, six_papa.lima_oscar, six_papa.alpha_victor, six_papa.charlie_seven_bravo, foxtrot_whiskey.november_lima_uniform, foxtrot_whiskey.kilo_oscar_yankee, foxtrot_whiskey.romeo_lima, foxtrot_whiskey.tango_india_romeo, tango_india_november.victor_seven, tango_india_november.november_lima_uniform, tango_india_november.india_mike_hotel, tango_india_november.papa_juliet, tango_india_november.kilo_mike, tango_india_november.november_lima_echo, tango_india_november.india_seven, tango_india_november.six_zulu, romeo_quebec_victor.kilo_oscar_yankee, romeo_quebec_victor.november_lima_uniform, romeo_quebec_victor.bravo_xray, romeo_quebec_victor.romeo_quebec_bravo, whiskey_juliet.kilo_oscar_yankee, whiskey_juliet.november_lima_uniform, whiskey_juliet.india_india, whiskey_juliet.yankee_mike, whiskey_juliet.foxtrot_romeo, whiskey_juliet.romeo_zulu, whiskey_juliet.foxtrot_oscar, whiskey_juliet.charlie_seven_romeo, whiskey_juliet.kilo_tango, whiskey_juliet.uniform_six, whiskey_juliet.tango_india_romeo, golf_kilo.november_lima_uniform, golf_kilo.victor_yankee, golf_kilo.hotel_delta
11. 0.053 38,828.228 ↑ 2,138.9 23 1

Nested Loop Left Join (cost=2.000..4,943,393.340 rows=49,194 width=262) (actual time=50.811..38,828.228 rows=23 loops=1)

  • Output: six_papa.quebec_seven, six_papa.foxtrot_three, six_papa.four_charlie, six_papa.lima_romeo, six_papa.tango_india_xray, six_papa.tango_sierra, six_papa.romeo_juliet_three, six_papa.xray_uniform, six_papa.zulu_foxtrot, six_papa.juliet_quebec, six_papa.hotel_quebec, six_papa.uniform_golf, six_papa.hotel_echo, six_papa.lima_zulu, six_papa.kilo_zulu, six_papa.foxtrot_bravo, six_papa.romeo_juliet_whiskey, six_papa.kilo_november, six_papa.lima_oscar, six_papa.alpha_victor, six_papa.charlie_seven_bravo, foxtrot_whiskey.november_lima_uniform, foxtrot_whiskey.kilo_oscar_yankee, foxtrot_whiskey.romeo_lima, foxtrot_whiskey.tango_india_romeo, tango_india_november.victor_seven, tango_india_november.november_lima_uniform, tango_india_november.india_mike_hotel, tango_india_november.papa_juliet, tango_india_november.kilo_mike, tango_india_november.november_lima_echo, tango_india_november.india_seven, tango_india_november.six_zulu, romeo_quebec_victor.kilo_oscar_yankee, romeo_quebec_victor.november_lima_uniform, romeo_quebec_victor.bravo_xray, romeo_quebec_victor.romeo_quebec_bravo, whiskey_juliet.kilo_oscar_yankee, whiskey_juliet.november_lima_uniform, whiskey_juliet.india_india, whiskey_juliet.yankee_mike, whiskey_juliet.foxtrot_romeo, whiskey_juliet.romeo_zulu, whiskey_juliet.foxtrot_oscar, whiskey_juliet.charlie_seven_romeo, whiskey_juliet.kilo_tango, whiskey_juliet.uniform_six, whiskey_juliet.tango_india_romeo
12. 0.056 38,828.037 ↑ 2,138.9 23 1

Nested Loop Left Join (cost=1.580..4,921,056.780 rows=49,194 width=203) (actual time=50.799..38,828.037 rows=23 loops=1)

  • Output: six_papa.quebec_seven, six_papa.foxtrot_three, six_papa.four_charlie, six_papa.lima_romeo, six_papa.tango_india_xray, six_papa.tango_sierra, six_papa.romeo_juliet_three, six_papa.xray_uniform, six_papa.zulu_foxtrot, six_papa.juliet_quebec, six_papa.hotel_quebec, six_papa.uniform_golf, six_papa.hotel_echo, six_papa.lima_zulu, six_papa.kilo_zulu, six_papa.foxtrot_bravo, six_papa.romeo_juliet_whiskey, six_papa.kilo_november, six_papa.lima_oscar, six_papa.alpha_victor, six_papa.charlie_seven_bravo, foxtrot_whiskey.november_lima_uniform, foxtrot_whiskey.kilo_oscar_yankee, foxtrot_whiskey.romeo_lima, foxtrot_whiskey.tango_india_romeo, tango_india_november.victor_seven, tango_india_november.november_lima_uniform, tango_india_november.india_mike_hotel, tango_india_november.papa_juliet, tango_india_november.kilo_mike, tango_india_november.november_lima_echo, tango_india_november.india_seven, tango_india_november.six_zulu, romeo_quebec_victor.kilo_oscar_yankee, romeo_quebec_victor.november_lima_uniform, romeo_quebec_victor.bravo_xray, romeo_quebec_victor.romeo_quebec_bravo
13. 0.070 38,827.981 ↑ 2,138.9 23 1

Nested Loop Left Join (cost=1.150..4,897,922.530 rows=49,194 width=160) (actual time=50.792..38,827.981 rows=23 loops=1)

  • Output: six_papa.quebec_seven, six_papa.foxtrot_three, six_papa.four_charlie, six_papa.lima_romeo, six_papa.tango_india_xray, six_papa.tango_sierra, six_papa.romeo_juliet_three, six_papa.xray_uniform, six_papa.zulu_foxtrot, six_papa.juliet_quebec, six_papa.hotel_quebec, six_papa.uniform_golf, six_papa.hotel_echo, six_papa.lima_zulu, six_papa.kilo_zulu, six_papa.foxtrot_bravo, six_papa.romeo_juliet_whiskey, six_papa.kilo_november, six_papa.lima_oscar, six_papa.alpha_victor, six_papa.charlie_seven_bravo, six_papa.xray_two, foxtrot_whiskey.november_lima_uniform, foxtrot_whiskey.kilo_oscar_yankee, foxtrot_whiskey.romeo_lima, foxtrot_whiskey.tango_india_romeo, tango_india_november.victor_seven, tango_india_november.november_lima_uniform, tango_india_november.india_mike_hotel, tango_india_november.papa_juliet, tango_india_november.kilo_mike, tango_india_november.november_lima_echo, tango_india_november.india_seven, tango_india_november.six_zulu
14. 2,293.527 38,827.750 ↑ 2,138.9 23 1

Nested Loop (cost=0.720..4,875,893.110 rows=49,194 width=123) (actual time=50.778..38,827.750 rows=23 loops=1)

  • Output: six_papa.quebec_seven, six_papa.foxtrot_three, six_papa.four_charlie, six_papa.lima_romeo, six_papa.tango_india_xray, six_papa.tango_sierra, six_papa.romeo_juliet_three, six_papa.xray_uniform, six_papa.zulu_foxtrot, six_papa.juliet_quebec, six_papa.hotel_quebec, six_papa.uniform_golf, six_papa.hotel_echo, six_papa.lima_zulu, six_papa.kilo_zulu, six_papa.foxtrot_bravo, six_papa.romeo_juliet_whiskey, six_papa.kilo_november, six_papa.lima_oscar, six_papa.alpha_victor, six_papa.charlie_seven_bravo, six_papa.xray_two, foxtrot_whiskey.november_lima_uniform, foxtrot_whiskey.kilo_oscar_yankee, foxtrot_whiskey.romeo_lima, foxtrot_whiskey.tango_india_romeo
15. 9,967.725 9,967.725 ↓ 1.0 13,283,249 1

Index Scan Backward using seven_sierra on two_seven_delta (cost=0.430..624,016.250 rows=13,283,248 width=99) (actual time=0.011..9,967.725 rows=13,283,249 loops=1)

  • Output: six_papa.quebec_seven, six_papa.hotel_quebec, six_papa.uniform_golf, six_papa.hotel_echo, six_papa.foxtrot_three, six_papa.four_charlie, six_papa.lima_romeo, six_papa.tango_india_xray, six_papa.tango_sierra, six_papa.romeo_juliet_three, six_papa.zulu_foxtrot, six_papa.two_seven_three, six_papa.kilo_zulu, six_papa.foxtrot_bravo, six_papa.romeo_juliet_whiskey, six_papa.kilo_november, six_papa.juliet_delta, six_papa.four_tango, six_papa.charlie_seven_bravo, six_papa.xray_two, six_papa.xray_uniform, six_papa.mike_tango, six_papa.five_hotel, six_papa.lima_zulu, six_papa.juliet_quebec, six_papa.lima_six, six_papa.yankee_five, six_papa.victor_alpha, six_papa.quebec_zulu, six_papa.alpha_victor, six_papa.lima_oscar, six_papa.papa_seven
16. 26,566.498 26,566.498 ↓ 0.0 0 13,283,249

Index Scan using alpha_tango_papa on juliet_zulu (cost=0.290..0.310 rows=1 width=28) (actual time=0.002..0.002 rows=0 loops=13,283,249)

  • Output: foxtrot_whiskey.quebec_seven, foxtrot_whiskey.alpha_victor, foxtrot_whiskey.november_lima_uniform, foxtrot_whiskey.bravo_six, foxtrot_whiskey.india_india, foxtrot_whiskey.yankee_mike, foxtrot_whiskey.foxtrot_romeo, foxtrot_whiskey.romeo_zulu, foxtrot_whiskey.six_two, foxtrot_whiskey.victor_charlie, foxtrot_whiskey.two_seven_three, foxtrot_whiskey."echo_mike", foxtrot_whiskey.three_yankee, foxtrot_whiskey.lima_bravo, foxtrot_whiskey.kilo_oscar_yankee, foxtrot_whiskey.juliet_delta, foxtrot_whiskey.oscar_alpha_hotel, foxtrot_whiskey.juliet_quebec, foxtrot_whiskey.charlie_seven_romeo, foxtrot_whiskey.kilo_tango, foxtrot_whiskey.tango_india_romeo, foxtrot_whiskey.romeo_lima
  • Index Cond: (foxtrot_whiskey.quebec_seven = six_papa.hotel_quebec)
  • Filter: (foxtrot_whiskey.alpha_victor = 11990)
  • Rows Removed by Filter: 1
17. 0.161 0.161 ↑ 1.0 1 23

Index Scan using three_lima on five_four (cost=0.420..0.440 rows=1 width=41) (actual time=0.007..0.007 rows=1 loops=23)

  • Output: tango_india_november.quebec_seven, tango_india_november.victor_seven, tango_india_november.november_lima_uniform, tango_india_november.kilo_mike, tango_india_november.six_zulu, tango_india_november.india_mike_hotel, tango_india_november.papa_juliet, tango_india_november.two_seven_three, tango_india_november.foxtrot_oscar, tango_india_november.juliet_delta, tango_india_november.whiskey_six, tango_india_november.alpha_juliet, tango_india_november.five_oscar, tango_india_november.india_seven, tango_india_november.november_lima_echo, tango_india_november.tango_alpha, tango_india_november.kilo_oscar_yankee, tango_india_november.quebec_echo, tango_india_november.quebec_five, tango_india_november.papa_november, tango_india_november.quebec_zulu
  • Index Cond: (six_papa.hotel_echo = tango_india_november.quebec_seven)
18. 0.000 0.000 ↓ 0.0 0 23

Index Scan using sierra_juliet on foxtrot_india (cost=0.430..0.460 rows=1 width=51) (actual time=0.000..0.000 rows=0 loops=23)

  • Output: romeo_quebec_victor.quebec_seven, romeo_quebec_victor.romeo_quebec_bravo, romeo_quebec_victor.november_lima_uniform, romeo_quebec_victor.sierra_november, romeo_quebec_victor.echo_bravo, romeo_quebec_victor.whiskey_three, romeo_quebec_victor.papa_mike_echo, romeo_quebec_victor.two_oscar_delta, romeo_quebec_victor.yankee_sierra, romeo_quebec_victor.whiskey_echo, romeo_quebec_victor.foxtrot_five, romeo_quebec_victor.papa_mike_romeo, romeo_quebec_victor.echo_four, romeo_quebec_victor.zulu_mike, romeo_quebec_victor.two_seven_three, romeo_quebec_victor.kilo_oscar_yankee, romeo_quebec_victor.bravo_xray, romeo_quebec_victor.juliet_delta
  • Index Cond: (six_papa.xray_two = romeo_quebec_victor.quebec_seven)
19. 0.138 0.138 ↑ 1.0 1 23

Index Scan using lima_november on november_four (cost=0.420..0.440 rows=1 width=63) (actual time=0.005..0.006 rows=1 loops=23)

  • Output: whiskey_juliet.quebec_seven, whiskey_juliet.uniform_six, whiskey_juliet.november_lima_uniform, whiskey_juliet.alpha_lima, whiskey_juliet.foxtrot_oscar, whiskey_juliet.hotel_lima, whiskey_juliet.kilo_oscar_yankee, whiskey_juliet.hotel_juliet, whiskey_juliet.two_seven_three, whiskey_juliet.papa_zulu, whiskey_juliet.four_victor, whiskey_juliet.charlie_seven_romeo, whiskey_juliet.india_india, whiskey_juliet.yankee_mike, whiskey_juliet.foxtrot_romeo, whiskey_juliet.romeo_zulu, whiskey_juliet.juliet_delta, whiskey_juliet.kilo_tango, whiskey_juliet.three_delta_two, whiskey_juliet.romeo_india, whiskey_juliet.xray_six, whiskey_juliet.foxtrot_three, whiskey_juliet.lima_romeo, whiskey_juliet.oscar_alpha_two, whiskey_juliet.three_mike, whiskey_juliet.tango_india_romeo, whiskey_juliet.victor_india, whiskey_juliet.lima_seven, whiskey_juliet.two_kilo_tango
  • Index Cond: (six_papa.uniform_golf = whiskey_juliet.quebec_seven)
20. 0.138 0.138 ↑ 1.0 1 23

Index Scan using zulu_india on alpha_tango_india (cost=0.290..0.310 rows=1 width=27) (actual time=0.004..0.006 rows=1 loops=23)

  • Output: golf_kilo.quebec_seven, golf_kilo.hotel_delta, golf_kilo.november_lima_uniform, golf_kilo.golf_three, golf_kilo.two_seven_three, golf_kilo.whiskey_whiskey, golf_kilo.victor_yankee, golf_kilo.juliet_delta
  • Index Cond: (tango_india_november.victor_seven = golf_kilo.quebec_seven)
21. 0.115 0.115 ↑ 1.0 1 23

Index Scan using sierra_four on bravo_mike (cost=0.290..0.310 rows=1 width=21) (actual time=0.004..0.005 rows=1 loops=23)

  • Output: papa_yankee.quebec_seven, papa_yankee.alpha_victor, papa_yankee.november_lima_uniform, papa_yankee.tango_yankee, papa_yankee.two_seven_three, papa_yankee.kilo_oscar_yankee, papa_yankee.juliet_delta, papa_yankee.india_tango
  • Index Cond: (golf_kilo.hotel_delta = papa_yankee.quebec_seven)
22. 0.069 0.069 ↑ 1.0 1 23

Index Scan using alpha_tango_papa on juliet_zulu six_four (cost=0.290..0.310 rows=1 width=20) (actual time=0.003..0.003 rows=1 loops=23)

  • Output: romeo_three11.quebec_seven, romeo_three11.alpha_victor, romeo_three11.november_lima_uniform, romeo_three11.bravo_six, romeo_three11.india_india, romeo_three11.yankee_mike, romeo_three11.foxtrot_romeo, romeo_three11.romeo_zulu, romeo_three11.six_two, romeo_three11.victor_charlie, romeo_three11.two_seven_three, romeo_three11."echo_mike", romeo_three11.three_yankee, romeo_three11.lima_bravo, romeo_three11.kilo_oscar_yankee, romeo_three11.juliet_delta, romeo_three11.oscar_alpha_hotel, romeo_three11.juliet_quebec, romeo_three11.charlie_seven_romeo, romeo_three11.kilo_tango, romeo_three11.tango_india_romeo, romeo_three11.romeo_lima
  • Index Cond: (whiskey_juliet.charlie_seven_romeo = romeo_three11.quebec_seven)
23. 0.000 0.000 ↓ 0.0 0 23

Index Scan using alpha_tango_papa on juliet_zulu zulu_juliet (cost=0.290..0.310 rows=1 width=20) (actual time=0.000..0.000 rows=0 loops=23)

  • Output: romeo_three12.quebec_seven, romeo_three12.alpha_victor, romeo_three12.november_lima_uniform, romeo_three12.bravo_six, romeo_three12.india_india, romeo_three12.yankee_mike, romeo_three12.foxtrot_romeo, romeo_three12.romeo_zulu, romeo_three12.six_two, romeo_three12.victor_charlie, romeo_three12.two_seven_three, romeo_three12."echo_mike", romeo_three12.three_yankee, romeo_three12.lima_bravo, romeo_three12.kilo_oscar_yankee, romeo_three12.juliet_delta, romeo_three12.oscar_alpha_hotel, romeo_three12.juliet_quebec, romeo_three12.charlie_seven_romeo, romeo_three12.kilo_tango, romeo_three12.tango_india_romeo, romeo_three12.romeo_lima
  • Index Cond: (whiskey_juliet.kilo_tango = romeo_three12.quebec_seven)
24. 0.115 0.115 ↑ 1.0 1 23

Index Scan using six_sierra on four_papa (cost=0.420..0.460 rows=1 width=29) (actual time=0.005..0.005 rows=1 loops=23)

  • Output: tango_seven.quebec_seven, tango_seven.alpha_victor, tango_seven.november_lima_uniform, tango_seven.india_india, tango_seven.yankee_mike, tango_seven.foxtrot_romeo, tango_seven.romeo_zulu, tango_seven.delta_juliet, tango_seven.six_two, tango_seven.victor_charlie, tango_seven.hotel_lima, tango_seven.two_seven_three, tango_seven.romeo_delta, tango_seven.kilo_oscar_yankee, tango_seven.juliet_delta
  • Index Cond: (whiskey_juliet.uniform_six = tango_seven.quebec_seven)
25. 0.000 0.000 ↓ 0.0 0 23

Index Scan using victor_sierra on four_seven (cost=0.290..0.310 rows=1 width=18) (actual time=0.000..0.000 rows=0 loops=23)

  • Output: november_alpha.quebec_seven, november_alpha.alpha_victor, november_alpha.november_lima_uniform, november_alpha.two_seven_three, november_alpha.kilo_oscar_yankee, november_alpha.juliet_delta, november_alpha.papa_mike_echo
  • Index Cond: (romeo_quebec_victor.romeo_quebec_bravo = november_alpha.quebec_seven)
26. 0.092 0.092 ↓ 0.0 0 23

Index Scan using lima_alpha on two_lima (cost=0.290..0.310 rows=1 width=5) (actual time=0.004..0.004 rows=0 loops=23)

  • Output: sierra_zulu.quebec_seven, sierra_zulu.six_mike, sierra_zulu.delta_three_papa, sierra_zulu.oscar_golf, sierra_zulu.xray_uniform, sierra_zulu.kilo_hotel_three, sierra_zulu.two_echo, sierra_zulu.four_hotel, sierra_zulu.kilo_papa
  • Index Cond: (six_papa.quebec_seven = sierra_zulu.four_hotel)
27. 0.000 0.000 ↓ 0.0 0 23

Index Scan using five_yankee on kilo_lima (cost=0.140..0.160 rows=1 width=15) (actual time=0.000..0.000 rows=0 loops=23)

  • Output: six_foxtrot.quebec_seven, six_foxtrot.two_seven_three, six_foxtrot.juliet_delta, six_foxtrot.alpha_victor, six_foxtrot.kilo_oscar_yankee, six_foxtrot.november_lima_uniform
  • Index Cond: (whiskey_juliet.tango_india_romeo = six_foxtrot.quebec_seven)
28. 0.000 0.000 ↓ 0.0 0 23

Index Scan using five_yankee on kilo_lima echo_golf (cost=0.140..0.180 rows=1 width=15) (actual time=0.000..0.000 rows=0 loops=23)

  • Output: romeo_three17.quebec_seven, romeo_three17.two_seven_three, romeo_three17.juliet_delta, romeo_three17.alpha_victor, romeo_three17.kilo_oscar_yankee, romeo_three17.november_lima_uniform
  • Index Cond: (foxtrot_whiskey.tango_india_romeo = romeo_three17.quebec_seven)
29.          

SubPlan (forNested Loop Left Join)

30. 0.000 0.000 ↓ 0.0 0

Index Scan using lima_juliet on delta_three_hotel uniform_foxtrot (cost=0.420..2.710 rows=1 width=0) (never executed)

  • Index Cond: (kilo_hotel_tango0.two_oscar_lima = six_papa.quebec_seven)
  • Filter: ((kilo_hotel_tango0.charlie_india)::text = 'two_zulu'::text)
31. 72.853 72.853 ↓ 1.0 137,208 1

Seq Scan on delta_three_hotel four_xray (cost=0.000..6,395.240 rows=136,645 width=4) (actual time=0.823..72.853 rows=137,208 loops=1)

  • Output: kilo_hotel_tango0kilo_oscar_quebec1.two_oscar_lima
  • Filter: ((kilo_hotel_tango0kilo_oscar_quebec1.charlie_india)::text = 'two_zulu'::text)
  • Rows Removed by Filter: 162891
32. 0.000 0.207 ↓ 0.0 0 23

Limit (cost=1.000..5.570 rows=1 width=16) (actual time=0.009..0.009 rows=0 loops=23)

  • Output: kilo_hotel_tango3.november_lima_uniform
33. 0.023 0.207 ↓ 0.0 0 23

Nested Loop Left Join (cost=1.000..5.570 rows=1 width=16) (actual time=0.009..0.009 rows=0 loops=23)

  • Output: kilo_hotel_tango3.november_lima_uniform
34. 0.023 0.184 ↓ 0.0 0 23

Nested Loop (cost=0.710..5.230 rows=1 width=4) (actual time=0.008..0.008 rows=0 loops=23)

  • Output: kilo_hotel_tango2.hotel_quebec
35. 0.161 0.161 ↓ 0.0 0 23

Index Scan using lima_juliet on delta_three_hotel tango_three (cost=0.420..2.710 rows=1 width=4) (actual time=0.007..0.007 rows=0 loops=23)

  • Output: kilo_hotel_tango0kilo_oscar_quebec2.quebec_seven, kilo_hotel_tango0kilo_oscar_quebec2.two_seven_three, kilo_hotel_tango0kilo_oscar_quebec2.juliet_delta, kilo_hotel_tango0kilo_oscar_quebec2.charlie_india, kilo_hotel_tango0kilo_oscar_quebec2.four_kilo, kilo_hotel_tango0kilo_oscar_quebec2.six_romeo, kilo_hotel_tango0kilo_oscar_quebec2.two_oscar_lima
  • Index Cond: (kilo_hotel_tango0kilo_oscar_quebec2.two_oscar_lima = six_papa.quebec_seven)
  • Filter: ((kilo_hotel_tango0kilo_oscar_quebec2.charlie_india)::text = 'two_zulu'::text)
  • Rows Removed by Filter: 1
36. 0.000 0.000 ↓ 0.0 0

Index Scan using delta_echo on alpha_echo xray_hotel (cost=0.290..2.510 rows=1 width=8) (never executed)

  • Output: kilo_hotel_tango2.quebec_seven, kilo_hotel_tango2.zulu_lima, kilo_hotel_tango2.alpha_victor, kilo_hotel_tango2.hotel_quebec, kilo_hotel_tango2.hotel_romeo, kilo_hotel_tango2.juliet_november, kilo_hotel_tango2.two_seven_three, kilo_hotel_tango2.four_echo, kilo_hotel_tango2.juliet_delta, kilo_hotel_tango2.romeo_echo, kilo_hotel_tango2.kilo_hotel_alpha
  • Index Cond: (kilo_hotel_tango2.quebec_seven = kilo_hotel_tango0kilo_oscar_quebec2.six_romeo)
37. 0.000 0.000 ↓ 0.0 0

Index Scan using alpha_tango_papa on juliet_zulu four_lima (cost=0.290..0.330 rows=1 width=20) (never executed)

  • Output: kilo_hotel_tango3.quebec_seven, kilo_hotel_tango3.alpha_victor, kilo_hotel_tango3.november_lima_uniform, kilo_hotel_tango3.bravo_six, kilo_hotel_tango3.india_india, kilo_hotel_tango3.yankee_mike, kilo_hotel_tango3.foxtrot_romeo, kilo_hotel_tango3.romeo_zulu, kilo_hotel_tango3.six_two, kilo_hotel_tango3.victor_charlie, kilo_hotel_tango3.two_seven_three, kilo_hotel_tango3."echo_mike", kilo_hotel_tango3.three_yankee, kilo_hotel_tango3.lima_bravo, kilo_hotel_tango3.kilo_oscar_yankee, kilo_hotel_tango3.juliet_delta, kilo_hotel_tango3.oscar_alpha_hotel, kilo_hotel_tango3.juliet_quebec, kilo_hotel_tango3.charlie_seven_romeo, kilo_hotel_tango3.kilo_tango, kilo_hotel_tango3.tango_india_romeo, kilo_hotel_tango3.romeo_lima
  • Index Cond: (kilo_hotel_tango2.hotel_quebec = kilo_hotel_tango3.quebec_seven)
38. 0.000 0.276 ↑ 1.0 1 23

Limit (cost=1.000..5.570 rows=1 width=16) (actual time=0.012..0.012 rows=1 loops=23)

  • Output: kilo_hotel_tango3kilo_oscar_quebec1.november_lima_uniform
39. 0.058 0.276 ↑ 1.0 1 23

Nested Loop Left Join (cost=1.000..5.570 rows=1 width=16) (actual time=0.012..0.012 rows=1 loops=23)

  • Output: kilo_hotel_tango3kilo_oscar_quebec1.november_lima_uniform
40. 0.047 0.184 ↑ 1.0 1 23

Nested Loop (cost=0.710..5.230 rows=1 width=4) (actual time=0.008..0.008 rows=1 loops=23)

  • Output: kilo_hotel_tango2kilo_oscar_quebec1.hotel_quebec
41. 0.069 0.069 ↑ 1.0 1 23

Index Scan using lima_juliet on delta_three_hotel india_mike_oscar (cost=0.420..2.710 rows=1 width=4) (actual time=0.003..0.003 rows=1 loops=23)

  • Output: kilo_hotel_tango0kilo_oscar_quebec3.quebec_seven, kilo_hotel_tango0kilo_oscar_quebec3.two_seven_three, kilo_hotel_tango0kilo_oscar_quebec3.juliet_delta, kilo_hotel_tango0kilo_oscar_quebec3.charlie_india, kilo_hotel_tango0kilo_oscar_quebec3.four_kilo, kilo_hotel_tango0kilo_oscar_quebec3.six_romeo, kilo_hotel_tango0kilo_oscar_quebec3.two_oscar_lima
  • Index Cond: (kilo_hotel_tango0kilo_oscar_quebec3.two_oscar_lima = six_papa.quebec_seven)
  • Filter: ((kilo_hotel_tango0kilo_oscar_quebec3.charlie_india)::text = ANY ('xray_foxtrot'::text[]))
42. 0.068 0.068 ↑ 1.0 1 17

Index Scan using delta_echo on alpha_echo charlie_uniform (cost=0.290..2.510 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=17)

  • Output: kilo_hotel_tango2kilo_oscar_quebec1.quebec_seven, kilo_hotel_tango2kilo_oscar_quebec1.zulu_lima, kilo_hotel_tango2kilo_oscar_quebec1.alpha_victor, kilo_hotel_tango2kilo_oscar_quebec1.hotel_quebec, kilo_hotel_tango2kilo_oscar_quebec1.hotel_romeo, kilo_hotel_tango2kilo_oscar_quebec1.juliet_november, kilo_hotel_tango2kilo_oscar_quebec1.two_seven_three, kilo_hotel_tango2kilo_oscar_quebec1.four_echo, kilo_hotel_tango2kilo_oscar_quebec1.juliet_delta, kilo_hotel_tango2kilo_oscar_quebec1.romeo_echo, kilo_hotel_tango2kilo_oscar_quebec1.kilo_hotel_alpha
  • Index Cond: (kilo_hotel_tango2kilo_oscar_quebec1.quebec_seven = kilo_hotel_tango0kilo_oscar_quebec3.six_romeo)
43. 0.034 0.034 ↑ 1.0 1 17

Index Scan using alpha_tango_papa on juliet_zulu foxtrot_mike (cost=0.290..0.330 rows=1 width=20) (actual time=0.002..0.002 rows=1 loops=17)

  • Output: kilo_hotel_tango3kilo_oscar_quebec1.quebec_seven, kilo_hotel_tango3kilo_oscar_quebec1.alpha_victor, kilo_hotel_tango3kilo_oscar_quebec1.november_lima_uniform, kilo_hotel_tango3kilo_oscar_quebec1.bravo_six, kilo_hotel_tango3kilo_oscar_quebec1.india_india, kilo_hotel_tango3kilo_oscar_quebec1.yankee_mike, kilo_hotel_tango3kilo_oscar_quebec1.foxtrot_romeo, kilo_hotel_tango3kilo_oscar_quebec1.romeo_zulu, kilo_hotel_tango3kilo_oscar_quebec1.six_two, kilo_hotel_tango3kilo_oscar_quebec1.victor_charlie, kilo_hotel_tango3kilo_oscar_quebec1.two_seven_three, kilo_hotel_tango3kilo_oscar_quebec1."echo_mike", kilo_hotel_tango3kilo_oscar_quebec1.three_yankee, kilo_hotel_tango3kilo_oscar_quebec1.lima_bravo, kilo_hotel_tango3kilo_oscar_quebec1.kilo_oscar_yankee, kilo_hotel_tango3kilo_oscar_quebec1.juliet_delta, kilo_hotel_tango3kilo_oscar_quebec1.oscar_alpha_hotel, kilo_hotel_tango3kilo_oscar_quebec1.juliet_quebec, kilo_hotel_tango3kilo_oscar_quebec1.charlie_seven_romeo, kilo_hotel_tango3kilo_oscar_quebec1.kilo_tango, kilo_hotel_tango3kilo_oscar_quebec1.tango_india_romeo, kilo_hotel_tango3kilo_oscar_quebec1.romeo_lima
  • Index Cond: (kilo_hotel_tango2kilo_oscar_quebec1.hotel_quebec = kilo_hotel_tango3kilo_oscar_quebec1.quebec_seven)
44. 0.138 0.138 ↑ 1.0 1 23

Index Scan using seven_sierra on two_seven_delta zulu_tango (cost=0.430..2.660 rows=1 width=0) (actual time=0.006..0.006 rows=1 loops=23)

  • Index Cond: (kilo_hotel_tango0kilo_oscar_quebec4.quebec_seven = six_papa.quebec_seven)
  • Filter: (kilo_hotel_tango0kilo_oscar_quebec4.alpha_victor = six_papa.alpha_victor)
45. 0.253 0.253 ↑ 1.0 1 23

CTE Scan on golf_papa yankee_charlie (cost=271.910..273.930 rows=1 width=516) (actual time=0.008..0.011 rows=1 loops=23)

  • Output: charlie_november1.november_lima_uniform
  • Filter: (charlie_november1.xray_six five_romeo NULL)
46.          

CTE golf_papa

47. 0.046 0.184 ↑ 101.0 1 23

Recursive Union (cost=0.420..271.910 rows=101 width=37) (actual time=0.005..0.008 rows=1 loops=23)

48. 0.092 0.092 ↑ 1.0 1 23

Index Scan using lima_november on november_four november_mike (cost=0.420..2.640 rows=1 width=37) (actual time=0.004..0.004 rows=1 loops=23)

  • Output: november_mike.quebec_seven, november_mike.november_lima_uniform, november_mike.kilo_oscar_yankee, november_mike.xray_six
  • Index Cond: (november_mike.quebec_seven = six_papa.uniform_golf)
49. 0.046 0.046 ↓ 0.0 0 23

Nested Loop (cost=0.420..26.730 rows=10 width=37) (actual time=0.002..0.002 rows=0 loops=23)

  • Output: foxtrot_sierra1.quebec_seven, foxtrot_sierra1.november_lima_uniform, foxtrot_sierra1.kilo_oscar_yankee, foxtrot_sierra1.xray_six
50. 0.000 0.000 ↑ 10.0 1 23

WorkTable Scan on ancestors (cost=0.000..0.200 rows=10 width=4) (actual time=0.000..0.000 rows=1 loops=23)

  • Output: golf_papa.quebec_seven, golf_papa.november_lima_uniform, golf_papa.kilo_oscar_yankee, golf_papa.xray_six
51. 0.000 0.000 ↓ 0.0 0 22

Index Scan using lima_november on november_four echo_yankee (cost=0.420..2.640 rows=1 width=37) (actual time=0.000..0.000 rows=0 loops=22)

  • Output: foxtrot_sierra1.quebec_seven, foxtrot_sierra1.uniform_six, foxtrot_sierra1.november_lima_uniform, foxtrot_sierra1.alpha_lima, foxtrot_sierra1.foxtrot_oscar, foxtrot_sierra1.hotel_lima, foxtrot_sierra1.kilo_oscar_yankee, foxtrot_sierra1.hotel_juliet, foxtrot_sierra1.two_seven_three, foxtrot_sierra1.papa_zulu, foxtrot_sierra1.four_victor, foxtrot_sierra1.charlie_seven_romeo, foxtrot_sierra1.india_india, foxtrot_sierra1.yankee_mike, foxtrot_sierra1.foxtrot_romeo, foxtrot_sierra1.romeo_zulu, foxtrot_sierra1.juliet_delta, foxtrot_sierra1.kilo_tango, foxtrot_sierra1.three_delta_two, foxtrot_sierra1.romeo_india, foxtrot_sierra1.xray_six, foxtrot_sierra1.foxtrot_three, foxtrot_sierra1.lima_romeo, foxtrot_sierra1.oscar_alpha_two, foxtrot_sierra1.three_mike, foxtrot_sierra1.tango_india_romeo, foxtrot_sierra1.victor_india, foxtrot_sierra1.lima_seven, foxtrot_sierra1.two_kilo_tango
  • Index Cond: (foxtrot_sierra1.quebec_seven = golf_papa.xray_six)
52. 0.184 0.184 ↑ 1.0 1 23

CTE Scan on golf_papa seven_six (cost=271.910..273.930 rows=1 width=32) (actual time=0.005..0.008 rows=1 loops=23)

  • Output: charlie_november3.kilo_oscar_yankee
  • Filter: (charlie_november3.xray_six five_romeo NULL)
53.          

CTE golf_papa

54. 0.023 0.138 ↑ 101.0 1 23

Recursive Union (cost=0.420..271.910 rows=101 width=37) (actual time=0.004..0.006 rows=1 loops=23)

55. 0.069 0.069 ↑ 1.0 1 23

Index Scan using lima_november on november_four yankee_bravo (cost=0.420..2.640 rows=1 width=37) (actual time=0.003..0.003 rows=1 loops=23)

  • Output: foxtrot_sierra2.quebec_seven, foxtrot_sierra2.november_lima_uniform, foxtrot_sierra2.kilo_oscar_yankee, foxtrot_sierra2.xray_six
  • Index Cond: (foxtrot_sierra2.quebec_seven = six_papa.uniform_golf)
56. 0.046 0.046 ↓ 0.0 0 23

Nested Loop (cost=0.420..26.730 rows=10 width=37) (actual time=0.002..0.002 rows=0 loops=23)

  • Output: foxtrot_sierra3.quebec_seven, foxtrot_sierra3.november_lima_uniform, foxtrot_sierra3.kilo_oscar_yankee, foxtrot_sierra3.xray_six
57. 0.000 0.000 ↑ 10.0 1 23

WorkTable Scan on ancestors ancestors_2 (cost=0.000..0.200 rows=10 width=4) (actual time=0.000..0.000 rows=1 loops=23)

  • Output: charlie_november2.quebec_seven, charlie_november2.november_lima_uniform, charlie_november2.kilo_oscar_yankee, charlie_november2.xray_six
58. 0.000 0.000 ↓ 0.0 0 22

Index Scan using lima_november on november_four two_kilo_xray (cost=0.420..2.640 rows=1 width=37) (actual time=0.000..0.000 rows=0 loops=22)

  • Output: foxtrot_sierra3.quebec_seven, foxtrot_sierra3.uniform_six, foxtrot_sierra3.november_lima_uniform, foxtrot_sierra3.alpha_lima, foxtrot_sierra3.foxtrot_oscar, foxtrot_sierra3.hotel_lima, foxtrot_sierra3.kilo_oscar_yankee, foxtrot_sierra3.hotel_juliet, foxtrot_sierra3.two_seven_three, foxtrot_sierra3.papa_zulu, foxtrot_sierra3.four_victor, foxtrot_sierra3.charlie_seven_romeo, foxtrot_sierra3.india_india, foxtrot_sierra3.yankee_mike, foxtrot_sierra3.foxtrot_romeo, foxtrot_sierra3.romeo_zulu, foxtrot_sierra3.juliet_delta, foxtrot_sierra3.kilo_tango, foxtrot_sierra3.three_delta_two, foxtrot_sierra3.romeo_india, foxtrot_sierra3.xray_six, foxtrot_sierra3.foxtrot_three, foxtrot_sierra3.lima_romeo, foxtrot_sierra3.oscar_alpha_two, foxtrot_sierra3.three_mike, foxtrot_sierra3.tango_india_romeo, foxtrot_sierra3.victor_india, foxtrot_sierra3.lima_seven, foxtrot_sierra3.two_kilo_tango
  • Index Cond: (foxtrot_sierra3.quebec_seven = charlie_november2.xray_six)
59. 0.092 0.299 ↓ 0.0 0 23

Limit (cost=0.000..1.760 rows=1 width=30) (actual time=0.013..0.013 rows=0 loops=23)

  • Output: kilo_hotel_tango0kilo_oscar_quebec5.six_mike
60. 0.207 0.207 ↓ 0.0 0 23

Seq Scan on six_kilo zulu_kilo (cost=0.000..1.760 rows=1 width=30) (actual time=0.009..0.009 rows=0 loops=23)

  • Output: kilo_hotel_tango0kilo_oscar_quebec5.six_mike
  • Filter: ((kilo_hotel_tango0kilo_oscar_quebec5.charlie_seven_bravo five_romeo NULL) AND ((kilo_hotel_tango0kilo_oscar_quebec5.lima_sierra)::text = 'zulu_papa'::text) AND (kilo_hotel_tango0kilo_oscar_quebec5.uniform_golf = six_papa.uniform_golf) AND (kilo_hotel_tango0kilo_oscar_quebec5.hotel_echo = six_papa.hotel_echo) AND (kilo_hotel_tango0kilo_oscar_quebec5.alpha_victor = 11990))
  • Rows Removed by Filter: 38
61. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.000..1.760 rows=1 width=30) (never executed)

  • Output: kilo_hotel_tango0kilo_oscar_quebec6.six_mike
62. 0.000 0.000 ↓ 0.0 0

Seq Scan on six_kilo romeo_oscar (cost=0.000..1.760 rows=1 width=30) (never executed)

  • Output: kilo_hotel_tango0kilo_oscar_quebec6.six_mike
  • Filter: ((kilo_hotel_tango0kilo_oscar_quebec6.charlie_seven_bravo five_romeo NULL) AND ((kilo_hotel_tango0kilo_oscar_quebec6.lima_sierra)::text = 'zulu_papa'::text) AND (kilo_hotel_tango0kilo_oscar_quebec6.uniform_golf = six_papa.uniform_golf) AND (kilo_hotel_tango0kilo_oscar_quebec6.hotel_echo = six_papa.hotel_echo) AND (kilo_hotel_tango0kilo_oscar_quebec6.alpha_victor = 11990))
63. 0.023 0.161 ↓ 0.0 0 23

Limit (cost=0.000..1.670 rows=1 width=30) (actual time=0.007..0.007 rows=0 loops=23)

  • Output: kilo_hotel_tango0kilo_oscar_quebec7.six_mike
64. 0.138 0.138 ↓ 0.0 0 23

Seq Scan on six_kilo two_victor (cost=0.000..1.670 rows=1 width=30) (actual time=0.006..0.006 rows=0 loops=23)

  • Output: kilo_hotel_tango0kilo_oscar_quebec7.six_mike
  • Filter: ((kilo_hotel_tango0kilo_oscar_quebec7.hotel_echo five_romeo NULL) AND (kilo_hotel_tango0kilo_oscar_quebec7.charlie_seven_bravo five_romeo NULL) AND ((kilo_hotel_tango0kilo_oscar_quebec7.lima_sierra)::text = 'zulu_papa'::text) AND (kilo_hotel_tango0kilo_oscar_quebec7.uniform_golf = six_papa.uniform_golf) AND (kilo_hotel_tango0kilo_oscar_quebec7.alpha_victor = 11990))
  • Rows Removed by Filter: 38
65. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.000..1.670 rows=1 width=30) (never executed)

  • Output: kilo_hotel_tango0kilo_oscar_quebec8.six_mike
66. 0.000 0.000 ↓ 0.0 0

Seq Scan on six_kilo lima_five (cost=0.000..1.670 rows=1 width=30) (never executed)

  • Output: kilo_hotel_tango0kilo_oscar_quebec8.six_mike
  • Filter: ((kilo_hotel_tango0kilo_oscar_quebec8.hotel_echo five_romeo NULL) AND (kilo_hotel_tango0kilo_oscar_quebec8.charlie_seven_bravo five_romeo NULL) AND ((kilo_hotel_tango0kilo_oscar_quebec8.lima_sierra)::text = 'zulu_papa'::text) AND (kilo_hotel_tango0kilo_oscar_quebec8.uniform_golf = six_papa.uniform_golf) AND (kilo_hotel_tango0kilo_oscar_quebec8.alpha_victor = 11990))
67. 0.023 0.253 ↓ 0.0 0 23

Limit (cost=0.000..1.760 rows=1 width=30) (actual time=0.011..0.011 rows=0 loops=23)

  • Output: kilo_hotel_tango0kilo_oscar_quebec9.six_mike
68. 0.230 0.230 ↓ 0.0 0 23

Seq Scan on six_kilo bravo_bravo (cost=0.000..1.760 rows=1 width=30) (actual time=0.010..0.010 rows=0 loops=23)

  • Output: kilo_hotel_tango0kilo_oscar_quebec9.six_mike
  • Filter: ((kilo_hotel_tango0kilo_oscar_quebec9.uniform_golf five_romeo NULL) AND ((kilo_hotel_tango0kilo_oscar_quebec9.lima_sierra)::text = 'zulu_papa'::text) AND (kilo_hotel_tango0kilo_oscar_quebec9.hotel_echo = six_papa.hotel_echo) AND (kilo_hotel_tango0kilo_oscar_quebec9.charlie_seven_bravo = six_papa.charlie_seven_bravo) AND (kilo_hotel_tango0kilo_oscar_quebec9.alpha_victor = 11990))
  • Rows Removed by Filter: 38
69. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.000..1.760 rows=1 width=30) (never executed)

  • Output: kilo_hotel_tango0kilo_oscar_quebec10.six_mike
70. 0.000 0.000 ↓ 0.0 0

Seq Scan on six_kilo quebec_tango (cost=0.000..1.760 rows=1 width=30) (never executed)

  • Output: kilo_hotel_tango0kilo_oscar_quebec10.six_mike
  • Filter: ((kilo_hotel_tango0kilo_oscar_quebec10.uniform_golf five_romeo NULL) AND ((kilo_hotel_tango0kilo_oscar_quebec10.lima_sierra)::text = 'zulu_papa'::text) AND (kilo_hotel_tango0kilo_oscar_quebec10.hotel_echo = six_papa.hotel_echo) AND (kilo_hotel_tango0kilo_oscar_quebec10.charlie_seven_bravo = six_papa.charlie_seven_bravo) AND (kilo_hotel_tango0kilo_oscar_quebec10.alpha_victor = 11990))
71. 0.023 0.184 ↓ 0.0 0 23

Limit (cost=0.000..1.670 rows=1 width=30) (actual time=0.008..0.008 rows=0 loops=23)

  • Output: kilo_hotel_tango0kilo_oscar_quebec11.six_mike
72. 0.161 0.161 ↓ 0.0 0 23

Seq Scan on six_kilo romeo_yankee (cost=0.000..1.670 rows=1 width=30) (actual time=0.007..0.007 rows=0 loops=23)

  • Output: kilo_hotel_tango0kilo_oscar_quebec11.six_mike
  • Filter: ((kilo_hotel_tango0kilo_oscar_quebec11.uniform_golf five_romeo NULL) AND (kilo_hotel_tango0kilo_oscar_quebec11.hotel_echo five_romeo NULL) AND ((kilo_hotel_tango0kilo_oscar_quebec11.lima_sierra)::text = 'zulu_papa'::text) AND (kilo_hotel_tango0kilo_oscar_quebec11.charlie_seven_bravo = six_papa.charlie_seven_bravo) AND (kilo_hotel_tango0kilo_oscar_quebec11.alpha_victor = 11990))
  • Rows Removed by Filter: 38
73. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.000..1.670 rows=1 width=30) (never executed)

  • Output: kilo_hotel_tango0kilo_oscar_quebec12.six_mike
74. 0.000 0.000 ↓ 0.0 0

Seq Scan on six_kilo lima_tango (cost=0.000..1.670 rows=1 width=30) (never executed)

  • Output: kilo_hotel_tango0kilo_oscar_quebec12.six_mike
  • Filter: ((kilo_hotel_tango0kilo_oscar_quebec12.uniform_golf five_romeo NULL) AND (kilo_hotel_tango0kilo_oscar_quebec12.hotel_echo five_romeo NULL) AND ((kilo_hotel_tango0kilo_oscar_quebec12.lima_sierra)::text = 'zulu_papa'::text) AND (kilo_hotel_tango0kilo_oscar_quebec12.charlie_seven_bravo = six_papa.charlie_seven_bravo) AND (kilo_hotel_tango0kilo_oscar_quebec12.alpha_victor = 11990))
75. 0.023 0.207 ↓ 0.0 0 23

Limit (cost=0.000..1.670 rows=1 width=30) (actual time=0.009..0.009 rows=0 loops=23)

  • Output: kilo_hotel_tango0kilo_oscar_quebec13.six_mike
76. 0.184 0.184 ↓ 0.0 0 23

Seq Scan on six_kilo kilo_whiskey (cost=0.000..1.670 rows=1 width=30) (actual time=0.008..0.008 rows=0 loops=23)

  • Output: kilo_hotel_tango0kilo_oscar_quebec13.six_mike
  • Filter: ((kilo_hotel_tango0kilo_oscar_quebec13.uniform_golf five_romeo NULL) AND (kilo_hotel_tango0kilo_oscar_quebec13.charlie_seven_bravo five_romeo NULL) AND ((kilo_hotel_tango0kilo_oscar_quebec13.lima_sierra)::text = 'zulu_papa'::text) AND (kilo_hotel_tango0kilo_oscar_quebec13.hotel_echo = six_papa.hotel_echo) AND (kilo_hotel_tango0kilo_oscar_quebec13.alpha_victor = 11990))
  • Rows Removed by Filter: 38
77. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.000..1.670 rows=1 width=30) (never executed)

  • Output: kilo_hotel_tango0kilo_oscar_quebec14.six_mike
78. 0.000 0.000 ↓ 0.0 0

Seq Scan on six_kilo sierra_uniform (cost=0.000..1.670 rows=1 width=30) (never executed)

  • Output: kilo_hotel_tango0kilo_oscar_quebec14.six_mike
  • Filter: ((kilo_hotel_tango0kilo_oscar_quebec14.uniform_golf five_romeo NULL) AND (kilo_hotel_tango0kilo_oscar_quebec14.charlie_seven_bravo five_romeo NULL) AND ((kilo_hotel_tango0kilo_oscar_quebec14.lima_sierra)::text = 'zulu_papa'::text) AND (kilo_hotel_tango0kilo_oscar_quebec14.hotel_echo = six_papa.hotel_echo) AND (kilo_hotel_tango0kilo_oscar_quebec14.alpha_victor = 11990))