explain.depesz.com

PostgreSQL's explain analyze made readable

Result: weIS

Settings
# exclusive inclusive rows x rows loops node
1. 84.324 329.638 ↓ 21,483.0 21,483 1

Sort (cost=805.800..805.800 rows=1 width=851) (actual time=328.008..329.638 rows=21,483 loops=1)

  • Output: uniform_papa4.romeo_golf, uniform_papa4.four_three, ((uniform_papa4.seven_romeo)::text), ((uniform_papa4.victor_quebec)::text), ((uniform_papa4.mike_uniform)::text), ((uniform_papa4.papa_november)::text), uniform_papa4.mike_oscar, uniform_papa4.echo_five, (CASE WHEN (uniform_papa4.five_tango five_romeo NOT NULL) THEN (uniform_papa4.five_tango + uniform_papa4.six_mike) ELSE NULL::numeric END), uniform_papa4.six_mike, uniform_papa4.uniform_tango, uniform_papa4.echo_bravo, (CASE WHEN (uniform_papa4.five_tango five_romeo NOT NULL) THEN (uniform_papa4.five_tango + uniform_papa4.echo_bravo) ELSE NULL::numeric END), uniform_papa4.xray_zulu, uniform_papa4.juliet_golf, uniform_papa4.five_india, uniform_papa4.four_romeo, uniform_papa4.tango_india, ((uniform_papa4.november_lima)::text), uniform_papa4.mike_mike, uniform_papa4.victor_uniform, uniform_papa4.lima_seven_delta, uniform_papa4.papa_juliet, uniform_papa4.tango_november, uniform_papa4.uniform_xray, uniform_papa4.juliet_delta, uniform_papa4.charlie_bravo, uniform_papa4.five_oscar, uniform_papa4.echo_two, uniform_papa4.two_november, uniform_papa4.uniform_delta, uniform_papa4.kilo_papa, uniform_papa4.bravo_two, uniform_papa4.foxtrot_three_lima, uniform_papa4.victor_kilo, uniform_papa4.oscar_quebec, uniform_papa4.four_delta
  • Sort Key: uniform_papa4.lima_seven_delta DESC, uniform_papa4.four_delta
  • Sort Method: quicksort Memory: 21687kB
  • Buffers: shared hit=59977 read=176 dirtied=4
2. 6.636 245.314 ↓ 21,483.0 21,483 1

Subquery Scan on juliet_alpha (cost=805.530..805.790 rows=1 width=851) (actual time=207.946..245.314 rows=21,483 loops=1)

  • Output: uniform_papa4.romeo_golf, uniform_papa4.four_three, (uniform_papa4.seven_romeo)::text, (uniform_papa4.victor_quebec)::text, (uniform_papa4.mike_uniform)::text, (uniform_papa4.papa_november)::text, uniform_papa4.mike_oscar, uniform_papa4.echo_five, CASE WHEN (uniform_papa4.five_tango five_romeo NOT NULL) THEN (uniform_papa4.five_tango + uniform_papa4.six_mike) ELSE NULL::numeric END, uniform_papa4.six_mike, uniform_papa4.uniform_tango, uniform_papa4.echo_bravo, CASE WHEN (uniform_papa4.five_tango five_romeo NOT NULL) THEN (uniform_papa4.five_tango + uniform_papa4.echo_bravo) ELSE NULL::numeric END, uniform_papa4.xray_zulu, uniform_papa4.juliet_golf, uniform_papa4.five_india, uniform_papa4.four_romeo, uniform_papa4.tango_india, (uniform_papa4.november_lima)::text, uniform_papa4.mike_mike, uniform_papa4.victor_uniform, uniform_papa4.lima_seven_delta, uniform_papa4.papa_juliet, uniform_papa4.tango_november, uniform_papa4.uniform_xray, uniform_papa4.juliet_delta, uniform_papa4.charlie_bravo, uniform_papa4.five_oscar, uniform_papa4.echo_two, uniform_papa4.two_november, uniform_papa4.uniform_delta, uniform_papa4.kilo_papa, uniform_papa4.bravo_two, uniform_papa4.foxtrot_three_lima, uniform_papa4.victor_kilo, uniform_papa4.oscar_quebec, uniform_papa4.four_delta
  • Filter: ((uniform_papa4.yankee_seven <= 100) AND (uniform_papa4.xray_seven = 1))
  • Rows Removed by Filter: 1933
  • Buffers: shared hit=59977 read=176 dirtied=4
3. 27.170 238.678 ↓ 23,416.0 23,416 1

