explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bB3w : Optimization for: plan #gsj1

Settings

Optimization path:

Optimization(s) for this plan:

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

Hash Join (cost=453.27..752.50 rows=7,981 width=35) (actual rows= loops=)

  • Hash Cond: (user_binding.auth_provider_user_id = ub.auth_provider_user_id)
2. 0.000 0.000 ↓ 0.0

HashAggregate (cost=206.67..306.41 rows=7,979 width=8) (actual rows= loops=)

  • Group Key: user_binding.auth_provider_user_id
  • Filter: (count(user_binding.id) > 1)
3. 0.000 0.000 ↓ 0.0

Seq Scan on user_binding (cost=0.00..166.78 rows=7,980 width=8) (actual rows= loops=)

  • Filter: ((status_id)::text = 'active'::text)
4. 0.000 0.000 ↓ 0.0

Hash (cost=146.82..146.82 rows=7,982 width=35) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Seq Scan on user_binding ub (cost=0.00..146.82 rows=7,982 width=35) (actual rows= loops=)