explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xiX2 : Original

Settings
# exclusive inclusive rows x rows loops node
1. 0.043 0.210 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.42..16.96 rows=1 width=580) (actual time=0.152..0.210 rows=1 loops=1)

2. 0.047 0.139 ↑ 1.0 1 1

Nested Loop (cost=0.29..16.54 rows=1 width=80) (actual time=0.100..0.139 rows=1 loops=1)

3. 0.064 0.064 ↑ 1.0 1 1

Index Scan using notifications_pkey on notifications (cost=0.15..8.17 rows=1 width=48) (actual time=0.045..0.064 rows=1 loops=1)

  • Index Cond: (notification_id = 12)
4. 0.028 0.028 ↑ 1.0 1 1

Index Scan using users_pkey on users (cost=0.14..8.16 rows=1 width=64) (actual time=0.019..0.028 rows=1 loops=1)

  • Index Cond: (id = notifications.user_id)
  • Filter: ((send_email IS TRUE) AND (confirmed IS NOT NULL))
5. 0.028 0.028 ↑ 1.0 1 1

Index Scan using partners_pkey on partners (cost=0.13..0.31 rows=1 width=532) (actual time=0.020..0.028 rows=1 loops=1)

  • Index Cond: (users.partner_id = id)
Planning time : 0.507 ms
Execution time : 0.444 ms