#	exclusive	inclusive	rows x	node
1.	0.000	0.000	↓ 0.0	→ Delete on twf_log_group_user (cost=224.15..887750.35 rows=9511248 width=6) (actual time=.. rows= loops=)
2.	0.000	0.000	↓ 0.0	→ Seq Scan on twf_log_group_user (cost=224.15..887750.35 rows=9511248 width=6) (actual time=.. rows= loops=) Filter: (NOT (hashed SubPlan 1))
3.				SubPlan (forSeq Scan)
4.	0.000	0.000	↓ 0.0	→ Seq Scan on twf_log_subjob (cost=0.00..205.52 rows=7452 width=6) (actual time=.. rows= loops=)

                                     QUERY PLAN                                      
-------------------------------------------------------------------------------------
 Delete on twf_log_group_user  (cost=224.15..887750.35 rows=9511248 width=6)
   ->  Seq Scan on twf_log_group_user  (cost=224.15..887750.35 rows=9511248 width=6)
         Filter: (NOT (hashed SubPlan 1))
         SubPlan 1
           ->  Seq Scan on twf_log_subjob  (cost=0.00..205.52 rows=7452 width=6)
(5 rows)

Per node type stats

node type	count	sum of times	% of query
Delete	1	0.000 ms	0.0 %
Seq Scan	2	0.000 ms	0.0 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
twf_log_group_user	2	0.000 ms	0.0 %
Delete	1	0.000 ms	0.0 %
Seq Scan	1	0.000 ms	0.0 %
twf_log_subjob	1	0.000 ms	0.0 %
Seq Scan	1	0.000 ms	0.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: I4B

Colorize:

Columns visibility:

Per node type stats

Per table stats