explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ooim

Settings
# exclusive inclusive rows x rows loops node
1. 0.457 24.230 ↑ 70.0 100 1

Bitmap Heap Scan on cartao car (cost=70.74..7,692.29 rows=6,999 width=131) (actual time=23.828..24.230 rows=100 loops=1)

  • Recheck Cond: ((car_ds_autorizacao)::text ~~ '%634563%'::text)
  • Rows Removed by Index Recheck: 130
  • Heap Blocks: exact=228
2. 23.773 23.773 ↑ 30.4 230 1

Bitmap Index Scan on cartao_idx_autorizacao (cost=0.00..68.99 rows=6,999 width=0) (actual time=23.773..23.773 rows=230 loops=1)

  • Index Cond: ((car_ds_autorizacao)::text ~~ '%634563%'::text)
Planning time : 0.294 ms
Execution time : 24.275 ms