explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NIRQ

Settings
# exclusive inclusive rows x rows loops node
1. 1.155 1.155 ↑ 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.154..1.155 rows=1 loops=1)

  • Index Cond: ((postalcode)::text = '21459'::text)
  • Filter: ((locality_ix)::text = 'malmoe'::text)
Planning time : 0.112 ms