explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Mmva : Optimization for: plan #jSKs

Settings

Optimization path:

Optimization(s) for this plan:

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

Merge Join (cost=12.49..5,747,508.30 rows=73,525,088 width=5,938) (actual rows= loops=)

  • Merge Cond: (c.id = f.documentevent_id)
2. 0.000 0.000 ↓ 0.0

Index Scan using ix_flagejb_fk_flagejb_documentevent_id on flagejb f (cost=0.57..4,773,035.38 rows=73,525,088 width=272) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Index Scan using documenteventejb_pkey on documenteventejb c (cost=0.42..53,906.25 rows=602,293 width=5,666) (actual rows= loops=)