explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hD1

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

Delete on srappointment (cost=0.00..6,458,518,870.00 rows=500,000 width=6) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Seq Scan on srappointment (cost=0.00..6,458,518,870.00 rows=500,000 width=6) (actual rows= loops=)

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

SubPlan (for Seq Scan)

4. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..11,667.00 rows=500,000 width=8) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Seq Scan on data (cost=0.00..7,213.00 rows=500,000 width=8) (actual rows= loops=)