explain.depesz.com

A tool for finding a real cause for slow queries.

Result: t2j

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Delete on callista_enrolment ce (cost=4,240.34..55,642.62 rows=92,775 width=12) (actual time=.. rows= loops=)

2. 0.000 0.000 ↓ 0.0

Hash Anti Join (cost=4,240.34..55,642.62 rows=92,775 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.000 0.000 ↓ 0.0

Seq Scan on callista_enrolment ce (cost=0.00..9,510.48 rows=94,248 width=630) (actual time=.. rows= loops=)

4. 0.000 0.000 ↓ 0.0

Hash (cost=2,076.81..2,076.81 rows=20,581 width=630) (actual time=.. rows= loops=)

5. 0.000 0.000 ↓ 0.0

Seq Scan on temp_enrolments te (cost=0.00..2,076.81 rows=20,581 width=630) (actual time=.. rows= loops=)