explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GGgO

Settings
# exclusive inclusive rows x rows loops node
1. 48.643 99.349 ↓ 4.7 116,597 1

Hash Join (cost=128.47..91,530.57 rows=24,811 width=183) (actual time=0.747..99.349 rows=116,597 loops=1)

  • Hash Cond: (action_user.action_id = actions.id)
  • Buffers: shared hit=43559
2. 49.985 49.985 ↓ 4.7 116,597 1

Index Scan using action_user_user_id_index on action_user (cost=0.58..91,061.53 rows=24,811 width=65) (actual time=0.015..49.985 rows=116,597 loops=1)

  • Index Cond: (user_id = 62)
  • Buffers: shared hit=43500
3. 0.389 0.721 ↑ 1.0 3,062 1

Hash (cost=89.62..89.62 rows=3,062 width=118) (actual time=0.721..0.721 rows=3,062 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 504kB
  • Buffers: shared hit=59
4. 0.332 0.332 ↑ 1.0 3,062 1

Seq Scan on actions (cost=0.00..89.62 rows=3,062 width=118) (actual time=0.003..0.332 rows=3,062 loops=1)

  • Buffers: shared hit=59
Planning time : 0.188 ms
Execution time : 104.495 ms