explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZuXo

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

Index Scan using index_members_on_source_id_and_source_type on public.members (cost=0.56..340.44 rows=68 width=168) (actual time=7.753..1,794.121 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=99 read=1,098 dirtied=38
  • I/O Timings: read=1,770.450