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=4240.34..55642.62 rows=92775 width=12) (actual time=.. rows= loops=)

2. 0.000 0.000 ↓ 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.000 0.000 ↓ 0.0

Seq Scan on callista_enrolment ce (cost=0.00..9510.48 rows=94248 width=630) (actual time=.. rows= loops=)

4. 0.000 0.000 ↓ 0.0

Hash (cost=2076.81..2076.81 rows=20581 width=630) (actual time=.. rows= loops=)

5. 0.000 0.000 ↓ 0.0

Seq Scan on temp_enrolments te (cost=0.00..2076.81 rows=20581 width=630) (actual time=.. rows= loops=)