explain.depesz.com

PostgreSQL's explain analyze made readable

Result: PgV

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 94.732 13,390.872 ↑ 267.4 1,557 1

HashAggregate (cost=1,740,846.33..1,742,303.49 rows=416,331 width=49) (actual time=13,388.891..13,390.872 rows=1,557 loops=1)

  • Group Key: initcap((city)::text), state, zip_code, metro
2. 12,317.927 13,296.140 ↑ 12.2 175,012 1

Bitmap Heap Scan on house_listings (cost=43,648.68..1,736,574.59 rows=2,135,868 width=49) (actual time=1,320.561..13,296.140 rows=175,012 loops=1)

  • Recheck Cond: ((state)::text = 'GA'::text)
  • Rows Removed by Index Recheck: 41302
  • Heap Blocks: exact=1064388 lossy=909994
3. 978.213 978.213 ↓ 2.6 5,599,803 1

Bitmap Index Scan on house_listings_state (cost=0.00..43,541.89 rows=2,135,868 width=0) (actual time=978.213..978.213 rows=5,599,803 loops=1)

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