explain.depesz.com

PostgreSQL's explain analyze made readable

Result: aeXZ

Settings
# exclusive inclusive rows x rows loops node
1. 15.816 17.800 ↑ 12.9 27,977 1

Bitmap Heap Scan on instrument (cost=9,344.96..905,944.86 rows=361,014 width=174) (actual time=2.287..17.800 rows=27,977 loops=1)

  • Filter: (upper((local_code)::text) ~~ 'IBM%'::text)
  • Heap Blocks: exact=2,596
2. 1.984 1.984 ↑ 12.9 27,977 1

Bitmap Index Scan on instrument_ind_10 (cost=0.00..9,254.71 rows=361,014 width=0) (actual time=1.984..1.984 rows=27,977 loops=1)

  • Index Cond: ((upper((local_code)::text) ~>=~ 'IBM'::text) AND (upper((local_code)::text) ~<~ 'IBN'::text))
Planning time : 0.116 ms
Execution time : 18.824 ms