explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FY0

Settings
# exclusive inclusive rows x rows loops node
1. 1.181 130.719 ↑ 1.0 1 1

Aggregate (cost=716.380..716.480 rows=1 width=8) (actual time=130.719..130.719 rows=1 loops=1)

  • Output: five_two_papa(1)
  • Buffers: shared hit=51188
2. 1.685 129.538 ↓ 17,774.0 17,774 1

Subquery Scan on juliet_alpha (cost=716.160..716.380 rows=1 width=0) (actual time=117.799..129.538 rows=17,774 loops=1)

  • Output: uniform_papa4.tango_india, uniform_papa4.four_delta, uniform_papa4.charlie_xray, uniform_papa4.uniform_xray, uniform_papa4.five_oscar, uniform_papa4.charlie_bravo, uniform_papa4.lima_seven_delta, uniform_papa4.victor_uniform, uniform_papa4.echo_victor, uniform_papa4.sierra_oscar, uniform_papa4.romeo_golf, uniform_papa4.four_romeo, uniform_papa4.yankee_seven, uniform_papa4.xray_seven
  • Filter: ((uniform_papa4.yankee_seven <= 100) AND (uniform_papa4.xray_seven = 1))
  • Rows Removed by Filter: 1544
  • Buffers: shared hit=51188
3. 8.573 127.853 ↓ 19,318.0 19,318 1

WindowAgg (cost=716.160..716.280 rows=1 width=229) (actual time=117.798..127.853 rows=19,318 loops=1)

  • Output: romeo_three2.tango_india, NULL::integer, NULL::character varying, NULL::numeric, NULL::numeric, NULL::numeric, NULL::boolean, NULL::real, NULL::character varying, NULL::bigint, whiskey_five.romeo_golf, (NULL::real), (five_zulu() zulu_quebec (?)), five_two_papa(*) zulu_quebec (?)
  • Buffers: shared hit=51188
4. 7.886 119.280 ↓ 19,318.0 19,318 1

Sort (cost=716.160..716.170 rows=1 width=44) (actual time=117.795..119.280 rows=19,318 loops=1)

  • Output: romeo_three2.tango_india, whiskey_five.romeo_golf, NULL::real, (five_zulu() zulu_quebec (?))
  • Sort Key: whiskey_five.romeo_golf
  • Sort Method: quicksort Memory: 2278kB
  • Buffers: shared hit=51188
5. 4.554 111.394 ↓ 19,318.0 19,318 1

WindowAgg (cost=716.040..716.150 rows=1 width=44) (actual time=105.930..111.394 rows=19,318 loops=1)

  • Output: romeo_three2.tango_india, whiskey_five.romeo_golf, (NULL::real), five_zulu() zulu_quebec (?)
  • Buffers: shared hit=51188
6. 6.243 106.840 ↓ 19,318.0 19,318 1

Sort (cost=716.040..716.050 rows=1 width=36) (actual time=105.927..106.840 rows=19,318 loops=1)

  • Output: romeo_three2.tango_india, whiskey_five.romeo_golf, NULL::real
  • Sort Key: romeo_three2.tango_india
  • Sort Method: quicksort Memory: 2278kB
  • Buffers: shared hit=51188
7. 20.426 100.597 ↓ 19,318.0 19,318 1

Nested Loop Left Join (cost=169.030..716.030 rows=1 width=36) (actual time=17.394..100.597 rows=19,318 loops=1)

  • Output: romeo_three2.tango_india, whiskey_five.romeo_golf, NULL::real
  • Join Filter: (echo_papa.lima_two = ANY (whiskey_five.tango_november))
  • Rows Removed by Join Filter: 77266
  • Buffers: shared hit=51188
8. 2.297 60.853 ↓ 19,318.0 19,318 1

Nested Loop (cost=169.030..714.590 rows=1 width=47) (actual time=17.386..60.853 rows=19,318 loops=1)

  • Output: romeo_three2.tango_india, whiskey_five.romeo_golf, whiskey_five.tango_november
  • Buffers: shared hit=31870
9. 0.056 17.813 ↓ 167.7 503 1

Subquery Scan on foxtrot_juliet (cost=168.600..170.710 rows=3 width=30) (actual time=17.371..17.813 rows=503 loops=1)

  • Output: romeo_three2.tango_india, romeo_three2.four_delta, romeo_three2.charlie_xray, romeo_three2.uniform_xray, romeo_three2.five_oscar, romeo_three2.charlie_bravo, romeo_three2.lima_seven_delta, romeo_three2.victor_uniform, romeo_three2.echo_victor, romeo_three2.sierra_oscar
  • Filter: (romeo_three2.sierra_oscar <= 1)
  • Rows Removed by Filter: 10
  • Buffers: shared hit=9131
10. 0.317 17.757 ↓ 57.0 513 1

WindowAgg (cost=168.600..169.790 rows=9 width=117) (actual time=17.370..17.757 rows=513 loops=1)

  • Output: seven_whiskey.tango_india, seven_whiskey.four_delta, seven_whiskey.charlie_xray, romeo_three.uniform_xray, NULL::numeric, 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, CASE WHEN (seven_whiskey.echo_victor five_romeo NULL) THEN 'november_golf'::bigint ELSE five_two_papa(*) zulu_quebec (?) END
  • Buffers: shared hit=9131
