explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 0rG : Optimization for: Optimization for: plan #p1hA; plan #QLVG

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.018 0.082 ↑ 1.0 1 1

Aggregate (cost=9.09..9.11 rows=1 width=32) (actual time=0.082..0.082 rows=1 loops=1)

2. 0.064 0.064 ↑ 1.5 4 1

Index Scan using venda_referencia_2d on venda ven (cost=0.13..9.02 rows=6 width=8) (actual time=0.059..0.064 rows=4 loops=1)

  • Index Cond: (ven_cd_unidade_negocio = 647)
Planning time : 0.813 ms
Execution time : 0.120 ms