explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4Tep

Settings
# exclusive inclusive rows x rows loops node
1. 0.011 0.055 ↑ 1.0 1 1

Index Scan using pk_cbu_id on cbulto (cost=2.78..5.00 rows=1 width=28) (actual time=0.055..0.055 rows=1 loops=1)

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

Initplan (forIndex Scan)

3. 0.044 0.044 ↑ 1.0 1 1

Index Scan using idx_cbulto_cfaen_cfaid on cbulto_cfacen (cost=0.28..2.50 rows=1 width=4) (actual time=0.044..0.044 rows=1 loops=1)

  • Index Cond: (cfa_id = 35111)