explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bvRS

Settings
# exclusive inclusive rows x rows loops node
1. 1,553.471 1,553.471 ↓ 4.4 27,977 1

Index Scan using instrument_ind_6 on instrument (cost=0.57..366.59 rows=6,350 width=174) (actual time=2.145..1,553.471 rows=27,977 loops=1)

  • Index Cond: (((local_code)::text ~>=~ 'IBM'::text) AND ((local_code)::text ~<~ 'IBN'::text))
  • Filter: ((local_code)::text ~~ 'IBM%'::text)
Planning time : 0.539 ms
Execution time : 1,554.861 ms