explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NdNg

Settings
# exclusive inclusive rows x rows loops node
1. 0.022 0.475 ↓ 19.0 19 1

Sort (cost=175.670..175.670 rows=1 width=59) (actual time=0.473..0.475 rows=19 loops=1)

  • Output: uniform_hotel_sierra0kilo_oscar.kilo_romeo, uniform_hotel_sierra0kilo_oscar.echo_bravo, seven_xray1kilo_oscar.november_lima_uniform, uniform_hotel_sierra0kilo_oscar.alpha_lima, uniform_hotel_sierra0kilo_oscar.uniform_kilo, uniform_hotel_sierra0kilo_oscar.lima_golf
  • Sort Key: uniform_hotel_sierra0kilo_oscar.alpha_lima DESC
  • Sort Method: quicksort Memory: 27kB
  • Buffers: shared hit=430
2. 0.018 0.453 ↓ 19.0 19 1

Nested Loop (cost=2.020..175.660 rows=1 width=59) (actual time=0.110..0.453 rows=19 loops=1)

  • Output: uniform_hotel_sierra0kilo_oscar.kilo_romeo, uniform_hotel_sierra0kilo_oscar.echo_bravo, seven_xray1kilo_oscar.november_lima_uniform, uniform_hotel_sierra0kilo_oscar.alpha_lima, uniform_hotel_sierra0kilo_oscar.uniform_kilo, uniform_hotel_sierra0kilo_oscar.lima_golf
  • Buffers: shared hit=430
3. 0.016 0.416 ↓ 19.0 19 1

Nested Loop (cost=1.730..175.350 rows=1 width=75) (actual time=0.103..0.416 rows=19 loops=1)

  • Output: uniform_hotel_sierra0kilo_oscar.kilo_romeo, uniform_hotel_sierra0kilo_oscar.echo_bravo, uniform_hotel_sierra0kilo_oscar.alpha_lima, uniform_hotel_sierra0kilo_oscar.uniform_kilo, uniform_hotel_sierra0kilo_oscar.lima_golf, seven_xray1kilo_oscar.november_lima_uniform, hotel_delta2kilo_oscar.echo_victor, zulu_quebec3kilo_oscar1kilo_oscar.quebec_seven
  • Buffers: shared hit=373
4. 0.028 0.375 ↓ 25.0 25 1

Nested Loop (cost=1.580..175.160 rows=1 width=67) (actual time=0.099..0.375 rows=25 loops=1)

  • Output: uniform_hotel_sierra0kilo_oscar.kilo_romeo, uniform_hotel_sierra0kilo_oscar.echo_bravo, uniform_hotel_sierra0kilo_oscar.alpha_lima, uniform_hotel_sierra0kilo_oscar.uniform_kilo, uniform_hotel_sierra0kilo_oscar.lima_golf, uniform_hotel_sierra0kilo_oscar.xray_two, hotel_delta2kilo_oscar.echo_victor, zulu_quebec3kilo_oscar1kilo_oscar.quebec_seven
  • Buffers: shared hit=323
5. 0.014 0.212 ↓ 27.0 27 1

Nested Loop (cost=1.160..174.640 rows=1 width=24) (actual time=0.035..0.212 rows=27 loops=1)

  • Output: hotel_delta2kilo_oscar.tango_echo, hotel_delta2kilo_oscar.echo_victor, zulu_quebec3kilo_oscar1kilo_oscar.quebec_seven
  • Buffers: shared hit=215
6. 0.013 0.088 ↓ 3.7 55 1

Nested Loop (cost=0.860..169.780 rows=15 width=16) (actual time=0.024..0.088 rows=55 loops=1)

  • Output: hotel_delta2kilo_oscar.tango_echo, hotel_delta2kilo_oscar.echo_victor
  • Buffers: shared hit=50
7. 0.021 0.021 ↑ 1.0 3 1

