explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5aQ1

Settings
# exclusive inclusive rows x rows loops node
1. 631.489 631.489 ↓ 18.0 791,519 1

Index Scan using idx_members_created_at_user_id_invite_token on public.members (cost=0.42..11,793.79 rows=43,905 width=168) (actual time=0.026..631.489 rows=791,519 loops=1)

  • Index Cond: (members.created_at <= '2020-06-17 11:09:02.593574'::timestamp without time zone)
  • Buffers: shared hit=729,833
  • planning: 0.158 ms
  • execution: 697.633 ms