WindowAgg (cost=805.530..805.680 rows=1 width=955) (actual time=207.941..238.678 rows=23,416 loops=1)

  • Output: romeo_three2.tango_india, romeo_three2.four_delta, NULL::character varying, romeo_three2.november_lima, romeo_three2.mike_mike, NULL::text[], romeo_three2.juliet_golf, romeo_three2.five_india, romeo_three2.kilo_papa, romeo_three2.bravo_two, romeo_three2.foxtrot_three_lima, romeo_three2.victor_kilo, romeo_three2.oscar_quebec, romeo_three2.five_oscar, romeo_three2.uniform_xray, romeo_three2.juliet_delta, romeo_three2.charlie_bravo, NULL::numeric, romeo_three2.uniform_delta, romeo_three2.echo_two, romeo_three2.two_november, romeo_three2.papa_juliet, NULL::text, romeo_three2.lima_seven_delta, romeo_three2.victor_uniform, NULL::double precision, NULL::real, romeo_three2.tango_november, NULL::character varying, NULL::bigint, whiskey_five.romeo_golf, whiskey_five.four_three, whiskey_five.november_lima, whiskey_five.zulu_mike, whiskey_five.mike_uniform, whiskey_five.papa_november, lima_sierra(whiskey_five.tango_november, 'four_five'::text[]), whiskey_five.echo_five, whiskey_five.five_tango, lima_sierra(whiskey_five.six_mike, 'november_golf'::numeric), whiskey_five.five_two_zulu, (NULL::real), lima_sierra((CASE echo_papa.four_three WHEN 'echo_victor_charlie'::text THEN echo_papa.six_mike WHEN 'whiskey_three'::text THEN (whiskey_five.six_mike * (echo_papa.six_mike / 100.0)) WHEN 'sierra_lima'::text THEN yankee_six((whiskey_five.six_mike - echo_papa.six_mike), 'november_golf'::numeric) ELSE NULL::numeric END + lima_sierra(whiskey_five.five_tango, 'november_golf'::numeric)), (lima_sierra(whiskey_five.six_mike, 'november_golf'::numeric) + lima_sierra(whiskey_five.five_tango, 'november_golf'::numeric))), CASE echo_papa.four_three WHEN 'echo_victor_charlie'::text THEN echo_papa.six_mike WHEN 'whiskey_three'::text THEN (whiskey_five.six_mike * (echo_papa.six_mike / 100.0)) WHEN 'sierra_lima'::text THEN yankee_six((whiskey_five.six_mike - echo_papa.six_mike), 'november_golf'::numeric) ELSE NULL::numeric END, NULL::integer, NULL::integer, NULL::integer, NULL::integer, (five_zulu() zulu_quebec (?)), five_two_papa(*) zulu_quebec (?)
  • Buffers: shared hit=59977 read=176 dirtied=4
4. 29.708 211.508 ↓ 23,416.0 23,416 1

Sort (cost=805.530..805.530 rows=1 width=667) (actual time=207.934..211.508 rows=23,416 loops=1)

  • Output: romeo_three2.tango_india, whiskey_five.romeo_golf, NULL::real, romeo_three2.four_delta, romeo_three2.november_lima, romeo_three2.mike_mike, romeo_three2.juliet_golf, romeo_three2.five_india, romeo_three2.kilo_papa, romeo_three2.bravo_two, romeo_three2.foxtrot_three_lima, romeo_three2.victor_kilo, romeo_three2.oscar_quebec, romeo_three2.five_oscar, romeo_three2.uniform_xray, romeo_three2.juliet_delta, romeo_three2.charlie_bravo, romeo_three2.uniform_delta, romeo_three2.echo_two, romeo_three2.two_november, romeo_three2.papa_juliet, romeo_three2.lima_seven_delta, romeo_three2.victor_uniform, romeo_three2.tango_november, whiskey_five.four_three, whiskey_five.november_lima, whiskey_five.zulu_mike, whiskey_five.mike_uniform, whiskey_five.papa_november, whiskey_five.tango_november, whiskey_five.echo_five, whiskey_five.five_tango, whiskey_five.six_mike, whiskey_five.five_two_zulu, echo_papa.four_three, echo_papa.six_mike, (five_zulu() zulu_quebec (?))
  • Sort Key: whiskey_five.romeo_golf
  • Sort Method: quicksort Memory: 23702kB
  • Buffers: shared hit=59977 read=176 dirtied=4
5. 13.183 181.800 ↓ 23,416.0 23,416 1

