explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6Yim

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 0.325 ↓ 0.0 0 1

Delete on events (cost=0.78..82.59 rows=10 width=34) (actual time=0.324..0.325 rows=0 loops=1)

2. 0.001 0.322 ↓ 0.0 0 1

Nested Loop (cost=0.78..82.59 rows=10 width=34) (actual time=0.322..0.322 rows=0 loops=1)

3. 0.002 0.321 ↓ 0.0 0 1

HashAggregate (cost=0.62..0.72 rows=10 width=32) (actual time=0.321..0.321 rows=0 loops=1)

  • Group Key: "ANY_subquery".id
4. 0.001 0.319 ↓ 0.0 0 1

Subquery Scan on ANY_subquery (cost=0.00..0.59 rows=10 width=32) (actual time=0.318..0.319 rows=0 loops=1)

5. 0.003 0.318 ↓ 0.0 0 1

Limit (cost=0.00..0.49 rows=10 width=10) (actual time=0.317..0.318 rows=0 loops=1)

6. 0.001 0.315 ↓ 0.0 0 1

LockRows (cost=0.00..766.34 rows=15,617 width=10) (actual time=0.315..0.315 rows=0 loops=1)

7. 0.314 0.314 ↓ 0.0 0 1

Seq Scan on events events_1 (cost=0.00..610.17 rows=15,617 width=10) (actual time=0.314..0.314 rows=0 loops=1)

  • Filter: (NOT relayed)
8. 0.000 0.000 ↓ 0.0 0

Index Scan using events_pkey on events (cost=0.16..8.18 rows=1 width=10) (never executed)

  • Index Cond: (id = "ANY_subquery".id)