explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 56sl

Settings

Optimization(s) for this plan:

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

Update on events (cost=14.77..678.75 rows=80 width=979) (actual time=0.321..0.322 rows=0 loops=1)

2. 0.002 0.320 ↓ 0.0 0 1

Nested Loop (cost=14.77..678.75 rows=80 width=979) (actual time=0.320..0.320 rows=0 loops=1)

3. 0.001 0.318 ↓ 0.0 0 1

HashAggregate (cost=14.35..15.15 rows=80 width=32) (actual time=0.318..0.318 rows=0 loops=1)

  • Group Key: "ANY_subquery".id
4. 0.002 0.317 ↓ 0.0 0 1

Subquery Scan on ANY_subquery (cost=0.28..14.15 rows=80 width=32) (actual time=0.316..0.317 rows=0 loops=1)

5. 0.003 0.315 ↓ 0.0 0 1

Limit (cost=0.28..13.35 rows=80 width=10) (actual time=0.314..0.315 rows=0 loops=1)

6. 0.001 0.312 ↓ 0.0 0 1

LockRows (cost=0.28..1,239.60 rows=7,587 width=10) (actual time=0.312..0.312 rows=0 loops=1)

7. 0.311 0.311 ↓ 0.0 0 1

Index Scan using events_unrelayed on events events_1 (cost=0.28..1,163.73 rows=7,587 width=10) (actual time=0.311..0.311 rows=0 loops=1)

  • Index Cond: (relayed = false)
  • Filter: (NOT relayed)
8. 0.000 0.000 ↓ 0.0 0

Index Scan using events_pkey on events (cost=0.42..8.29 rows=1 width=946) (never executed)

  • Index Cond: (id = "ANY_subquery".id)
Planning time : 0.216 ms