WindowAgg (cost=805.400..805.520 rows=1 width=667) (actual time=166.905..181.800 rows=23,416 loops=1)

  • Output: romeo_three2.tango_india, whiskey_five.romeo_golf, (NULL::real), romeo_three2.four_delta, romeo_three2.november_lima, romeo_three2.mike_mike, romeo_three2.juliet_golf, romeo_three2.five_india, romeo_three2.kilo_papa, romeo_three2.bravo_two, romeo_three2.foxtrot_three_lima, romeo_three2.victor_kilo, romeo_three2.oscar_quebec, romeo_three2.five_oscar, romeo_three2.uniform_xray, romeo_three2.juliet_delta, romeo_three2.charlie_bravo, romeo_three2.uniform_delta, romeo_three2.echo_two, romeo_three2.two_november, romeo_three2.papa_juliet, romeo_three2.lima_seven_delta, romeo_three2.victor_uniform, romeo_three2.tango_november, whiskey_five.four_three, whiskey_five.november_lima, whiskey_five.zulu_mike, whiskey_five.mike_uniform, whiskey_five.papa_november, whiskey_five.tango_november, whiskey_five.echo_five, whiskey_five.five_tango, whiskey_five.six_mike, whiskey_five.five_two_zulu, echo_papa.four_three, echo_papa.six_mike, five_zulu() zulu_quebec (?)
  • Buffers: shared hit=59977 read=176 dirtied=4
6. 28.930 168.617 ↓ 23,416.0 23,416 1

Sort (cost=805.400..805.410 rows=1 width=659) (actual time=166.900..168.617 rows=23,416 loops=1)

  • Output: romeo_three2.tango_india, whiskey_five.romeo_golf, NULL::real, romeo_three2.four_delta, romeo_three2.november_lima, romeo_three2.mike_mike, romeo_three2.juliet_golf, romeo_three2.five_india, romeo_three2.kilo_papa, romeo_three2.bravo_two, romeo_three2.foxtrot_three_lima, romeo_three2.victor_kilo, romeo_three2.oscar_quebec, romeo_three2.five_oscar, romeo_three2.uniform_xray, romeo_three2.juliet_delta, romeo_three2.charlie_bravo, romeo_three2.uniform_delta, romeo_three2.echo_two, romeo_three2.two_november, romeo_three2.papa_juliet, romeo_three2.lima_seven_delta, romeo_three2.victor_uniform, romeo_three2.tango_november, whiskey_five.four_three, whiskey_five.november_lima, whiskey_five.zulu_mike, whiskey_five.mike_uniform, whiskey_five.papa_november, whiskey_five.tango_november, whiskey_five.echo_five, whiskey_five.five_tango, whiskey_five.six_mike, whiskey_five.five_two_zulu, echo_papa.four_three, echo_papa.six_mike
  • Sort Key: romeo_three2.tango_india
  • Sort Method: quicksort Memory: 23373kB
  • Buffers: shared hit=59977 read=176 dirtied=4
7. 8.892 139.687 ↓ 23,416.0 23,416 1

Nested Loop Left Join (cost=258.020..805.390 rows=1 width=659) (actual time=20.860..139.687 rows=23,416 loops=1)

  • Output: romeo_three2.tango_india, whiskey_five.romeo_golf, NULL::real, romeo_three2.four_delta, romeo_three2.november_lima, romeo_three2.mike_mike, romeo_three2.juliet_golf, romeo_three2.five_india, romeo_three2.kilo_papa, romeo_three2.bravo_two, romeo_three2.foxtrot_three_lima, romeo_three2.victor_kilo, romeo_three2.oscar_quebec, romeo_three2.five_oscar, romeo_three2.uniform_xray, romeo_three2.juliet_delta, romeo_three2.charlie_bravo, romeo_three2.uniform_delta, romeo_three2.echo_two, romeo_three2.two_november, romeo_three2.papa_juliet, romeo_three2.lima_seven_delta, romeo_three2.victor_uniform, romeo_three2.tango_november, whiskey_five.four_three, whiskey_five.november_lima, whiskey_five.zulu_mike, whiskey_five.mike_uniform, whiskey_five.papa_november, whiskey_five.tango_november, whiskey_five.echo_five, whiskey_five.five_tango, whiskey_five.six_mike, whiskey_five.five_two_zulu, echo_papa.four_three, echo_papa.six_mike
  • Buffers: shared hit=59977 read=176 dirtied=4
8. 28.987 130.795 ↓ 23,416.0 23,416 1