Index Scan using xray_hotel on romeo_hotel quebec_uniform (cost=0.430..12.500 rows=3 width=8) (actual time=0.015..0.021 rows=3 loops=1)

  • Output: seven_kilo4kilo_oscar.quebec_seven, seven_kilo4kilo_oscar.uniform_zulu, seven_kilo4kilo_oscar.bravo_golf, seven_kilo4kilo_oscar.november_lima_uniform, seven_kilo4kilo_oscar.quebec_golf, seven_kilo4kilo_oscar.whiskey_alpha, seven_kilo4kilo_oscar.lima_four, seven_kilo4kilo_oscar.uniform_five, seven_kilo4kilo_oscar.tango_five_bravo, seven_kilo4kilo_oscar.romeo_alpha, seven_kilo4kilo_oscar.hotel_lima, seven_kilo4kilo_oscar.juliet_charlie_india, seven_kilo4kilo_oscar.november_foxtrot, seven_kilo4kilo_oscar.whiskey_charlie, seven_kilo4kilo_oscar.six_two, seven_kilo4kilo_oscar.six_two2, seven_kilo4kilo_oscar.three_juliet, seven_kilo4kilo_oscar.victor_charlie, seven_kilo4kilo_oscar.papa_foxtrot, seven_kilo4kilo_oscar.yankee_oscar_seven, seven_kilo4kilo_oscar.five_mike_mike, seven_kilo4kilo_oscar.sierra_five, seven_kilo4kilo_oscar.zulu_xray, seven_kilo4kilo_oscar.hotel_quebec, seven_kilo4kilo_oscar.quebec_hotel, seven_kilo4kilo_oscar.echo_charlie, seven_kilo4kilo_oscar.yankee_two, seven_kilo4kilo_oscar.zulu_romeo, seven_kilo4kilo_oscar.foxtrot_lima, seven_kilo4kilo_oscar.delta_three, seven_kilo4kilo_oscar.uniform_golf, seven_kilo4kilo_oscar.seven_mike, seven_kilo4kilo_oscar.three_kilo, seven_kilo4kilo_oscar.five_victor, seven_kilo4kilo_oscar.four_kilo
  • Index Cond: ((seven_kilo4kilo_oscar.tango_five_bravo)::text = 'foxtrot_golf'::text)
  • Buffers: shared hit=9
8. 0.054 0.054 ↓ 1.2 18 3

Index Scan using yankee_oscar_mike on uniform_november quebec_bravo (cost=0.430..52.280 rows=15 width=24) (actual time=0.006..0.018 rows=18 loops=3)

  • Output: hotel_delta2kilo_oscar.quebec_seven, hotel_delta2kilo_oscar.uniform_zulu, hotel_delta2kilo_oscar.tango_echo, hotel_delta2kilo_oscar.echo_victor, hotel_delta2kilo_oscar.lima_seven, hotel_delta2kilo_oscar.quebec_hotel, hotel_delta2kilo_oscar.echo_charlie, hotel_delta2kilo_oscar.yankee_two, hotel_delta2kilo_oscar.six_hotel, hotel_delta2kilo_oscar.five_zulu, hotel_delta2kilo_oscar.uniform_victor
  • Index Cond: (hotel_delta2kilo_oscar.lima_seven = seven_kilo4kilo_oscar.quebec_seven)
  • Buffers: shared hit=41
9. 0.110 0.110 ↓ 0.0 0 55

Index Scan using lima_five on juliet_mike oscar_oscar (cost=0.290..0.310 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=55)

  • Output: zulu_quebec3kilo_oscar1kilo_oscar.quebec_seven, zulu_quebec3kilo_oscar1kilo_oscar.uniform_zulu, zulu_quebec3kilo_oscar1kilo_oscar.india_victor, zulu_quebec3kilo_oscar1kilo_oscar.two, zulu_quebec3kilo_oscar1kilo_oscar.four_three, zulu_quebec3kilo_oscar1kilo_oscar.november_lima_uniform, zulu_quebec3kilo_oscar1kilo_oscar.mike, zulu_quebec3kilo_oscar1kilo_oscar.zulu_whiskey, zulu_quebec3kilo_oscar1kilo_oscar.zulu_mike, zulu_quebec3kilo_oscar1kilo_oscar.romeo_foxtrot, zulu_quebec3kilo_oscar1kilo_oscar.quebec_hotel, zulu_quebec3kilo_oscar1kilo_oscar.echo_charlie, zulu_quebec3kilo_oscar1kilo_oscar.yankee_two, zulu_quebec3kilo_oscar1kilo_oscar.echo_india, zulu_quebec3kilo_oscar1kilo_oscar.kilo_delta_bravo, zulu_quebec3kilo_oscar1kilo_oscar.delta_juliet, zulu_quebec3kilo_oscar1kilo_oscar.golf, zulu_quebec3kilo_oscar1kilo_oscar.xray_two, zulu_quebec3kilo_oscar1kilo_oscar.november_echo
  • Index Cond: (zulu_quebec3kilo_oscar1kilo_oscar.quebec_seven = hotel_delta2kilo_oscar.echo_victor)
  • Filter: ((zulu_quebec3kilo_oscar1kilo_oscar.zulu_whiskey)::text = 'juliet_three'::text)
  • Rows Removed by Filter: 1
  • Buffers: shared hit=165
