explain.depesz.com

A tool for finding a real cause for slow queries.

Result: UlWN

options
# exclusive inclusive rows x rows loops node
1. 0.006 425.804 ↓ 10.0 10 1
→

Limit (cost=1147.320..1147.320 rows=1 width=76) (actual time=425.800..425.804 rows=10 loops=1)

2. 0.052 425.798 ↓ 20.0 20 1
→

Sort (cost=1147.320..1147.320 rows=1 width=76) (actual time=425.796..425.798 rows=20 loops=1)

  • Sort Key: zulu_juliet.golf
  • Sort Method: quicksort Memory: 28kB
3. 33.522 425.746 ↓ 27.0 27 1
→

HashAggregate (cost=1147.280..1147.310 rows=1 width=76) (actual time=425.732..425.746 rows=27 loops=1)

4. 80.613 392.224 ↓ 482.4 30876 1
→

Nested Loop (cost=11.660..1147.120 rows=64 width=76) (actual time=0.126..392.224 rows=30876 loops=1)

5. 39.674 64.603 ↓ 482.4 30876 1
→

Hash Join (cost=11.660..1126.250 rows=64 width=93) (actual time=0.096..64.603 rows=30876 loops=1)

  • Hash Cond: (lima.delta = zulu_juliet.quebec)
6. 24.846 24.846 ↑ 1.0 30876 1
→

Seq Scan on lima (cost=0.000..996.880 rows=30876 width=21) (actual time=0.005..24.846 rows=30876 loops=1)

7. 0.010 0.083 ↓ 27.0 27 1
→

Hash (cost=11.630..11.630 rows=1 width=76) (actual time=0.083..0.083 rows=27 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 3kB
8. 0.049 0.073 ↓ 27.0 27 1
→

Bitmap Heap Scan on zulu_juliet (cost=7.180..11.630 rows=1 width=76) (actual time=0.035..0.073 rows=27 loops=1)

  • Recheck Cond: (quebec = ANY ('xray_foxtrot'::integer[]))
  • Filter: ((alpha_foxtrot = ANY ('six_victor'::integer[])) AND (golf = ANY ('zulu_kilo'::integer[])) AND ((kilo_charlie ~~ 'oscar'::text) OR (kilo_charlie ~~ 'bravo_golf'::text) OR (kilo_charlie ~~ 'india_oscar'::text) OR (kilo_charlie ~~ 'three_alpha'::text) OR (kilo_charlie ~~ 'xray_india'::text) OR (kilo_charlie ~~ 'six_golf'::text) OR (kilo_charlie ~~ 'three_november'::text) OR (kilo_charlie ~~ 'papa'::text) OR (kilo_charlie ~~ 'uniform'::text) OR (kilo_charlie ~~ 'juliet'::text) OR (kilo_charlie ~~ 'bravo_seven'::text) OR (kilo_charlie ~~ 'four'::text) OR (kilo_charlie ~~ 'india_two'::text) OR (kilo_charlie ~~ 'hotel_victor'::text) OR (kilo_charlie ~~ 'alpha_tango'::text) OR (kilo_charlie ~~ 'two'::text) OR (kilo_charlie ~~ 'yankee_echo'::text) OR (kilo_charlie ~~ 'five'::text)))
9. 0.024 0.024 ↓ 1.0 27 1
→

Bitmap Index Scan on india_foxtrot (cost=0.000..7.180 rows=26 width=0) (actual time=0.024..0.024 rows=27 loops=1)

  • Index Cond: (quebec = ANY ('xray_foxtrot'::integer[]))
10. 247.008 247.008 ↑ 1.0 1 30876
→

Index Scan using xray_victor on yankee_sierra (cost=0.000..0.290 rows=1 width=17) (actual time=0.007..0.008 rows=1 loops=30876)

  • Index Cond: (echo5kilo_delta = lima.echo5kilo_delta)
  • Filter: (hotel_mike = 1)