explain.depesz.com

PostgreSQL's explain analyze made readable

Result: MVZZ : Optimization for: plan #56sl

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.004 0.013 ↓ 0.0 0 1

Delete on events (cost=0.00..2.05 rows=1 width=34) (actual time=0.012..0.013 rows=0 loops=1)

2. 0.000 0.009 ↓ 0.0 0 1

Nested Loop Semi Join (cost=0.00..2.05 rows=1 width=34) (actual time=0.009..0.009 rows=0 loops=1)

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

Seq Scan on events (cost=0.00..1.01 rows=1 width=10) (actual time=0.008..0.009 rows=0 loops=1)

4. 0.000 0.000 ↓ 0.0 0

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

5. 0.000 0.000 ↓ 0.0 0

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

6. 0.000 0.000 ↓ 0.0 0

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

7. 0.000 0.000 ↓ 0.0 0

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

  • Filter: (NOT relayed)