explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5JWH

Settings
# exclusive inclusive rows x rows loops node
1. 35.337 49.317 ↑ 1.0 6,743 1

Bitmap Heap Scan on produto pro (cost=3,416.20..8,614.68 rows=6,859 width=350) (actual time=14.438..49.317 rows=6,743 loops=1)

  • Recheck Cond: (pro_cd_rede = 91)
  • Heap Blocks: exact=2145
2. 13.980 13.980 ↑ 1.0 6,745 1

Bitmap Index Scan on produto_pro_ds_referencia_pro_cd_rede_pro_bl_identificado_idx (cost=0.00..3,414.48 rows=6,859 width=0) (actual time=13.980..13.980 rows=6,745 loops=1)

  • Index Cond: (pro_cd_rede = 91)
Planning time : 0.225 ms
Execution time : 49.881 ms