explain.depesz.com

PostgreSQL's explain analyze made readable

Result: aHpS : Optimization for: Optimization for: plan #kzi; plan #kicj

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.041 0.613 ↑ 1.0 1 1

Index Scan using pk_cbu_id on cbulto (cost=36.05..38.26 rows=1 width=28) (actual time=0.612..0.613 rows=1 loops=1)

  • Index Cond: (cbu_id = $0)
2.          

Initplan (forIndex Scan)

3. 0.572 0.572 ↑ 1.0 1 1

Seq Scan on cbulto_cfacen (cost=0.00..35.76 rows=1 width=4) (actual time=0.508..0.572 rows=1 loops=1)

  • Filter: (cfa_id = 35111)
  • Rows Removed by Filter: 2025