explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KsLV

Settings
# exclusive inclusive rows x rows loops node
1. 16.619 16.619 ↑ 1.0 1 1

Index Only Scan using zipcode_zipcode on zipcode (cost=0.29..4.30 rows=1 width=0) (actual time=16.615..16.619 rows=1 loops=1)

  • Index Cond: (zipcode = '26521'::citext)
  • Heap Fetches: 0