explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rE89 : aaaa

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.43..24.51 rows=1 width=1,724) (actual rows= loops=)

  • Join Filter: (ac.uuid = acm.account_channel_uuid)
2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.29..16.34 rows=1 width=1,112) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Index Scan using accounts_uuid_index on accounts a (cost=0.14..8.16 rows=1 width=548) (actual rows= loops=)

  • Index Cond: (uuid = '5387119a-a490-4c71-8a25-6ff36e43b0ab'::uuid)
4. 0.000 0.000 ↓ 0.0

Index Scan using account_channels_account_uuid_index on account_channels ac (cost=0.14..8.16 rows=1 width=564) (actual rows= loops=)

  • Index Cond: (account_uuid = '5387119a-a490-4c71-8a25-6ff36e43b0ab'::uuid)
5. 0.000 0.000 ↓ 0.0

Index Scan using account_channel_members_user_uuid_index on account_channel_members acm (cost=0.14..8.16 rows=1 width=612) (actual rows= loops=)

  • Index Cond: (user_uuid = '1e9d3fe6-3f63-42d4-815a-6f567681c149'::uuid)