explain.depesz.com

A tool for finding a real cause for slow queries.

Result: nh2

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 0.003 719.011 ↓ 0.0 0 1

Limit (cost=8,895.87..8,895.88 rows=1 width=8) (actual time=719.011..719.011 rows=0 loops=1)

2. 0.041 719.008 ↓ 0.0 0 1

Sort (cost=8,895.87..8,895.88 rows=1 width=8) (actual time=719.008..719.008 rows=0 loops=1)

  • Sort Key: (count(*))
  • Sort Method: quicksort Memory: 25kB
3. 0.003 718.967 ↓ 0.0 0 1

HashAggregate (cost=8,895.85..8,895.86 rows=1 width=8) (actual time=718.967..718.967 rows=0 loops=1)

4. 715.372 718.964 ↓ 0.0 0 1

Bitmap Heap Scan on bookings_flights (cost=85.18..8,895.84 rows=1 width=8) (actual time=718.964..718.964 rows=0 loops=1)

  • Recheck Cond: (((from_country)::text = '/DE'::text) AND ((to_country)::text = '/KR'::text))
  • Filter: ((fare_type <> 207) AND (journey_type <> 1) AND ((carrier)::text = 'AEU'::text) AND (booked > (('now'::text)::date - '1 year'::interval)))
5. 3.592 3.592 ↓ 1.6 3,767 1

Bitmap Index Scan on bookings_flights_idx7 (cost=0.00..85.18 rows=2,361 width=0) (actual time=3.592..3.592 rows=3,767 loops=1)

  • Index Cond: (((from_country)::text = '/DE'::text) AND ((to_country)::text = '/KR'::text))