explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cTSz

Settings
# exclusive inclusive rows x rows loops node
1. 3.691 560.269 ↑ 3.0 2,807 1

Group (cost=33,447.550..33,532.220 rows=8,437 width=29) (actual time=550.710..560.269 rows=2,807 loops=1)

  • Group Key: hotel_romeo, golf, bravo
2. 131.928 556.578 ↓ 2.6 22,331 1

Sort (cost=33,447.550..33,468.720 rows=8,467 width=29) (actual time=550.707..556.578 rows=22,331 loops=1)

  • Sort Key: hotel_romeo, golf, bravo
  • Sort Method: quicksort Memory: 2513kB
3. 398.660 424.650 ↓ 2.6 22,331 1

Bitmap Heap Scan on sierra (cost=433.630..32,895.180 rows=8,467 width=29) (actual time=40.946..424.650 rows=22,331 loops=1)

  • Recheck Cond: ((kilo = ANY ('romeo'::text[])) AND (five >= 'hotel_mike'::timestamp without time zone) AND (five <= '
  • Heap Blocks: exact=52907
4. 25.990 25.990 ↓ 8.9 75,102 1

Bitmap Index Scan on four (cost=0.000..431.510 rows=8,467 width=0) (actual time=25.990..25.990 rows=75,102 loops=1)

  • Index Cond: ((kilo = ANY ('romeo'::text[])) AND (five >= 'hotel_mike'::timestamp without time zone) AND (five