explain.depesz.com

PostgreSQL's explain analyze made readable

Result: c9vf

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.020 ↑ 1.0 1 1

Result (cost=13.42..13.43 rows=1 width=1) (actual time=0.020..0.020 rows=1 loops=1)

2.          

Initplan (for Result)

3. 0.000 0.019 ↓ 0.0 0 1

Nested Loop (cost=1.14..13.42 rows=1 width=0) (actual time=0.019..0.019 rows=0 loops=1)

4. 0.001 0.019 ↓ 0.0 0 1

Nested Loop (cost=0.86..13.10 rows=1 width=4) (actual time=0.019..0.019 rows=0 loops=1)

5. 0.015 0.015 ↑ 1.0 1 1

Index Scan using idx_user_profile_account_holder_uuid on user_profile (cost=0.43..8.45 rows=1 width=4) (actual time=0.013..0.015 rows=1 loops=1)

  • Index Cond: (account_holder_uuid = 'cca910e7-371d-419a-90d8-8f12e4959b01'::uuid)
6. 0.003 0.003 ↓ 0.0 0 1

Index Only Scan using idx_service_announcement_notification_user_id on service_announcement_notification (cost=0.43..4.57 rows=8 width=8) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (user_profile_id = user_profile.id)
  • Heap Fetches: 0
7. 0.000 0.000 ↓ 0.0 0

Index Scan using service_information_pkey on service_information (cost=0.27..0.29 rows=1 width=4) (never executed)

  • Index Cond: (id = service_announcement_notification.service_announcement_id)
  • Filter: ((service_information_uid)::text = 'de69efd4-5a76-4fb2-95c0-1b32c27ca617'::text)
Planning time : 0.610 ms
Execution time : 0.061 ms