explain.depesz.com

PostgreSQL's explain analyze made readable

Result: f9Hb

Settings
# exclusive inclusive rows x rows loops node
1. 4.723 4.723 ↓ 19.1 1,296 1

Index Scan using index_members_on_source_id_and_source_type on public.members (cost=0.56..341.25 rows=68 width=168) (actual time=0.045..4.723 rows=1,296 loops=1)

  • Index Cond: ((members.source_id = 9,970) AND ((members.source_type)::text = 'Namespace'::text))
  • Filter: ((members.requested_at IS NULL) AND (members.access_level <> 5) AND ((members.type)::text = 'GroupMember'::text))
  • Rows Removed by Filter: 0
  • Buffers: shared hit=1,195