explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XW8e

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

Index Scan using permissions_resource_id_index on permissions p0 (cost=0.42..8.46 rows=1 width=42) (actual rows= loops=)

  • Index Cond: ((resource_id)::text = '1195b741-9896-4394-91ad-92a1f9c9e874'::text)
  • Filter: (((resource_type)::text = 'srn:resource:user'::text) AND ('entity:write'::text = ANY ((scopes)::text[])))