explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9jan

Settings
# exclusive inclusive rows x rows loops node
1. 0.053 848.925 ↓ 17.4 87 1

Subquery Scan on members (cost=25.96..26.05 rows=5 width=168) (actual time=848.815..848.925 rows=87 loops=1)

  • Buffers: shared hit=423 read=421 dirtied=8
  • I/O Timings: read=815.599
2. 0.049 848.872 ↓ 17.4 87 1

Unique (cost=25.96..26.00 rows=5 width=172) (actual time=848.811..848.872 rows=87 loops=1)

  • Buffers: shared hit=423 read=421 dirtied=8
  • I/O Timings: read=815.599
3. 0.528 848.823 ↓ 17.4 87 1

Sort (cost=25.96..25.97 rows=5 width=172) (actual time=848.810..848.823 rows=87 loops=1)

  • Sort Key: members_1.user_id, members_1.invite_email, (CASE WHEN ((members_1.type)::text = 'ProjectMember'::text) THEN 278964 WHEN ((members_1.type)::text = 'GroupMember'::text) THEN 2 ELSE 3 END)
  • Sort Method: quicksort Memory: 37kB
  • Buffers: shared hit=423 read=421 dirtied=8
  • I/O Timings: read=815.599
4. 0.669 848.295 ↓ 17.4 87 1

Nested Loop Left Join (cost=1.56..25.90 rows=5 width=172) (actual time=23.329..848.295 rows=87 loops=1)

  • Buffers: shared hit=417 read=421 dirtied=8
  • I/O Timings: read=815.599
5. 0.702 423.936 ↓ 17.4 87 1

Nested Loop Left Join (cost=0.99..21.55 rows=5 width=172) (actual time=13.994..423.936 rows=87 loops=1)

  • Buffers: shared hit=229 read=207 dirtied=6
  • I/O Timings: read=395.996
6. 0.079 206.343 ↓ 17.4 87 1

Append (cost=0.56..10.30 rows=5 width=168) (actual time=11.436..206.343 rows=87 loops=1)

  • Buffers: shared hit=4 read=84 dirtied=5
  • I/O Timings: read=185.827
7. 2.979 2.979 ↓ 0.0 0 1

Index Scan using index_members_on_source_id_and_source_type on public.members members_1 (cost=0.56..3.58 rows=1 width=168) (actual time=2.979..2.979 rows=0 loops=1)

  • Index Cond: ((members_1.source_id = 22) AND ((members_1.source_type)::text = 'Namespace'::text))
  • Filter: ((members_1.requested_at IS NULL) AND (members_1.invite_token IS NULL) AND ((members_1.type)::text = 'GroupMember'::text))
  • Rows Removed by Filter: 0
  • Buffers: shared hit=3 read=1
  • I/O Timings: read=2.819
8. 203.285 203.285 ↓ 21.8 87 1

Index Scan using index_non_requested_project_members_on_source_id_and_type on public.members members_2 (cost=0.56..6.64 rows=4 width=168) (actual time=8.455..203.285 rows=87 loops=1)

  • Index Cond: ((members_2.source_id = 278,964) AND ((members_2.source_type)::text = 'Project'::text))
  • Buffers: shared hit=1 read=83 dirtied=5
  • I/O Timings: read=183.008
9. 216.891 216.891 ↑ 1.0 1 87

Index Only Scan using users_pkey on public.users (cost=0.43..2.25 rows=1 width=4) (actual time=2.493..2.493 rows=1 loops=87)

  • Index Cond: (users.id = members_1.user_id)
  • Heap Fetches: 17
  • Buffers: shared hit=225 read=123 dirtied=1
  • I/O Timings: read=210.169
10. 423.690 423.690 ↑ 1.0 1 87

Index Only Scan using index_project_authorizations_on_user_id_project_id_access_level on public.project_authorizations (cost=0.57..0.86 rows=1 width=8) (actual time=4.857..4.870 rows=1 loops=87)

  • Index Cond: ((project_authorizations.user_id = users.id) AND (project_authorizations.project_id = 278,964))
  • Heap Fetches: 11
  • Buffers: shared hit=188 read=214 dirtied=2
  • I/O Timings: read=419.603