explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8tax

Settings
# exclusive inclusive rows x rows loops node
1. 0.032 0.051 ↑ 36,101.4 10 1

Bitmap Heap Scan on instrument (cost=14,100.96..910,700.86 rows=361,014 width=174) (actual time=0.032..0.051 rows=10 loops=1)

  • Filter: (upper((name)::text) ~~ 'IBMC%'::text)
  • Heap Blocks: exact=7
2. 0.019 0.019 ↑ 36,101.4 10 1

Bitmap Index Scan on instrument_ind_9 (cost=0.00..14,010.71 rows=361,014 width=0) (actual time=0.019..0.019 rows=10 loops=1)

  • Index Cond: ((upper((name)::text) ~>=~ 'IBMC'::text) AND (upper((name)::text) ~<~ 'IBMD'::text))
Planning time : 0.165 ms
Execution time : 0.081 ms