explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QLVG : Optimization for: plan #p1hA

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.013 0.243 ↑ 1.0 1 1

Aggregate (cost=5,456.38..5,456.39 rows=1 width=32) (actual time=0.243..0.243 rows=1 loops=1)

2. 0.027 0.230 ↑ 6.0 4 1

Bitmap Heap Scan on venda ven (cost=54.96..5,456.08 rows=24 width=8) (actual time=0.221..0.230 rows=4 loops=1)

  • Recheck Cond: ((ven_ds_referencia)::text ~~ '2D%'::text)
  • Filter: (((ven_cd_unidade_negocio)::character varying)::text = '647'::text)
  • Rows Removed by Filter: 2
  • Heap Blocks: exact=5
3. 0.203 0.203 ↑ 483.3 10 1

Bitmap Index Scan on venda_ref_gin_trgm_idx (cost=0.00..54.95 rows=4,833 width=0) (actual time=0.203..0.203 rows=10 loops=1)

  • Index Cond: ((ven_ds_referencia)::text ~~ '2D%'::text)
Planning time : 0.663 ms
Execution time : 0.292 ms