explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xffy

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 8.378 ↓ 0.0 0 1

Limit (cost=7.05..7.05 rows=1 width=1,243) (actual time=8.378..8.378 rows=0 loops=1)

  • Buffers: shared hit=3 read=4
  • I/O Timings: read=8.294
2. 0.042 8.377 ↓ 0.0 0 1

Sort (cost=7.05..7.05 rows=1 width=1,243) (actual time=8.377..8.377 rows=0 loops=1)

  • Sort Key: users.id
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=3 read=4
  • I/O Timings: read=8.294
3. 0.002 8.335 ↓ 0.0 0 1

Nested Loop (cost=0.99..7.04 rows=1 width=1,243) (actual time=8.334..8.335 rows=0 loops=1)

  • Buffers: shared read=4
  • I/O Timings: read=8.294
4. 8.333 8.333 ↓ 0.0 0 1

Index Scan using index_members_on_source_id_and_source_type on public.members (cost=0.56..3.59 rows=1 width=4) (actual time=8.333..8.333 rows=0 loops=1)

  • Index Cond: ((members.source_id = 2,108,148) AND ((members.source_type)::text = 'Namespace'::text))
  • Filter: ((members.requested_at IS NULL) AND ((members.type)::text = 'GroupMember'::text) AND (members.access_level = 50))
  • Rows Removed by Filter: 0
  • Buffers: shared read=4
  • I/O Timings: read=8.294
5. 0.000 0.000 ↓ 0.0 0 0

Index Scan using users_pkey on public.users (cost=0.43..3.45 rows=1 width=1,243) (actual time=0.000..0.000 rows=0 loops=0)

  • Index Cond: (users.id = members.user_id)