explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jSKs

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 587.005 1,255.539 ↑ 1.4 1,420,849 1

Nested Loop (cost=1.37..1,616,464.46 rows=2,004,476 width=6,153) (actual time=0.026..1,255.539 rows=1,420,849 loops=1)

2. 60.069 290.874 ↑ 1.0 16,420 1

Merge Join (cost=0.81..57,122.09 rows=16,420 width=5,881) (actual time=0.018..290.874 rows=16,420 loops=1)

  • Merge Cond: (c.id = falc.fckid)
3. 225.506 225.506 ↑ 1.0 602,203 1

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

4. 5.299 5.299 ↑ 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.004..5.299 rows=16,420 loops=1)

5. 377.660 377.660 ↑ 28.4 87 16,420

Index Scan using ix_flagejb_fk_flagejb_documentevent_id on flagejb f (cost=0.57..70.26 rows=2,471 width=272) (actual time=0.004..0.023 rows=87 loops=16,420)

  • Index Cond: (documentevent_id = c.id)