Skip to content

Resolve "Avoid N+1 queries on project search"

Tan Le requested to merge 215592-avoid-n-1-queries-on-project-search into master

What does this MR do?

Reduce N+1 queries on project-scope web search.

Relates to #215592 (closed)

Performance improvement

The following queries are collected on search results from 4 different projects.

Before

62 Queries 
[
    [ 0] "SELECT \"users\".* FROM \"users\" WHERE \"users\".\"id\" = 1 ORDER BY \"users\".\"id\" ASC LIMIT 1",
    [ 1] "SELECT 1 AS one FROM \"identities\" WHERE \"identities\".\"user_id\" = 1 AND (provider LIKE 'ldap%' AND extern_uid IS NOT NULL) LIMIT 1",
    [ 2] "SELECT \"user_preferences\".* FROM \"user_preferences\" WHERE \"user_preferences\".\"user_id\" = 1 LIMIT 1",
    [ 3] "SELECT \"projects\".\"id\" FROM \"projects\" INNER JOIN \"project_authorizations\" ON \"projects\".\"id\" = \"project_authorizations\".\"project_id\" WHERE \"project_authorizations\".\"user_id\" = 1",
    [ 4] "SELECT COUNT(*) FROM \"projects\" WHERE \"projects\".\"id\" IN ($1, $2, $3, $4)",
    [ 5] "SELECT \"projects\".* FROM \"projects\" WHERE \"projects\".\"id\" IN ($1, $2, $3, $4) ORDER BY \"projects\".\"id\" ASC LIMIT $5",
    [ 6] "SELECT \"routes\".* FROM \"routes\" WHERE \"routes\".\"source_type\" = $1 AND \"routes\".\"source_id\" IN ($2, $3, $4, $5)",
    [ 7] "SELECT \"namespaces\".* FROM \"namespaces\" WHERE \"namespaces\".\"id\" IN ($1, $2, $3, $4)",
    [ 8] "SELECT \"namespaces\".* FROM \"namespaces\" WHERE \"namespaces\".\"type\" = $1 AND \"namespaces\".\"id\" = $2 AND \"namespaces\".\"type\" = $3 LIMIT $4",
    [ 9] "SELECT \"namespaces\".* FROM \"namespaces\" WHERE \"namespaces\".\"type\" = $1 AND \"namespaces\".\"id\" = $2 AND \"namespaces\".\"type\" = $3 LIMIT $4",
    [10] "SELECT \"namespaces\".* FROM \"namespaces\" WHERE \"namespaces\".\"type\" = $1 AND \"namespaces\".\"id\" = $2 AND \"namespaces\".\"type\" = $3 LIMIT $4",
    [11] "SELECT \"namespaces\".* FROM \"namespaces\" WHERE \"namespaces\".\"type\" = $1 AND \"namespaces\".\"id\" = $2 AND \"namespaces\".\"type\" = $3 LIMIT $4",
    [12] "SELECT \"licenses\".* FROM \"licenses\" ORDER BY \"licenses\".\"id\" DESC LIMIT $1",
    [13] "SELECT MAX(\"project_authorizations\".\"access_level\") AS maximum_access_level, \"project_authorizations\".\"project_id\" AS project_authorizations_project_id FROM \"project_authorizations\" WHERE \"project_authorizations\".\"user_id\" = $1 AND \"project_authorizations\".\"project_id\" IN ($2, $3, $4, $5) GROUP BY \"project_authorizations\".\"project_id\"",
    [14] "SELECT \"users\".* FROM \"users\" WHERE \"users\".\"id\" = $1 LIMIT $2",
    [15] "SELECT \"features\".\"key\" FROM \"features\"",
    [16] "SELECT \"routes\".* FROM \"routes\" WHERE \"routes\".\"source_id\" = $1 AND \"routes\".\"source_type\" = $2 LIMIT $3",
    [17] "SELECT \"users\".* FROM \"users\" WHERE \"users\".\"id\" = $1 LIMIT $2",
    [18] "SELECT \"project_compliance_framework_settings\".* FROM \"project_compliance_framework_settings\" WHERE \"project_compliance_framework_settings\".\"project_id\" = $1 LIMIT $2",
    [19] "SELECT 1 AS one FROM \"geo_nodes\" LIMIT $1",
    [20] "SELECT COUNT(*) FROM \"fork_network_members\" WHERE \"fork_network_members\".\"forked_from_project_id\" = $1",
    [21] "SELECT COUNT(*) FROM \"merge_requests\" WHERE \"merge_requests\".\"target_project_id\" = $1 AND (\"merge_requests\".\"state_id\" IN (1))",
    [22] "SELECT COUNT(*) FROM \"issues\" WHERE (\"issues\".\"state_id\" IN (1)) AND \"issues\".\"confidential\" = $1 AND \"issues\".\"project_id\" = $2",
    [23] "SELECT \"users\".* FROM \"users\" WHERE \"users\".\"id\" = $1 LIMIT $2",
    [24] "SELECT \"routes\".* FROM \"routes\" WHERE \"routes\".\"source_id\" = $1 AND \"routes\".\"source_type\" = $2 LIMIT $3",
    [25] "SELECT \"users\".* FROM \"users\" WHERE \"users\".\"id\" = $1 LIMIT $2",
    [26] "SELECT \"project_compliance_framework_settings\".* FROM \"project_compliance_framework_settings\" WHERE \"project_compliance_framework_settings\".\"project_id\" = $1 LIMIT $2",
    [27] "SELECT COUNT(*) FROM \"fork_network_members\" WHERE \"fork_network_members\".\"forked_from_project_id\" = $1",
    [28] "SELECT COUNT(*) FROM \"merge_requests\" WHERE \"merge_requests\".\"target_project_id\" = $1 AND (\"merge_requests\".\"state_id\" IN (1))",
    [29] "SELECT COUNT(*) FROM \"issues\" WHERE (\"issues\".\"state_id\" IN (1)) AND \"issues\".\"confidential\" = $1 AND \"issues\".\"project_id\" = $2",
    [30] "SELECT \"users\".* FROM \"users\" WHERE \"users\".\"id\" = $1 LIMIT $2",
    [31] "SELECT \"routes\".* FROM \"routes\" WHERE \"routes\".\"source_id\" = $1 AND \"routes\".\"source_type\" = $2 LIMIT $3",
    [32] "SELECT \"users\".* FROM \"users\" WHERE \"users\".\"id\" = $1 LIMIT $2",
    [33] "SELECT \"project_compliance_framework_settings\".* FROM \"project_compliance_framework_settings\" WHERE \"project_compliance_framework_settings\".\"project_id\" = $1 LIMIT $2",
    [34] "SELECT COUNT(*) FROM \"fork_network_members\" WHERE \"fork_network_members\".\"forked_from_project_id\" = $1",
    [35] "SELECT COUNT(*) FROM \"merge_requests\" WHERE \"merge_requests\".\"target_project_id\" = $1 AND (\"merge_requests\".\"state_id\" IN (1))",
    [36] "SELECT COUNT(*) FROM \"issues\" WHERE (\"issues\".\"state_id\" IN (1)) AND \"issues\".\"confidential\" = $1 AND \"issues\".\"project_id\" = $2",
    [37] "SELECT \"users\".* FROM \"users\" WHERE \"users\".\"id\" = $1 LIMIT $2",
    [38] "SELECT \"routes\".* FROM \"routes\" WHERE \"routes\".\"source_id\" = $1 AND \"routes\".\"source_type\" = $2 LIMIT $3",
    [39] "SELECT \"users\".* FROM \"users\" WHERE \"users\".\"id\" = $1 LIMIT $2",
    [40] "SELECT \"project_compliance_framework_settings\".* FROM \"project_compliance_framework_settings\" WHERE \"project_compliance_framework_settings\".\"project_id\" = $1 LIMIT $2",
    [41] "SELECT COUNT(*) FROM \"fork_network_members\" WHERE \"fork_network_members\".\"forked_from_project_id\" = $1",
    [42] "SELECT COUNT(*) FROM \"merge_requests\" WHERE \"merge_requests\".\"target_project_id\" = $1 AND (\"merge_requests\".\"state_id\" IN (1))",
    [43] "SELECT COUNT(*) FROM \"issues\" WHERE (\"issues\".\"state_id\" IN (1)) AND \"issues\".\"confidential\" = $1 AND \"issues\".\"project_id\" = $2",
    [44] "SELECT \"appearances\".* FROM \"appearances\" ORDER BY \"appearances\".\"id\" ASC LIMIT $1",
    [45] "SELECT \"appearances\".* FROM \"appearances\" ORDER BY \"appearances\".\"id\" ASC LIMIT $1",
    [46] "SELECT \"appearances\".* FROM \"appearances\" ORDER BY \"appearances\".\"id\" ASC LIMIT $1",
    [47] "SELECT \"feature_gates\".* FROM \"feature_gates\" WHERE \"feature_gates\".\"feature_key\" = $1",
    [48] "SELECT \"appearances\".* FROM \"appearances\" ORDER BY \"appearances\".\"id\" ASC LIMIT $1",
    [49] "SELECT COUNT(*) FROM \"projects\" INNER JOIN \"namespaces\" ON \"projects\".\"namespace_id\" = \"namespaces\".\"id\" WHERE \"namespaces\".\"owner_id\" = $1 AND \"namespaces\".\"type\" IS NULL",
    [50] "SELECT 1 AS one FROM \"users\" WHERE \"users\".\"id\" = $1 LIMIT $2",
    [51] "SELECT \"users\".* FROM \"users\" WHERE \"users\".\"id\" = $1",
    [52] "SELECT COUNT(*) FROM \"issues\" INNER JOIN \"projects\" ON \"projects\".\"id\" = \"issues\".\"project_id\" LEFT JOIN project_features ON projects.id = project_features.project_id WHERE (\n      issues.confidential IS NOT TRUE\n      OR (issues.confidential = TRUE\n        AND (issues.author_id = 1\n          OR EXISTS (SELECT TRUE FROM issue_assignees WHERE user_id = 1 AND issue_id = issues.id)\n          OR EXISTS (SELECT 1 FROM \"project_authorizations\" WHERE \"project_authorizations\".\"user_id\" = 1 AND (project_authorizations.project_id = issues.project_id) AND (project_authorizations.access_level >= 20))))) AND (EXISTS (SELECT 1 FROM \"project_authorizations\" WHERE \"project_authorizations\".\"user_id\" = 1 AND (project_authorizations.project_id = projects.id) AND (project_authorizations.access_level >= 10)) OR projects.visibility_level IN (10,20)) AND (\"project_features\".\"issues_access_level\" IS NULL OR \"project_features\".\"issues_access_level\" IN (20,30) OR (\"project_features\".\"issues_access_level\" = 10 AND EXISTS (SELECT 1 FROM \"project_authorizations\" WHERE \"project_authorizations\".\"user_id\" = 1 AND (project_authorizations.project_id = projects.id) AND (project_authorizations.access_level >= 10)))) AND (\"issues\".\"state_id\" IN (1)) AND (EXISTS (SELECT true FROM \"issue_assignees\" WHERE \"issue_assignees\".\"user_id\" IN (1) AND issue_id = issues.id)) AND \"projects\".\"archived\" = $1",
    [53] "SELECT \"users\".* FROM \"users\" WHERE \"users\".\"id\" = $1 ORDER BY \"users\".\"id\" ASC LIMIT $2",
    [54] "SELECT COUNT(*) FROM \"merge_requests\" INNER JOIN \"projects\" ON \"projects\".\"id\" = \"merge_requests\".\"target_project_id\" LEFT JOIN project_features ON projects.id = project_features.project_id WHERE (EXISTS (SELECT 1 FROM \"project_authorizations\" WHERE \"project_authorizations\".\"user_id\" = 1 AND (project_authorizations.project_id = projects.id) AND (project_authorizations.access_level >= 20)) OR projects.visibility_level IN (10,20)) AND (\"project_features\".\"merge_requests_access_level\" IS NULL OR \"project_features\".\"merge_requests_access_level\" IN (20,30) OR (\"project_features\".\"merge_requests_access_level\" = 10 AND EXISTS (SELECT 1 FROM \"project_authorizations\" WHERE \"project_authorizations\".\"user_id\" = 1 AND (project_authorizations.project_id = projects.id) AND (project_authorizations.access_level >= 20)))) AND (\"merge_requests\".\"state_id\" IN (1)) AND (EXISTS (SELECT true FROM \"merge_request_assignees\" WHERE \"merge_request_assignees\".\"user_id\" IN (1) AND merge_request_id = merge_requests.id)) AND \"projects\".\"archived\" = $1",
    [55] "SELECT COUNT(*) FROM \"todos\" WHERE \"todos\".\"user_id\" = $1 AND (\"todos\".\"state\" IN ('pending'))",
    [56] "SELECT \"feature_gates\".* FROM \"feature_gates\" WHERE \"feature_gates\".\"feature_key\" = $1",
    [57] "SELECT \"user_statuses\".* FROM \"user_statuses\" WHERE \"user_statuses\".\"user_id\" = $1 LIMIT $2",
    [58] "SELECT \"feature_gates\".* FROM \"feature_gates\" WHERE \"feature_gates\".\"feature_key\" = $1",
    [59] "SELECT 1 AS one FROM \"user_callouts\" WHERE \"user_callouts\".\"user_id\" = $1 AND \"user_callouts\".\"feature_name\" = $2 LIMIT $3",
    [60] "SELECT \"broadcast_messages\".* FROM \"broadcast_messages\" WHERE (ends_at > '2020-05-26 09:47:22.679281') AND \"broadcast_messages\".\"broadcast_type\" = $1 ORDER BY \"broadcast_messages\".\"id\" ASC",
    [61] "SELECT \"broadcast_messages\".* FROM \"broadcast_messages\" WHERE (ends_at > '2020-05-26 09:47:22.683766') AND \"broadcast_messages\".\"broadcast_type\" = $1 ORDER BY \"broadcast_messages\".\"id\" ASC"
]

