explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gg5P

Settings
# exclusive inclusive rows x rows loops node
1. 0.044 797.386 ↑ 1.0 1 1

Aggregate (cost=697.31..697.33 rows=1 width=32) (actual time=797.385..797.386 rows=1 loops=1)

2. 461.931 797.342 ↑ 1.5 4 1

Bitmap Heap Scan on venda ven (cost=690.55..697.24 rows=6 width=8) (actual time=585.939..797.342 rows=4 loops=1)

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

BitmapAnd (cost=690.55..690.55 rows=6 width=0) (actual time=335.411..335.411 rows=0 loops=1)

4. 90.272 90.272 ↑ 805.5 6 1

Bitmap Index Scan on venda_ref_gin_trgm_idx (cost=0.00..50.55 rows=4,833 width=0) (actual time=90.272..90.272 rows=6 loops=1)

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

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

  • Index Cond: (ven_cd_unidade_negocio = 647)
Planning time : 250.541 ms
Execution time : 797.531 ms