Nested Loop Left Join (cost=258.020..805.090 rows=1 width=655) (actual time=20.858..130.795 rows=23,416 loops=1)

  • Output: romeo_three2.tango_india, romeo_three2.four_delta, romeo_three2.november_lima, romeo_three2.mike_mike, romeo_three2.juliet_golf, romeo_three2.five_india, romeo_three2.kilo_papa, romeo_three2.bravo_two, romeo_three2.foxtrot_three_lima, romeo_three2.victor_kilo, romeo_three2.oscar_quebec, romeo_three2.five_oscar, romeo_three2.uniform_xray, romeo_three2.juliet_delta, romeo_three2.charlie_bravo, romeo_three2.uniform_delta, romeo_three2.echo_two, romeo_three2.two_november, romeo_three2.papa_juliet, romeo_three2.lima_seven_delta, romeo_three2.victor_uniform, romeo_three2.tango_november, whiskey_five.romeo_golf, whiskey_five.four_three, whiskey_five.november_lima, whiskey_five.zulu_mike, whiskey_five.mike_uniform, whiskey_five.papa_november, whiskey_five.tango_november, whiskey_five.echo_five, whiskey_five.five_tango, whiskey_five.six_mike, whiskey_five.five_two_zulu, echo_papa.four_three, echo_papa.six_mike
  • Join Filter: (echo_papa.lima_two = ANY (whiskey_five.tango_november))
  • Rows Removed by Join Filter: 93637
  • Buffers: shared hit=59977 read=176 dirtied=4
9. 4.823 78.393 ↓ 23,415.0 23,415 1

Nested Loop (cost=258.020..803.650 rows=1 width=631) (actual time=20.850..78.393 rows=23,415 loops=1)

  • Output: romeo_three2.tango_india, romeo_three2.four_delta, romeo_three2.november_lima, romeo_three2.mike_mike, romeo_three2.juliet_golf, romeo_three2.five_india, romeo_three2.kilo_papa, romeo_three2.bravo_two, romeo_three2.foxtrot_three_lima, romeo_three2.victor_kilo, romeo_three2.oscar_quebec, romeo_three2.five_oscar, romeo_three2.uniform_xray, romeo_three2.juliet_delta, romeo_three2.charlie_bravo, romeo_three2.uniform_delta, romeo_three2.echo_two, romeo_three2.two_november, romeo_three2.papa_juliet, romeo_three2.lima_seven_delta, romeo_three2.victor_uniform, romeo_three2.tango_november, whiskey_five.romeo_golf, whiskey_five.four_three, whiskey_five.november_lima, whiskey_five.zulu_mike, whiskey_five.mike_uniform, whiskey_five.papa_november, whiskey_five.tango_november, whiskey_five.echo_five, whiskey_five.five_tango, whiskey_five.six_mike, whiskey_five.five_two_zulu
  • Buffers: shared hit=36562 read=176 dirtied=4
10. 0.078 21.890 ↓ 202.7 608 1

Subquery Scan on foxtrot_juliet (cost=257.590..259.770 rows=3 width=456) (actual time=20.821..21.890 rows=608 loops=1)

  • Output: romeo_three2.tango_india, romeo_three2.four_delta, romeo_three2.charlie_xray, romeo_three2.november_lima, romeo_three2.mike_mike, romeo_three2.india_yankee, romeo_three2.juliet_golf, romeo_three2.five_india, romeo_three2.kilo_papa, romeo_three2.bravo_two, romeo_three2.foxtrot_three_lima, romeo_three2.victor_kilo, romeo_three2.oscar_quebec, romeo_three2.five_oscar, romeo_three2.uniform_xray, romeo_three2.juliet_delta, romeo_three2.charlie_bravo, romeo_three2.tango_uniform, romeo_three2.uniform_delta, romeo_three2.echo_two, romeo_three2.two_november, romeo_three2.papa_juliet, romeo_three2.kilo_golf, romeo_three2.lima_seven_delta, romeo_three2.victor_uniform, romeo_three2.oscar_xray, romeo_three2.lima_seven_echo, romeo_three2.tango_november, romeo_three2.echo_victor_victor, romeo_three2.sierra_oscar
  • Filter: (romeo_three2.sierra_oscar <= 1)
  • Rows Removed by Filter: 13
  • Buffers: shared hit=10195 read=2 dirtied=1
11. 0.870 21.812 ↓ 69.0 621 1

