explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VqiF

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

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

2. 0.000 0.000 ↓ 0.0

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

  • Hash Cond: (mh.user_id = users.id)
3. 0.000 0.000 ↓ 0.0

Seq Scan on modification_history mh (cost=0.00..2,245,158.03 rows=4,570,103 width=10) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

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

5. 0.000 0.000 ↓ 0.0

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