explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oZAR

Settings
# exclusive inclusive rows x rows loops node
1. 0.029 29.819 ↑ 9.8 39 1

Nested Loop (cost=2,985.78..5,414.26 rows=383 width=1,736) (actual time=29.623..29.819 rows=39 loops=1)

2. 0.383 29.595 ↑ 12.2 39 1

HashAggregate (cost=2,985.49..2,990.23 rows=474 width=16) (actual time=29.585..29.595 rows=39 loops=1)

  • Group Key: a.notify_user_id
3. 29.212 29.212 ↑ 1.1 1,138 1

Seq Scan on activities a (cost=0.00..2,982.38 rows=1,244 width=16) (actual time=0.009..29.212 rows=1,138 loops=1)

  • Filter: ((inserted_at <= now()) AND (seen_at <= now()))
  • Rows Removed by Filter: 61,175
4. 0.195 0.195 ↑ 1.0 1 39

Index Scan using users_pkey on users u0 (cost=0.29..5.22 rows=1 width=1,736) (actual time=0.005..0.005 rows=1 loops=39)

  • Index Cond: (id = a.notify_user_id)
  • Filter: ((email_confirm_by IS NULL) AND (deleted_at IS NULL) AND (next_digest_date <= now()))
Planning time : 0.749 ms
Execution time : 29.892 ms