explain.depesz.com

PostgreSQL's explain analyze made readable

Result: eZhu

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 0.017 ↓ 0.0 0 1

Delete on events (cost=0.12..67.18 rows=1 width=34) (actual time=0.017..0.017 rows=0 loops=1)

2. 0.002 0.015 ↓ 0.0 0 1

Nested Loop Semi Join (cost=0.12..67.18 rows=1 width=34) (actual time=0.014..0.015 rows=0 loops=1)

  • Join Filter: (events.id = "ANY_subquery".id)
3. 0.013 0.013 ↓ 0.0 0 1

Index Scan using events_pkey on events (cost=0.12..8.14 rows=1 width=10) (actual time=0.012..0.013 rows=0 loops=1)

4. 0.000 0.000 ↓ 0.0 0

Subquery Scan on ANY_subquery (cost=0.00..59.03 rows=1 width=32) (never executed)

5. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..59.02 rows=1 width=10) (never executed)

6. 0.000 0.000 ↓ 0.0 0

LockRows (cost=0.00..59.02 rows=1 width=10) (never executed)

7. 0.000 0.000 ↓ 0.0 0

Seq Scan on events events_1 (cost=0.00..59.01 rows=1 width=10) (never executed)

Planning time : 18.850 ms