10. 0.135 0.135 ↑ 1.0 1 27

Index Scan using uniform_oscar on tango_charlie delta_hotel (cost=0.430..0.520 rows=1 width=59) (actual time=0.005..0.005 rows=1 loops=27)

  • Output: uniform_hotel_sierra0kilo_oscar.quebec_seven, uniform_hotel_sierra0kilo_oscar.uniform_zulu, uniform_hotel_sierra0kilo_oscar.bravo_golf, uniform_hotel_sierra0kilo_oscar.two, uniform_hotel_sierra0kilo_oscar.kilo_romeo, uniform_hotel_sierra0kilo_oscar.echo_bravo, uniform_hotel_sierra0kilo_oscar.alpha_bravo, uniform_hotel_sierra0kilo_oscar.hotel_whiskey, uniform_hotel_sierra0kilo_oscar.xray_two, uniform_hotel_sierra0kilo_oscar.alpha_lima, uniform_hotel_sierra0kilo_oscar.hotel_echo, uniform_hotel_sierra0kilo_oscar.uniform_uniform, uniform_hotel_sierra0kilo_oscar.juliet_charlie_romeo, uniform_hotel_sierra0kilo_oscar.quebec_hotel, uniform_hotel_sierra0kilo_oscar.echo_charlie, uniform_hotel_sierra0kilo_oscar.yankee_two, uniform_hotel_sierra0kilo_oscar.bravo_xray, uniform_hotel_sierra0kilo_oscar.yankee_xray, uniform_hotel_sierra0kilo_oscar.uniform_yankee, uniform_hotel_sierra0kilo_oscar.whiskey_hotel, uniform_hotel_sierra0kilo_oscar.xray_tango, uniform_hotel_sierra0kilo_oscar.tango_hotel_november, uniform_hotel_sierra0kilo_oscar.sierra_papa, uniform_hotel_sierra0kilo_oscar.three_charlie, uniform_hotel_sierra0kilo_oscar.november_victor, uniform_hotel_sierra0kilo_oscar.zulu_sierra, uniform_hotel_sierra0kilo_oscar.tango_kilo_quebec, uniform_hotel_sierra0kilo_oscar.uniform_kilo, uniform_hotel_sierra0kilo_oscar.lima_golf, uniform_hotel_sierra0kilo_oscar.uniform_xray, uniform_hotel_sierra0kilo_oscar.five_mike_foxtrot, uniform_hotel_sierra0kilo_oscar.tango_quebec, uniform_hotel_sierra0kilo_oscar.romeo_five, uniform_hotel_sierra0kilo_oscar.kilo_delta_two, uniform_hotel_sierra0kilo_oscar.uniform_hotel_five, uniform_hotel_sierra0kilo_oscar.kilo_echo, uniform_hotel_sierra0kilo_oscar.sierra_foxtrot_mike, uniform_hotel_sierra0kilo_oscar.india_three, uniform_hotel_sierra0kilo_oscar.charlie, uniform_hotel_sierra0kilo_oscar.whiskey_tango, uniform_hotel_sierra0kilo_oscar.lima_uniform, uniform_hotel_sierra0kilo_oscar.whiskey_foxtrot, uniform_hotel_sierra0kilo_oscar.kilo_five, uniform_hotel_sierra0kilo_oscar.zulu_kilo, uniform_hotel_sierra0kilo_oscar.hotel_zulu, uniform_hotel_sierra0kilo_oscar.bravo_echo, uniform_hotel_sierra0kilo_oscar.seven_uniform, uniform_hotel_sierra0kilo_oscar.papa_delta, uniform_hotel_sierra0kilo_oscar.quebec_november, uniform_hotel_sierra0kilo_oscar.sierra_foxtrot_november, uniform_hotel_sierra0kilo_oscar.three_delta, uniform_hotel_sierra0kilo_oscar.papa_uniform, uniform_hotel_sierra0kilo_oscar.yankee_kilo, uniform_hotel_sierra0kilo_oscar.tango_hotel_lima, uniform_hotel_sierra0kilo_oscar.oscar_five, uniform_hotel_sierra0kilo_oscar.seven_echo, uniform_hotel_sierra0kilo_oscar.alpha_november_sierra, uniform_hotel_sierra0kilo_oscar.alpha_zulu, uniform_hotel_sierra0kilo_oscar.six_kilo, uniform_hotel_sierra0kilo_oscar.four_papa, uniform_hotel_sierra0kilo_oscar.oscar_zulu
  • Index Cond: (uniform_hotel_sierra0kilo_oscar.quebec_seven = hotel_delta2kilo_oscar.tango_echo)
  • Filter: (((uniform_hotel_sierra0kilo_oscar.juliet_charlie_romeo)::text <> november_november ('hotel_uniform'::text[])) AND ((uniform_hotel_sierra0kilo_oscar.two)::text = 'november_lima_yankee'::text))
  • Rows Removed by Filter: 0
  • Buffers: shared hit=108
