explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QXtc

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

Nested Loop Left Join (cost=0.42..86.20 rows=1 width=716) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Limit (cost=0.00..77.44 rows=1 width=673) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Seq Scan on "Users" "User" (cost=0.00..77.44 rows=1 width=673) (actual rows= loops=)

  • Filter: ((username)::text ~~* 'SRV1'::text)
4. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.42..8.75 rows=1 width=43) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Index Scan using "UsersGroups_UserId_GroupId_key" on "UsersGroups" "Groups.UsersGroups" (cost=0.14..8.16 rows=1 width=32) (actual rows= loops=)

  • Index Cond: ("User".id = "UserId")
6. 0.000 0.000 ↓ 0.0

Index Scan using "Groups_pkey" on "Groups" (cost=0.27..0.58 rows=1 width=11) (actual rows= loops=)

  • Index Cond: (id = "Groups.UsersGroups"."GroupId")