explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xugeo

Settings
# exclusive inclusive rows x rows loops node
1. 1.252 18.690 ↓ 1.2 1,138 1

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

  • Buffers: shared hit=5,200
2. 15.162 15.162 ↑ 1.1 1,138 1

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

  • Filter: ((inserted_at <= now()) AND (seen_at <= now()))
  • Rows Removed by Filter: 61,175
  • Buffers: shared hit=1,786
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()))
  • Buffers: shared hit=3,414
Planning time : 0.457 ms
Execution time : 18.810 ms