explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7gr

Settings
# exclusive inclusive rows x rows loops node
1. 332.404 32,494.997 ↑ 419,137.0 2 1

Hash Anti Join (cost=88,606.87..2,945,434.15 rows=838,274 width=4) (actual time=32,494.499..32,494.997 rows=2 loops=1)

  • Hash Cond: (mh.user_id = users.id)
2. 31,009.446 31,009.446 ↑ 2.2 2,286,267 1

Seq Scan on modification_history mh (cost=0.00..2,790,424.16 rows=5,068,116 width=8) (actual time=2,265.311..31,009.446 rows=2,286,267 loops=1)

3. 13.622 1,153.147 ↓ 1.0 92,626 1

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

  • Buckets: 131072 Batches: 2 Memory Usage: 2655kB
4. 1,139.525 1,139.525 ↓ 1.0 92,626 1

Seq Scan on users (cost=0.00..87,087.72 rows=92,572 width=4) (actual time=0.448..1,139.525 rows=92,626 loops=1)