#	rows x	node
1.	↓ 0.0	→ Delete on callista_enrolment ce (cost=4240.34..55642.62 rows=92775 width=12) (actual time=.. rows= loops=)
2.	↓ 0.0	→ Hash Anti Join (cost=4240.34..55642.62 rows=92775 width=12) (actual time=.. rows= loops=) Hash Cond: (((ce.username)::text = (te.username)::text) AND ((ce.person_id)::text = (te.person_id)::text) AND (ce.unit_offer_id = te.unit_offer_id) AND ((ce.unit_attempt_status)::text = (te.unit_attempt
3.	↓ 0.0	→ Seq Scan on callista_enrolment ce (cost=0.00..9510.48 rows=94248 width=630) (actual time=.. rows= loops=)
4.	↓ 0.0	→ Hash (cost=2076.81..2076.81 rows=20581 width=630) (actual time=.. rows= loops=)
5.	↓ 0.0	→ Seq Scan on temp_enrolments te (cost=0.00..2076.81 rows=20581 width=630) (actual time=.. rows= loops=)

                                                                                                                                                       QUERY PLAN                                                  
                                                                                                     
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------
 Delete on callista_enrolment ce  (cost=4240.34..55642.62 rows=92775 width=12)
   ->  Hash Anti Join  (cost=4240.34..55642.62 rows=92775 width=12)
         Hash Cond: (((ce.username)::text = (te.username)::text) AND ((ce.person_id)::text = (te.person_id)::text) AND (ce.unit_offer_id = te.unit_offer_id) AND ((ce.unit_attempt_status)::text = (te.unit_attempt
_status)::text) AND ((ce.course_cd)::text = (te.course_cd)::text) AND (ce.update_on = te.update_on))
         ->  Seq Scan on callista_enrolment ce  (cost=0.00..9510.48 rows=94248 width=630)
         ->  Hash  (cost=2076.81..2076.81 rows=20581 width=630)
               ->  Seq Scan on temp_enrolments te  (cost=0.00..2076.81 rows=20581 width=630)

Per node type stats

node type	count	sum of times	% of query
Delete	1	0.000 ms	0.0 %
Hash	1	0.000 ms	0.0 %
Hash Anti Join	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
callista_enrolment	2	0.000 ms	0.0 %
Delete	1	0.000 ms	0.0 %
Seq Scan	1	0.000 ms	0.0 %
temp_enrolments	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: t2j

Colorize:

Columns visibility:

Per node type stats

Per table stats