explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2EjB

Settings
# exclusive inclusive rows x rows loops node
1. 263.727 588.649 ↑ 5.0 4,720 1

HashAggregate (cost=54,880.15..55,117.50 rows=23,735 width=25) (actual time=586.961..588.649 rows=4,720 loops=1)

  • Group Key: state, city, zip_code, metro
2. 324.922 324.922 ↑ 1.0 211,253 1

Seq Scan on house_listings (cost=0.00..52,761.71 rows=211,844 width=25) (actual time=0.070..324.922 rows=211,253 loops=1)

  • Filter: ((state)::text = ANY ('{GA,TN,OH,WA,AL,MS}'::text[]))
  • Rows Removed by Filter: 26102