After

48 Queries 
[
    [ 0] "SELECT \"users\".* FROM \"users\" WHERE \"users\".\"id\" = 1 ORDER BY \"users\".\"id\" ASC LIMIT 1",
    [ 1] "SELECT 1 AS one FROM \"identities\" WHERE \"identities\".\"user_id\" = 1 AND (provider LIKE 'ldap%' AND extern_uid IS NOT NULL) LIMIT 1",
    [ 2] "SELECT \"user_preferences\".* FROM \"user_preferences\" WHERE \"user_preferences\".\"user_id\" = 1 LIMIT 1",
    [ 3] "SELECT \"projects\".\"id\" FROM \"projects\" INNER JOIN \"project_authorizations\" ON \"projects\".\"id\" = \"project_authorizations\".\"project_id\" WHERE \"project_authorizations\".\"user_id\" = 1",
    [ 4] "SELECT COUNT(*) FROM \"projects\" WHERE \"projects\".\"id\" IN ($1, $2, $3, $4)",
    [ 5] "SELECT \"projects\".* FROM \"projects\" WHERE \"projects\".\"id\" IN ($1, $2, $3, $4) ORDER BY \"projects\".\"id\" ASC LIMIT $5",
    [ 6] "SELECT \"project_features\".* FROM \"project_features\" WHERE \"project_features\".\"project_id\" IN ($1, $2, $3, $4)",
    [ 7] "SELECT \"routes\".* FROM \"routes\" WHERE \"routes\".\"source_type\" = $1 AND \"routes\".\"source_id\" IN ($2, $3, $4, $5)",
    [ 8] "SELECT \"users\".* FROM \"users\" WHERE \"users\".\"id\" IN ($1, $2, $3, $4)",
    [ 9] "SELECT \"namespaces\".* FROM \"namespaces\" WHERE \"namespaces\".\"type\" = $1 AND \"namespaces\".\"type\" = $2 AND \"namespaces\".\"id\" IN ($3, $4, $5, $6)",
    [10] "SELECT \"namespaces\".* FROM \"namespaces\" WHERE \"namespaces\".\"id\" IN ($1, $2, $3, $4)",
    [11] "SELECT \"routes\".* FROM \"routes\" WHERE \"routes\".\"source_type\" = $1 AND \"routes\".\"source_id\" IN ($2, $3, $4, $5)",
    [12] "SELECT \"users\".* FROM \"users\" WHERE \"users\".\"id\" IN ($1, $2, $3, $4)",
    [13] "SELECT \"project_compliance_framework_settings\".* FROM \"project_compliance_framework_settings\" WHERE \"project_compliance_framework_settings\".\"project_id\" IN ($1, $2, $3, $4)",
    [14] "SELECT \"licenses\".* FROM \"licenses\" ORDER BY \"licenses\".\"id\" DESC LIMIT $1",
    [15] "SELECT MAX(\"project_authorizations\".\"access_level\") AS maximum_access_level, \"project_authorizations\".\"project_id\" AS project_authorizations_project_id FROM \"project_authorizations\" WHERE \"project_authorizations\".\"user_id\" = $1 AND \"project_authorizations\".\"project_id\" IN ($2, $3, $4, $5) GROUP BY \"project_authorizations\".\"project_id\"",
    [16] "SELECT \"features\".\"key\" FROM \"features\"",
    [17] "SELECT 1 AS one FROM \"geo_nodes\" LIMIT $1",
    [18] "SELECT COUNT(*) FROM \"fork_network_members\" WHERE \"fork_network_members\".\"forked_from_project_id\" = $1",
    [19] "SELECT COUNT(*) FROM \"merge_requests\" WHERE \"merge_requests\".\"target_project_id\" = $1 AND (\"merge_requests\".\"state_id\" IN (1))",
    [20] "SELECT COUNT(*) FROM \"issues\" WHERE (\"issues\".\"state_id\" IN (1)) AND \"issues\".\"confidential\" = $1 AND \"issues\".\"project_id\" = $2",
    [21] "SELECT COUNT(*) FROM \"fork_network_members\" WHERE \"fork_network_members\".\"forked_from_project_id\" = $1",
    [22] "SELECT COUNT(*) FROM \"merge_requests\" WHERE \"merge_requests\".\"target_project_id\" = $1 AND (\"merge_requests\".\"state_id\" IN (1))",
    [23] "SELECT COUNT(*) FROM \"issues\" WHERE (\"issues\".\"state_id\" IN (1)) AND \"issues\".\"confidential\" = $1 AND \"issues\".\"project_id\" = $2",
    [24] "SELECT COUNT(*) FROM \"fork_network_members\" WHERE \"fork_network_members\".\"forked_from_project_id\" = $1",
    [25] "SELECT COUNT(*) FROM \"merge_requests\" WHERE \"merge_requests\".\"target_project_id\" = $1 AND (\"merge_requests\".\"state_id\" IN (1))",
    [26] "SELECT COUNT(*) FROM \"issues\" WHERE (\"issues\".\"state_id\" IN (1)) AND \"issues\".\"confidential\" = $1 AND \"issues\".\"project_id\" = $2",
    [27] "SELECT COUNT(*) FROM \"fork_network_members\" WHERE \"fork_network_members\".\"forked_from_project_id\" = $1",
    [28] "SELECT COUNT(*) FROM \"merge_requests\" WHERE \"merge_requests\".\"target_project_id\" = $1 AND (\"merge_requests\".\"state_id\" IN (1))",
    [29] "SELECT COUNT(*) FROM \"issues\" WHERE (\"issues\".\"state_id\" IN (1)) AND \"issues\".\"confidential\" = $1 AND \"issues\".\"project_id\" = $2",
    [30] "SELECT \"appearances\".* FROM \"appearances\" ORDER BY \"appearances\".\"id\" ASC LIMIT $1",
    [31] "SELECT \"appearances\".* FROM \"appearances\" ORDER BY \"appearances\".\"id\" ASC LIMIT $1",
    [32] "SELECT \"appearances\".* FROM \"appearances\" ORDER BY \"appearances\".\"id\" ASC LIMIT $1",
    [33] "SELECT \"feature_gates\".* FROM \"feature_gates\" WHERE \"feature_gates\".\"feature_key\" = $1",
    [34] "SELECT \"appearances\".* FROM \"appearances\" ORDER BY \"appearances\".\"id\" ASC LIMIT $1",
    [35] "SELECT COUNT(*) FROM \"projects\" INNER JOIN \"namespaces\" ON \"projects\".\"namespace_id\" = \"namespaces\".\"id\" WHERE \"namespaces\".\"owner_id\" = $1 AND \"namespaces\".\"type\" IS NULL",
    [36] "SELECT 1 AS one FROM \"users\" WHERE \"users\".\"id\" = $1 LIMIT $2",
    [37] "SELECT \"users\".* FROM \"users\" WHERE \"users\".\"id\" = $1",
    [38] "SELECT COUNT(*) FROM \"issues\" INNER JOIN \"projects\" ON \"projects\".\"id\" = \"issues\".\"project_id\" LEFT JOIN project_features ON projects.id = project_features.project_id WHERE (\n      issues.confidential IS NOT TRUE\n      OR (issues.confidential = TRUE\n        AND (issues.author_id = 1\n          OR EXISTS (SELECT TRUE FROM issue_assignees WHERE user_id = 1 AND issue_id = issues.id)\n          OR EXISTS (SELECT 1 FROM \"project_authorizations\" WHERE \"project_authorizations\".\"user_id\" = 1 AND (project_authorizations.project_id = issues.project_id) AND (project_authorizations.access_level >= 20))))) AND (EXISTS (SELECT 1 FROM \"project_authorizations\" WHERE \"project_authorizations\".\"user_id\" = 1 AND (project_authorizations.project_id = projects.id) AND (project_authorizations.access_level >= 10)) OR projects.visibility_level IN (10,20)) AND (\"project_features\".\"issues_access_level\" IS NULL OR \"project_features\".\"issues_access_level\" IN (20,30) OR (\"project_features\".\"issues_access_level\" = 10 AND EXISTS (SELECT 1 FROM \"project_authorizations\" WHERE \"project_authorizations\".\"user_id\" = 1 AND (project_authorizations.project_id = projects.id) AND (project_authorizations.access_level >= 10)))) AND (\"issues\".\"state_id\" IN (1)) AND (EXISTS (SELECT true FROM \"issue_assignees\" WHERE \"issue_assignees\".\"user_id\" IN (1) AND issue_id = issues.id)) AND \"projects\".\"archived\" = $1",
    [39] "SELECT \"users\".* FROM \"users\" WHERE \"users\".\"id\" = $1 ORDER BY \"users\".\"id\" ASC LIMIT $2",
    [40] "SELECT COUNT(*) FROM \"merge_requests\" INNER JOIN \"projects\" ON \"projects\".\"id\" = \"merge_requests\".\"target_project_id\" LEFT JOIN project_features ON projects.id = project_features.project_id WHERE (EXISTS (SELECT 1 FROM \"project_authorizations\" WHERE \"project_authorizations\".\"user_id\" = 1 AND (project_authorizations.project_id = projects.id) AND (project_authorizations.access_level >= 20)) OR projects.visibility_level IN (10,20)) AND (\"project_features\".\"merge_requests_access_level\" IS NULL OR \"project_features\".\"merge_requests_access_level\" IN (20,30) OR (\"project_features\".\"merge_requests_access_level\" = 10 AND EXISTS (SELECT 1 FROM \"project_authorizations\" WHERE \"project_authorizations\".\"user_id\" = 1 AND (project_authorizations.project_id = projects.id) AND (project_authorizations.access_level >= 20)))) AND (\"merge_requests\".\"state_id\" IN (1)) AND (EXISTS (SELECT true FROM \"merge_request_assignees\" WHERE \"merge_request_assignees\".\"user_id\" IN (1) AND merge_request_id = merge_requests.id)) AND \"projects\".\"archived\" = $1",
    [41] "SELECT COUNT(*) FROM \"todos\" WHERE \"todos\".\"user_id\" = $1 AND (\"todos\".\"state\" IN ('pending'))",
    [42] "SELECT \"feature_gates\".* FROM \"feature_gates\" WHERE \"feature_gates\".\"feature_key\" = $1",
    [43] "SELECT \"user_statuses\".* FROM \"user_statuses\" WHERE \"user_statuses\".\"user_id\" = $1 LIMIT $2",
    [44] "SELECT \"feature_gates\".* FROM \"feature_gates\" WHERE \"feature_gates\".\"feature_key\" = $1",
    [45] "SELECT 1 AS one FROM \"user_callouts\" WHERE \"user_callouts\".\"user_id\" = $1 AND \"user_callouts\".\"feature_name\" = $2 LIMIT $3",
    [46] "SELECT \"broadcast_messages\".* FROM \"broadcast_messages\" WHERE (ends_at > '2020-05-26 09:52:13.029418') AND \"broadcast_messages\".\"broadcast_type\" = $1 ORDER BY \"broadcast_messages\".\"id\" ASC",
    [47] "SELECT \"broadcast_messages\".* FROM \"broadcast_messages\" WHERE (ends_at > '2020-05-26 09:52:13.033115') AND \"broadcast_messages\".\"broadcast_type\" = $1 ORDER BY \"broadcast_messages\".\"id\" ASC"
]

Conformity

Availability and Testing

Security

If this MR contains changes to processing or storing of credentials or tokens, authorization and authentication methods and other items described in the security review guidelines:

  • [-] Label as security and @ mention @gitlab-com/gl-security/appsec
  • [-] The MR includes necessary changes to maintain consistency between UI, API, email, or other methods
  • [-] Security reports checked/validated by a reviewer from the AppSec team
Edited by Yorick Peterse

Merge request reports