explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gsj1

Settings

Optimization(s) for this plan:

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

Subquery Scan on tablewithcount (cost=0.28..525.42 rows=2,660 width=23) (actual rows= loops=)

  • Filter: (tablewithcount.count > 1)
2. 0.000 0.000 ↓ 0.0

WindowAgg (cost=0.28..425.67 rows=7,980 width=19) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Index Scan using user_binding__auth_provider_user_id on user_binding (cost=0.28..305.97 rows=7,980 width=19) (actual rows= loops=)

  • Filter: ((status_id)::text = 'active'::text)