explain.depesz.com

PostgreSQL's explain analyze made readable

Result: h4HA

Settings
# exclusive inclusive rows x rows loops node
1. 0.058 75.377 ↑ 14.0 3 1

Sort (cost=1,257.130..1,257.230 rows=42 width=9,136) (actual time=75.375..75.377 rows=3 loops=1)

  • Sort Key: kilo_whiskey0kilo_oscar.uniform, kilo_whiskey0kilo_oscar.zulu_golf
  • Sort Method: quicksort Memory: 29kB
  • Buffers: shared hit=1341
  • Buffers: shared hit=321
  • Buffers: shared hit=4
2. 0.018 75.319 ↑ 14.0 3 1

Nested Loop Left Join (cost=192.290..1,255.990 rows=42 width=9,136) (actual time=68.937..75.319 rows=3 loops=1)

  • Buffers: shared hit=1341
3. 0.013 75.292 ↑ 14.0 3 1

Nested Loop Left Join (cost=192.140..1,248.750 rows=42 width=7,800) (actual time=68.929..75.292 rows=3 loops=1)

  • Buffers: shared hit=1339
4. 0.031 75.255 ↑ 14.0 3 1

Nested Loop Left Join (cost=191.720..1,227.620 rows=42 width=5,616) (actual time=68.923..75.255 rows=3 loops=1)

  • Buffers: shared hit=1335
5. 3.217 75.104 ↑ 14.0 3 1

Bitmap Heap Scan on foxtrot_charlie india_lima_juliet (cost=191.290..1,090.910 rows=42 width=3,541) (actual time=68.851..75.104 rows=3 loops=1)

  • Recheck Cond: ((seven_foxtrot)::text ~~ 'bravo_four'::text)
  • Rows Removed by Index Recheck: 4
  • Filter: ((NOT four_victor) AND ((five_papa)::text = ANY ('oscar_tango'::text[])) AND (lima_four >= 'mike_tango'::timestamp without time zone) AND (zulu_romeo = 1) AND ((five_kilo five_romeo NULL) OR (delta_four 1) OR (delta_four 2)))
  • Rows Removed by Filter: 214
  • Buffers: shared hit=1323
6. 66.641 66.641 ↓ 1.9 221 1

Bitmap Index Scan on four_india (cost=0.000..191.280 rows=117 width=0) (actual time=66.641..66.641 rows=221 loops=1)

  • Index Cond: ((seven_foxtrot)::text ~~ 'bravo_four'::text)
  • Buffers: shared hit=371
7.          

SubPlan (for Bitmap Heap Scan)

8. 0.996 3.486 ↓ 0.0 0 83

Merge Join (cost=0.850..4.410 rows=7 width=4) (actual time=0.042..0.042 rows=0 loops=83)

  • Merge Cond: ((golf_yankee8kilo_oscar.quebec_delta = delta_papa7kilo_oscar.lima_golf_uniform) AND (golf_yankee8kilo_oscar.bravo_six = delta_papa7kilo_oscar.mike_kilo))
  • Buffers: shared hit=571
9. 0.913 0.913 ↓ 1.3 8 83

Index Only Scan using victor_india on three_uniform foxtrot_uniform (cost=0.410..2.020 rows=6 width=8) (actual time=0.007..0.011 rows=8 loops=83)

  • Index Cond: ((lima_golf_uniform = 1303) AND (zulu_sierra <= 'mike_zulu'::timestamp without time zone) AND (lima_golf_tango > 'mike_zulu'::timestamp without time zone) AND (seven_alpha = 0))
  • Heap Fetches: 0
  • Buffers: shared hit=250
10. 1.577 1.577 ↑ 3.0 6 83

Index Only Scan using alpha_victor on lima_xray victor_mike (cost=0.430..2.190 rows=18 width=12) (actual time=0.015..0.019 rows=6 loops=83)

  • Index Cond: ((five_kilo = kilo_whiskey0kilo_oscar.five_kilo) AND (golf_two = 262))
  • Heap Fetches: 12
11. 0.160 1.760 ↓ 0.0 0 80

Nested Loop (cost=1.130..6.140 rows=6 width=4) (actual time=0.022..0.022 rows=0 loops=80)

  • Buffers: shared hit=165
12. 0.720 1.600 ↓ 0.0 0 80

Nested Loop (cost=0.700..4.050 rows=1 width=4) (actual time=0.020..0.020 rows=0 loops=80)

  • Join Filter: (zulu_papa9kilo_oscar.lima_golf_uniform = golf_yankee10kilo_oscar.quebec_delta)
  • Rows Removed by Join Filter: 6
  • Buffers: shared hit=165
13. 0.400 0.400 ↑ 1.3 3 80

Index Only Scan using three_yankee on lima_golf_hotel juliet (cost=0.290..1.750 rows=4 width=4) (actual time=0.003..0.005 rows=3 loops=80)

  • Index Cond: (golf_two = 2664)
  • Heap Fetches: 0
  • Buffers: shared hit=161
14. 0.464 0.480 ↑ 2.0 2 240

Materialize (cost=0.410..2.070 rows=4 width=8) (actual time=0.001..0.002 rows=2 loops=240)

  • Buffers: shared hit=4
15. 0.016 0.016 ↑ 2.0 2 1

Index Only Scan using victor_india on three_uniform zulu_hotel (cost=0.410..2.050 rows=4 width=8) (actual time=0.012..0.016 rows=2 loops=1)

  • Index Cond: ((lima_golf_uniform = 1303) AND (zulu_sierra <= 'mike_zulu'::timestamp without time zone) AND (lima_golf_tango > 'mike_zulu'::timestamp without time zone))
  • Filter: (bravo_six <> (-1))
  • Rows Removed by Filter: 13
  • Heap Fetches: 0
  • Buffers: shared hit=4
16. 0.000 0.000 ↓ 0.0 0

Index Only Scan using alpha_victor on lima_xray lima_quebec (cost=0.430..2.070 rows=1 width=8) (never executed)

  • Index Cond: ((five_kilo = kilo_whiskey0kilo_oscar.five_kilo) AND (golf_two = 262) AND (mike_kilo = golf_yankee10kilo_oscar.bravo_six))
  • Heap Fetches: 0
17. 0.120 0.120 ↑ 1.0 1 3

Index Scan using oscar_seven on delta_zulu xray (cost=0.430..3.250 rows=1 width=2,075) (actual time=0.039..0.040 rows=1 loops=3)

  • Index Cond: (kilo_whiskey0kilo_oscar.two = bravo_papa)
  • Buffers: shared hit=12
18. 0.024 0.024 ↓ 0.0 0 3

Index Scan using oscar_seven on delta_zulu quebec_two (cost=0.430..0.490 rows=1 width=2,184) (actual time=0.007..0.008 rows=0 loops=3)

  • Index Cond: (alpha_golf1kilo_oscar.six_romeo = bravo_papa)
19. 0.009 0.009 ↓ 0.0 0 3

Index Scan using mike_yankee on delta_bravo india_lima_three (cost=0.140..0.160 rows=1 width=1,336) (actual time=0.003..0.003 rows=0 loops=3)

  • Index Cond: (romeo3kilo_oscar.six_delta = bravo_papa)
  • Buffers: shared hit=2
Total runtime : 76.136 ms