explain.depesz.com

A tool for finding a real cause for slow queries.

Result: uxy : CTE @120ms

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 0.000 114.202 ↑ 25.0 1 1

Limit (cost=26677.680..26677.740 rows=25 width=1101) (actual time=114.202..114.202 rows=1 loops=1)

2.          

CTE refs

3. 110.341 114.191 ↑ 3499.0 1 1

Bitmap Heap Scan on five november (cost=238.530..26508.960 rows=3499 width=83) (actual time=114.096..114.191 rows=1 loops=1)

  • Recheck Cond: (sierra_india OR (victor_five = 'zulu_delta'::bpchar))
  • Filter: ((sierra_india OR (victor_five = 'zulu_delta'::bpchar)) AND (xray_golf = 36) AND (victor_juliet = ANY ('zulu_zulu'::bpchar[])) AND (foxtrot = ANY ('papa_sierra'::integer[])))
  • Rows Removed by Filter: 21388
4. 0.000 3.850 ↓ 0.0 0 1

BitmapOr (cost=238.530..238.530 rows=20655 width=0) (actual time=3.850..3.850 rows=0 loops=1)

5. 3.833 3.833 ↓ 1.0 21475 1

Bitmap Index Scan on papa_lima (cost=0.000..234.340 rows=20655 width=0) (actual time=3.833..3.833 rows=21475 loops=1)

  • Index Cond: (sierra_india = true)
6. 0.017 0.017 ↓ 17.0 17 1

Bitmap Index Scan on sierra_kilo (cost=0.000..2.440 rows=1 width=0) (actual time=0.017..0.017 rows=17 loops=1)

  • Index Cond: (victor_five = 'zulu_delta'::bpchar)
7. 0.006 114.202 ↑ 3499.0 1 1

Sort (cost=168.720..177.470 rows=3499 width=1101) (actual time=114.202..114.202 rows=1 loops=1)

  • Sort Key: yankee.xray_victor
  • Sort Method: quicksort Memory: 25kB
8. 114.196 114.196 ↑ 3499.0 1 1

CTE Scan on yankee (cost=0.000..69.980 rows=3499 width=1101) (actual time=114.100..114.196 rows=1 loops=1)