explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1kfe

Settings
# exclusive inclusive rows x rows loops node
1. 0.011 0.073 ↑ 118.3 6 1

Nested Loop (cost=22.50..8,738.65 rows=710 width=8) (actual time=0.039..0.073 rows=6 loops=1)

2. 0.015 0.032 ↑ 118.3 6 1

Bitmap Heap Scan on notification_recipients (cost=22.07..2,748.50 rows=710 width=4) (actual time=0.024..0.032 rows=6 loops=1)

  • Recheck Cond: (userid = 1611853341)
3. 0.017 0.017 ↑ 118.3 6 1

Bitmap Index Scan on ix_notification_recipients_userid_email (cost=0.00..21.89 rows=710 width=0) (actual time=0.017..0.017 rows=6 loops=1)

  • Index Cond: (userid = 1611853341)
4. 0.030 0.030 ↑ 1.0 1 6

Index Scan using activity_pkey on activity (cost=0.43..8.43 rows=1 width=12) (actual time=0.005..0.005 rows=1 loops=6)

  • Index Cond: (id = notification_recipients.activityid)