explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rGWS : o

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

Index Scan using valid_postalcode_areas_se_postalcode_ix_like on valid_postalcode_areas_se (cost=0.29..8.30 rows=1 width=6) (actual time=1.011..1.013 rows=1 loops=1)

  • Index Cond: ((postalcode)::text = '56146'::text)
  • Filter: ((locality_ix)::text = 'huskvarna'::text)
Planning time : 16.570 ms