explain.depesz.com

PostgreSQL's explain analyze made readable

Result: eTQW

Settings
# exclusive inclusive rows x rows loops node
1. 5.994 30.046 ↑ 70.0 100 1

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

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

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

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