explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vX47

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 39,494.438 ↓ 0.0 0 1

Delete on modification_history mh (cost=88,697.87..2,402,785.42 rows=755,902 width=12) (actual time=39,494.438..39,494.438 rows=0 loops=1)

2. 442.567 39,494.436 ↓ 0.0 0 1

Hash Anti Join (cost=88,697.87..2,402,785.42 rows=755,902 width=12) (actual time=39,494.436..39,494.436 rows=0 loops=1)

  • Hash Cond: (mh.user_id = users.id)
3. 37,646.747 37,646.747 ↑ 2.0 2,286,265 1

Seq Scan on modification_history mh (cost=0.00..2,245,158.03 rows=4,570,103 width=10) (actual time=2,653.489..37,646.747 rows=2,286,265 loops=1)

4. 34.806 1,405.122 ↓ 1.0 92,626 1

Hash (cost=87,087.72..87,087.72 rows=92,572 width=10) (actual time=1,405.122..1,405.122 rows=92,626 loops=1)

  • Buckets: 131072 Batches: 2 Memory Usage: 3017kB
5. 1,370.316 1,370.316 ↓ 1.0 92,626 1

Seq Scan on users (cost=0.00..87,087.72 rows=92,572 width=10) (actual time=0.172..1,370.316 rows=92,626 loops=1)