explain.depesz.com

PostgreSQL's explain analyze made readable

Result: nf3E

Settings

Optimization(s) for this plan:

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

Sort (cost=227,757.900..227,758.370 rows=188 width=861) (actual rows= loops=)

  • Sort Key: seven_uniform.yankee_yankee
2. 0.000 0.000 ↓ 0.0

HashAggregate (cost=227,746.090..227,750.790 rows=188 width=861) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.000..227,694.870 rows=683 width=861) (actual rows= loops=)

  • Join Filter: (((uniform_bravo(hotel_sierra(yankee_uniform(juliet_quebec(hotel_three((seven_uniform.alpha_romeo)::text, 'two_whiskey'::text, 'juliet_five'::text), 'alpha_golf'::text, ''juliet_foxtrot'kilo_tango'mike_sierra' 'juliet_foxtrot' 'delta_sierra'áàâãäåpapaÁÂÃÄÅmike_bravoÀéèêëzuluÉdelta_kiloÈìíîïìindiaÌÍÎÏÌuniform_yankeeóôõöjuliet_limaòÒÓÔÕÖtwo_novemberùúûüuniform_hotelÙÚÛÜcharlie_sevençÇñÑýÝ'juliet_foxtrot'romeo_india'charlie_oscar'[^quebec_three-kilo_whiskey-sierra_charlie ]'oscar_papa'kilo_tango'mike_sierra' 'juliet_foxtrot' 'juliet_tango'0'charlie_oscar'[^quebec_three-kilo_whiskey-sierra_charlie0-9]'oscar_papa'kilo_tango'golf_foxtrot'0'charlie_oscar'[^quebec_three-kilo_whiskey-sierra_charlie0-9]'oscar_papa'kilo_tango'seven_four'áàâãäåpapaÁÂÃÄÅmike_bravoÀéèêëzuluÉdelta_kiloÈìíîïìindiaÌÍÎÏÌuniform_yankeeóôõöjuliet_limaòÒÓÔÕÖtwo_novemberùúûüuniform_hotelÙÚÛÜcharlie_sevençÇñÑýÝ'juliet_foxtrot'romeo_india'charlie_oscar'[^quebec_three-kilo_whiskey-sierra_charlie ]'oscar_papa'kilo_tango'mike_sierra' 'juliet_foxtrot' 'delta_sierra'áàâãäåpapaÁÂÃÄÅmike_bravoÀéèêëzuluÉdelta_kiloÈìíîïìindiaÌÍÎÏÌuniform_yankeeóôõöjuliet_limaòÒÓÔÕÖtwo_novemberùúûüuniform_hotelÙÚÛÜcharlie_sevençÇñÑýÝ'juliet_foxtrot'romeo_india'charlie_oscar'[^quebec_three-kilo_whiskey-sierra_charlie ]'oscar_papa'kilo_tango'mike_sierra' 'juliet_foxtrot' 'juliet_tango'0'charlie_oscar'[^quebec_three-kilo_whiskey-sierra_charlie0-9]'oscar_papa'kilo_tango'golf_foxtrot'0'charlie_oscar'[^quebec_three-kilo_whiskey-sierra_charlie0-9]'oscar_papa'kilo_tango'xray_juliet'áàâãäåpapaÁÂÃÄÅmike_bravoÀéèêëzuluÉdelta_kiloÈìíîïìindiaÌÍÎÏÌuniform_yankeeóôõöjuliet_limaòÒÓÔÕÖtwo_novemberùúûüuniform_hotelÙÚÛÜcharlie_sevençÇñÑýÝ'juliet_foxtrot'romeo_india'charlie_oscar'[^quebec_three-kilo_whiskey-sierra_charlie ]'oscar_papa'kilo_tango'mike_sierra' 'juliet_foxtrot' 'delta_sierra'áàâãäåpapaÁÂÃÄÅmike_bravoÀéèêëzuluÉdelta_kiloÈìíîïìindiaÌÍÎÏÌuniform_yankeeóôõöjuliet_limaòÒÓÔÕÖtwo_novemberùúûüuniform_hotelÙÚÛÜcharlie_sevençÇñÑýÝ'juliet_foxtrot'romeo_india'charlie_oscar'[^quebec_three-kilo_whiskey-sierra_charlie ]'oscar_papa'kilo_tango'mike_sierra' 'juliet_foxtrot' 'tango'áàâãäåpapaÁÂÃÄÅmike_bravoÀéèêëzuluÉdelta_kiloÈìíîïìindiaÌÍÎÏÌuniform_yankeeóôõöjuliet_limaòÒÓÔÕÖtwo_novemberùúûüuniform_hotelÙÚÛÜcharlie_sevençÇñÑýÝ'juliet_foxtrot'romeo_india'charlie_oscar'[^quebec_three-kilo_whiskey-sierra_charlie ]'oscar_papa'kilo_tango'mike_sierra' 'juliet_foxtrot' 'mike_sierra' 'six_hotel'áàâãäåpapaÁÂÃÄÅmike_bravoÀéèêëzuluÉdelta_kiloÈìíîïìindiaÌÍÎÏÌuniform_yankeeóôõöjuliet_limaòÒÓÔÕÖtwo_novemberùúûüuniform_hotelÙÚÛÜcharlie_sevençÇñÑýÝ'juliet_foxtrot'romeo_india'charlie_oscar'[^quebec_three-kilo_whiskey-sierra_charlie ]'oscar_papa'kilo_tango'mike_sierra' 'juliet_foxtrot' 'mike_sierra' 'seven_bravo'0'charlie_oscar'[^quebec_three-kilo_whiskey-sierra_charlie0-9]'oscar_papa'kilo_tango'golf_foxtrot'0'charlie_oscar'[^quebec_three-kilo_whiskey-sierra_charlie0-9]'oscar_papa'kilo_tango'lima'áàâãäåpapaÁÂÃÄÅmike_bravoÀéèêëzuluÉdelta_kiloÈìíîïìindiaÌÍÎÏÌuniform_yankeeóôõöjuliet_limaòÒÓÔÕÖtwo_novemberùúûüuniform_hotelÙÚÛÜcharlie_sevençÇñÑýÝ'juliet_foxtrot'romeo_india'charlie_oscar'[^quebec_three-kilo_whiskey-sierra_charlie ]'oscar_papa'kilo_tango'mike_sierra' 'juliet_foxtrot' 'delta_sierra'áàâãäåpapaÁÂÃÄÅmike_bravoÀéèêëzuluÉdelta_kiloÈìíîïìindiaÌÍÎÏÌuniform_yankeeóôõöjuliet_limaòÒÓÔÕÖtwo_novemberùúûüuniform_hotelÙÚÛÜcharlie_sevençÇñÑýÝ'juliet_foxtrot'romeo_india'charlie_oscar'[^quebec_three-kilo_whiskey-sierra_charlie ]'oscar_papa'kilo_tango'mike_sierra' 'juliet_foxtrot' '::text))))
4. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.000..47,600.460 rows=188 width=819) (actual rows= loops=)

  • Join Filter: (((uniform_bravo(hotel_sierra(yankee_uniform(juliet_quebec(hotel_three((seven_uniform.alpha_romeo)::text, 'two_whiskey'::text, 'juliet_five'::text), 'alpha_golf'::text, ''juliet_foxtrot'kilo_tango'mike_sierra' 'juliet_foxtrot' 'oscar_kilo'áàâãäåpapaÁÂÃÄÅmike_bravoÀéèêëzuluÉdelta_kiloÈìíîïìindiaÌÍÎÏÌuniform_yankeeóôõöjuliet_limaòÒÓÔÕÖtwo_novemberùúûüuniform_hotelÙÚÛÜcharlie_sevençÇñÑýÝ'juliet_foxtrot'romeo_india'charlie_oscar'[^quebec_three-kilo_whiskey-sierra_charlie ]'oscar_papa'kilo_tango'mike_sierra' 'juliet_foxtrot' 'juliet_tango'0'charlie_oscar'[^quebec_three-kilo_whiskey-sierra_charlie0-9]'oscar_papa'kilo_tango'sierra_whiskey'0'charlie_oscar'[^quebec_three-kilo_whiskey-sierra_charlie0-9]'oscar_papa'kilo_tango'charlie_lima'áàâãäåpapaÁÂÃÄÅmike_bravoÀéèêëzuluÉdelta_kiloÈìíîïìindiaÌÍÎÏÌuniform_yankeeóôõöjuliet_limaòÒÓÔÕÖtwo_novemberùúûüuniform_hotelÙÚÛÜcharlie_sevençÇñÑýÝ'juliet_foxtrot'romeo_india'charlie_oscar'[^quebec_three-kilo_whiskey-sierra_charlie ]'oscar_papa'kilo_tango'mike_sierra' 'juliet_foxtrot' 'oscar_kilo'áàâãäåpapaÁÂÃÄÅmike_bravoÀéèêëzuluÉdelta_kiloÈìíîïìindiaÌÍÎÏÌuniform_yankeeóôõöjuliet_limaòÒÓÔÕÖtwo_novemberùúûüuniform_hotelÙÚÛÜcharlie_sevençÇñÑýÝ'juliet_foxtrot'romeo_india'charlie_oscar'[^quebec_three-kilo_whiskey-sierra_charlie ]'oscar_papa'kilo_tango'mike_sierra' 'juliet_foxtrot' 'juliet_tango'0'charlie_oscar'[^quebec_three-kilo_whiskey-sierra_charlie0-9]'oscar_papa'kilo_tango'sierra_whiskey'0'charlie_oscar'[^quebec_three-kilo_whiskey-sierra_charlie0-9]'oscar_papa'kilo_tango'xray_juliet'áàâãäåpapaÁÂÃÄÅmike_bravoÀéèêëzuluÉdelta_kiloÈìíîïìindiaÌÍÎÏÌuniform_yankeeóôõöjuliet_limaòÒÓÔÕÖtwo_novemberùúûüuniform_hotelÙÚÛÜcharlie_sevençÇñÑýÝ'juliet_foxtrot'romeo_india'charlie_oscar'[^quebec_three-kilo_whiskey-sierra_charlie ]'oscar_papa'kilo_tango'mike_sierra' 'juliet_foxtrot' 'oscar_kilo'áàâãäåpapaÁÂÃÄÅmike_bravoÀéèêëzuluÉdelta_kiloÈìíîïìindiaÌÍÎÏÌuniform_yankeeóôõöjuliet_limaòÒÓÔÕÖtwo_novemberùúûüuniform_hotelÙÚÛÜcharlie_sevençÇñÑýÝ'juliet_foxtrot'romeo_india'charlie_oscar'[^quebec_three-kilo_whiskey-sierra_charlie ]'oscar_papa'kilo_tango'mike_sierra' 'juliet_foxtrot' 'xray_yankee'áàâãäåpapaÁÂÃÄÅmike_bravoÀéèêëzuluÉdelta_kiloÈìíîïìindiaÌÍÎÏÌuniform_yankeeóôõöjuliet_limaòÒÓÔÕÖtwo_novemberùúûüuniform_hotelÙÚÛÜcharlie_sevençÇñÑýÝ'juliet_foxtrot'romeo_india'charlie_oscar'[^quebec_three-kilo_whiskey-sierra_charlie ]'oscar_papa'kilo_tango'mike_sierra' 'juliet_foxtrot' 'mike_sierra' 'alpha_quebec'áàâãäåpapaÁÂÃÄÅmike_bravoÀéèêëzuluÉdelta_kiloÈìíîïìindiaÌÍÎÏÌuniform_yankeeóôõöjuliet_limaòÒÓÔÕÖtwo_novemberùúûüuniform_hotelÙÚÛÜcharlie_sevençÇñÑýÝ'juliet_foxtrot'romeo_india'charlie_oscar'[^quebec_three-kilo_whiskey-sierra_charlie ]'oscar_papa'kilo_tango'mike_sierra' 'juliet_foxtrot' 'mike_sierra' 'seven_bravo'0'charlie_oscar'[^quebec_three-kilo_whiskey-sierra_charlie0-9]'oscar_papa'kilo_tango'sierra_whiskey'0'charlie_oscar'[^quebec_three-kilo_whiskey-sierra_charlie0-9]'oscar_papa'kilo_tango'lima'áàâãäåpapaÁÂÃÄÅmike_bravoÀéèêëzuluÉdelta_kiloÈìíîïìindiaÌÍÎÏÌuniform_yankeeóôõöjuliet_limaòÒÓÔÕÖtwo_novemberùúûüuniform_hotelÙÚÛÜcharlie_sevençÇñÑýÝ'juliet_foxtrot'romeo_india'charlie_oscar'[^quebec_three-kilo_whiskey-sierra_charlie ]'oscar_papa'kilo_tango'mike_sierra' 'juliet_foxtrot' 'oscar_kilo'áàâãäåpapaÁÂÃÄÅmike_bravoÀéèêëzuluÉdelta_kiloÈìíîïìindiaÌÍÎÏÌuniform_yankeeóôõöjuliet_limaòÒÓÔÕÖtwo_novemberùúûüuniform_hotelÙÚÛÜcharlie_sevençÇñÑýÝ'juliet_foxtrot'romeo_india'charlie_oscar'[^quebec_three-kilo_whiskey-sierra_charlie ]'oscar_papa'kilo_tango'mike_sierra' 'juliet_foxtrot' '::text))))
5. 0.000 0.000 ↓ 0.0

Index Scan using echo_papa on four seven_uniform (cost=0.000..212.580 rows=188 width=786) (actual rows= loops=)

  • Index Cond: ((uniform_golf)::text = 'romeo_juliet'::text)
  • Filter: (quebec_xray five NULL)
6. 0.000 0.000 ↓ 0.0

Index Scan using echo_papa on four golf_papa (cost=0.000..212.580 rows=188 width=285) (actual rows= loops=)

  • Index Cond: ((golf_papa.uniform_golf)::text = 'delta_mike'::text)
7. 0.000 0.000 ↓ 0.0

Index Scan using six_kilo on uniform_five echo_oscar (cost=0.000..807.590 rows=716 width=83) (actual rows= loops=)

  • Index Cond: ((echo_oscar.uniform_golf)::text = 'delta_mike'::text)
  • Filter: ((echo_oscar.two_charlie)::text = 'bravo'::text)