explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YrC5 : eqweq

Settings
# exclusive inclusive rows x rows loops node
1. 0.009 0.096 ↓ 0.0 0 1

HashAggregate (cost=1,014.77..1,039.74 rows=2,497 width=2,443) (actual time=0.096..0.096 rows=0 loops=1)

  • Group Key: users.id, users.email, users.encrypted_password, users.reset_password_token, users.reset_password_sent_at, users.remember_created_at, users.sign_in_count, users.current_sign_in_at, users.last_sign_in_at, users.current_sign_in_ip, users.last_sign_in_ip, users.created_at, users.updated_at, users.name, users.admin, users.projects_limit, users.skype, users.linkedin, users.twitter, users.bio, users.failed_attempts, users.locked_at, users.username, users.can_create_group, users.can_create_team, users.state, users.color_scheme_id, users.password_expires_at, users.created_by_id, users.last_credential_check_at, users.avatar, users.confirmation_token, users.confirmed_at, users.confirmation_sent_at, users.unconfirmed_email, users.hide_no_ssh_key, users.website_url, users.admin_email_unsubscribed_at, users.notification_email, users.hide_no_password, users.password_automatically_set, users.location, users.encrypted_otp_secret, users.encrypted_otp_secret_iv, users.encrypted_otp_secret_salt, users.otp_required_for_login, users.otp_backup_codes, users.public_email, users.dashboard, users.project_view, users.consumed_timestep, users.layout, users.hide_project_limit, users.note, users.unlock_token, users.otp_grace_period_started_at, users.external, users.incoming_email_token, users.organization, users.auditor, users.require_two_factor_authentication_from_group, users.two_factor_grace_period, users.ghost, users.last_activity_on, users.notified_of_own_activity, users.preferred_language, users.email_opted_in, users.email_opted_in_ip, users.email_opted_in_source_id, users.email_opted_in_at, users.theme_id, users.accepted_term_id, users.feed_token, users.private_profile, users.roadmap_layout, users.include_private_contributions, users.commit_email, users.group_view, users.managing_group_id, users.bot_type, users.first_name, users.last_name, users.static_object_token, users.role
2. 0.004 0.087 ↓ 0.0 0 1

Hash Semi Join (cost=113.22..490.40 rows=2,497 width=2,443) (actual time=0.087..0.087 rows=0 loops=1)

  • Hash Cond: (members.source_id = projects.id)
3. 0.007 0.030 ↑ 2,996.0 1 1

Merge Join (cost=0.56..342.10 rows=2,996 width=2,447) (actual time=0.030..0.030 rows=1 loops=1)

  • Merge Cond: (users.id = members.user_id)
4. 0.009 0.009 ↑ 2,556.0 2 1

Index Scan using users_pkey on users (cost=0.28..290.96 rows=5,112 width=2,443) (actual time=0.008..0.009 rows=2 loops=1)

5. 0.014 0.014 ↑ 2,996.0 1 1

Index Scan using index_members_on_user_id on members (cost=0.28..114.76 rows=2,996 width=8) (actual time=0.014..0.014 rows=1 loops=1)

  • Filter: ((requested_at IS NULL) AND ((type)::text = 'ProjectMember'::text) AND ((source_type)::text = 'Project'::text))
  • Rows Removed by Filter: 12
6. 0.000 0.053 ↓ 0.0 0 1

Hash (cost=112.41..112.41 rows=20 width=8) (actual time=0.053..0.053 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
7. 0.003 0.053 ↓ 0.0 0 1

Hash Join (cost=32.00..112.41 rows=20 width=8) (actual time=0.053..0.053 rows=0 loops=1)

  • Hash Cond: ((unnest(issue_user_mentions.mentioned_projects_ids)) = projects.id)
8. 0.010 0.030 ↓ 0.0 0 1

HashAggregate (cost=29.55..69.55 rows=3,200 width=4) (actual time=0.030..0.030 rows=0 loops=1)

  • Group Key: unnest(issue_user_mentions.mentioned_projects_ids)
9. 0.004 0.020 ↓ 0.0 0 1

ProjectSet (cost=0.42..20.80 rows=3,500 width=4) (actual time=0.020..0.020 rows=0 loops=1)

10. 0.016 0.016 ↓ 1.1 40 1

Index Scan using index_issue_user_mentions_on_issue_id on issue_user_mentions (cost=0.42..3.04 rows=35 width=32) (actual time=0.008..0.016 rows=40 loops=1)

  • Index Cond: (issue_id = 3937)
11. 0.005 0.020 ↑ 1.0 20 1

Hash (cost=2.20..2.20 rows=20 width=4) (actual time=0.020..0.020 rows=20 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
12. 0.015 0.015 ↑ 1.0 20 1

Seq Scan on projects (cost=0.00..2.20 rows=20 width=4) (actual time=0.009..0.015 rows=20 loops=1)

Planning time : 2.659 ms
Execution time : 1.323 ms