11. 0.845 17.440 ↓ 57.0 513 1

Sort (cost=168.600..168.620 rows=9 width=77) (actual time=17.366..17.440 rows=513 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, seven_whiskey.tango_india, seven_whiskey.charlie_xray
  • Sort Key: seven_whiskey.echo_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: 82kB
  • Buffers: shared hit=9131
12. 0.767 16.595 ↓ 57.0 513 1

Nested Loop Left Join (cost=104.300..168.450 rows=9 width=77) (actual time=8.034..16.595 rows=513 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, seven_whiskey.tango_india, seven_whiskey.charlie_xray
  • Buffers: shared hit=9131
13. 0.081 13.263 ↓ 57.0 513 1

Nested Loop (cost=103.860..160.310 rows=9 width=254) (actual time=8.018..13.263 rows=513 loops=1)

  • Output: romeo_three.uniform_xray, seven_whiskey.tango_india, seven_whiskey.four_delta, seven_whiskey.charlie_xray, seven_whiskey.papa_mike, seven_whiskey.yankee_xray, seven_whiskey.two_foxtrot, seven_whiskey.lima_whiskey, seven_whiskey.whiskey_golf, seven_whiskey.echo_victor, hotel_quebec.charlie_bravo
  • Buffers: shared hit=7169
14. 0.600 10.617 ↓ 57.0 513 1

Nested Loop (cost=103.600..158.250 rows=9 width=254) (actual time=7.890..10.617 rows=513 loops=1)

  • Output: romeo_three.uniform_xray, seven_whiskey.tango_india, seven_whiskey.four_delta, seven_whiskey.charlie_xray, seven_whiskey.papa_mike, seven_whiskey.yankee_xray, seven_whiskey.two_foxtrot, seven_whiskey.lima_whiskey, seven_whiskey.whiskey_golf, seven_whiskey.echo_victor, seven_whiskey.mike_romeo
  • Inner Unique: true
  • Buffers: shared hit=7166
15. 0.218 8.352 ↓ 55.5 555 1

Subquery Scan on romeo_three (cost=103.180..112.970 rows=10 width=21) (actual time=7.880..8.352 rows=555 loops=1)

  • Output: romeo_three.romeo_two, romeo_three.golf_november, romeo_three.uniform_xray, romeo_three.five_oscar, 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) AND (romeo_three.five_oscar > 'romeo_six'::numeric))
  • Rows Removed by Filter: 313
  • Buffers: shared hit=4985
16. 0.163 8.134 ↓ 10.0 868 1

Unique (cost=103.180..103.620 rows=87 width=40) (actual time=7.878..8.134 rows=868 loops=1)

  • Output: charlie_victor.romeo_two, charlie_victor.golf_november, charlie_victor.uniform_xray, charlie_victor.five_oscar, charlie_victor.four_six, charlie_victor.six_whiskey, ((charlie_victor.four_six <> 'delta_romeo'::kilo_three))
  • Buffers: shared hit=4985
17. 0.386 7.971 ↓ 10.1 876 1

Sort (cost=103.180..103.400 rows=87 width=40) (actual time=7.877..7.971 rows=876 loops=1)

  • Output: charlie_victor.romeo_two, charlie_victor.golf_november, charlie_victor.uniform_xray, charlie_victor.five_oscar, 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=4985
18. 0.403 7.585 ↓ 10.1 876 1

Nested Loop (cost=0.850..100.380 rows=87 width=40) (actual time=0.225..7.585 rows=876 loops=1)

  • Output: charlie_victor.romeo_two, charlie_victor.golf_november, charlie_victor.uniform_xray, charlie_victor.five_oscar, charlie_victor.four_six, charlie_victor.six_whiskey, (charlie_victor.four_six <> 'delta_romeo'::kilo_three)
  • Buffers: shared hit=4985
19. 4.038 4.038 ↓ 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.209..4.038 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=1863
20. 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=55) (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
21. 1.665 1.665 ↑ 1.0 1 555

Index Scan using india_papa on delta_delta seven_whiskey (cost=0.420..4.530 rows=1 width=249) (actual time=0.003..0.003 rows=1 loops=555)

  • 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, 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[])
  • Buffers: shared hit=2181
22. 2.565 2.565 ↑ 1.0 1 513

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=513)

  • 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
23. 2.565 2.565 ↓ 0.0 0 513

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=513)

  • 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: 483
  • Buffers: shared hit=1962
24. 40.743 40.743 ↓ 38.0 38 503

Index Scan using two_juliet on four_alpha whiskey_five (cost=0.430..181.190 rows=1 width=441) (actual time=0.008..0.081 rows=38 loops=503)

  • 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=22739
25. 19.318 19.318 ↓ 2.0 4 19,318

Seq Scan on mike_november (cost=0.000..1.220 rows=2 width=24) (actual time=0.000..0.001 rows=4 loops=19,318)

  • 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=19318