explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DZRW

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 1,140.014 ↑ 1.0 1 1

Aggregate (cost=195.24..195.25 rows=1 width=8) (actual time=1,140.014..1,140.014 rows=1 loops=1)

  • Buffers: shared hit=228 read=953
  • I/O Timings: read=1,128.857
2. 1,140.008 1,140.008 ↓ 0.0 0 1

Index Scan using index_members_on_source_id_and_source_type on public.members (cost=0.56..195.24 rows=1 width=0) (actual time=1,140.008..1,140.008 rows=0 loops=1)

  • Index Cond: ((members.source_id = 9,970) AND ((members.source_type)::text = 'Namespace'::text))
  • Filter: ((members.invite_token IS NOT NULL) AND (members.created_at >= '2020-10-16 00:00:00'::timestamp without time zone) AND (members.created_at <= '2020-10-16 23:59:59.999999'::timestamp without time zone))
  • Rows Removed by Filter: 1,276
  • Buffers: shared hit=228 read=953