explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rZgU

Settings
# exclusive inclusive rows x rows loops node
1. 15.118 38.506 ↑ 25.3 1,155 1

Unique (cost=0.42..5,169.59 rows=29,246 width=50) (actual time=0.098..38.506 rows=1,155 loops=1)

2. 23.388 23.388 ↑ 1.0 53,661 1

Index Only Scan using house_listings_state_city_zip_code_metro on house_listings (cost=0.42..4,629.47 rows=54,012 width=50) (actual time=0.096..23.388 rows=53,661 loops=1)

  • Index Cond: (state = ANY ('{GA,TN,OH}'::text[]))
  • Heap Fetches: 1170