explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tD3d

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Delete on srappointment (cost=17,978.51..36,848.51 rows=500,000 width=6) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Seq Scan on srappointment (cost=17,978.51..36,848.51 rows=500,000 width=6) (actual rows= loops=)

  • Filter: (NOT (hashed SubPlan 1))
3.          

SubPlan (for Seq Scan)

4. 0.000 0.000 ↓ 0.0

Unique (cost=17,978.50..17,978.51 rows=1 width=8) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Sort (cost=17,978.50..17,978.51 rows=1 width=8) (actual rows= loops=)

  • Sort Key: p."RowIdentifier
6. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.41..17,978.49 rows=1 width=8) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Seq Scan on srpatient p (cost=0.00..17,970.00 rows=1 width=23) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Index Only Scan using greenlist_nhs_dob_gpcode on greenlist g (cost=0.41..8.48 rows=1 width=15) (actual rows= loops=)

  • Index Cond: ((nhs_number = (p."NHSNumber")::bpchar) AND (nhs_number IS NOT NULL) AND (date_of_birth = (p."DateBirth")::date))