#	rows x	node
1.	↓ 0.0	→ Merge Join (cost=1.14..5,335,110.39 rows=40,580,906 width=487) (actual rows= loops=) Merge Cond: (falc.fckid = f.documentevent_id)
2.	↓ 0.0	→ Index Scan using ixfckid on sc_wh_falcs_aggr falc (cost=0.29..1,511.12 rows=16,420 width=215) (actual rows= loops=)
3.	↓ 0.0	→ 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 rows= loops=)

Merge Join  (cost=1.14..5335110.39 rows=40580906 width=487)
  Merge Cond: (falc.fckid = f.documentevent_id)
  ->  Index Scan using ixfckid on sc_wh_falcs_aggr falc  (cost=0.29..1511.12 rows=16420 width=215)
  ->  Index Scan using ix_flagejb_fk_flagejb_documentevent_id on flagejb f  (cost=0.57..4744325.60 rows=73525088 width=272)

Per node type stats

node type	count	sum of times	% of query
Index Scan	2	0.000 ms	0.0 %
Merge Join	1	0.000 ms	0.0 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
flagejb	1	0.000 ms	0.0 %
Index Scan	1	0.000 ms	0.0 %
sc_wh_falcs_aggr	1	0.000 ms	0.0 %
Index Scan	1	0.000 ms	0.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

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

Color mode:

Visible columns:

Optimization path:

Optimization(s) for this plan:

Per node type stats

Per table stats