explain.depesz.com

PostgreSQL's explain analyze made readable

Result: InNw : Optimization for: plan #JkRi

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Seq Scan on estoque_saldo s (cost=0.00..400.23 rows=1 width=68) (actual rows= loops=)

  • Filter: ((ano_base = 2019) AND (mes_base = 5))
2.          

SubPlan (forSeq Scan)

3. 0.000 0.000 ↓ 0.0

Limit (cost=0.42..5.70 rows=1 width=14) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Index Scan Backward using idx_st1_estoque_custo on estoque_custo c (cost=0.42..10.99 rows=2 width=14) (actual rows= loops=)