explain.depesz.com

PostgreSQL's explain analyze made readable

Result: U2yK

Settings
# exclusive inclusive rows x rows loops node
1. 0.025 0.428 ↑ 1.0 1 1

GroupAggregate (cost=0.71..45.04 rows=1 width=160) (actual time=0.428..0.428 rows=1 loops=1)

  • Group Key: "user".id
2. 0.030 0.403 ↑ 1.5 55 1

Nested Loop Left Join (cost=0.71..44.62 rows=80 width=160) (actual time=0.072..0.403 rows=55 loops=1)

  • Join Filter: (access.user_id = "user".id)
3. 0.022 0.022 ↑ 1.0 1 1

Index Scan using user_pkey on "user" (cost=0.28..2.50 rows=1 width=152) (actual time=0.022..0.022 rows=1 loops=1)

  • Index Cond: (id = 2759)
  • Filter: is_active
4. 0.351 0.351 ↑ 1.5 55 1

Index Scan using idx_oauth_access_user_id on access (cost=0.42..41.13 rows=80 width=12) (actual time=0.047..0.351 rows=55 loops=1)

  • Index Cond: (user_id = 2759)
  • Filter: (client <> 'ba68dda3-d1e5-44f6-8bbf-48832ebe2f9c'::text)
  • Rows Removed by Filter: 30