explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xqSL

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

Delete on jobs (cost=145.01..2,940.05 rows=1,000 width=34) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=145.01..2,940.05 rows=1,000 width=34) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

HashAggregate (cost=144.45..154.45 rows=1,000 width=32) (actual rows= loops=)

  • Group Key: "ANY_subquery".id
4. 0.000 0.000 ↓ 0.0

Subquery Scan on ANY_subquery (cost=0.57..141.95 rows=1,000 width=32) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Limit (cost=0.57..131.95 rows=1,000 width=12) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Index Scan using ix_created on jobs jobs_1 (cost=0.57..1,206,241.97 rows=9,181,195 width=12) (actual rows= loops=)

  • Index Cond: (created < (now() - '365 days'::interval))
7. 0.000 0.000 ↓ 0.0

Index Scan using jobs_pkey on jobs (cost=0.56..2.78 rows=1 width=10) (actual rows= loops=)

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