#	exclusive	inclusive	rows x	rows	loops	node
1.	60.307	495.670	↓ 0.0	0	1	→ Hash Join (cost=64,844.05..68,795.81 rows=8,211 width=8) (actual time=495.670..495.670 rows=0 loops=1) Hash Cond: (ce.task_id = tt.id)
2.	12.147	12.147	↓ 1.1	32,841	1	→ Index Scan using cal_event_i04 on cal_event_t ce (cost=0.00..1,703.27 rows=31,138 width=16) (actual time=0.013..12.147 rows=32,841 loops=1) Index Cond: (start_date > '2018-12-03'::date)
3.	75.772	423.216	↓ 1.5	587,230	1	→ Hash (cost=58,338.96..58,338.96 rows=396,487 width=4) (actual time=423.216..423.216 rows=587,230 loops=1) Buckets: 4096 Batches: 32 (originally 16) Memory Usage: 1025kB
4.	187.262	347.444	↓ 1.5	587,230	1	→ Hash Join (cost=1.17..58,338.96 rows=396,487 width=4) (actual time=0.036..347.444 rows=587,230 loops=1) Hash Cond: (tt.status_id = st.id)
5.	160.176	160.176	↑ 1.0	1,387,705	1	→ Seq Scan on om_task_t tt (cost=0.00..50,821.05 rows=1,387,705 width=8) (actual time=0.024..160.176 rows=1,387,705 loops=1)
6.	0.001	0.006	↑ 1.0	2	1	→ Hash (cost=1.15..1.15 rows=2 width=8) (actual time=0.006..0.006 rows=2 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 1kB
7.	0.005	0.005	↑ 1.0	2	1	→ Seq Scan on fm_status_t st (cost=0.00..1.15 rows=2 width=8) (actual time=0.004..0.005 rows=2 loops=1) Filter: ((code)::text = ANY ('{ORPHAN,CANCEL}'::text[])) Rows Removed by Filter: 10

"Hash Join  (cost=64844.05..68795.81 rows=8211 width=8) (actual time=495.670..495.670 rows=0 loops=1)"
"  Hash Cond: (ce.task_id = tt.id)"
"  ->  Index Scan using cal_event_i04 on cal_event_t ce  (cost=0.00..1703.27 rows=31138 width=16) (actual time=0.013..12.147 rows=32841 loops=1)"
"        Index Cond: (start_date > '2018-12-03'::date)"
"  ->  Hash  (cost=58338.96..58338.96 rows=396487 width=4) (actual time=423.216..423.216 rows=587230 loops=1)"
"        Buckets: 4096  Batches: 32 (originally 16)  Memory Usage: 1025kB"
"        ->  Hash Join  (cost=1.17..58338.96 rows=396487 width=4) (actual time=0.036..347.444 rows=587230 loops=1)"
"              Hash Cond: (tt.status_id = st.id)"
"              ->  Seq Scan on om_task_t tt  (cost=0.00..50821.05 rows=1387705 width=8) (actual time=0.024..160.176 rows=1387705 loops=1)"
"              ->  Hash  (cost=1.15..1.15 rows=2 width=8) (actual time=0.006..0.006 rows=2 loops=1)"
"                    Buckets: 1024  Batches: 1  Memory Usage: 1kB"
"                    ->  Seq Scan on fm_status_t st  (cost=0.00..1.15 rows=2 width=8) (actual time=0.004..0.005 rows=2 loops=1)"
"                          Filter: ((code)::text = ANY ('{ORPHAN,CANCEL}'::text[]))"
"                          Rows Removed by Filter: 10"
"Total runtime: 495.720 ms"

Per node type stats

node type	count	sum of times	% of query
Hash	2	75.773 ms	15.3 %
Hash Join	2	247.569 ms	49.9 %
Index Scan	1	12.147 ms	2.5 %
Seq Scan	2	160.181 ms	32.3 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
cal_event_t	1	12.147 ms	2.5 %
Index Scan	1	12.147 ms	100.0 %
fm_status_t	1	0.005 ms	0.0 %
Seq Scan	1	0.005 ms	100.0 %
om_task_t	1	160.176 ms	32.3 %
Seq Scan	1	160.176 ms	100.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZQiQ

Color mode:

Visible columns:

Per node type stats

Per table stats