explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3Ad1 : Optimization for: plan #PgV

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 74.364 444.578 ↑ 21.8 1,557 1

HashAggregate (cost=291,187.83..291,306.64 rows=33,946 width=49) (actual time=444.078..444.578 rows=1,557 loops=1)

  • Group Key: initcap((city)::text), state, zip_code, metro
2. 339.280 370.214 ↓ 1.0 175,012 1

Bitmap Heap Scan on house_listings (cost=2,348.02..290,839.52 rows=174,151 width=49) (actual time=48.663..370.214 rows=175,012 loops=1)

  • Recheck Cond: ((state)::text = 'GA'::text)
  • Heap Blocks: exact=97619
3. 30.934 30.934 ↓ 1.0 175,012 1

Bitmap Index Scan on idx_house_listings_state_city_zip_code_metro (cost=0.00..2,339.31 rows=174,151 width=0) (actual time=30.934..30.934 rows=175,012 loops=1)

  • Index Cond: ((state)::text = 'GA'::text)