explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bheh

Settings
# exclusive inclusive rows x rows loops node
1. 1.212 18.600 ↓ 1.2 1,138 1

Nested Loop (cost=0.29..7,968.02 rows=917 width=1,736) (actual time=0.025..18.600 rows=1,138 loops=1)

2. 15.112 15.112 ↑ 1.1 1,138 1

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

  • Filter: ((inserted_at <= now()) AND (seen_at <= now()))
  • Rows Removed by Filter: 61,175
3. 2.276 2.276 ↑ 1.0 1 1,138

Index Scan using users_pkey on users u0 (cost=0.29..4.01 rows=1 width=1,736) (actual time=0.002..0.002 rows=1 loops=1,138)

  • 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.449 ms
Execution time : 18.702 ms