explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jNvi

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

Delete on sms_bulks (cost=0.43..2,698,496,870,397.79 rows=8,170,338 width=6) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Seq Scan on sms_bulks (cost=0.43..2,698,496,870,397.79 rows=8,170,338 width=6) (actual rows= loops=)

3.          

SubPlan (forDelete)

4. 0.000 0.000 ↓ 0.0

Materialize (cost=0.43..324,807.89 rows=2,188,866 width=4) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Index Only Scan using sms_requests_pkey on sms_requests (cost=0.43..305,312.56 rows=2,188,866 width=4) (actual rows= loops=)