explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uXqR

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

Index Scan using index_members_on_source_id_and_source_type on public.members (cost=0.56..339.42 rows=68 width=168) (actual time=0.061..2.425 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.type)::text = 'GroupMember'::text))
  • Rows Removed by Filter: 0
  • Buffers: shared hit=1,195