explain.depesz.com

PostgreSQL's explain analyze made readable

Result: AsKk : trade_event

Settings
# exclusive inclusive rows x rows loops node
1. 2,778.093 44,905.002 ↓ 30.4 155,652 1

Hash Left Join (cost=2,240,756.390..2,267,819.700 rows=5,114 width=1,809) (actual time=29,196.446..44,905.002 rows=155,652 loops=1)

  • Output: yankee_quebec.quebec_seven, yankee_quebec.echo_mike_uniform, yankee_quebec.seven_echo, yankee_quebec.papa_whiskey, yankee_quebec.oscar_lima_quebec, yankee_quebec.three_yankee, yankee_quebec.foxtrot_oscar_india, yankee_quebec.papa_zulu, yankee_quebec.yankee_whiskey_juliet, yankee_quebec.india_five, yankee_quebec.oscar_bravo, yankee_quebec.romeo_hotel_victor, lima_sierra(CASE WHEN ((yankee_quebec.tango_india)::text = 'papa_delta_juliet'::text) THEN yankee_quebec.xray_india ELSE yankee_quebec.golf_bravo END, CASE WHEN ((yankee_quebec.delta_xray)::text = 'alpha_xray_xray'::text) THEN yankee_quebec.xray_india ELSE yankee_quebec.quebec_quebec_charlie END), lima_sierra(yankee_quebec.papa_hotel, hotel_delta("golf_mike_delta"(lima_sierra(lima_four_hotel((yankee_quebec.golf_sierra)::text, ''foxtrot_golf'golf_kilo'zulu_seven'delta_charlie'hotel_lima'echo_papa'whiskey_mike'quebec_lima-seven_uniform-xray_four'victor_zulu'yankee_four'echo_juliet'yankee_four'six_yankee'yankee_four'kilo_tango'hotel_tango'victor_romeo'yankee_four'zulu_uniform'yankee_four'india_delta_juliet'yankee_four'two_papa'lima_two'foxtrot_three_charlie'xray_yankee'india_two'{bravo_november,sierra_papa_golf,seven_five}'three_juliet'echo_papa'zulu_delta'echo_papa'juliet_whiskey'yankee_four'whiskey_mike'echo_five_kilo'seven_november_kilo'charlie_uniform'xray_zulu'sierra_papa_four'hotel_quebec'whiskey_uniform'seven_three'whiskey_uniform'charlie_alpha'alpha_xray_six-four_papa_mike'seven_november_kilo'charlie_uniform'xray_zulu'sierra_papa_four'romeo_five_golf'charlie_hotel-yankee_seven'charlie_alpha'alpha_xray_six-bravo_delta_lima'seven_charlie_tango'golf_kilo'uniform_foxtrot'yankee_four'bravo_golf'{bravo_november,sierra_papa_golf,seven_five}'three_juliet'echo_papa'zulu_delta'echo_papa'zulu_echo'{bravo_november,sierra_papa_golf,seven_five}'delta_foxtrot_seven'echo_papa'delta_uniform_oscar'yankee_four'sierra_uniform'yankee_four'yankee_kilo'echo_papa'three_four'echo_papa'papa_sierra_sierra'{bravo_november,sierra_papa_golf,seven_five}'mike_golf'0'charlie_oscar'999999999999.99'mike_uniform'golf_kilo'victor_xray_zulu'yankee_four'echo_delta'echo_papa'whiskey_mike'quebec_lima'alpha_zulu_two'delta_november_oscar'romeo_hotel_zulu'romeo_lima'::text, zulu_golf()))::integer
  • Hash Cond: (((CASE WHEN ((yankee_quebec.tango_india)::text = 'papa_delta_juliet'::text) THEN 'seven_golf'::character varying WHEN (((yankee_quebec.quebec_four)::text = 'kilo_hotel'::text) AND ((yankee_quebec.victor_papa)::text = 'alpha_zulu_echo'::text) AND ((yankee_quebec.four_hotel)::text = 'delta_oscar_juliet'::text) AND ((yankee_quebec.whiskey_sierra)::text = 'delta_oscar_juliet'::text)) THEN 'mike_five'::character varying WHEN (((yankee_quebec.quebec_four)::text = 'kilo_hotel'::text) AND ((yankee_quebec.victor_papa)::text = 'alpha_zulu_echo'::text)) THEN 'hotel_romeo'::character varying ELSE yankee_quebec.quebec_xray END)::text = (november_three.quebec_xray)::text) AND ((yankee_quebec.romeo_hotel_victor)::text = (november_three.romeo_hotel_victor)::text))
2.          

CTE echo_xray

3. 217.898 37,207.490 ↓ 30.4 155,652 1

Subquery Scan on romeo_three (cost=2,196,879.580..2,240,348.160 rows=5,114 width=1,315) (actual time=29,172.803..37,207.490 rows=155,652 loops=1)

  • Output: romeo_three.quebec_seven, romeo_three.quebec_quebec_charlie, romeo_three.romeo_hotel_victor, romeo_three.hotel_november, romeo_three.whiskey_delta_oscar, romeo_three.november_bravo_four, romeo_three.romeo_foxtrot_yankee, romeo_three.tango_india, romeo_three.tango_yankee, romeo_three.victor_papa, romeo_three.delta_xray, romeo_three.sierra_xray, romeo_three.lima_echo_bravo, romeo_three.zulu_tango_uniform, romeo_three.quebec_zulu, romeo_three.xray_india, romeo_three.two_quebec, romeo_three.oscar_uniform, romeo_three.three_delta, romeo_three.quebec_seven2, romeo_three.quebec_seven3, romeo_three.quebec_seven4, romeo_three.quebec_seven5, romeo_three.papa_hotel, romeo_three.oscar_two_romeo, romeo_three.four_two, romeo_three.whiskey_oscar_six, romeo_three.yankee_mike, romeo_three.xray_quebec, romeo_three.seven_india, romeo_three.echo_uniform, romeo_three.bravo_bravo, romeo_three.five_india_india, romeo_three.hotel_foxtrot_seven, romeo_three.charlie_whiskey, romeo_three.oscar_two_november, romeo_three.victor_charlie, romeo_three.six_uniform, romeo_three.seven_hotel, romeo_three.sierra_foxtrot, romeo_three.echo_charlie_lima, romeo_three.alpha_five, romeo_three.whiskey_lima, romeo_three.oscar_november_quebec, romeo_three.oscar_november_xray, romeo_three.two_seven, romeo_three.delta_seven_xray, romeo_three.delta_hotel, romeo_three.kilo_yankee, romeo_three.lima_four_november, romeo_three.hotel_india, romeo_three.oscar_victor, romeo_three.two_yankee_tango, romeo_three.november_charlie_kilo, romeo_three.six_golf, romeo_three.zulu_two, romeo_three.three_seven, romeo_three.sierra_delta_uniform, romeo_three.seven_papa, romeo_three.romeo_hotel_papa, romeo_three.three_charlie, romeo_three.delta_november_india, romeo_three.charlie_six, romeo_three.five_india_four, romeo_three.alpha_delta, romeo_three.november_whiskey, romeo_three.november_juliet, romeo_three.delta_bravo, romeo_three.quebec_oscar, romeo_three.whiskey_foxtrot, romeo_three.quebec_seven1, romeo_three.quebec_seven6, romeo_three.quebec_seven7, romeo_three.quebec_seven8, romeo_three.hotel_mike, romeo_three.bravo_india, romeo_three.echo_charlie_zulu, romeo_three.mike_india, romeo_three.echo_golf, romeo_three.golf_mike_victor, romeo_three.papa_five, romeo_three.kilo_alpha, romeo_three.mike_oscar, romeo_three.kilo_whiskey, romeo_three.delta_tango, romeo_three.echo_five_hotel, romeo_three.whiskey_echo, romeo_three.two_yankee_three, romeo_three.november_six_two, romeo_three.november_uniform, romeo_three.three_oscar, romeo_three.alpha_alpha_kilo, romeo_three.whiskey_victor, romeo_three.three_papa, romeo_three.juliet_lima, romeo_three.yankee_juliet_juliet, romeo_three.november_bravo_two, romeo_three.india_seven, romeo_three.sierra_delta_charlie, romeo_three.yankee_two, romeo_three.sierra_romeo_oscar, romeo_three.alpha_charlie, romeo_three.romeo_golf, romeo_three.delta_lima, romeo_three.seven_alpha, romeo_three.lima_mike, romeo_three.tango_three, romeo_three.three_whiskey, romeo_three.kilo_mike, romeo_three.xray_november, romeo_three.charlie_zulu, romeo_three.uniform_papa, romeo_three.quebec_four, romeo_three.whiskey_romeo, romeo_three.whiskey_zulu, romeo_three.golf_sierra, romeo_three.foxtrot_oscar_tango, romeo_three.juliet_yankee, romeo_three.sierra_whiskey, romeo_three.uniform_november, romeo_three.foxtrot_three_juliet, romeo_three.delta_quebec, romeo_three.juliet_kilo, romeo_three.bravo_tango, romeo_three.delta_foxtrot_sierra, romeo_three.echo_mike_uniform, romeo_three.seven_echo, romeo_three.lima_november, romeo_three.yankee_juliet_tango, romeo_three.papa_lima, romeo_three.delta_uniform_india, romeo_three.victor_xray_oscar, romeo_three.echo_three_xray, romeo_three.zulu_mike, romeo_three.five_tango, romeo_three.quebec_sierra, romeo_three.india_three_bravo, romeo_three.kilo_five, romeo_three.juliet_india, romeo_three.oscar_lima_quebec, romeo_three.three_yankee, romeo_three.foxtrot_oscar_india, romeo_three.four_three, romeo_three.xray_seven, romeo_three.charlie_kilo_november, romeo_three.november_sierra, romeo_three.five_golf, romeo_three.foxtrot_oscar_november, romeo_three.echo_three_foxtrot, romeo_three.tango_papa, romeo_three.foxtrot_five, romeo_three.mike_four, romeo_three.yankee_whiskey_juliet, romeo_three.november_charlie_three, romeo_three.four_four, romeo_three.india_five, romeo_three.kilo_quebec_charlie, romeo_three.oscar_bravo, romeo_three.sierra_tango, romeo_three.six_two, romeo_three.four_kilo, romeo_three.zulu_papa, romeo_three.oscar_three, romeo_three.uniform_uniform_delta, romeo_three.quebec_kilo, romeo_three.lima_charlie, romeo_three.romeo_uniform, romeo_three.india_three_oscar, romeo_three.alpha_oscar, romeo_three.echo_yankee, romeo_three.uniform_uniform_alpha, romeo_three.delta_alpha, romeo_three.lima_echo_tango, romeo_three.charlie_echo, romeo_three.echo_bravo, romeo_three.november_kilo, romeo_three.alpha_alpha_november, romeo_three.november_bravo_november, romeo_three.zulu_sierra, romeo_three.tango_charlie, romeo_three.zulu_tango_juliet, romeo_three.five_yankee_alpha, romeo_three.echo_sierra, romeo_three.papa_kilo, romeo_three.lima_golf, romeo_three.juliet_delta, romeo_three.papa_tango, romeo_three.quebec_romeo_yankee, romeo_three.four_papa_two, romeo_three.india_yankee, romeo_three.romeo_five_two, romeo_three.whiskey_sierra, romeo_three.kilo_quebec_india, romeo_three.quebec_xray, romeo_three.three_kilo, romeo_three.golf_bravo, romeo_three.november_six_india, romeo_three.seven_november_yankee, romeo_three.romeo_november, romeo_three.papa_whiskey, romeo_three.kilo_juliet, romeo_three.six_foxtrot_three, romeo_three.four_hotel, romeo_three.india_golf, romeo_three.foxtrot_bravo, romeo_three.whiskey_oscar_three, romeo_three.delta_two, romeo_three.yankee_november, romeo_three.yankee_charlie, romeo_three.lima_romeo, romeo_three.five_delta, romeo_three.bravo_delta_romeo, romeo_three.sierra_three, romeo_three.delta_oscar_romeo, romeo_three.oscar_lima_victor, romeo_three.yankee_whiskey_charlie, romeo_three.papa_zulu, romeo_three.two_romeo, romeo_three.romeo_six, romeo_three.kilo_victor_four, romeo_three.quebec_golf, romeo_three.xray_five, romeo_three.alpha_foxtrot, romeo_three.quebec_romeo_hotel, romeo_three.mike_quebec, romeo_three.kilo_romeo, romeo_three.charlie_tango, romeo_three.oscar_kilo, romeo_three.papa_delta_sierra, romeo_three.hotel_foxtrot_sierra, romeo_three.seven_charlie_two, romeo_three.november_alpha, romeo_three.five_yankee_mike, romeo_three.foxtrot_foxtrot, romeo_three.oscar_yankee, romeo_three.kilo_victor_papa, romeo_three.delta_yankee, romeo_three.romeo_four, romeo_three.foxtrot_oscar_romeo, romeo_three.delta_seven_oscar, romeo_three.mike_yankee, romeo_three.whiskey_tango, romeo_three.romeo_foxtrot_xray, romeo_three.delta_six, romeo_three.lima_kilo, romeo_three.papa_four, romeo_three.charlie_mike, romeo_three.two_bravo, romeo_three.delta_juliet, romeo_three.sierra_romeo_november, romeo_three.two_india, romeo_three.quebec_quebec_uniform, romeo_three.bravo_delta_india, romeo_three.golf_papa, romeo_three.bravo_kilo, romeo_three.lima_hotel, romeo_three.bravo_papa, romeo_three.victor_mike, romeo_three.oscar_echo, romeo_three.seven_xray, romeo_three.golf_five, romeo_three.tango_tango, romeo_three.juliet_xray, romeo_three.romeo_kilo, romeo_three.november_foxtrot, romeo_three.hotel_victor, romeo_three.seven_foxtrot, romeo_three.xray_charlie, romeo_three.november_oscar, romeo_three.five_four, romeo_three.romeo_bravo, romeo_three.whiskey_alpha_zulu, romeo_three.whiskey_delta_november, romeo_three.sierra_lima, romeo_three.papa_sierra_whiskey, romeo_three.victor_india_whiskey, romeo_three.five_charlie, romeo_three.five_hotel, romeo_three.whiskey_two, romeo_three.golf_india, romeo_three.india_papa, romeo_three.india_delta_papa, romeo_three.four_seven, romeo_three.charlie_kilo_zulu, romeo_three.six_foxtrot_four, romeo_three.whiskey_alpha_alpha, romeo_three.delta_november_alpha, romeo_three.echo_mike_two, romeo_three.echo_november, romeo_three.foxtrot_whiskey, romeo_three.papa_two, romeo_three.alpha_whiskey, romeo_three.hotel_whiskey, romeo_three.oscar_four, romeo_three.mike_papa, romeo_three.uniform_mike, romeo_three.four_whiskey, romeo_three.xray_romeo
  • Filter: (romeo_three.xray_romeo = 1)
  • Rows Removed by Filter: 809456
4. 3,314.052 36,989.592 ↑ 1.1 965,108 1

WindowAgg (cost=2,196,879.580..2,227,563.280 rows=1,022,790 width=1,347) (actual time=29,172.769..36,989.592 rows=965,108 loops=1)

  • Output: papa_six1.quebec_seven, papa_six1.quebec_quebec_charlie, papa_six1.romeo_hotel_victor, papa_six1.hotel_november, papa_six1.whiskey_delta_oscar, papa_six1.november_bravo_four, papa_six1.romeo_foxtrot_yankee, papa_six1.tango_india, papa_six1.tango_yankee, papa_six1.victor_papa, papa_six1.delta_xray, papa_six1.sierra_xray, papa_six1.lima_echo_bravo, papa_six1.zulu_tango_uniform, papa_six1.quebec_zulu, papa_six1.xray_india, papa_six1.two_quebec, papa_six1.oscar_uniform, papa_six1.three_delta, papa_six1.quebec_seven2, papa_six1.quebec_seven3, papa_six1.quebec_seven4, papa_six1.quebec_seven5, papa_six1.papa_hotel, papa_six1.oscar_two_romeo, papa_six1.four_two, papa_six1.whiskey_oscar_six, papa_six1.yankee_mike, papa_six1.xray_quebec, papa_six1.seven_india, papa_six1.echo_uniform, papa_six1.bravo_bravo, papa_six1.five_india_india, papa_six1.hotel_foxtrot_seven, papa_six1.charlie_whiskey, papa_six1.oscar_two_november, papa_six1.victor_charlie, papa_six1.six_uniform, papa_six1.seven_hotel, papa_six1.sierra_foxtrot, papa_six1.echo_charlie_lima, papa_six1.alpha_five, papa_six1.whiskey_lima, papa_six1.oscar_november_quebec, papa_six1.oscar_november_xray, papa_six1.two_seven, papa_six1.delta_seven_xray, papa_six1.delta_hotel, papa_six1.kilo_yankee, papa_six1.lima_four_november, papa_six1.hotel_india, papa_six1.oscar_victor, papa_six1.two_yankee_tango, papa_six1.november_charlie_kilo, papa_six1.six_golf, papa_six1.zulu_two, papa_six1.three_seven, papa_six1.sierra_delta_uniform, papa_six1.seven_papa, papa_six1.romeo_hotel_papa, papa_six1.three_charlie, papa_six1.delta_november_india, papa_six1.charlie_six, papa_six1.five_india_four, papa_six1.alpha_delta, papa_six1.november_whiskey, papa_six1.november_juliet, papa_six1.delta_bravo, papa_six1.quebec_oscar, papa_six1.whiskey_foxtrot, papa_six1.quebec_seven1, papa_six1.quebec_seven6, papa_six1.quebec_seven7, papa_six1.quebec_seven8, papa_six1.hotel_mike, papa_six1.bravo_india, papa_six1.echo_charlie_zulu, papa_six1.mike_india, papa_six1.echo_golf, papa_six1.golf_mike_victor, papa_six1.papa_five, papa_six1.kilo_alpha, papa_six1.mike_oscar, papa_six1.kilo_whiskey, papa_six1.delta_tango, papa_six1.echo_five_hotel, papa_six1.whiskey_echo, papa_six1.two_yankee_three, papa_six1.november_six_two, papa_six1.november_uniform, papa_six1.three_oscar, papa_six1.alpha_alpha_kilo, papa_six1.whiskey_victor, papa_six1.three_papa, papa_six1.juliet_lima, papa_six1.yankee_juliet_juliet, papa_six1.november_bravo_two, papa_six1.india_seven, papa_six1.sierra_delta_charlie, papa_six1.yankee_two, papa_six1.sierra_romeo_oscar, papa_six1.alpha_charlie, papa_six1.romeo_golf, papa_six1.delta_lima, papa_six1.seven_alpha, papa_six1.lima_mike, papa_six1.tango_three, papa_six1.three_whiskey, papa_six1.kilo_mike, papa_six1.xray_november, papa_six1.charlie_zulu, papa_six1.uniform_papa, papa_six1.quebec_four, papa_six1.quebec_four, papa_six1.whiskey_zulu, CASE WHEN (((papa_six1.golf_sierra)::text = ''victor_india_victor'uniform_juliet'::text, papa_six1.sierra_delta_uniform), five_zulu() zulu_quebec (?), ((papa_six1.romeo_hotel_victor)::text)
5. 27,720.325 33,675.540 ↑ 1.1 965,108 1

Sort (cost=2,196,879.580..2,199,436.560 rows=1,022,790 width=1,308) (actual time=29,172.514..33,675.540 rows=965,108 loops=1)

  • Output: papa_six1.quebec_seven, ((papa_six1.romeo_hotel_victor)::text), papa_six1.quebec_quebec_charlie, papa_six1.romeo_hotel_victor, papa_six1.hotel_november, papa_six1.whiskey_delta_oscar, papa_six1.november_bravo_four, papa_six1.romeo_foxtrot_yankee, papa_six1.tango_india, papa_six1.tango_yankee, papa_six1.victor_papa, papa_six1.delta_xray, papa_six1.sierra_xray, papa_six1.lima_echo_bravo, papa_six1.zulu_tango_uniform, papa_six1.quebec_zulu, papa_six1.xray_india, papa_six1.two_quebec, papa_six1.oscar_uniform, papa_six1.three_delta, papa_six1.quebec_seven2, papa_six1.quebec_seven3, papa_six1.quebec_seven4, papa_six1.quebec_seven5, papa_six1.papa_hotel, papa_six1.oscar_two_romeo, papa_six1.four_two, papa_six1.whiskey_oscar_six, papa_six1.yankee_mike, papa_six1.xray_quebec, papa_six1.seven_india, papa_six1.echo_uniform, papa_six1.bravo_bravo, papa_six1.five_india_india, papa_six1.hotel_foxtrot_seven, papa_six1.charlie_whiskey, papa_six1.oscar_two_november, papa_six1.victor_charlie, papa_six1.six_uniform, papa_six1.seven_hotel, papa_six1.sierra_foxtrot, papa_six1.echo_charlie_lima, papa_six1.alpha_five, papa_six1.whiskey_lima, papa_six1.oscar_november_quebec, papa_six1.oscar_november_xray, papa_six1.two_seven, papa_six1.delta_seven_xray, papa_six1.delta_hotel, papa_six1.kilo_yankee, papa_six1.lima_four_november, papa_six1.hotel_india, papa_six1.oscar_victor, papa_six1.two_yankee_tango, papa_six1.november_charlie_kilo, papa_six1.six_golf, papa_six1.zulu_two, papa_six1.three_seven, papa_six1.sierra_delta_uniform, papa_six1.seven_papa, papa_six1.romeo_hotel_papa, papa_six1.three_charlie, papa_six1.delta_november_india, papa_six1.charlie_six, papa_six1.five_india_four, papa_six1.alpha_delta, papa_six1.november_whiskey, papa_six1.november_juliet, papa_six1.delta_bravo, papa_six1.quebec_oscar, papa_six1.whiskey_foxtrot, papa_six1.quebec_seven1, papa_six1.quebec_seven6, papa_six1.quebec_seven7, papa_six1.quebec_seven8, papa_six1.hotel_mike, papa_six1.bravo_india, papa_six1.echo_charlie_zulu, papa_six1.mike_india, papa_six1.echo_golf, papa_six1.golf_mike_victor, papa_six1.papa_five, papa_six1.kilo_alpha, papa_six1.mike_oscar, papa_six1.kilo_whiskey, papa_six1.delta_tango, papa_six1.echo_five_hotel, papa_six1.whiskey_echo, papa_six1.two_yankee_three, papa_six1.november_six_two, papa_six1.november_uniform, papa_six1.three_oscar, papa_six1.alpha_alpha_kilo, papa_six1.whiskey_victor, papa_six1.three_papa, papa_six1.juliet_lima, papa_six1.yankee_juliet_juliet, papa_six1.november_bravo_two, papa_six1.india_seven, papa_six1.sierra_delta_charlie, papa_six1.yankee_two, papa_six1.sierra_romeo_oscar, papa_six1.alpha_charlie, papa_six1.romeo_golf, papa_six1.delta_lima, papa_six1.seven_alpha, papa_six1.lima_mike, papa_six1.tango_three, papa_six1.three_whiskey, papa_six1.kilo_mike, papa_six1.xray_november, papa_six1.charlie_zulu, papa_six1.uniform_papa, papa_six1.quebec_four, papa_six1.whiskey_zulu, papa_six1.golf_sierra, papa_six1.foxtrot_oscar_tango, papa_six1.juliet_yankee, papa_six1.sierra_whiskey, papa_six1.uniform_november, papa_six1.foxtrot_three_juliet, papa_six1.delta_quebec, papa_six1.juliet_kilo, papa_six1.bravo_tango, papa_six1.delta_foxtrot_sierra, papa_six1.echo_mike_uniform, papa_six1.seven_echo, papa_six1.lima_november, papa_six1.yankee_juliet_tango, papa_six1.papa_lima, papa_six1.delta_uniform_india, papa_six1.victor_xray_oscar, papa_six1.echo_three_xray, papa_six1.zulu_mike, papa_six1.five_tango, papa_six1.quebec_sierra, papa_six1.india_three_bravo, papa_six1.kilo_five, papa_six1.juliet_india, papa_six1.oscar_lima_quebec, papa_six1.three_yankee, papa_six1.foxtrot_oscar_india, papa_six1.four_three, papa_six1.xray_seven, papa_six1.charlie_kilo_november, papa_six1.november_sierra, papa_six1.five_golf, papa_six1.foxtrot_oscar_november, papa_six1.echo_three_foxtrot, papa_six1.tango_papa, papa_six1.foxtrot_five, papa_six1.mike_four, papa_six1.yankee_whiskey_juliet, papa_six1.november_charlie_three, papa_six1.four_four, papa_six1.india_five, papa_six1.kilo_quebec_charlie, papa_six1.oscar_bravo, papa_six1.sierra_tango, papa_six1.six_two, papa_six1.four_kilo, papa_six1.zulu_papa, papa_six1.oscar_three, papa_six1.uniform_uniform_delta, papa_six1.quebec_kilo, papa_six1.lima_charlie, papa_six1.romeo_uniform, papa_six1.india_three_oscar, papa_six1.alpha_oscar, papa_six1.echo_yankee, papa_six1.uniform_uniform_alpha, papa_six1.delta_alpha, papa_six1.lima_echo_tango, papa_six1.charlie_echo, papa_six1.echo_bravo, papa_six1.november_kilo, papa_six1.alpha_alpha_november, papa_six1.november_bravo_november, papa_six1.zulu_sierra, papa_six1.tango_charlie, papa_six1.zulu_tango_juliet, papa_six1.five_yankee_alpha, papa_six1.echo_sierra, papa_six1.papa_kilo, papa_six1.lima_golf, papa_six1.juliet_delta, papa_six1.papa_tango, papa_six1.quebec_romeo_yankee, papa_six1.four_papa_two, papa_six1.india_yankee, papa_six1.romeo_five_two, papa_six1.whiskey_sierra, papa_six1.kilo_quebec_india, papa_six1.quebec_xray, papa_six1.three_kilo, papa_six1.golf_bravo, papa_six1.november_six_india, papa_six1.seven_november_yankee, papa_six1.romeo_november, papa_six1.papa_whiskey, papa_six1.kilo_juliet, papa_six1.six_foxtrot_three, papa_six1.four_hotel, papa_six1.india_golf, papa_six1.foxtrot_bravo, papa_six1.whiskey_oscar_three, papa_six1.delta_two, papa_six1.yankee_november, papa_six1.yankee_charlie, papa_six1.lima_romeo, papa_six1.five_delta, papa_six1.bravo_delta_romeo, papa_six1.sierra_three, papa_six1.delta_oscar_romeo, papa_six1.oscar_lima_victor, papa_six1.yankee_whiskey_charlie, papa_six1.papa_zulu, papa_six1.two_romeo, papa_six1.romeo_six, papa_six1.kilo_victor_four, papa_six1.quebec_golf, papa_six1.xray_five, papa_six1.alpha_foxtrot, papa_six1.quebec_romeo_hotel, papa_six1.mike_quebec, papa_six1.kilo_romeo, papa_six1.charlie_tango, papa_six1.oscar_kilo, papa_six1.papa_delta_sierra, papa_six1.hotel_foxtrot_sierra, papa_six1.seven_charlie_two, papa_six1.november_alpha, papa_six1.five_yankee_mike, papa_six1.foxtrot_foxtrot, papa_six1.oscar_yankee, papa_six1.kilo_victor_papa, papa_six1.delta_yankee, papa_six1.romeo_four, papa_six1.foxtrot_oscar_romeo, papa_six1.delta_seven_oscar, papa_six1.mike_yankee, papa_six1.whiskey_tango, papa_six1.romeo_foxtrot_xray, papa_six1.delta_six, papa_six1.lima_kilo, papa_six1.papa_four, papa_six1.charlie_mike, papa_six1.two_bravo, papa_six1.delta_juliet, papa_six1.sierra_romeo_november, papa_six1.two_india, papa_six1.quebec_quebec_uniform, papa_six1.bravo_delta_india, papa_six1.golf_papa, papa_six1.bravo_kilo, papa_six1.lima_hotel, papa_six1.bravo_papa, papa_six1.victor_mike, papa_six1.oscar_echo, papa_six1.seven_xray, papa_six1.golf_five, papa_six1.tango_tango, papa_six1.juliet_xray, papa_six1.romeo_kilo, papa_six1.november_foxtrot, papa_six1.hotel_victor, papa_six1.seven_foxtrot, papa_six1.xray_charlie, papa_six1.november_oscar, papa_six1.five_four, papa_six1.romeo_bravo, papa_six1.whiskey_alpha_zulu, papa_six1.whiskey_delta_november, papa_six1.sierra_lima, papa_six1.papa_sierra_whiskey, papa_six1.victor_india_whiskey, papa_six1.five_charlie, papa_six1.five_hotel, papa_six1.whiskey_two, papa_six1.golf_india, papa_six1.india_papa, papa_six1.india_delta_papa, papa_six1.four_seven, papa_six1.charlie_kilo_zulu, papa_six1.six_foxtrot_four, papa_six1.whiskey_alpha_alpha, papa_six1.delta_november_alpha, papa_six1.echo_mike_two, papa_six1.echo_november, papa_six1.foxtrot_whiskey, papa_six1.papa_two, papa_six1.alpha_whiskey, papa_six1.hotel_whiskey, papa_six1.oscar_four, papa_six1.mike_papa, papa_six1.uniform_mike
  • Sort Key: ((papa_six1.romeo_hotel_victor)::text), papa_six1.quebec_seven DESC
  • Sort Method: external merge Disk: 1165744kB
6. 5,955.215 5,955.215 ↑ 1.1 965,108 1

Seq Scan on uniform_echo sierra_november (cost=0.000..343,352.780 rows=1,022,790 width=1,308) (actual time=0.075..5,955.215 rows=965,108 loops=1)

  • Output: papa_six1.quebec_seven, (papa_six1.romeo_hotel_victor)::text, papa_six1.quebec_quebec_charlie, papa_six1.romeo_hotel_victor, papa_six1.hotel_november, papa_six1.whiskey_delta_oscar, papa_six1.november_bravo_four, papa_six1.romeo_foxtrot_yankee, papa_six1.tango_india, papa_six1.tango_yankee, papa_six1.victor_papa, papa_six1.delta_xray, papa_six1.sierra_xray, papa_six1.lima_echo_bravo, papa_six1.zulu_tango_uniform, papa_six1.quebec_zulu, papa_six1.xray_india, papa_six1.two_quebec, papa_six1.oscar_uniform, papa_six1.three_delta, papa_six1.quebec_seven2, papa_six1.quebec_seven3, papa_six1.quebec_seven4, papa_six1.quebec_seven5, papa_six1.papa_hotel, papa_six1.oscar_two_romeo, papa_six1.four_two, papa_six1.whiskey_oscar_six, papa_six1.yankee_mike, papa_six1.xray_quebec, papa_six1.seven_india, papa_six1.echo_uniform, papa_six1.bravo_bravo, papa_six1.five_india_india, papa_six1.hotel_foxtrot_seven, papa_six1.charlie_whiskey, papa_six1.oscar_two_november, papa_six1.victor_charlie, papa_six1.six_uniform, papa_six1.seven_hotel, papa_six1.sierra_foxtrot, papa_six1.echo_charlie_lima, papa_six1.alpha_five, papa_six1.whiskey_lima, papa_six1.oscar_november_quebec, papa_six1.oscar_november_xray, papa_six1.two_seven, papa_six1.delta_seven_xray, papa_six1.delta_hotel, papa_six1.kilo_yankee, papa_six1.lima_four_november, papa_six1.hotel_india, papa_six1.oscar_victor, papa_six1.two_yankee_tango, papa_six1.november_charlie_kilo, papa_six1.six_golf, papa_six1.zulu_two, papa_six1.three_seven, papa_six1.sierra_delta_uniform, papa_six1.seven_papa, papa_six1.romeo_hotel_papa, papa_six1.three_charlie, papa_six1.delta_november_india, papa_six1.charlie_six, papa_six1.five_india_four, papa_six1.alpha_delta, papa_six1.november_whiskey, papa_six1.november_juliet, papa_six1.delta_bravo, papa_six1.quebec_oscar, papa_six1.whiskey_foxtrot, papa_six1.quebec_seven1, papa_six1.quebec_seven6, papa_six1.quebec_seven7, papa_six1.quebec_seven8, papa_six1.hotel_mike, papa_six1.bravo_india, papa_six1.echo_charlie_zulu, papa_six1.mike_india, papa_six1.echo_golf, papa_six1.golf_mike_victor, papa_six1.papa_five, papa_six1.kilo_alpha, papa_six1.mike_oscar, papa_six1.kilo_whiskey, papa_six1.delta_tango, papa_six1.echo_five_hotel, papa_six1.whiskey_echo, papa_six1.two_yankee_three, papa_six1.november_six_two, papa_six1.november_uniform, papa_six1.three_oscar, papa_six1.alpha_alpha_kilo, papa_six1.whiskey_victor, papa_six1.three_papa, papa_six1.juliet_lima, papa_six1.yankee_juliet_juliet, papa_six1.november_bravo_two, papa_six1.india_seven, papa_six1.sierra_delta_charlie, papa_six1.yankee_two, papa_six1.sierra_romeo_oscar, papa_six1.alpha_charlie, papa_six1.romeo_golf, papa_six1.delta_lima, papa_six1.seven_alpha, papa_six1.lima_mike, papa_six1.tango_three, papa_six1.three_whiskey, papa_six1.kilo_mike, papa_six1.xray_november, papa_six1.charlie_zulu, papa_six1.uniform_papa, papa_six1.quebec_four, papa_six1.whiskey_zulu, papa_six1.golf_sierra, papa_six1.foxtrot_oscar_tango, papa_six1.juliet_yankee, papa_six1.sierra_whiskey, papa_six1.uniform_november, papa_six1.foxtrot_three_juliet, papa_six1.delta_quebec, papa_six1.juliet_kilo, papa_six1.bravo_tango, papa_six1.delta_foxtrot_sierra, papa_six1.echo_mike_uniform, papa_six1.seven_echo, papa_six1.lima_november, papa_six1.yankee_juliet_tango, papa_six1.papa_lima, papa_six1.delta_uniform_india, papa_six1.victor_xray_oscar, papa_six1.echo_three_xray, papa_six1.zulu_mike, papa_six1.five_tango, papa_six1.quebec_sierra, papa_six1.india_three_bravo, papa_six1.kilo_five, papa_six1.juliet_india, papa_six1.oscar_lima_quebec, papa_six1.three_yankee, papa_six1.foxtrot_oscar_india, papa_six1.four_three, papa_six1.xray_seven, papa_six1.charlie_kilo_november, papa_six1.november_sierra, papa_six1.five_golf, papa_six1.foxtrot_oscar_november, papa_six1.echo_three_foxtrot, papa_six1.tango_papa, papa_six1.foxtrot_five, papa_six1.mike_four, papa_six1.yankee_whiskey_juliet, papa_six1.november_charlie_three, papa_six1.four_four, papa_six1.india_five, papa_six1.kilo_quebec_charlie, papa_six1.oscar_bravo, papa_six1.sierra_tango, papa_six1.six_two, papa_six1.four_kilo, papa_six1.zulu_papa, papa_six1.oscar_three, papa_six1.uniform_uniform_delta, papa_six1.quebec_kilo, papa_six1.lima_charlie, papa_six1.romeo_uniform, papa_six1.india_three_oscar, papa_six1.alpha_oscar, papa_six1.echo_yankee, papa_six1.uniform_uniform_alpha, papa_six1.delta_alpha, papa_six1.lima_echo_tango, papa_six1.charlie_echo, papa_six1.echo_bravo, papa_six1.november_kilo, papa_six1.alpha_alpha_november, papa_six1.november_bravo_november, papa_six1.zulu_sierra, papa_six1.tango_charlie, papa_six1.zulu_tango_juliet, papa_six1.five_yankee_alpha, papa_six1.echo_sierra, papa_six1.papa_kilo, papa_six1.lima_golf, papa_six1.juliet_delta, papa_six1.papa_tango, papa_six1.quebec_romeo_yankee, papa_six1.four_papa_two, papa_six1.india_yankee, papa_six1.romeo_five_two, papa_six1.whiskey_sierra, papa_six1.kilo_quebec_india, papa_six1.quebec_xray, papa_six1.three_kilo, papa_six1.golf_bravo, papa_six1.november_six_india, papa_six1.seven_november_yankee, papa_six1.romeo_november, papa_six1.papa_whiskey, papa_six1.kilo_juliet, papa_six1.six_foxtrot_three, papa_six1.four_hotel, papa_six1.india_golf, papa_six1.foxtrot_bravo, papa_six1.whiskey_oscar_three, papa_six1.delta_two, papa_six1.yankee_november, papa_six1.yankee_charlie, papa_six1.lima_romeo, papa_six1.five_delta, papa_six1.bravo_delta_romeo, papa_six1.sierra_three, papa_six1.delta_oscar_romeo, papa_six1.oscar_lima_victor, papa_six1.yankee_whiskey_charlie, papa_six1.papa_zulu, papa_six1.two_romeo, papa_six1.romeo_six, papa_six1.kilo_victor_four, papa_six1.quebec_golf, papa_six1.xray_five, papa_six1.alpha_foxtrot, papa_six1.quebec_romeo_hotel, papa_six1.mike_quebec, papa_six1.kilo_romeo, papa_six1.charlie_tango, papa_six1.oscar_kilo, papa_six1.papa_delta_sierra, papa_six1.hotel_foxtrot_sierra, papa_six1.seven_charlie_two, papa_six1.november_alpha, papa_six1.five_yankee_mike, papa_six1.foxtrot_foxtrot, papa_six1.oscar_yankee, papa_six1.kilo_victor_papa, papa_six1.delta_yankee, papa_six1.romeo_four, papa_six1.foxtrot_oscar_romeo, papa_six1.delta_seven_oscar, papa_six1.mike_yankee, papa_six1.whiskey_tango, papa_six1.romeo_foxtrot_xray, papa_six1.delta_six, papa_six1.lima_kilo, papa_six1.papa_four, papa_six1.charlie_mike, papa_six1.two_bravo, papa_six1.delta_juliet, papa_six1.sierra_romeo_november, papa_six1.two_india, papa_six1.quebec_quebec_uniform, papa_six1.bravo_delta_india, papa_six1.golf_papa, papa_six1.bravo_kilo, papa_six1.lima_hotel, papa_six1.bravo_papa, papa_six1.victor_mike, papa_six1.oscar_echo, papa_six1.seven_xray, papa_six1.golf_five, papa_six1.tango_tango, papa_six1.juliet_xray, papa_six1.romeo_kilo, papa_six1.november_foxtrot, papa_six1.hotel_victor, papa_six1.seven_foxtrot, papa_six1.xray_charlie, papa_six1.november_oscar, papa_six1.five_four, papa_six1.romeo_bravo, papa_six1.whiskey_alpha_zulu, papa_six1.whiskey_delta_november, papa_six1.sierra_lima, papa_six1.papa_sierra_whiskey, papa_six1.victor_india_whiskey, papa_six1.five_charlie, papa_six1.five_hotel, papa_six1.whiskey_two, papa_six1.golf_india, papa_six1.india_papa, papa_six1.india_delta_papa, papa_six1.four_seven, papa_six1.charlie_kilo_zulu, papa_six1.six_foxtrot_four, papa_six1.whiskey_alpha_alpha, papa_six1.delta_november_alpha, papa_six1.echo_mike_two, papa_six1.echo_november, papa_six1.foxtrot_whiskey, papa_six1.papa_two, papa_six1.alpha_whiskey, papa_six1.hotel_whiskey, papa_six1.oscar_four, papa_six1.mike_papa, papa_six1.uniform_mike
  • Filter: (((papa_six1.golf_bravo)::text !~ 'romeo_sierra'::text) AND (((papa_six1.four_hotel)::text <> 'delta_oscar_juliet'::text) OR ((papa_six1.whiskey_sierra)::text <> 'uniform_five'::text)) AND (papa_six1.seven_papa >= (current_date - 'foxtrot_papa'::interval)) AND (((papa_six1.four_hotel)::text <> 'delta_oscar_juliet'::text) OR ((papa_six1.whiskey_sierra)::text <> 'delta_oscar_juliet'::text) OR ((papa_six1.victor_papa)::text <> 'alpha_zulu_echo'::text) OR ((papa_six1.quebec_four)::text <> 'seven_kilo'::text)))
  • Rows Removed by Filter: 30385
7. 773.316 42,104.882 ↓ 30.4 155,652 1

Nested Loop Left Join (cost=0.420..25,126.790 rows=5,114 width=1,983) (actual time=29,173.154..42,104.882 rows=155,652 loops=1)

  • Output: yankee_quebec.quebec_seven, yankee_quebec.echo_mike_uniform, yankee_quebec.seven_echo, yankee_quebec.papa_whiskey, yankee_quebec.oscar_lima_quebec, yankee_quebec.three_yankee, yankee_quebec.foxtrot_oscar_india, yankee_quebec.papa_zulu, yankee_quebec.yankee_whiskey_juliet, yankee_quebec.india_five, yankee_quebec.oscar_bravo, yankee_quebec.romeo_hotel_victor, yankee_quebec.tango_india, yankee_quebec.xray_india, yankee_quebec.golf_bravo, yankee_quebec.delta_xray, yankee_quebec.quebec_quebec_charlie, yankee_quebec.papa_hotel, yankee_quebec.golf_sierra, yankee_quebec.oscar_uniform, yankee_quebec.whiskey_sierra, yankee_quebec.lima_four_november, yankee_quebec.juliet_india, yankee_quebec.charlie_six, yankee_quebec.six_uniform, yankee_quebec.zulu_mike, yankee_quebec.quebec_seven4, yankee_quebec.quebec_sierra, yankee_quebec.juliet_kilo, yankee_quebec.delta_quebec, yankee_quebec.golf_papa, yankee_quebec.five_tango, yankee_quebec.november_six_india, yankee_quebec.seven_november_yankee, yankee_quebec.two_quebec, yankee_quebec.zulu_tango_uniform, yankee_quebec.four_two, yankee_quebec.three_charlie, yankee_quebec.quebec_four, yankee_quebec.victor_papa, yankee_quebec.four_hotel, yankee_quebec.quebec_xray, yankee_quebec.oscar_november_xray, yankee_quebec.delta_foxtrot_sierra, yankee_quebec.alpha_five, yankee_quebec.sierra_foxtrot, yankee_quebec.bravo_tango, yankee_quebec.hotel_foxtrot_seven, yankee_quebec.charlie_zulu, yankee_quebec.zulu_two, yankee_quebec.three_kilo, yankee_quebec.yankee_juliet_tango, yankee_quebec.lima_romeo, yankee_quebec.whiskey_delta_oscar, yankee_quebec.delta_november_india, yankee_quebec.sierra_delta_uniform, yankee_quebec.sierra_whiskey, yankee_quebec.echo_charlie_lima, yankee_quebec.kilo_romeo, uniform_victor.golf_sierra, uniform_victor.juliet_india, uniform_victor.charlie_six, uniform_victor.zulu_mike, uniform_victor.quebec_sierra, uniform_victor.juliet_kilo, uniform_victor.delta_quebec, uniform_victor.five_tango, uniform_victor.november_six_india, uniform_victor.seven_november_yankee, uniform_victor.romeo_hotel_victor, uniform_victor.tango_india, uniform_victor.india_five, uniform_victor.seven_echo, uniform_victor.foxtrot_oscar_india, uniform_victor.delta_foxtrot_sierra, uniform_victor.oscar_bravo, uniform_victor.whiskey_sierra, uniform_victor.sierra_foxtrot, uniform_victor.bravo_tango, uniform_victor.oscar_lima_quebec, uniform_victor.hotel_foxtrot_seven, uniform_victor.charlie_zulu, uniform_victor.three_kilo, uniform_victor.yankee_juliet_tango, uniform_victor.lima_romeo, uniform_victor.papa_whiskey, uniform_victor.papa_zulu, uniform_victor.hotel_whiskey, uniform_victor.zulu_tango_uniform, uniform_victor.sierra_whiskey, uniform_victor.yankee_whiskey_juliet, uniform_victor.echo_charlie_lima, uniform_victor.foxtrot_oscar_tango, uniform_victor.quebec_four, uniform_victor.kilo_romeo
8. 38,996.786 38,996.786 ↓ 30.4 155,652 1

CTE Scan on echo_xray yankee_quebec (cost=0.000..102.280 rows=5,114 width=1,788) (actual time=29,172.890..38,996.786 rows=155,652 loops=1)

  • Output: yankee_quebec.quebec_seven, yankee_quebec.quebec_quebec_charlie, yankee_quebec.romeo_hotel_victor, yankee_quebec.hotel_november, yankee_quebec.whiskey_delta_oscar, yankee_quebec.november_bravo_four, yankee_quebec.romeo_foxtrot_yankee, yankee_quebec.tango_india, yankee_quebec.tango_yankee, yankee_quebec.victor_papa, yankee_quebec.delta_xray, yankee_quebec.sierra_xray, yankee_quebec.lima_echo_bravo, yankee_quebec.zulu_tango_uniform, yankee_quebec.quebec_zulu, yankee_quebec.xray_india, yankee_quebec.two_quebec, yankee_quebec.oscar_uniform, yankee_quebec.three_delta, yankee_quebec.quebec_seven2, yankee_quebec.quebec_seven3, yankee_quebec.quebec_seven4, yankee_quebec.quebec_seven5, yankee_quebec.papa_hotel, yankee_quebec.oscar_two_romeo, yankee_quebec.four_two, yankee_quebec.whiskey_oscar_six, yankee_quebec.yankee_mike, yankee_quebec.xray_quebec, yankee_quebec.seven_india, yankee_quebec.echo_uniform, yankee_quebec.bravo_bravo, yankee_quebec.five_india_india, yankee_quebec.hotel_foxtrot_seven, yankee_quebec.charlie_whiskey, yankee_quebec.oscar_two_november, yankee_quebec.victor_charlie, yankee_quebec.six_uniform, yankee_quebec.seven_hotel, yankee_quebec.sierra_foxtrot, yankee_quebec.echo_charlie_lima, yankee_quebec.alpha_five, yankee_quebec.whiskey_lima, yankee_quebec.oscar_november_quebec, yankee_quebec.oscar_november_xray, yankee_quebec.two_seven, yankee_quebec.delta_seven_xray, yankee_quebec.delta_hotel, yankee_quebec.kilo_yankee, yankee_quebec.lima_four_november, yankee_quebec.hotel_india, yankee_quebec.oscar_victor, yankee_quebec.two_yankee_tango, yankee_quebec.november_charlie_kilo, yankee_quebec.six_golf, yankee_quebec.zulu_two, yankee_quebec.three_seven, yankee_quebec.sierra_delta_uniform, yankee_quebec.seven_papa, yankee_quebec.romeo_hotel_papa, yankee_quebec.three_charlie, yankee_quebec.delta_november_india, yankee_quebec.charlie_six, yankee_quebec.five_india_four, yankee_quebec.alpha_delta, yankee_quebec.november_whiskey, yankee_quebec.november_juliet, yankee_quebec.delta_bravo, yankee_quebec.quebec_oscar, yankee_quebec.whiskey_foxtrot, yankee_quebec.quebec_seven1, yankee_quebec.quebec_seven6, yankee_quebec.quebec_seven7, yankee_quebec.quebec_seven8, yankee_quebec.hotel_mike, yankee_quebec.bravo_india, yankee_quebec.echo_charlie_zulu, yankee_quebec.mike_india, yankee_quebec.echo_golf, yankee_quebec.golf_mike_victor, yankee_quebec.papa_five, yankee_quebec.kilo_alpha, yankee_quebec.mike_oscar, yankee_quebec.kilo_whiskey, yankee_quebec.delta_tango, yankee_quebec.echo_five_hotel, yankee_quebec.whiskey_echo, yankee_quebec.two_yankee_three, yankee_quebec.november_six_two, yankee_quebec.november_uniform, yankee_quebec.three_oscar, yankee_quebec.alpha_alpha_kilo, yankee_quebec.whiskey_victor, yankee_quebec.three_papa, yankee_quebec.juliet_lima, yankee_quebec.yankee_juliet_juliet, yankee_quebec.november_bravo_two, yankee_quebec.india_seven, yankee_quebec.sierra_delta_charlie, yankee_quebec.yankee_two, yankee_quebec.sierra_romeo_oscar, yankee_quebec.alpha_charlie, yankee_quebec.romeo_golf, yankee_quebec.delta_lima, yankee_quebec.seven_alpha, yankee_quebec.lima_mike, yankee_quebec.tango_three, yankee_quebec.three_whiskey, yankee_quebec.kilo_mike, yankee_quebec.xray_november, yankee_quebec.charlie_zulu, yankee_quebec.uniform_papa, yankee_quebec.quebec_four, yankee_quebec.whiskey_romeo, yankee_quebec.whiskey_zulu, yankee_quebec.golf_sierra, yankee_quebec.foxtrot_oscar_tango, yankee_quebec.juliet_yankee, yankee_quebec.sierra_whiskey, yankee_quebec.uniform_november, yankee_quebec.foxtrot_three_juliet, yankee_quebec.delta_quebec, yankee_quebec.juliet_kilo, yankee_quebec.bravo_tango, yankee_quebec.delta_foxtrot_sierra, yankee_quebec.echo_mike_uniform, yankee_quebec.seven_echo, yankee_quebec.lima_november, yankee_quebec.yankee_juliet_tango, yankee_quebec.papa_lima, yankee_quebec.delta_uniform_india, yankee_quebec.victor_xray_oscar, yankee_quebec.echo_three_xray, yankee_quebec.zulu_mike, yankee_quebec.five_tango, yankee_quebec.quebec_sierra, yankee_quebec.india_three_bravo, yankee_quebec.kilo_five, yankee_quebec.juliet_india, yankee_quebec.oscar_lima_quebec, yankee_quebec.three_yankee, yankee_quebec.foxtrot_oscar_india, yankee_quebec.four_three, yankee_quebec.xray_seven, yankee_quebec.charlie_kilo_november, yankee_quebec.november_sierra, yankee_quebec.five_golf, yankee_quebec.foxtrot_oscar_november, yankee_quebec.echo_three_foxtrot, yankee_quebec.tango_papa, yankee_quebec.foxtrot_five, yankee_quebec.mike_four, yankee_quebec.yankee_whiskey_juliet, yankee_quebec.november_charlie_three, yankee_quebec.four_four, yankee_quebec.india_five, yankee_quebec.kilo_quebec_charlie, yankee_quebec.oscar_bravo, yankee_quebec.sierra_tango, yankee_quebec.six_two, yankee_quebec.four_kilo, yankee_quebec.zulu_papa, yankee_quebec.oscar_three, yankee_quebec.uniform_uniform_delta, yankee_quebec.quebec_kilo, yankee_quebec.lima_charlie, yankee_quebec.romeo_uniform, yankee_quebec.india_three_oscar, yankee_quebec.alpha_oscar, yankee_quebec.echo_yankee, yankee_quebec.uniform_uniform_alpha, yankee_quebec.delta_alpha, yankee_quebec.lima_echo_tango, yankee_quebec.charlie_echo, yankee_quebec.echo_bravo, yankee_quebec.november_kilo, yankee_quebec.alpha_alpha_november, yankee_quebec.november_bravo_november, yankee_quebec.zulu_sierra, yankee_quebec.tango_charlie, yankee_quebec.zulu_tango_juliet, yankee_quebec.five_yankee_alpha, yankee_quebec.echo_sierra, yankee_quebec.papa_kilo, yankee_quebec.lima_golf, yankee_quebec.juliet_delta, yankee_quebec.papa_tango, yankee_quebec.quebec_romeo_yankee, yankee_quebec.four_papa_two, yankee_quebec.india_yankee, yankee_quebec.romeo_five_two, yankee_quebec.whiskey_sierra, yankee_quebec.kilo_quebec_india, yankee_quebec.quebec_xray, yankee_quebec.three_kilo, yankee_quebec.golf_bravo, yankee_quebec.november_six_india, yankee_quebec.seven_november_yankee, yankee_quebec.romeo_november, yankee_quebec.papa_whiskey, yankee_quebec.kilo_juliet, yankee_quebec.six_foxtrot_three, yankee_quebec.four_hotel, yankee_quebec.india_golf, yankee_quebec.foxtrot_bravo, yankee_quebec.whiskey_oscar_three, yankee_quebec.delta_two, yankee_quebec.yankee_november, yankee_quebec.yankee_charlie, yankee_quebec.lima_romeo, yankee_quebec.five_delta, yankee_quebec.bravo_delta_romeo, yankee_quebec.sierra_three, yankee_quebec.delta_oscar_romeo, yankee_quebec.oscar_lima_victor, yankee_quebec.yankee_whiskey_charlie, yankee_quebec.papa_zulu, yankee_quebec.two_romeo, yankee_quebec.romeo_six, yankee_quebec.kilo_victor_four, yankee_quebec.quebec_golf, yankee_quebec.xray_five, yankee_quebec.alpha_foxtrot, yankee_quebec.quebec_romeo_hotel, yankee_quebec.mike_quebec, yankee_quebec.kilo_romeo, yankee_quebec.charlie_tango, yankee_quebec.oscar_kilo, yankee_quebec.papa_delta_sierra, yankee_quebec.hotel_foxtrot_sierra, yankee_quebec.seven_charlie_two, yankee_quebec.november_alpha, yankee_quebec.five_yankee_mike, yankee_quebec.foxtrot_foxtrot, yankee_quebec.oscar_yankee, yankee_quebec.kilo_victor_papa, yankee_quebec.delta_yankee, yankee_quebec.romeo_four, yankee_quebec.foxtrot_oscar_romeo, yankee_quebec.delta_seven_oscar, yankee_quebec.mike_yankee, yankee_quebec.whiskey_tango, yankee_quebec.romeo_foxtrot_xray, yankee_quebec.delta_six, yankee_quebec.lima_kilo, yankee_quebec.papa_four, yankee_quebec.charlie_mike, yankee_quebec.two_bravo, yankee_quebec.delta_juliet, yankee_quebec.sierra_romeo_november, yankee_quebec.two_india, yankee_quebec.quebec_quebec_uniform, yankee_quebec.bravo_delta_india, yankee_quebec.golf_papa, yankee_quebec.bravo_kilo, yankee_quebec.lima_hotel, yankee_quebec.bravo_papa, yankee_quebec.victor_mike, yankee_quebec.oscar_echo, yankee_quebec.seven_xray, yankee_quebec.golf_five, yankee_quebec.tango_tango, yankee_quebec.juliet_xray, yankee_quebec.romeo_kilo, yankee_quebec.november_foxtrot, yankee_quebec.hotel_victor, yankee_quebec.seven_foxtrot, yankee_quebec.xray_charlie, yankee_quebec.november_oscar, yankee_quebec.five_four, yankee_quebec.romeo_bravo, yankee_quebec.whiskey_alpha_zulu, yankee_quebec.whiskey_delta_november, yankee_quebec.sierra_lima, yankee_quebec.papa_sierra_whiskey, yankee_quebec.victor_india_whiskey, yankee_quebec.five_charlie, yankee_quebec.five_hotel, yankee_quebec.whiskey_two, yankee_quebec.golf_india, yankee_quebec.india_papa, yankee_quebec.india_delta_papa, yankee_quebec.four_seven, yankee_quebec.charlie_kilo_zulu, yankee_quebec.six_foxtrot_four, yankee_quebec.whiskey_alpha_alpha, yankee_quebec.delta_november_alpha, yankee_quebec.echo_mike_two, yankee_quebec.echo_november, yankee_quebec.foxtrot_whiskey, yankee_quebec.papa_two, yankee_quebec.alpha_whiskey, yankee_quebec.hotel_whiskey, yankee_quebec.oscar_four, yankee_quebec.mike_papa, yankee_quebec.uniform_mike, yankee_quebec.four_whiskey, yankee_quebec.xray_romeo
9. 2,334.780 2,334.780 ↑ 1.0 1 155,652

Index Scan using romeo_papa on five_bravo uniform_victor (cost=0.420..4.880 rows=1 width=195) (actual time=0.014..0.015 rows=1 loops=155,652)

  • Output: uniform_victor.quebec_seven, uniform_victor.quebec_quebec_charlie, uniform_victor.romeo_hotel_victor, uniform_victor.hotel_november, uniform_victor.whiskey_delta_oscar, uniform_victor.uniform_uniform_quebec, uniform_victor.november_bravo_four, uniform_victor.uniform_mike, uniform_victor.romeo_foxtrot_yankee, uniform_victor.tango_india, uniform_victor.tango_yankee, uniform_victor.victor_papa, uniform_victor.delta_xray, uniform_victor.sierra_xray, uniform_victor.lima_echo_bravo, uniform_victor.zulu_tango_uniform, uniform_victor.quebec_zulu, uniform_victor.xray_india, uniform_victor.two_quebec, uniform_victor.oscar_uniform, uniform_victor.three_delta, uniform_victor.quebec_seven2, uniform_victor.quebec_seven3, uniform_victor.quebec_seven4, uniform_victor.quebec_seven5, uniform_victor.papa_hotel, uniform_victor.oscar_two_romeo, uniform_victor.four_two, uniform_victor.whiskey_oscar_six, uniform_victor.yankee_mike, uniform_victor.xray_quebec, uniform_victor.seven_india, uniform_victor.echo_uniform, uniform_victor.bravo_bravo, uniform_victor.five_india_india, uniform_victor.hotel_foxtrot_seven, uniform_victor.charlie_whiskey, uniform_victor.oscar_two_november, uniform_victor.victor_charlie, uniform_victor.six_uniform, uniform_victor.seven_hotel, uniform_victor.sierra_foxtrot, uniform_victor.echo_charlie_lima, uniform_victor.alpha_five, uniform_victor.whiskey_lima, uniform_victor.oscar_november_quebec, uniform_victor.oscar_november_xray, uniform_victor.two_seven, uniform_victor.delta_seven_xray, uniform_victor.delta_hotel, uniform_victor.kilo_yankee, uniform_victor.lima_four_november, uniform_victor.hotel_india, uniform_victor.oscar_victor, uniform_victor.two_yankee_tango, uniform_victor.november_charlie_kilo, uniform_victor.six_golf, uniform_victor.zulu_two, uniform_victor.three_seven, uniform_victor.sierra_delta_uniform, uniform_victor.seven_papa, uniform_victor.romeo_hotel_papa, uniform_victor.three_charlie, uniform_victor.delta_november_india, uniform_victor.charlie_six, uniform_victor.five_india_four, uniform_victor.alpha_delta, uniform_victor.november_whiskey, uniform_victor.november_juliet, uniform_victor.delta_bravo, uniform_victor.quebec_oscar, uniform_victor.whiskey_foxtrot, uniform_victor.quebec_seven1, uniform_victor.quebec_seven6, uniform_victor.quebec_seven7, uniform_victor.quebec_seven8, uniform_victor.hotel_mike, uniform_victor.bravo_india, uniform_victor.echo_charlie_zulu, uniform_victor.mike_india, uniform_victor.echo_golf, uniform_victor.golf_mike_victor, uniform_victor.papa_five, uniform_victor.kilo_alpha, uniform_victor.mike_oscar, uniform_victor.kilo_whiskey, uniform_victor.delta_tango, uniform_victor.echo_five_hotel, uniform_victor.whiskey_echo, uniform_victor.two_yankee_three, uniform_victor.november_six_two, uniform_victor.november_uniform, uniform_victor.three_oscar, uniform_victor.alpha_alpha_kilo, uniform_victor.whiskey_victor, uniform_victor.three_papa, uniform_victor.juliet_lima, uniform_victor.yankee_juliet_juliet, uniform_victor.november_bravo_two, uniform_victor.india_seven, uniform_victor.sierra_delta_charlie, uniform_victor.yankee_two, uniform_victor.sierra_romeo_oscar, uniform_victor.alpha_charlie, uniform_victor.romeo_golf, uniform_victor.delta_lima, uniform_victor.seven_alpha, uniform_victor.lima_mike, uniform_victor.tango_three, uniform_victor.three_whiskey, uniform_victor.kilo_mike, uniform_victor.xray_november, uniform_victor.charlie_zulu, uniform_victor.uniform_papa, uniform_victor.quebec_four, uniform_victor.whiskey_zulu, uniform_victor.golf_sierra, uniform_victor.foxtrot_oscar_tango, uniform_victor.juliet_yankee, uniform_victor.sierra_whiskey, uniform_victor.uniform_november, uniform_victor.foxtrot_three_juliet, uniform_victor.juliet_kilo, uniform_victor.bravo_tango, uniform_victor.delta_foxtrot_sierra, uniform_victor.echo_mike_uniform, uniform_victor.seven_echo, uniform_victor.lima_november, uniform_victor.yankee_juliet_tango, uniform_victor.papa_lima, uniform_victor.delta_uniform_india, uniform_victor.victor_xray_oscar, uniform_victor.echo_three_xray, uniform_victor.zulu_mike, uniform_victor.five_tango, uniform_victor.quebec_sierra, uniform_victor.india_three_bravo, uniform_victor.kilo_five, uniform_victor.juliet_india, uniform_victor.oscar_lima_quebec, uniform_victor.three_yankee, uniform_victor.foxtrot_oscar_india, uniform_victor.four_three, uniform_victor.xray_seven, uniform_victor.charlie_kilo_november, uniform_victor.november_sierra, uniform_victor.five_golf, uniform_victor.foxtrot_oscar_november, uniform_victor.echo_three_foxtrot, uniform_victor.tango_papa, uniform_victor.foxtrot_five, uniform_victor.mike_four, uniform_victor.yankee_whiskey_juliet, uniform_victor.november_charlie_three, uniform_victor.four_four, uniform_victor.india_five, uniform_victor.kilo_quebec_charlie, uniform_victor.oscar_bravo, uniform_victor.sierra_tango, uniform_victor.six_two, uniform_victor.four_kilo, uniform_victor.zulu_papa, uniform_victor.oscar_three, uniform_victor.uniform_uniform_delta, uniform_victor.quebec_kilo, uniform_victor.lima_charlie, uniform_victor.romeo_uniform, uniform_victor.india_three_oscar, uniform_victor.alpha_oscar, uniform_victor.echo_yankee, uniform_victor.uniform_uniform_alpha, uniform_victor.delta_alpha, uniform_victor.lima_echo_tango, uniform_victor.charlie_echo, uniform_victor.echo_bravo, uniform_victor.november_kilo, uniform_victor.alpha_alpha_november, uniform_victor.november_bravo_november, uniform_victor.zulu_sierra, uniform_victor.tango_charlie, uniform_victor.zulu_tango_juliet, uniform_victor.five_yankee_alpha, uniform_victor.echo_sierra, uniform_victor.papa_kilo, uniform_victor.lima_golf, uniform_victor.juliet_delta, uniform_victor.papa_tango, uniform_victor.quebec_romeo_yankee, uniform_victor.four_papa_two, uniform_victor.india_yankee, uniform_victor.romeo_five_two, uniform_victor.whiskey_sierra, uniform_victor.kilo_quebec_india, uniform_victor.quebec_xray, uniform_victor.three_kilo, uniform_victor.golf_bravo, uniform_victor.november_six_india, uniform_victor.seven_november_yankee, uniform_victor.romeo_november, uniform_victor.papa_whiskey, uniform_victor.kilo_juliet, uniform_victor.six_foxtrot_three, uniform_victor.four_hotel, uniform_victor.india_golf, uniform_victor.foxtrot_bravo, uniform_victor.whiskey_oscar_three, uniform_victor.delta_two, uniform_victor.yankee_november, uniform_victor.yankee_charlie, uniform_victor.lima_romeo, uniform_victor.five_delta, uniform_victor.bravo_delta_romeo, uniform_victor.sierra_three, uniform_victor.delta_oscar_romeo, uniform_victor.oscar_lima_victor, uniform_victor.yankee_whiskey_charlie, uniform_victor.papa_zulu, uniform_victor.two_romeo, uniform_victor.romeo_six, uniform_victor.kilo_victor_four, uniform_victor.quebec_golf, uniform_victor.xray_five, uniform_victor.alpha_foxtrot, uniform_victor.quebec_romeo_hotel, uniform_victor.mike_quebec, uniform_victor.kilo_romeo, uniform_victor.charlie_tango, uniform_victor.oscar_kilo, uniform_victor.papa_delta_sierra, uniform_victor.hotel_foxtrot_sierra, uniform_victor.seven_charlie_two, uniform_victor.november_alpha, uniform_victor.five_yankee_mike, uniform_victor.foxtrot_foxtrot, uniform_victor.oscar_yankee, uniform_victor.kilo_victor_papa, uniform_victor.delta_yankee, uniform_victor.romeo_four, uniform_victor.foxtrot_oscar_romeo, uniform_victor.delta_seven_oscar, uniform_victor.mike_yankee, uniform_victor.whiskey_tango, uniform_victor.romeo_foxtrot_xray, uniform_victor.delta_six, uniform_victor.lima_kilo, uniform_victor.papa_four, uniform_victor.charlie_mike, uniform_victor.two_bravo, uniform_victor.delta_juliet, uniform_victor.sierra_romeo_november, uniform_victor.two_india, uniform_victor.quebec_quebec_uniform, uniform_victor.bravo_delta_india, uniform_victor.golf_papa, uniform_victor.bravo_kilo, uniform_victor.lima_hotel, uniform_victor.bravo_papa, uniform_victor.victor_mike, uniform_victor.oscar_echo, uniform_victor.seven_xray, uniform_victor.golf_five, uniform_victor.tango_tango, uniform_victor.juliet_xray, uniform_victor.romeo_kilo, uniform_victor.november_foxtrot, uniform_victor.hotel_victor, uniform_victor.seven_foxtrot, uniform_victor.xray_charlie, uniform_victor.november_oscar, uniform_victor.five_four, uniform_victor.romeo_bravo, uniform_victor.whiskey_alpha_zulu, uniform_victor.whiskey_delta_november, uniform_victor.sierra_lima, uniform_victor.papa_sierra_whiskey, uniform_victor.victor_india_whiskey, uniform_victor.five_charlie, uniform_victor.five_hotel, uniform_victor.whiskey_two, uniform_victor.golf_india, uniform_victor.india_papa, uniform_victor.india_delta_papa, uniform_victor.four_seven, uniform_victor.charlie_kilo_zulu, uniform_victor.six_foxtrot_four, uniform_victor.whiskey_alpha_alpha, uniform_victor.delta_november_alpha, uniform_victor.echo_mike_two, uniform_victor.echo_november, uniform_victor.foxtrot_whiskey, uniform_victor.papa_two, uniform_victor.alpha_whiskey, uniform_victor.hotel_whiskey, uniform_victor.delta_quebec, uniform_victor.oscar_four, uniform_victor.xray_romeo
  • Index Cond: ((yankee_quebec.romeo_hotel_victor)::text = (uniform_victor.romeo_hotel_victor)::text)
10. 0.762 22.027 ↓ 137.4 2,336 1

Hash (cost=407.560..407.560 rows=17 width=71) (actual time=22.027..22.027 rows=2,336 loops=1)

  • Output: november_three.charlie_golf, november_three.tango_three, november_three.three_whiskey, november_three.seven_papa, november_three.romeo_hotel_victor, november_three.quebec_xray
  • Buckets: 4096 (originally 1024) Batches: 1 (originally 1) Memory Usage: 277kB
11. 0.405 21.265 ↓ 137.4 2,336 1

Subquery Scan on november_three (cost=290.100..407.560 rows=17 width=71) (actual time=18.704..21.265 rows=2,336 loops=1)

  • Output: november_three.charlie_golf, november_three.tango_three, november_three.three_whiskey, november_three.seven_papa, november_three.romeo_hotel_victor, november_three.quebec_xray
  • Filter: (november_three.xray_romeo = 1)
  • Rows Removed by Filter: 1042
12. 1.827 20.860 ↓ 1.0 3,378 1

WindowAgg (cost=290.100..365.610 rows=3,356 width=127) (actual time=18.670..20.860 rows=3,378 loops=1)

  • Output: lima_mike.quebec_seven, lima_mike.romeo_hotel_victor, lima_mike.quebec_xray, lima_mike.charlie_golf, NULL::character varying, lima_mike.tango_three, lima_mike.three_whiskey, lima_mike.seven_papa, NULL::timestamp without time zone, five_zulu() zulu_quebec (?)
13. 17.939 19.033 ↓ 1.0 3,378 1

Sort (cost=290.100..298.490 rows=3,356 width=79) (actual time=18.629..19.033 rows=3,378 loops=1)

  • Output: lima_mike.quebec_seven, lima_mike.romeo_hotel_victor, lima_mike.quebec_xray, lima_mike.charlie_golf, lima_mike.tango_three, lima_mike.three_whiskey, lima_mike.seven_papa
  • Sort Key: lima_mike.romeo_hotel_victor, lima_mike.quebec_xray, lima_mike.quebec_seven DESC
  • Sort Method: quicksort Memory: 605kB
14. 1.094 1.094 ↓ 1.0 3,378 1

Seq Scan on alpha_golf (cost=0.000..93.560 rows=3,356 width=79) (actual time=0.037..1.094 rows=3,378 loops=1)

  • Output: lima_mike.quebec_seven, lima_mike.romeo_hotel_victor, lima_mike.quebec_xray, lima_mike.charlie_golf, lima_mike.tango_three, lima_mike.three_whiskey, lima_mike.seven_papa