explain.depesz.com

PostgreSQL's explain analyze made readable

Result: M5yE : Long-running query

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

Unique (cost=52,206.84..52,246.52 rows=7,936 width=8) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Sort (cost=52,206.84..52,226.68 rows=7,936 width=8) (actual rows= loops=)

  • Sort Key: retryable_event.event_id
3. 0.000 0.000 ↓ 0.0

Seq Scan on retryable_event (cost=50,728.43..51,692.81 rows=7,936 width=8) (actual rows= loops=)

  • Filter: (NOT (hashed SubPlan 1))
4.          

SubPlan (for Seq Scan)

5. 0.000 0.000 ↓ 0.0

Unique (cost=0.29..50,442.55 rows=114,352 width=8) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Index Only Scan using pk_transaction_event on transaction_event " " (cost=0.29..50,156.67 rows=114,352 width=8) (actual rows= loops=)