explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Lo59

Settings
# exclusive inclusive rows x rows loops node
1. 1.354 1.354 ↑ 1.0 3,143 1

Seq Scan on public.county_typology (cost=0.00..64.43 rows=3,143 width=52) (actual time=0.010..1.354 rows=3,143 loops=1)

  • Output: fipsid, state, name, is_metro, econ_type, econ_type_txt, is_farming, is_mining, is_manufacturing,is_govt, is_recreation, is_nonspecialized, is_low_education, is_low_employment, had_pop_loss, is_retirement_dest, has_pers_poverty, has_pers_child_poverty
  • Buffers: shared hit=33