explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CZFR : Optimization for: Optimization for: plan #JyUw; plan #okFF

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.013 0.053 ↑ 1.0 1 1

Aggregate (cost=2.51..2.52 rows=1 width=32) (actual time=0.053..0.053 rows=1 loops=1)

2. 0.040 0.040 ↓ 10.0 10 1

Index Scan using idx_dfactura_despacho_cmoid_proid on dfactura_despacho dp (cost=0.29..2.51 rows=1 width=5) (actual time=0.020..0.040 rows=10 loops=1)

  • Index Cond: ((cmo_id = 36847) AND (pro_id = 3783))