#	exclusive	inclusive	rows x	rows	loops	node
1.	0.003	719.011	↓ 0.0	0	1	→ Limit (cost=8895.87..8895.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=8895.87..8895.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=8895.85..8895.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..8895.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	3767	1	→ Bitmap Index Scan on bookings_flights_idx7 (cost=0.00..85.18 rows=2361 width=0) (actual time=3.592..3.592 rows=3767 loops=1) Index Cond: (((from_country)::text = '/DE'::text) AND ((to_country)::text = '/KR'::text))

 Limit  (cost=8895.87..8895.88 rows=1 width=8) (actual time=719.011..719.011 rows=0 loops=1)
   ->  Sort  (cost=8895.87..8895.88 rows=1 width=8) (actual time=719.008..719.008 rows=0 loops=1)
         Sort Key: (count(*))
         Sort Method:  quicksort  Memory: 25kB
         ->  HashAggregate  (cost=8895.85..8895.86 rows=1 width=8) (actual time=718.967..718.967 rows=0 loops=1)
               ->  Bitmap Heap Scan on bookings_flights  (cost=85.18..8895.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)))
                     ->  Bitmap Index Scan on bookings_flights_idx7  (cost=0.00..85.18 rows=2361 width=0) (actual time=3.592..3.592 rows=3767 loops=1)
                           Index Cond: (((from_country)::text = '/DE'::text) AND ((to_country)::text = '/KR'::text))
 Total runtime: 719.263 ms

Per node type stats

node type	count	sum of times	% of query
Bitmap Heap Scan	1	715.372 ms	99.5 %
Bitmap Index Scan	1	3.592 ms	0.5 %
HashAggregate	1	0.003 ms	0.0 %
Limit	1	0.003 ms	0.0 %
Sort	1	0.041 ms	0.0 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
bookings_flights	1	715.372 ms	99.5 %
Bitmap Heap Scan	1	715.372 ms	100.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: nh2

Colorize:

Columns visibility:

Per node type stats

Per table stats