explain.depesz.com

PostgreSQL's explain analyze made readable

Result: N3IF

Settings
# exclusive inclusive rows x rows loops node
1. 0.048 3.189 ↑ 1.0 1 1

Index Scan using namespaces_pkey on public.namespaces (cost=0.43..38.91 rows=1 width=370) (actual time=3.188..3.189 rows=1 loops=1)

  • Index Cond: (namespaces.id = 9,970)
  • Filter: ((namespaces.type)::text = 'Group'::text)
  • Rows Removed by Filter: 0
  • Buffers: shared hit=1,480
2.          

SubPlan (for Index Scan)

3. 0.055 0.561 ↑ 1.0 1 1

Aggregate (cost=28.24..28.25 rows=1 width=8) (actual time=0.561..0.561 rows=1 loops=1)

  • Buffers: shared hit=244
4. 0.506 0.506 ↓ 11.8 213 1

Index Scan using index_projects_on_namespace_id_and_id on public.projects (cost=0.43..28.20 rows=18 width=0) (actual time=0.025..0.506 rows=213 loops=1)

  • Index Cond: (projects.namespace_id = namespaces.id)
  • Filter: (NOT projects.archived)
  • Rows Removed by Filter: 27
  • Buffers: shared hit=244
5. 0.220 2.517 ↑ 1.0 1 1

Aggregate (cost=3.59..3.60 rows=1 width=8) (actual time=2.517..2.517 rows=1 loops=1)

  • Buffers: shared hit=1,195
6. 2.297 2.297 ↓ 1,296.0 1,296 1

Index Scan using index_members_on_source_id_and_source_type on public.members (cost=0.56..3.58 rows=1 width=0) (actual time=0.056..2.297 rows=1,296 loops=1)

  • Index Cond: ((members.source_id = namespaces.id) AND ((members.source_type)::text = 'Namespace'::text))
  • Filter: ((members.requested_at IS NULL) AND (members.access_level > 5))
  • Rows Removed by Filter: 0
  • Buffers: shared hit=1,195
7. 0.009 0.063 ↑ 1.0 1 1

Aggregate (cost=3.60..3.60 rows=1 width=8) (actual time=0.062..0.063 rows=1 loops=1)

  • Buffers: shared hit=37
8. 0.054 0.054 ↓ 5.4 43 1

Index Only Scan using index_namespaces_on_parent_id_and_id on public.namespaces children (cost=0.43..3.58 rows=8 width=0) (actual time=0.028..0.054 rows=43 loops=1)

  • Index Cond: (children.parent_id = namespaces.id)
  • Heap Fetches: 4
  • Buffers: shared hit=37