explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jNC

Settings
# exclusive inclusive rows x rows loops node
1. 0.010 204.545 ↑ 1.0 1 1

GroupAggregate (cost=1,000.28..82,683.86 rows=1 width=160) (actual time=204.544..204.545 rows=1 loops=1)

  • Group Key: "user".id
2. 0.000 204.535 ↑ 42,486.0 1 1

Nested Loop Left Join (cost=1,000.28..82,471.42 rows=42,486 width=160) (actual time=204.531..204.535 rows=1 loops=1)

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

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

  • Index Cond: (id = 1)
  • Filter: is_active
4. 35.316 234.917 ↓ 0.0 0 1

Gather (cost=1,000.00..81,937.84 rows=42,486 width=12) (actual time=204.509..234.917 rows=0 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
5. 199.601 199.601 ↓ 0.0 0 3

Parallel Seq Scan on access (cost=0.00..76,689.24 rows=17,702 width=12) (actual time=199.601..199.601 rows=0 loops=3)

  • Filter: ((user_id = 1) AND (client = '9faba46c-942f-4677-a07e-6da3d6312da3'::text))
  • Rows Removed by Filter: 320101