explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1DKx

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

Limit (cost=89.83..89.83 rows=1 width=143) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Sort (cost=89.76..89.83 rows=30 width=143) (actual rows= loops=)

  • Sort Key: object, role_id, expires_by
3. 0.000 0.000 ↓ 0.0

Index Scan using ix_ra_org_obj_exp on role_assignment (cost=0.42..89.02 rows=30 width=143) (actual rows= loops=)

  • Index Cond: (organization_id = 'f0c94277-6756-4549-96a6-5dea272b9c95'::uuid)