explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JkRi

Settings

Optimization(s) for this plan:

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

Seq Scan on estoque_saldo s (cost=0.00..3,561.92 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=3,167.39..3,167.39 rows=1 width=14) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Sort (cost=3,167.39..3,167.41 rows=10 width=14) (actual rows= loops=)

  • Sort Key: c.r_data_lancamento DESC
5. 0.000 0.000 ↓ 0.0

Seq Scan on estoque_custo c (cost=0.00..3,167.34 rows=10 width=14) (actual rows= loops=)