explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RykI

Settings
# exclusive inclusive rows x rows loops node
1. 0.300 0.300 ↓ 46.0 46 1

Index Scan using index_members_on_user_id on public.members (cost=0.44..19.12 rows=1 width=168) (actual time=0.044..0.300 rows=46 loops=1)

  • Index Cond: (members.user_id = 1)
  • Filter: ((members.requested_at IS NULL) AND ((members.source_type)::text = 'Namespace'::text) AND ((members.type)::text = 'GroupMember'::text))
  • Rows Removed by Filter: 111
  • Buffers: shared hit=152