explain.depesz.com

PostgreSQL's explain analyze made readable

Result: H1l : Optimization for: Optimization for: Optimization for: plan #jSKs; plan #Mmva; plan #VLI

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 11,618.386 148,102.648 ↑ 28.6 1,420,849 1

Merge Join (cost=1.14..5,335,110.39 rows=40,580,906 width=487) (actual time=0.089..148,102.648 rows=1,420,849 loops=1)

  • Merge Cond: (falc.fckid = f.documentevent_id)
2. 6.270 6.270 ↑ 1.0 16,420 1

Index Scan using ixfckid on sc_wh_falcs_aggr falc (cost=0.29..1,511.12 rows=16,420 width=215) (actual time=0.006..6.270 rows=16,420 loops=1)

3. 136,477.992 136,477.992 ↑ 1.0 73,521,337 1

Index Scan using ix_flagejb_fk_flagejb_documentevent_id on flagejb f (cost=0.57..4,744,325.60 rows=73,525,088 width=272) (actual time=0.004..136,477.992 rows=73,521,337 loops=1)