explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JLQE

Settings
# exclusive inclusive rows x rows loops node
1. 8.741 8.741 ↑ 248.0 1 1

Seq Scan on storekeepers (cost=0.00..4,797.18 rows=248 width=859) (actual time=8.497..8.741 rows=1 loops=1)

  • Filter: ("substring"((geohash)::text, 1, 4) = 'h4g6'::text)
  • Rows Removed by Filter: 49684
Planning time : 0.066 ms
Execution time : 13.407 ms