WindowAgg (cost=257.590..258.850 rows=9 width=577) (actual time=20.820..21.812 rows=621 loops=1)

  • Output: seven_whiskey.tango_india, seven_whiskey.four_delta, seven_whiskey.charlie_xray, seven_whiskey.november_lima, seven_whiskey.mike_mike, NULL::text[], seven_whiskey.juliet_golf, seven_whiskey.five_india, seven_whiskey.kilo_papa, seven_whiskey.bravo_two, seven_whiskey.foxtrot_three_lima, seven_whiskey.victor_kilo, seven_whiskey.oscar_quebec, (((lima_sierra(seven_whiskey.whiskey_foxtrot, 0) + lima_sierra(seven_whiskey.five_oscar, 0)))::numeric + romeo_three.five_oscar), romeo_three.uniform_xray, romeo_three.juliet_delta, hotel_quebec.charlie_bravo, NULL::numeric, seven_whiskey.uniform_delta, seven_whiskey.echo_two, seven_whiskey.two_november, seven_whiskey.papa_juliet, NULL::text, ((seven_whiskey.papa_mike AND (lima_sierra(seven_whiskey.yankee_xray, false) OR seven_whiskey.two_foxtrot) AND lima_sierra((true), false) AND ((seven_whiskey.lima_whiskey five_romeo NULL) OR ((hotel_quebec.charlie_bravo)::double precision < seven_whiskey.lima_whiskey)))), (((seven_whiskey.whiskey_golf #>> 'bravo_three'::text[]))::real), NULL::double precision, NULL::real, seven_whiskey.tango_november, seven_whiskey.echo_victor_victor, CASE WHEN (seven_whiskey.echo_victor_victor five_romeo NULL) THEN 'november_golf'::bigint ELSE five_two_papa(*) zulu_quebec (?) END
  • Buffers: shared hit=10195 read=2 dirtied=1
12. 1.352 20.942 ↓ 69.0 621 1

Sort (cost=257.590..257.610 rows=9 width=440) (actual time=20.814..20.942 rows=621 loops=1)

  • Output: seven_whiskey.four_delta, romeo_three.uniform_xray, hotel_quebec.charlie_bravo, ((seven_whiskey.papa_mike AND (lima_sierra(seven_whiskey.yankee_xray, false) OR seven_whiskey.two_foxtrot) AND lima_sierra((true), false) AND ((seven_whiskey.lima_whiskey five_romeo NULL) OR ((hotel_quebec.charlie_bravo)::double precision < seven_whiskey.lima_whiskey)))), (((seven_whiskey.whiskey_golf #>> 'bravo_three'::text[]))::real), seven_whiskey.echo_victor_victor, seven_whiskey.tango_india, seven_whiskey.charlie_xray, seven_whiskey.november_lima, seven_whiskey.mike_mike, seven_whiskey.juliet_golf, seven_whiskey.five_india, seven_whiskey.kilo_papa, seven_whiskey.bravo_two, seven_whiskey.foxtrot_three_lima, seven_whiskey.victor_kilo, seven_whiskey.oscar_quebec, seven_whiskey.whiskey_foxtrot, seven_whiskey.five_oscar, romeo_three.five_oscar, romeo_three.juliet_delta, seven_whiskey.uniform_delta, seven_whiskey.echo_two, seven_whiskey.two_november, seven_whiskey.papa_juliet, seven_whiskey.tango_november
  • Sort Key: seven_whiskey.echo_victor_victor, ((seven_whiskey.papa_mike AND (lima_sierra(seven_whiskey.yankee_xray, false) OR seven_whiskey.two_foxtrot) AND lima_sierra((true), false) AND ((seven_whiskey.lima_whiskey five_romeo NULL) OR ((hotel_quebec.charlie_bravo)::double precision < seven_whiskey.lima_whiskey)))) DESC, hotel_quebec.charlie_bravo, romeo_three.uniform_xray, (((seven_whiskey.whiskey_golf #>> 'bravo_three'::text[]))::real) DESC, seven_whiskey.four_delta
  • Sort Method: quicksort Memory: 470kB
  • Buffers: shared hit=10195 read=2 dirtied=1
13. 1.119 19.590 ↓ 69.0 621 1

Nested Loop Left Join (cost=104.300..257.450 rows=9 width=440) (actual time=8.480..19.590 rows=621 loops=1)

  • Output: seven_whiskey.four_delta, romeo_three.uniform_xray, hotel_quebec.charlie_bravo, (seven_whiskey.papa_mike AND (lima_sierra(seven_whiskey.yankee_xray, false) OR seven_whiskey.two_foxtrot) AND lima_sierra((true), false) AND ((seven_whiskey.lima_whiskey five_romeo NULL) OR ((hotel_quebec.charlie_bravo)::double precision < seven_whiskey.lima_whiskey))), ((seven_whiskey.whiskey_golf #>> 'bravo_three'::text[]))::real, seven_whiskey.echo_victor_victor, seven_whiskey.tango_india, seven_whiskey.charlie_xray, seven_whiskey.november_lima, seven_whiskey.mike_mike, seven_whiskey.juliet_golf, seven_whiskey.five_india, seven_whiskey.kilo_papa, seven_whiskey.bravo_two, seven_whiskey.foxtrot_three_lima, seven_whiskey.victor_kilo, seven_whiskey.oscar_quebec, seven_whiskey.whiskey_foxtrot, seven_whiskey.five_oscar, romeo_three.five_oscar, romeo_three.juliet_delta, seven_whiskey.uniform_delta, seven_whiskey.echo_two, seven_whiskey.two_november, seven_whiskey.papa_juliet, seven_whiskey.tango_november
  • Buffers: shared hit=10195 read=2 dirtied=1
14. 0.230 15.366 ↓ 69.0 621 1

Nested Loop (cost=103.860..249.300 rows=9 width=617) (actual time=8.454..15.366 rows=621 loops=1)

  • Output: romeo_three.five_oscar, romeo_three.uniform_xray, romeo_three.juliet_delta, seven_whiskey.tango_india, seven_whiskey.four_delta, seven_whiskey.charlie_xray, seven_whiskey.november_lima, seven_whiskey.mike_mike, seven_whiskey.juliet_golf, seven_whiskey.five_india, seven_whiskey.kilo_papa, seven_whiskey.bravo_two, seven_whiskey.foxtrot_three_lima, seven_whiskey.victor_kilo, seven_whiskey.oscar_quebec, seven_whiskey.whiskey_foxtrot, seven_whiskey.five_oscar, seven_whiskey.uniform_delta, seven_whiskey.echo_two, seven_whiskey.two_november, seven_whiskey.papa_juliet, seven_whiskey.papa_mike, seven_whiskey.yankee_xray, seven_whiskey.two_foxtrot, seven_whiskey.lima_whiskey, seven_whiskey.whiskey_golf, seven_whiskey.tango_november, seven_whiskey.echo_victor_victor, hotel_quebec.charlie_bravo
  • Buffers: shared hit=7850 read=2 dirtied=1
15. 0.270 12.031 ↓ 69.0 621 1

Nested Loop (cost=103.600..247.240 rows=9 width=617) (actual time=8.300..12.031 rows=621 loops=1)

  • Output: romeo_three.five_oscar, romeo_three.uniform_xray, romeo_three.juliet_delta, seven_whiskey.tango_india, seven_whiskey.four_delta, seven_whiskey.charlie_xray, seven_whiskey.november_lima, seven_whiskey.mike_mike, seven_whiskey.juliet_golf, seven_whiskey.five_india, seven_whiskey.kilo_papa, seven_whiskey.bravo_two, seven_whiskey.foxtrot_three_lima, seven_whiskey.victor_kilo, seven_whiskey.oscar_quebec, seven_whiskey.whiskey_foxtrot, seven_whiskey.five_oscar, seven_whiskey.uniform_delta, seven_whiskey.echo_two, seven_whiskey.two_november, seven_whiskey.papa_juliet, seven_whiskey.papa_mike, seven_whiskey.yankee_xray, seven_whiskey.two_foxtrot, seven_whiskey.lima_whiskey, seven_whiskey.whiskey_golf, seven_whiskey.tango_november, seven_whiskey.echo_victor_victor, seven_whiskey.mike_romeo
  • Inner Unique: true
  • Buffers: shared hit=7847 read=2 dirtied=1
16. 0.216 8.777 ↓ 25.7 746 1

Subquery Scan on romeo_three (cost=103.180..112.750 rows=29 width=30) (actual time=8.284..8.777 rows=746 loops=1)

  • Output: romeo_three.romeo_two, romeo_three.golf_november, romeo_three.five_oscar, romeo_three.uniform_xray, romeo_three.juliet_delta, romeo_three.four_six, romeo_three.six_whiskey, ((charlie_victor.four_six <> 'delta_romeo'::kilo_three))
  • Filter: ((romeo_three.four_six <> 'delta_romeo'::kilo_three) AND (romeo_three.uniform_xray < 'echo_oscar'::numeric))
  • Rows Removed by Filter: 122
  • Buffers: shared hit=4983 read=2 dirtied=1
17. 0.171 8.561 ↓ 10.0 868 1

Unique (cost=103.180..103.620 rows=87 width=46) (actual time=8.282..8.561 rows=868 loops=1)

  • Output: charlie_victor.romeo_two, charlie_victor.golf_november, charlie_victor.five_oscar, charlie_victor.uniform_xray, charlie_victor.juliet_delta, charlie_victor.four_six, charlie_victor.six_whiskey, ((charlie_victor.four_six <> 'delta_romeo'::kilo_three))
  • Buffers: shared hit=4983 read=2 dirtied=1
18. 0.445 8.390 ↓ 10.1 876 1

Sort (cost=103.180..103.400 rows=87 width=46) (actual time=8.281..8.390 rows=876 loops=1)

  • Output: charlie_victor.romeo_two, charlie_victor.golf_november, charlie_victor.five_oscar, charlie_victor.uniform_xray, charlie_victor.juliet_delta, charlie_victor.four_six, charlie_victor.six_whiskey, ((charlie_victor.four_six <> 'delta_romeo'::kilo_three))
  • Sort Key: charlie_victor.romeo_two, ((charlie_victor.four_six <> 'delta_romeo'::kilo_three)), charlie_victor.six_whiskey COLLATE "papa_alpha", charlie_victor.golf_november
  • Sort Method: quicksort Memory: 93kB
  • Buffers: shared hit=4983 read=2 dirtied=1
19. 0.595 7.945 ↓ 10.1 876 1

Nested Loop (cost=0.850..100.380 rows=87 width=46) (actual time=0.253..7.945 rows=876 loops=1)

  • Output: charlie_victor.romeo_two, charlie_victor.golf_november, charlie_victor.five_oscar, charlie_victor.uniform_xray, charlie_victor.juliet_delta, charlie_victor.four_six, charlie_victor.six_whiskey, (charlie_victor.four_six <> 'delta_romeo'::kilo_three)
  • Buffers: shared hit=4983 read=2 dirtied=1
20. 4.206 4.206 ↓ 786.0 786 1

Index Scan using juliet_mike on yankee_juliet two_kilo (cost=0.420..4.780 rows=1 width=16) (actual time=0.235..4.206 rows=786 loops=1)

  • Output: two_kilo.uniform_two, two_kilo.kilo_kilo, two_kilo.oscar_five
  • Index Cond: (two_kilo.oscar_five && 'echo_romeo'::seven_five)
  • Filter: whiskey_papa(two_kilo.oscar_five, 'echo_romeo'::seven_five)
  • Rows Removed by Filter: 1042
  • Buffers: shared hit=1861 read=2
21. 3.144 3.144 ↑ 88.0 1 786

Index Scan using india_kilo on hotel_tango charlie_victor (cost=0.430..86.590 rows=88 width=61) (actual time=0.004..0.004 rows=1 loops=786)

  • Output: charlie_victor.echo_quebec, charlie_victor.uniform_two, charlie_victor.romeo_two, charlie_victor.four_six, charlie_victor.golf_november, charlie_victor.five_oscar, charlie_victor.golf_seven, charlie_victor.uniform_xray, charlie_victor.six_whiskey, charlie_victor.juliet_delta, charlie_victor.echo_whiskey
  • Index Cond: (charlie_victor.uniform_two = two_kilo.uniform_two)
  • Buffers: shared hit=3122 dirtied=1
22. 2.984 2.984 ↑ 1.0 1 746

Index Scan using india_papa on delta_delta seven_whiskey (cost=0.420..4.540 rows=1 width=603) (actual time=0.004..0.004 rows=1 loops=746)

  • Output: seven_whiskey.tango_india, seven_whiskey.four_delta, seven_whiskey.november_lima, seven_whiskey.seven_papa, seven_whiskey.delta_echo, seven_whiskey.echo_victor_victor, seven_whiskey.oscar_echo, seven_whiskey.kilo_charlie, seven_whiskey.tango_november, seven_whiskey.juliet_juliet, seven_whiskey.golf_uniform, seven_whiskey.uniform_delta, seven_whiskey.tango_uniform, seven_whiskey.uniform_hotel, seven_whiskey.whiskey_foxtrot, seven_whiskey.five_oscar, seven_whiskey.mike_kilo, seven_whiskey.charlie_kilo, seven_whiskey.mike_romeo, seven_whiskey.bravo_yankee, seven_whiskey.charlie_xray, seven_whiskey.echo_two, seven_whiskey.whiskey_golf, seven_whiskey.kilo_papa, seven_whiskey.bravo_two, seven_whiskey.foxtrot_three_lima, seven_whiskey.victor_kilo, seven_whiskey.oscar_quebec, seven_whiskey.papa_two, seven_whiskey.two_foxtrot, seven_whiskey.papa_mike, seven_whiskey.yankee_xray, seven_whiskey.papa_juliet, seven_whiskey.mike_mike, seven_whiskey.yankee_zulu, seven_whiskey.lima_seven_echo, seven_whiskey.lima_whiskey, seven_whiskey.juliet_golf, seven_whiskey.five_india, seven_whiskey.two_november, seven_whiskey.quebec
  • Index Cond: (seven_whiskey.tango_india = romeo_three.romeo_two)
  • Filter: ((seven_whiskey.golf_uniform && 'lima_charlie'::text[]) AND ((((lima_sierra(seven_whiskey.whiskey_foxtrot, 0) + lima_sierra(seven_whiskey.five_oscar, 0)))::numeric + romeo_three.five_oscar) > 'romeo_six'::numeric))
  • Rows Removed by Filter: 0
  • Buffers: shared hit=2864
23. 3.105 3.105 ↑ 1.0 1 621

Function Scan on sierra_zulu hotel_quebec (cost=0.260..0.360 rows=1 width=32) (actual time=0.005..0.005 rows=1 loops=621)

  • Output: hotel_quebec.charlie_bravo
  • Function Call: round(((_st_distance((merc.location)::geography, '0101000020E61000000000001C738647C09920F1AAD3DA36C0'::geography, '0'::double precision, true))::numeric / 1000.0), 2)
  • Buffers: shared hit=3
24. 3.105 3.105 ↓ 0.0 0 621

Index Only Scan using xray_papa on november_juliet three_papa (cost=0.430..0.790 rows=1 width=31) (actual time=0.005..0.005 rows=0 loops=621)

  • Output: three_papa.four_delta, three_papa.alpha, three_papa.lima_xray, true
  • Index Cond: ((three_papa.four_delta = seven_whiskey.four_delta) AND (three_papa.lima_xray = (echo_tango('papa_sierra'::text, charlie_xray((seven_whiskey.charlie_xray)::text, zulu_golf())))::integer))
  • Filter: (three_papa.alpha @> mike_alpha((charlie_xray((seven_whiskey.charlie_xray)::text, zulu_golf()))::time without time zone, (charlie_xray((seven_whiskey.charlie_xray)::text, zulu_golf()))::time without time zone, 'three_alpha'::text))
  • Rows Removed by Filter: 1
  • Heap Fetches: 557
  • Buffers: shared hit=2345
25. 51.680 51.680 ↓ 39.0 39 608

Index Scan using two_juliet on four_alpha whiskey_five (cost=0.430..181.190 rows=1 width=595) (actual time=0.009..0.085 rows=39 loops=608)

  • Output: whiskey_five.four_three, whiskey_five.romeo_golf, whiskey_five.november_lima, whiskey_five.four_delta, whiskey_five.zulu_mike, whiskey_five.tango_romeo, whiskey_five.mike_uniform, whiskey_five.papa_november, whiskey_five.kilo_victor, whiskey_five.tango_november, whiskey_five.five_tango, whiskey_five.five_two_zulu, whiskey_five.echo_five, whiskey_five.six_mike, whiskey_five.charlie_whiskey, whiskey_five.yankee_zulu
  • Index Cond: (whiskey_five.four_delta = romeo_three2.four_delta)
  • Filter: (((whiskey_five.charlie_whiskey five_romeo NULL) OR ((charlie_xray((romeo_three2.charlie_xray)::text, papa_delta((delta_two((echo_tango('uniform_whiskey'::text, zulu_golf()) / 'romeo_november'::double precision)) * 'romeo_november'::double precision))))::time without time zone = ANY (whiskey_five.charlie_whiskey))) AND (echo_tango('papa_sierra'::text, zulu_golf()) = ANY ((lima_sierra(whiskey_five.kilo_victor, 'golf_five'::integer[]))::double precision[])))
  • Rows Removed by Filter: 3
  • Buffers: shared hit=26367 read=174 dirtied=3
26. 23.415 23.415 ↓ 2.0 4 23,415

Seq Scan on mike_november (cost=0.000..1.220 rows=2 width=48) (actual time=0.001..0.001 rows=4 loops=23,415)

  • Output: echo_papa.lima_two, echo_papa.two_charlie, echo_papa.four_three, echo_papa.foxtrot_three_tango, echo_papa.lima_romeo, echo_papa.hotel_two, echo_papa.six_mike
  • Filter: (echo_papa.hotel_two AND (zulu_golf() >= echo_papa.foxtrot_three_tango) AND (zulu_golf() <= echo_papa.lima_romeo))
  • Buffers: shared hit=23415
27. 0.000 0.000 ↑ 1.0 1 23,416

Result (cost=0.000..0.100 rows=1 width=12) (actual time=0.000..0.000 rows=1 loops=23,416)

  • Output: NULL::integer, NULL::integer, NULL::integer