explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KsE6

Settings
# exclusive inclusive rows x rows loops node
1. 7.682 2,308.032 ↑ 1.0 1 1

Index Scan using namespaces_pkey on public.namespaces (cost=0.43..38.91 rows=1 width=370) (actual time=2,308.031..2,308.032 rows=1 loops=1)

  • Index Cond: (namespaces.id = 9,970)
  • Filter: ((namespaces.type)::text = 'Group'::text)
  • Rows Removed by Filter: 0
  • Buffers: shared hit=126 read=1,358 dirtied=24
  • I/O Timings: read=2,292.666
2.          

SubPlan (for Index Scan)

3. 0.282 563.757 ↑ 1.0 1 1

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

  • Buffers: shared hit=4 read=244 dirtied=8
  • I/O Timings: read=559.906
4. 563.475 563.475 ↓ 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=7.276..563.475 rows=213 loops=1)

  • Index Cond: (projects.namespace_id = namespaces.id)
  • Filter: (NOT projects.archived)
  • Rows Removed by Filter: 27
  • Buffers: shared hit=4 read=244 dirtied=8
  • I/O Timings: read=559.906
5. 1.050 1,707.387 ↑ 1.0 1 1

Aggregate (cost=3.58..3.59 rows=1 width=8) (actual time=1,707.386..1,707.387 rows=1 loops=1)

  • Buffers: shared hit=98 read=1,097 dirtied=15
  • I/O Timings: read=1,696.136
6. 1,706.337 1,706.337 ↓ 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=14.640..1,706.337 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)
  • Rows Removed by Filter: 0
  • Buffers: shared hit=98 read=1,097 dirtied=15
  • I/O Timings: read=1,696.136
7. 0.021 29.206 ↑ 1.0 1 1

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

  • Buffers: shared hit=24 read=13 dirtied=1
  • I/O Timings: read=29.023
8. 29.185 29.185 ↓ 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=7.428..29.185 rows=43 loops=1)

  • Index Cond: (children.parent_id = namespaces.id)
  • Heap Fetches: 4
  • Buffers: shared hit=24 read=13 dirtied=1
  • I/O Timings: read=29.023