explain.depesz.com

PostgreSQL's explain analyze made readable

Result: PGNF

Settings
# exclusive inclusive rows x rows loops node
1. 0.015 0.683 ↑ 1.0 1 1

Aggregate (cost=701.71..701.73 rows=1 width=32) (actual time=0.683..0.683 rows=1 loops=1)

2. 0.018 0.668 ↑ 1.5 4 1

Bitmap Heap Scan on venda ven (cost=694.95..701.64 rows=6 width=8) (actual time=0.661..0.668 rows=4 loops=1)

  • Recheck Cond: (((ven_ds_referencia)::text ~~ '2D%'::text) AND (ven_cd_unidade_negocio = 647))
  • Heap Blocks: exact=3
3. 0.003 0.650 ↓ 0.0 0 1

BitmapAnd (cost=694.95..694.95 rows=6 width=0) (actual time=0.650..0.650 rows=0 loops=1)

4. 0.212 0.212 ↑ 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.212..0.212 rows=10 loops=1)

  • Index Cond: ((ven_ds_referencia)::text ~~ '2D%'::text)
5. 0.435 0.435 ↑ 22.5 2,698 1

Bitmap Index Scan on venda_ven_cd_unidade_negocio_idx (cost=0.00..639.75 rows=60,731 width=0) (actual time=0.435..0.435 rows=2,698 loops=1)

  • Index Cond: (ven_cd_unidade_negocio = 647)
Planning time : 0.701 ms
Execution time : 0.734 ms