11. 0.025 0.025 ↑ 1.0 1 25

Index Scan using foxtrot_three on hotel_xray romeo_zulu (cost=0.140..0.170 rows=1 width=24) (actual time=0.001..0.001 rows=1 loops=25)

  • Output: seven_xray1kilo_oscar.quebec_seven, seven_xray1kilo_oscar.uniform_zulu, seven_xray1kilo_oscar.alpha_november_golf, seven_xray1kilo_oscar.november_lima_uniform, seven_xray1kilo_oscar.four_three, seven_xray1kilo_oscar.mike, seven_xray1kilo_oscar.zulu_mike, seven_xray1kilo_oscar.quebec_hotel, seven_xray1kilo_oscar.echo_charlie, seven_xray1kilo_oscar.yankee_two, seven_xray1kilo_oscar.alpha_yankee, seven_xray1kilo_oscar.tango_sierra, seven_xray1kilo_oscar.tango_kilo_kilo, seven_xray1kilo_oscar.tango_five_four, seven_xray1kilo_oscar.uniform_charlie, seven_xray1kilo_oscar.foxtrot_charlie, seven_xray1kilo_oscar.sierra_oscar, seven_xray1kilo_oscar.four_zulu, seven_xray1kilo_oscar.papa_oscar, seven_xray1kilo_oscar.four_november, seven_xray1kilo_oscar.victor_papa, seven_xray1kilo_oscar.oscar_four, seven_xray1kilo_oscar.uniform_romeo
  • Index Cond: (seven_xray1kilo_oscar.quebec_seven = uniform_hotel_sierra0kilo_oscar.xray_two)
  • Filter: ((seven_xray1kilo_oscar.four_three)::text = ANY ('alpha_five'::text[]))
  • Rows Removed by Filter: 0
  • Buffers: shared hit=50
12. 0.019 0.019 ↑ 1.0 1 19

Index Only Scan using victor_mike on three_seven papa_quebec (cost=0.290..0.300 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=19)

  • Output: zulu_quebec3kilo_oscar.quebec_seven
  • Index Cond: (zulu_quebec3kilo_oscar.quebec_seven = hotel_delta2kilo_oscar.echo_victor)
  • Heap Fetches: 19
  • Buffers: shared hit=57
Planning time : 5.801 ms
Execution time : 0.639 ms