explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XQhT

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

Index Scan using index_members_on_user_id on public.members (cost=0.44..19.17 rows=1 width=168) (actual time=4.424..235.656 rows=46 loops=1)

  • Index Cond: (members.user_id = 1)
  • Filter: ((members.requested_at IS NULL) AND (members.access_level >= 10) AND ((members.source_type)::text = 'Namespace'::text) AND ((members.type)::text = 'GroupMember'::text))
  • Rows Removed by Filter: 111
  • Buffers: shared hit=5 read=147 dirtied=1
  • I/O Timings: read=232.467