explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1sE9u

Settings
# exclusive inclusive rows x rows loops node
1. 6.193 6.193 ↑ 722.0 10 1

Index Scan using instrument_ind_1 on instrument (cost=0.57..32.73 rows=7,220 width=174) (actual time=2.891..6.193 rows=10 loops=1)

  • Index Cond: (((name)::text ~>=~ 'IBMC'::text) AND ((name)::text ~<~ 'IBMD'::text))
  • Filter: ((name)::text ~~ 'IBMC%'::text)
Planning time : 50.483 ms
Execution time : 7.485 ms