explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HkK7

Settings
# exclusive inclusive rows x rows loops node
1. 17.157 58.424 ↓ 1.4 625 1

HashAggregate (cost=9,634.08..9,638.43 rows=435 width=2,946) (actual time=57.681..58.424 rows=625 loops=1)

  • Group Key: namespaces.id, namespaces.name, namespaces.path, namespaces.owner_id, namespaces.created_at, namespaces.updated_at, namespaces.type, namespaces.description, namespaces.avatar, namespaces.membership_lock, namespaces.share_with_group_lock, namespaces.visibility_level, namespaces.request_access_enabled, namespaces.ldap_sync_status, namespaces.ldap_sync_error, namespaces.ldap_sync_last_update_at, namespaces.ldap_sync_last_successful_update_at, namespaces.ldap_sync_last_sync_at, namespaces.lfs_enabled, namespaces.description_html, namespaces.parent_id, namespaces.shared_runners_minutes_limit, namespaces.repository_size_limit, namespaces.require_two_factor_authentication, namespaces.two_factor_grace_period, namespaces.cached_markdown_version, namespaces.project_creation_level, namespaces.runners_token, namespaces.file_template_project_id, namespaces.saml_discovery_token, namespaces.runners_token_encrypted, namespaces.custom_project_templates_group_id, namespaces.auto_devops_enabled, namespaces.extra_shared_runners_minutes_limit, namespaces.last_ci_minutes_notification_at, namespaces.last_ci_minutes_usage_notification_level, namespaces.subgroup_creation_level, namespaces.emails_disabled, namespaces.max_pages_size, namespaces.max_artifacts_size, namespaces.mentions_disabled, namespaces.default_branch_protection, namespaces.unlock_membership_to_ldap, namespaces.max_personal_access_token_lifetime, namespaces.push_rule_id, namespaces.shared_runners_enabled, namespaces.allow_descendants_override_disabled_shared_runners, namespaces.traversal_ids, namespaces.delayed_project_removal
  • Buffers: shared hit=35,994
2. 0.763 41.267 ↓ 9.3 4,052 1

Append (cost=0.87..9,580.80 rows=435 width=2,946) (actual time=0.041..41.267 rows=4,052 loops=1)

  • Buffers: shared hit=35,994
3. 0.034 0.546 ↓ 46.0 46 1

Nested Loop (cost=0.87..22.58 rows=1 width=346) (actual time=0.041..0.546 rows=46 loops=1)

  • Buffers: shared hit=336
4. 0.236 0.236 ↓ 46.0 46 1

Index Scan using index_members_on_user_id on public.members (cost=0.44..19.12 rows=1 width=4) (actual time=0.027..0.236 rows=46 loops=1)

  • Index Cond: (members.user_id = 1)
  • Filter: ((members.requested_at IS NULL) AND ((members.type)::text = 'GroupMember'::text) AND ((members.source_type)::text = 'Namespace'::text))
  • Rows Removed by Filter: 111
  • Buffers: shared hit=152
5. 0.276 0.276 ↑ 1.0 1 46

Index Scan using namespaces_pkey on public.namespaces (cost=0.43..3.46 rows=1 width=346) (actual time=0.006..0.006 rows=1 loops=46)

  • Index Cond: (namespaces.id = members.source_id)
  • Filter: ((namespaces.type)::text = 'Group'::text)
  • Rows Removed by Filter: 0
  • Buffers: shared hit=184
6. 5.764 39.958 ↓ 9.2 4,006 1

Nested Loop (cost=1.44..9,551.69 rows=434 width=346) (actual time=0.139..39.958 rows=4,006 loops=1)

  • Buffers: shared hit=35,658
7. 2.562 21.732 ↓ 1.9 4,154 1

Nested Loop (cost=1.01..8,477.03 rows=2,243 width=4) (actual time=0.035..21.732 rows=4,154 loops=1)

  • Buffers: shared hit=18,993
8. 2.554 2.554 ↓ 1.9 4,154 1

Index Only Scan using index_project_authorizations_on_user_id_project_id_access_level on public.project_authorizations (cost=0.57..823.07 rows=2,243 width=4) (actual time=0.024..2.554 rows=4,154 loops=1)

  • Index Cond: (project_authorizations.user_id = 1)
  • Heap Fetches: 942
  • Buffers: shared hit=2,373
9. 16.616 16.616 ↑ 1.0 1 4,154

Index Scan using projects_pkey on public.projects (cost=0.43..3.41 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=4,154)

  • Index Cond: (projects.id = project_authorizations.project_id)
  • Buffers: shared hit=16,620
10. 12.462 12.462 ↑ 1.0 1 4,154

Index Scan using namespaces_pkey on public.namespaces namespaces_1 (cost=0.43..0.48 rows=1 width=346) (actual time=0.003..0.003 rows=1 loops=4,154)

  • Index Cond: (namespaces_1.id = projects.namespace_id)
  • Filter: ((namespaces_1.type)::text = 'Group'::text)
  • Rows Removed by Filter: 0
  • Buffers: shared hit=16,665