Draft: Reduce number of queries from Project.pipelines query
What does this MR do and why?
Describe in detail what your merge request does and why.
1) getting pipeline information nested in a project performance when preloading keeps the queries under the threshold
Failure/Error:
expect do
post_graphql(query, current_user: current_user)
end.not_to exceed_query_limit(control)
Expected a maximum of 76 queries, got 130:
Query Diff:
-----------
SELECT "personal_access_tokens".* FROM "personal_access_tokens"...
-- (expected: 2, got: 0)
WHERE "personal_access_tokens"."token_digest" = 'zLPAZLaSwJNuLPOwXLalHhjBhMCBfJqQHAIShMZ3XLo=' LIMIT 1
-- (expected: 0, got: 2)
WHERE "personal_access_tokens"."token_digest" = 'tAQdSG0y5Xx9ik+e0r70UAHm080lE/GDzlj5YtEDk3I=' LIMIT 1
INSERT INTO "personal_access_tokens" ("user_id", "name", "expires_at", "created_at", "updated_at", "scopes", "token_digest")...
-- (expected: 1, got: 0)
VALUES (2, 'PAT 8', '2021-11-16', '2021-11-11 12:03:56.181926', '2021-11-11 12:03:56.181926', '---
- api
', 'zLPAZLaSwJNuLPOwXLalHhjBhMCBfJqQHAIShMZ3XLo=') RETURNING "id"
-- (expected: 0, got: 1)
VALUES (2, 'PAT 9', '2021-11-16', '2021-11-11 12:03:56.891300', '2021-11-11 12:03:56.891300', '---
- api
', 'tAQdSG0y5Xx9ik+e0r70UAHm080lE/GDzlj5YtEDk3I=') RETURNING "id"
UPDATE "personal_access_tokens"...
-- (expected: 1, got: 0)
SET "last_used_at" = '2021-11-11 12:03:56.530463' WHERE "personal_access_tokens"."id" = 8
-- (expected: 0, got: 1)
SET "last_used_at" = '2021-11-11 12:03:57.213494' WHERE "personal_access_tokens"."id" = 9
SELECT "users".* FROM "users"...
-- (expected: 1, got: 0)
WHERE "users"."id" = 0
-- (expected: 0, got: 1)
WHERE "users"."id" IN (0, 2)
SELECT "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"."description_html", "namespaces"."lfs_enabled", "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" FROM "namespaces"...
-- (expected: 0, got: 1)
WHERE "namespaces"."id" = 3 LIMIT 1
-- (expected: 0, got: 1)
WHERE "namespaces"."id" = 4 LIMIT 1
-- (expected: 0, got: 1)
WHERE "namespaces"."owner_id" = 2 AND ("namespaces"."type" = 'User' OR "namespaces"."type" IS NULL) LIMIT 1
SELECT "ci_pipelines".* FROM "ci_pipelines"...
-- (expected: 1, got: 0)
WHERE "ci_pipelines"."project_id" = 1 AND "ci_pipelines"."iid" = 1 ORDER BY "ci_pipelines"."id" DESC
-- (expected: 0, got: 1)
WHERE "ci_pipelines"."project_id" = 1 AND "ci_pipelines"."iid" IN (1, 2, 3) ORDER BY "ci_pipelines"."id" DESC
-- (expected: 0, got: 1)
INNER JOIN "ci_sources_pipelines" ON "ci_pipelines"."id" = "ci_sources_pipelines"."pipeline_id" WHERE "ci_sources_pipelines"."source_pipeline_id" = 3 ORDER BY "ci_pipelines"."id" DESC LIMIT 100
-- (expected: 0, got: 1)
INNER JOIN "ci_sources_pipelines" ON "ci_pipelines"."id" = "ci_sources_pipelines"."source_pipeline_id" WHERE "ci_sources_pipelines"."pipeline_id" = 3 LIMIT 1
-- (expected: 0, got: 1)
INNER JOIN "ci_sources_pipelines" ON "ci_pipelines"."id" = "ci_sources_pipelines"."pipeline_id" WHERE "ci_sources_pipelines"."source_pipeline_id" = 5 ORDER BY "ci_pipelines"."id" DESC LIMIT 100
-- (expected: 0, got: 1)
INNER JOIN "ci_sources_pipelines" ON "ci_pipelines"."id" = "ci_sources_pipelines"."source_pipeline_id" WHERE "ci_sources_pipelines"."pipeline_id" = 5 LIMIT 1
SELECT "routes".* FROM "routes"...
-- (expected: 0, got: 1)
WHERE "routes"."source_id" = 3 AND "routes"."source_type" = 'Namespace' LIMIT 1
-- (expected: 0, got: 1)
WHERE "routes"."source_id" = 4 AND "routes"."source_type" = 'Namespace' LIMIT 1
-- (expected: 0, got: 1)
WHERE "routes"."source_id" = 2 AND "routes"."source_type" = 'Namespace' LIMIT 1
SELECT 1 AS one FROM "ci_stages"...
-- (expected: 0, got: 1)
WHERE "ci_stages"."pipeline_id" = 3 LIMIT 1 OFFSET 100
-- (expected: 0, got: 1)
WHERE "ci_stages"."pipeline_id" = 5 LIMIT 1 OFFSET 100
SELECT "ci_stages".* FROM "ci_stages"...
-- (expected: 0, got: 1)
WHERE "ci_stages"."pipeline_id" = 3 ORDER BY "ci_stages"."position" ASC, "ci_stages"."id" DESC LIMIT 100
-- (expected: 0, got: 1)
WHERE "ci_stages"."pipeline_id" = 5 ORDER BY "ci_stages"."position" ASC, "ci_stages"."id" DESC LIMIT 100
SELECT 1 AS one FROM "ci_builds"...
-- (expected: 0, got: 1)
WHERE "ci_builds"."commit_id" = 3 LIMIT 1 OFFSET 100
-- (expected: 0, got: 1)
WHERE "ci_builds"."commit_id" = 5 LIMIT 1 OFFSET 100
SELECT "ci_builds".* FROM "ci_builds"...
-- (expected: 0, got: 1)
WHERE "ci_builds"."commit_id" = 3 ORDER BY "ci_builds"."id" DESC LIMIT 100
-- (expected: 0, got: 1)
INNER JOIN "ci_sources_pipelines" ON "ci_builds"."id" = "ci_sources_pipelines"."source_job_id" WHERE "ci_sources_pipelines"."pipeline_id" = 3 LIMIT 1
-- (expected: 0, got: 1)
WHERE "ci_builds"."commit_id" = 5 ORDER BY "ci_builds"."id" DESC LIMIT 100
-- (expected: 0, got: 1)
INNER JOIN "ci_sources_pipelines" ON "ci_builds"."id" = "ci_sources_pipelines"."source_job_id" WHERE "ci_sources_pipelines"."pipeline_id" = 5 LIMIT 1
SELECT COUNT(*) FROM "ci_builds"...
-- (expected: 0, got: 1)
WHERE "ci_builds"."commit_id" = 3
-- (expected: 0, got: 1)
WHERE "ci_builds"."commit_id" = 5
SELECT "projects"."id", "projects"."name", "projects"."path", "projects"."description", "projects"."created_at", "projects"."updated_at", "projects"."creator_id", "projects"."namespace_id", "projects"."last_activity_at", "projects"."import_url", "projects"."visibility_level", "projects"."archived", "projects"."avatar", "projects"."merge_requests_template", "projects"."star_count", "projects"."merge_requests_rebase_enabled", "projects"."import_type", "projects"."import_source", "projects"."approvals_before_merge", "projects"."reset_approvals_on_push", "projects"."merge_requests_ff_only_enabled", "projects"."issues_template", "projects"."mirror", "projects"."mirror_user_id", "projects"."shared_runners_enabled", "projects"."runners_token", "projects"."build_coverage_regex", "projects"."build_allow_git_fetch", "projects"."build_timeout", "projects"."mirror_trigger_builds", "projects"."pending_delete", "projects"."public_builds", "projects"."last_repository_check_failed", "projects"."last_repository_check_at", "projects"."only_allow_merge_if_pipeline_succeeds", "projects"."has_external_issue_tracker", "projects"."repository_storage", "projects"."repository_read_only", "projects"."request_access_enabled", "projects"."has_external_wiki", "projects"."ci_config_path", "projects"."lfs_enabled", "projects"."description_html", "projects"."only_allow_merge_if_all_discussions_are_resolved", "projects"."repository_size_limit", "projects"."printing_merge_request_link_enabled", "projects"."auto_cancel_pending_pipelines", "projects"."service_desk_enabled", "projects"."cached_markdown_version", "projects"."delete_error", "projects"."last_repository_updated_at", "projects"."disable_overriding_approvers_per_merge_request", "projects"."storage_version", "projects"."resolve_outdated_diff_discussions", "projects"."remote_mirror_available_overridden", "projects"."only_mirror_protected_branches", "projects"."pull_mirror_available_overridden", "projects"."jobs_cache_index", "projects"."external_authorization_classification_label", "projects"."mirror_overwrites_diverged_branches", "projects"."pages_https_only", "projects"."external_webhook_token", "projects"."packages_enabled", "projects"."merge_requests_author_approval", "projects"."pool_repository_id", "projects"."runners_token_encrypted", "projects"."bfg_object_map", "projects"."detected_repository_languages", "projects"."merge_requests_disable_committers_approval", "projects"."require_password_to_approve", "projects"."emails_disabled", "projects"."max_pages_size", "projects"."max_artifacts_size", "projects"."remove_source_branch_after_merge", "projects"."marked_for_deletion_at", "projects"."marked_for_deletion_by_user_id", "projects"."autoclose_referenced_issues", "projects"."suggestion_commit_message", "projects"."project_namespace_id" FROM "projects"...
-- (expected: 0, got: 1)
WHERE "projects"."id" = 2 LIMIT 1
-- (expected: 0, got: 1)
WHERE "projects"."id" = 3 LIMIT 1
SELECT "tags".* FROM "tags"...
-- (expected: 0, got: 1)
INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 4 AND "taggings"."taggable_type" = 'CommitStatus' AND "taggings"."context" = 'tags'
-- (expected: 0, got: 1)
INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 5 AND "taggings"."taggable_type" = 'CommitStatus' AND "taggings"."context" = 'tags'
SELECT "ci_runners".* FROM ((SELECT "ci_runners".* FROM "ci_runners" INNER JOIN "ci_runner_projects" ON "ci_runners"."id" = "ci_runner_projects"."runner_id" WHERE "ci_runner_projects"."project_id" = 1)
UNION
(SELECT "ci_runners".* FROM "ci_runners" INNER JOIN "ci_runner_namespaces" ON "ci_runner_namespaces"."runner_id" = "ci_runners"."id" INNER JOIN "namespaces" ON "namespaces"."id" = "ci_runner_namespaces"."namespace_id" AND "namespaces"."type" = 'Group' WHERE "namespaces"."id" IN (WITH RECURSIVE "base_and_ancestors" AS ((SELECT "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"."description_html", "namespaces"."lfs_enabled", "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" FROM "namespaces" INNER JOIN "projects" ON "projects"."namespace_id" = "namespaces"."id" WHERE "namespaces"."type" = 'Group' AND "projects"."id" = 1)
UNION
(SELECT "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"."description_html", "namespaces"."lfs_enabled", "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" FROM "namespaces", "base_and_ancestors" WHERE "namespaces"."type" = 'Group' AND "namespaces"."id" = "base_and_ancestors"."parent_id")) SELECT "namespaces"."id" FROM "base_and_ancestors" AS "namespaces"))
UNION
(SELECT "ci_runners".* FROM "ci_runners"...
-- (expected: 1, got: 0)
WHERE "ci_runners"."runner_type" = 1)) ci_runners WHERE "ci_runners"."active" = TRUE AND (contacted_at > '2021-11-11 10:03:56.672821')
-- (expected: 0, got: 1)
WHERE "ci_runners"."runner_type" = 1)) ci_runners WHERE "ci_runners"."active" = TRUE AND (contacted_at > '2021-11-11 10:03:57.560775')
SELECT 1 AS one FROM "ci_pipelines"...
-- (expected: 0, got: 1)
INNER JOIN "ci_sources_pipelines" ON "ci_pipelines"."id" = "ci_sources_pipelines"."pipeline_id" WHERE "ci_sources_pipelines"."source_pipeline_id" = 3 LIMIT 1 OFFSET 100
-- (expected: 0, got: 1)
INNER JOIN "ci_sources_pipelines" ON "ci_pipelines"."id" = "ci_sources_pipelines"."pipeline_id" WHERE "ci_sources_pipelines"."source_pipeline_id" = 5 LIMIT 1 OFFSET 100
SELECT COUNT(*) FROM "ci_pipelines"...
-- (expected: 0, got: 1)
INNER JOIN "ci_sources_pipelines" ON "ci_pipelines"."id" = "ci_sources_pipelines"."pipeline_id" WHERE "ci_sources_pipelines"."source_pipeline_id" = 3
-- (expected: 0, got: 1)
INNER JOIN "ci_sources_pipelines" ON "ci_pipelines"."id" = "ci_sources_pipelines"."pipeline_id" WHERE "ci_sources_pipelines"."source_pipeline_id" = 5
SELECT "ci_build_report_results".* FROM "ci_build_report_results"...
-- (expected: 0, got: 1)
INNER JOIN "ci_builds" ON "ci_build_report_results"."build_id" = "ci_builds"."id" WHERE "ci_builds"."type" = 'Ci::Build' AND "ci_builds"."commit_id" = 3 AND ("ci_builds"."retried" = FALSE OR "ci_builds"."retried" IS NULL)
-- (expected: 0, got: 1)
INNER JOIN "ci_builds" ON "ci_build_report_results"."build_id" = "ci_builds"."id" WHERE "ci_builds"."type" = 'Ci::Build' AND "ci_builds"."commit_id" = 5 AND ("ci_builds"."retried" = FALSE OR "ci_builds"."retried" IS NULL)
SELECT "security_scans".* FROM "security_scans"...
-- (expected: 0, got: 1)
WHERE "security_scans"."pipeline_id" = 3 AND "security_scans"."scan_type" IN (1, 2, 3, 4, 5, 6, 7, 8)
-- (expected: 0, got: 1)
WHERE "security_scans"."pipeline_id" = 5 AND "security_scans"."scan_type" IN (1, 2, 3, 4, 5, 6, 7, 8)
SELECT "dast_profiles_pipelines"."dast_profile_id" FROM "dast_profiles_pipelines"...
-- (expected: 0, got: 1)
WHERE "dast_profiles_pipelines"."ci_pipeline_id" = 3
-- (expected: 0, got: 1)
WHERE "dast_profiles_pipelines"."ci_pipeline_id" = 5
SELECT "ci_builds"."status", "ci_builds"."finished_at", "ci_builds"."trace", "ci_builds"."created_at", "ci_builds"."updated_at", "ci_builds"."started_at", "ci_builds"."runner_id", "ci_builds"."coverage", "ci_builds"."commit_id", "ci_builds"."name", "ci_builds"."options", "ci_builds"."allow_failure", "ci_builds"."stage", "ci_builds"."trigger_request_id", "ci_builds"."stage_idx", "ci_builds"."tag", "ci_builds"."ref", "ci_builds"."user_id", "ci_builds"."type", "ci_builds"."target_url", "ci_builds"."description", "ci_builds"."project_id", "ci_builds"."erased_by_id", "ci_builds"."erased_at", "ci_builds"."artifacts_expire_at", "ci_builds"."environment", "ci_builds"."when", "ci_builds"."yaml_variables", "ci_builds"."queued_at", "ci_builds"."token", "ci_builds"."lock_version", "ci_builds"."coverage_regex", "ci_builds"."auto_canceled_by_id", "ci_builds"."retried", "ci_builds"."protected", "ci_builds"."failure_reason", "ci_builds"."scheduled_at", "ci_builds"."token_encrypted", "ci_builds"."upstream_pipeline_id", "ci_builds"."resource_group_id", "ci_builds"."waiting_for_resource_at", "ci_builds"."processed", "ci_builds"."scheduling_type", "ci_builds"."id", "ci_builds"."stage_id" FROM "ci_builds" WHERE "ci_builds"."type" = 'Ci::Build' AND "ci_builds"."commit_id" = 3 AND ("ci_builds"."retried" = FALSE OR "ci_builds"."retried" IS NULL) AND (EXISTS (SELECT 1 FROM "ci_job_artifacts"...
-- (expected: 0, got: 1)
WHERE (ci_builds.id = ci_job_artifacts.job_id) AND "ci_job_artifacts"."file_type" IN (5, 6, 7, 8, 21, 23, 26, 27)))
-- (expected: 0, got: 1)
WHERE (ci_builds.id = ci_job_artifacts.job_id) AND "ci_job_artifacts"."file_type" = 9))
SELECT "ci_builds"."status", "ci_builds"."finished_at", "ci_builds"."trace", "ci_builds"."created_at", "ci_builds"."updated_at", "ci_builds"."started_at", "ci_builds"."runner_id", "ci_builds"."coverage", "ci_builds"."commit_id", "ci_builds"."name", "ci_builds"."options", "ci_builds"."allow_failure", "ci_builds"."stage", "ci_builds"."trigger_request_id", "ci_builds"."stage_idx", "ci_builds"."tag", "ci_builds"."ref", "ci_builds"."user_id", "ci_builds"."type", "ci_builds"."target_url", "ci_builds"."description", "ci_builds"."project_id", "ci_builds"."erased_by_id", "ci_builds"."erased_at", "ci_builds"."artifacts_expire_at", "ci_builds"."environment", "ci_builds"."when", "ci_builds"."yaml_variables", "ci_builds"."queued_at", "ci_builds"."token", "ci_builds"."lock_version", "ci_builds"."coverage_regex", "ci_builds"."auto_canceled_by_id", "ci_builds"."retried", "ci_builds"."protected", "ci_builds"."failure_reason", "ci_builds"."scheduled_at", "ci_builds"."token_encrypted", "ci_builds"."upstream_pipeline_id", "ci_builds"."resource_group_id", "ci_builds"."waiting_for_resource_at", "ci_builds"."processed", "ci_builds"."scheduling_type", "ci_builds"."id", "ci_builds"."stage_id" FROM "ci_builds" WHERE "ci_builds"."type" = 'Ci::Build' AND "ci_builds"."commit_id" = 5 AND ("ci_builds"."retried" = FALSE OR "ci_builds"."retried" IS NULL) AND (EXISTS (SELECT 1 FROM "ci_job_artifacts"...
-- (expected: 0, got: 1)
WHERE (ci_builds.id = ci_job_artifacts.job_id) AND "ci_job_artifacts"."file_type" IN (5, 6, 7, 8, 21, 23, 26, 27)))
-- (expected: 0, got: 1)
WHERE (ci_builds.id = ci_job_artifacts.job_id) AND "ci_job_artifacts"."file_type" = 9))
SELECT "namespace_limits".* FROM "namespace_limits"...
-- (expected: 0, got: 1)
WHERE "namespace_limits"."namespace_id" = 2 LIMIT 1
SELECT SUM((("project_statistics"."repository_size" + "project_statistics"."lfs_objects_size") - "projects"."repository_size_limit")) FROM "projects"...
-- (expected: 0, got: 1)
INNER JOIN "project_statistics" ON "project_statistics"."project_id" = "projects"."id" WHERE "projects"."namespace_id" = 2 AND "projects"."repository_size_limit" != 0 AND ("project_statistics"."repository_size" + "project_statistics"."lfs_objects_size") > "projects"."repository_size_limit"
SELECT SUM(("project_statistics"."repository_size" + "project_statistics"."lfs_objects_size")) FROM "projects"...
-- (expected: 0, got: 1)
INNER JOIN "project_statistics" ON "project_statistics"."project_id" = "projects"."id" WHERE "projects"."namespace_id" = 2
SELECT COUNT(*) FROM "projects"...
-- (expected: 0, got: 1)
INNER JOIN "project_statistics" ON "project_statistics"."project_id" = "projects"."id" WHERE "projects"."namespace_id" = 2 AND "projects"."repository_size_limit" != 0 AND ("project_statistics"."repository_size" + "project_statistics"."lfs_objects_size") > "projects"."repository_size_limit"
SELECT "gitlab_subscriptions".* FROM "gitlab_subscriptions"...
-- (expected: 0, got: 1)
WHERE "gitlab_subscriptions"."namespace_id" = 2 LIMIT 1
SELECT "plans".* FROM "plans"...
-- (expected: 0, got: 1)
WHERE "plans"."name" = 'default' LIMIT 1
SELECT "plan_limits"."id", "plan_limits"."plan_id", "plan_limits"."ci_active_pipelines", "plan_limits"."ci_pipeline_size", "plan_limits"."ci_active_jobs", "plan_limits"."project_hooks", "plan_limits"."group_hooks", "plan_limits"."ci_project_subscriptions", "plan_limits"."ci_pipeline_schedules", "plan_limits"."offset_pagination_limit", "plan_limits"."ci_instance_level_variables", "plan_limits"."storage_size_limit", "plan_limits"."ci_max_artifact_size_lsif", "plan_limits"."ci_max_artifact_size_archive", "plan_limits"."ci_max_artifact_size_metadata", "plan_limits"."ci_max_artifact_size_trace", "plan_limits"."ci_max_artifact_size_junit", "plan_limits"."ci_max_artifact_size_sast", "plan_limits"."ci_max_artifact_size_dependency_scanning", "plan_limits"."ci_max_artifact_size_container_scanning", "plan_limits"."ci_max_artifact_size_dast", "plan_limits"."ci_max_artifact_size_codequality", "plan_limits"."ci_max_artifact_size_license_management", "plan_limits"."ci_max_artifact_size_license_scanning", "plan_limits"."ci_max_artifact_size_performance", "plan_limits"."ci_max_artifact_size_metrics", "plan_limits"."ci_max_artifact_size_metrics_referee", "plan_limits"."ci_max_artifact_size_network_referee", "plan_limits"."ci_max_artifact_size_dotenv", "plan_limits"."ci_max_artifact_size_cobertura", "plan_limits"."ci_max_artifact_size_terraform", "plan_limits"."ci_max_artifact_size_accessibility", "plan_limits"."ci_max_artifact_size_cluster_applications", "plan_limits"."ci_max_artifact_size_secret_detection", "plan_limits"."ci_max_artifact_size_requirements", "plan_limits"."ci_max_artifact_size_coverage_fuzzing", "plan_limits"."ci_max_artifact_size_browser_performance", "plan_limits"."ci_max_artifact_size_load_performance", "plan_limits"."ci_needs_size_limit", "plan_limits"."conan_max_file_size", "plan_limits"."maven_max_file_size", "plan_limits"."npm_max_file_size", "plan_limits"."nuget_max_file_size", "plan_limits"."pypi_max_file_size", "plan_limits"."generic_packages_max_file_size", "plan_limits"."golang_max_file_size", "plan_limits"."debian_max_file_size", "plan_limits"."project_feature_flags", "plan_limits"."ci_max_artifact_size_api_fuzzing", "plan_limits"."ci_pipeline_deployments", "plan_limits"."pull_mirror_interval_seconds", "plan_limits"."daily_invites", "plan_limits"."rubygems_max_file_size", "plan_limits"."terraform_module_max_file_size", "plan_limits"."helm_max_file_size", "plan_limits"."ci_registered_group_runners", "plan_limits"."ci_registered_project_runners", "plan_limits"."web_hook_calls", "plan_limits"."ci_daily_pipeline_schedule_triggers", "plan_limits"."ci_max_artifact_size_cluster_image_scanning", "plan_limits"."ci_jobs_trace_size_limit", "plan_limits"."pages_file_entries", "plan_limits"."dast_profile_schedules", "plan_limits"."external_audit_event_destinations" FROM "plan_limits"...
-- (expected: 0, got: 1)
WHERE "plan_limits"."plan_id" = 1 LIMIT 1
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" = 2 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"...
-- (expected: 0, got: 1)
WHERE "project_authorizations"."user_id" = 2 AND (project_authorizations.project_id = projects.id) AND (project_authorizations.access_level >= 20)))) AND "merge_requests"."author_id" = 2
SELECT EXTRACT(epoch FROM SUM(AGE(merge_request_metrics.merged_at, merge_request_metrics.created_at))) FROM "merge_requests" INNER JOIN "projects" ON "projects"."id" = "merge_requests"."target_project_id" INNER JOIN "merge_request_metrics" ON "merge_request_metrics"."merge_request_id" = "merge_requests"."id" LEFT JOIN project_features ON projects.id = project_features.project_id WHERE (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 2 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"...
-- (expected: 0, got: 1)
WHERE "project_authorizations"."user_id" = 2 AND (project_authorizations.project_id = projects.id) AND (project_authorizations.access_level >= 20)))) AND "merge_requests"."author_id" = 2 AND "merge_requests"."target_project_id" = "merge_request_metrics"."target_project_id" AND "merge_request_metrics"."merged_at" > "merge_request_metrics"."created_at"
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" = 2 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" = 2 AND (project_authorizations.project_id = projects.id) AND (project_authorizations.access_level >= 20)))) AND EXISTS (SELECT "merge_request_assignees".* FROM "merge_request_assignees"...
-- (expected: 0, got: 1)
WHERE "merge_request_assignees"."user_id" = 2 AND (merge_request_id = merge_requests.id))
SELECT EXTRACT(epoch FROM SUM(AGE(merge_request_metrics.merged_at, merge_request_metrics.created_at))) FROM "merge_requests" INNER JOIN "projects" ON "projects"."id" = "merge_requests"."target_project_id" INNER JOIN "merge_request_metrics" ON "merge_request_metrics"."merge_request_id" = "merge_requests"."id" LEFT JOIN project_features ON projects.id = project_features.project_id WHERE (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 2 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" = 2 AND (project_authorizations.project_id = projects.id) AND (project_authorizations.access_level >= 20)))) AND EXISTS (SELECT "merge_request_assignees".* FROM "merge_request_assignees"...
-- (expected: 0, got: 1)
WHERE "merge_request_assignees"."user_id" = 2 AND (merge_request_id = merge_requests.id)) AND "merge_requests"."target_project_id" = "merge_request_metrics"."target_project_id" AND "merge_request_metrics"."merged_at" > "merge_request_metrics"."created_at"
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" = 2 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" = 2 AND (project_authorizations.project_id = projects.id) AND (project_authorizations.access_level >= 20)))) AND EXISTS (SELECT true FROM "merge_request_reviewers"...
-- (expected: 0, got: 1)
WHERE merge_request_id = merge_requests.id AND "merge_request_reviewers"."user_id" = 2)
SELECT EXTRACT(epoch FROM SUM(AGE(merge_request_metrics.merged_at, merge_request_metrics.created_at))) FROM "merge_requests" INNER JOIN "projects" ON "projects"."id" = "merge_requests"."target_project_id" INNER JOIN "merge_request_metrics" ON "merge_request_metrics"."merge_request_id" = "merge_requests"."id" LEFT JOIN project_features ON projects.id = project_features.project_id WHERE (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 2 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" = 2 AND (project_authorizations.project_id = projects.id) AND (project_authorizations.access_level >= 20)))) AND EXISTS (SELECT true FROM "merge_request_reviewers"...
-- (expected: 0, got: 1)
WHERE merge_request_id = merge_requests.id AND "merge_request_reviewers"."user_id" = 2) AND "merge_requests"."target_project_id" = "merge_request_metrics"."target_project_id" AND "merge_request_metrics"."merged_at" > "merge_request_metrics"."created_at"
SELECT COUNT(*) AS count_all, "user_id" AS user_id FROM ((SELECT namespaces.*, members.user_id as user_id FROM "namespaces" INNER JOIN "members" ON "members"."source_type" = 'Namespace' AND "members"."requested_at" IS NULL AND "members"."access_level" != 5 AND "members"."source_id" = "namespaces"."id" AND "members"."type" = 'GroupMember' WHERE "namespaces"."type" = 'Group' AND "members"."user_id" = 2 AND (access_level >= 10))
UNION
(SELECT namespaces.*, project_authorizations.user_id as user_id FROM "namespaces"...
-- (expected: 0, got: 1)
INNER JOIN "projects" ON "projects"."namespace_id" = "namespaces"."id" INNER JOIN "project_authorizations" ON "project_authorizations"."project_id" = "projects"."id" WHERE "namespaces"."type" = 'Group' AND "project_authorizations"."user_id" = 2)) namespaces GROUP BY "user_id"
# ./spec/requests/api/graphql/project/pipeline_spec.rb:126:in `block (5 levels) in <top (required)>'
# ./spec/requests/api/graphql/project/pipeline_spec.rb:124:in `block (4 levels) in <top (required)>'
# ./spec/spec_helper.rb:408:in `block (3 levels) in <top (required)>'
# ./spec/support/sidekiq_middleware.rb:9:in `with_sidekiq_server_middleware'
# ./spec/spec_helper.rb:399:in `block (2 levels) in <top (required)>'
# ./spec/spec_helper.rb:395:in `block (3 levels) in <top (required)>'
# ./lib/gitlab/application_context.rb:31:in `with_raw_context'
# ./spec/spec_helper.rb:395:in `block (2 levels) in <top (required)>'
# ./spec/support/database/prevent_cross_joins.rb:102:in `block (3 levels) in <main>'
# ./spec/support/database/prevent_cross_joins.rb:56:in `with_cross_joins_prevented'
# ./spec/support/database/prevent_cross_joins.rb:102:in `block (2 levels) in <main>'
Finished in 35.7 seconds (files took 57.07 seconds to load)
15 examples, 1 failure
Failed examples:
rspec ./spec/requests/api/graphql/project/pipeline_spec.rb:114 # getting pipeline information nested in a project performance when preloading keeps the queries under the threshold
app/models/ci/pipeline.rb:1276:in `tap'
QueryRecorder backtrace: --> app/models/ci/pipeline.rb:1276:in `security_reports'
QueryRecorder backtrace: --> ee/app/finders/security/pipeline_vulnerabilities_finder.rb:60:in `requested_reports'
QueryRecorder backtrace: --> ee/app/finders/security/pipeline_vulnerabilities_finder.rb:31:in `execute'
QueryRecorder backtrace: --> ee/app/graphql/resolvers/pipeline_security_report_findings_resolver.rb:29:in `resolve'{ project(fullPath: "namespace1/project1"){
pipeline0: pipeline(iid: "1") { userPermissions {
adminPipeline
destroyPipeline
updatePipeline
}
detailedStatus {
group
icon
favicon
detailsPath
hasDetails
label
text
tooltip
action {
buttonTitle
icon
method
title
}
}
stages {
pageInfo {
hasNextPage
hasPreviousPage
startCursor
endCursor
}
edges {
cursor
}
nodes {
name
}
}
user {
userPermissions {
createSnippet
}
bot
username
name
state
email
publicEmail
avatarUrl
webUrl
webPath
groupCount
location
namespace {
name
fullName
fullPath
description
descriptionHtml
visibility
lfsEnabled
requestAccessEnabled
sharedRunnersSetting
additionalPurchasedStorageSize
totalRepositorySizeExcess
totalRepositorySize
containsLockedProjects
repositorySizeExcessProjectCount
actualRepositorySizeLimit
storageSizeLimit
isTemporaryStorageIncreaseEnabled
temporaryStorageIncreaseEndsOn
}
authoredMergeRequests {
count
totalTimeToMerge
}
assignedMergeRequests {
count
totalTimeToMerge
}
reviewRequestedMergeRequests {
count
totalTimeToMerge
}
}
jobs {
pageInfo {
hasNextPage
hasPreviousPage
startCursor
endCursor
}
count
edges {
cursor
}
nodes {
name
allowFailure
tags
queuedAt
scheduledAt
shortSha
schedulingType
refName
refPath
playable
stuck
createdByTag
manualJob
triggered
}
}
job {
userPermissions {
readJobArtifacts
readBuild
updateBuild
}
name
stage {
name
}
allowFailure
tags
queuedAt
scheduledAt
detailedStatus {
group
icon
favicon
detailsPath
hasDetails
label
text
tooltip
}
shortSha
schedulingType
refName
refPath
playable
stuck
createdByTag
manualJob
triggered
}
sourceJob {
userPermissions {
readJobArtifacts
readBuild
updateBuild
}
name
stage {
name
}
allowFailure
tags
queuedAt
scheduledAt
detailedStatus {
group
icon
favicon
detailsPath
hasDetails
label
text
tooltip
}
shortSha
schedulingType
refName
refPath
playable
stuck
createdByTag
manualJob
triggered
}
downstream {
pageInfo {
hasNextPage
hasPreviousPage
startCursor
endCursor
}
count
edges {
cursor
}
}
upstream {
userPermissions {
adminPipeline
destroyPipeline
updatePipeline
}
detailedStatus {
group
icon
favicon
detailsPath
hasDetails
label
text
tooltip
}
user {
bot
username
name
state
email
publicEmail
avatarUrl
webUrl
webPath
groupCount
location
}
jobs {
count
}
job {
name
allowFailure
tags
queuedAt
scheduledAt
shortSha
schedulingType
refName
refPath
playable
stuck
createdByTag
manualJob
triggered
}
sourceJob {
name
allowFailure
tags
queuedAt
scheduledAt
shortSha
schedulingType
refName
refPath
playable
stuck
createdByTag
manualJob
triggered
}
downstream {
count
}
project {
fullPath
nameWithNamespace
name
description
descriptionHtml
tagList
topics
sshUrlToRepo
httpUrlToRepo
webUrl
starCount
forksCount
lastActivityAt
archived
visibility
sharedRunnersEnabled
lfsEnabled
mergeRequestsFfOnlyEnabled
serviceDeskEnabled
serviceDeskAddress
avatarUrl
issuesEnabled
mergeRequestsEnabled
wikiEnabled
snippetsEnabled
containerRegistryEnabled
jobsEnabled
publicJobs
openIssuesCount
importStatus
jiraImportStatus
onlyAllowMergeIfPipelineSucceeds
allowMergeOnSkippedPipeline
requestAccessEnabled
onlyAllowMergeIfAllDiscussionsAreResolved
printingMergeRequestLinkEnabled
removeSourceBranchAfterMerge
autocloseReferencedIssues
suggestionCommitMessage
squashReadOnly
containerRepositoriesCount
securityDashboardPath
repositorySizeExcess
actualRepositorySizeLimit
}
codeQualityReports {
count
}
dastProfile {
name
description
editPath
}
}
project {
userPermissions {
changeNamespace
changeVisibilityLevel
renameProject
removeProject
archiveProject
removeForkProject
removePages
readProject
createMergeRequestIn
readWiki
readProjectMember
createIssue
uploadFile
readCycleAnalytics
downloadCode
downloadWikiCode
forkProject
readCommitStatus
requestAccess
createPipeline
createPipelineSchedule
createMergeRequestFrom
createWiki
pushCode
createDeployment
pushToDeleteProtectedBranch
adminWiki
adminProject
updatePages
adminRemoteMirror
createLabel
updateWiki
destroyWiki
createPages
destroyPages
readPagesContent
adminOperations
readMergeRequest
readDesign
createDesign
destroyDesign
createSnippet
adminPathLocks
}
fullPath
nameWithNamespace
name
description
descriptionHtml
tagList
topics
sshUrlToRepo
httpUrlToRepo
webUrl
starCount
forksCount
lastActivityAt
archived
visibility
sharedRunnersEnabled
lfsEnabled
mergeRequestsFfOnlyEnabled
serviceDeskEnabled
serviceDeskAddress
avatarUrl
issuesEnabled
mergeRequestsEnabled
wikiEnabled
snippetsEnabled
containerRegistryEnabled
jobsEnabled
publicJobs
openIssuesCount
importStatus
jiraImportStatus
onlyAllowMergeIfPipelineSucceeds
allowMergeOnSkippedPipeline
requestAccessEnabled
onlyAllowMergeIfAllDiscussionsAreResolved
printingMergeRequestLinkEnabled
removeSourceBranchAfterMerge
autocloseReferencedIssues
suggestionCommitMessage
squashReadOnly
namespace {
name
fullName
fullPath
description
descriptionHtml
visibility
lfsEnabled
requestAccessEnabled
sharedRunnersSetting
additionalPurchasedStorageSize
totalRepositorySizeExcess
totalRepositorySize
containsLockedProjects
repositorySizeExcessProjectCount
actualRepositorySizeLimit
storageSizeLimit
isTemporaryStorageIncreaseEnabled
temporaryStorageIncreaseEndsOn
}
group {
name
fullName
fullPath
description
descriptionHtml
visibility
lfsEnabled
requestAccessEnabled
sharedRunnersSetting
additionalPurchasedStorageSize
totalRepositorySizeExcess
totalRepositorySize
containsLockedProjects
repositorySizeExcessProjectCount
actualRepositorySizeLimit
storageSizeLimit
isTemporaryStorageIncreaseEnabled
temporaryStorageIncreaseEndsOn
webUrl
avatarUrl
shareWithGroupLock
projectCreationLevel
subgroupCreationLevel
requireTwoFactorAuthentication
twoFactorGracePeriod
autoDevopsEnabled
emailsDisabled
mentionsDisabled
containerRepositoriesCount
dependencyProxyImageCount
dependencyProxyBlobCount
dependencyProxyTotalSize
dependencyProxyImagePrefix
epicsEnabled
billableMembersCount
}
statistics {
commitCount
storageSize
repositorySize
lfsObjectsSize
buildArtifactsSize
packagesSize
wikiSize
snippetsSize
pipelineArtifactsSize
uploadsSize
}
repository {
rootRef
empty
exists
diskPath
}
mergeRequests {
count
totalTimeToMerge
}
issues {
count
weight
}
issueStatusCounts {
opened
closed
all
}
environment {
name
state
}
issue {
title
titleHtml
description
descriptionHtml
state
reference
dueDate
confidential
hidden
discussionLocked
upvotes
downvotes
mergeRequestsCount
userNotesCount
userDiscussionsCount
webPath
webUrl
relativePosition
emailsDisabled
subscribed
timeEstimate
totalTimeSpent
humanTimeEstimate
humanTotalTimeSpent
closedAt
type
severity
moved
createNoteEmail
projectId
weight
blocked
blockingCount
blockedByCount
healthStatus
statusPagePublishedIncident
slaDueAt
}
packages {
count
}
jobs {
count
}
pipelines {
count
}
ciCdSettings {
mergePipelinesEnabled
mergeTrainsEnabled
keepLatestArtifact
jobTokenScopeEnabled
}
grafanaIntegration {
grafanaUrl
enabled
}
sentryErrors {
externalUrl
}
alertManagementAlertStatusCounts {
triggered
acknowledged
resolved
ignored
open
all
}
releases {
count
}
containerExpirationPolicy {
enabled
olderThan
cadence
keepN
nameRegex
nameRegexKeep
nextRunAt
}
containerRepositoriesCount
terraformStates {
count
}
pipelineAnalytics {
weekPipelinesTotals
weekPipelinesSuccessful
weekPipelinesLabels
monthPipelinesTotals
monthPipelinesSuccessful
monthPipelinesLabels
yearPipelinesTotals
yearPipelinesSuccessful
yearPipelinesLabels
pipelineTimesValues
pipelineTimesLabels
}
clusterAgents {
count
}
labels {
count
}
securityScanners {
enabled
available
pipelineRun
}
vulnerabilitySeveritiesCount {
info
unknown
low
medium
high
critical
}
requirement {
title
titleHtml
description
descriptionHtml
state
lastTestReportState
lastTestReportManuallyCreated
}
requirementStatesCount {
opened
archived
}
securityDashboardPath
repositorySizeExcess
actualRepositorySizeLimit
codeCoverageSummary {
averageCoverage
coverageCount
lastUpdatedOn
}
apiFuzzingCiConfiguration {
scanModes
}
pushRules {
rejectUnsignedCommits
}
}
testReportSummary {
total {
time
count
success
failed
skipped
error
suiteError
}
testSuites {
count
}
}
securityReportSummary {
sast {
vulnerabilitiesCount
scannedResourcesCount
scannedResourcesCsvPath
}
dependencyScanning {
vulnerabilitiesCount
scannedResourcesCount
scannedResourcesCsvPath
}
containerScanning {
vulnerabilitiesCount
scannedResourcesCount
scannedResourcesCsvPath
}
dast {
vulnerabilitiesCount
scannedResourcesCount
scannedResourcesCsvPath
}
secretDetection {
vulnerabilitiesCount
scannedResourcesCount
scannedResourcesCsvPath
}
coverageFuzzing {
vulnerabilitiesCount
scannedResourcesCount
scannedResourcesCsvPath
}
apiFuzzing {
vulnerabilitiesCount
scannedResourcesCount
scannedResourcesCsvPath
}
clusterImageScanning {
vulnerabilitiesCount
scannedResourcesCount
scannedResourcesCsvPath
}
generic {
vulnerabilitiesCount
scannedResourcesCount
scannedResourcesCsvPath
}
}
securityReportFindings {
pageInfo {
hasNextPage
hasPreviousPage
startCursor
endCursor
}
edges {
cursor
}
nodes {
reportType
name
severity
confidence
falsePositive
projectFingerprint
uuid
description
solution
state
}
}
codeQualityReports {
pageInfo {
hasNextPage
hasPreviousPage
startCursor
endCursor
}
count
edges {
cursor
}
nodes {
description
fingerprint
severity
line
}
}
dastProfile {
name
description
dastSiteProfile {
profileName
targetUrl
targetType
editPath
excludedUrls
requestHeaders
validationStatus
normalizedTargetUrl
referencedInSecurityPolicies
}
dastScannerProfile {
profileName
spiderTimeout
targetTimeout
scanType
useAjaxSpider
showDebugMessages
editPath
referencedInSecurityPolicies
}
dastProfileSchedule {
startsAt
timezone
nextRunAt
}
branch {
name
exists
}
editPath
} } pipeline1: pipeline(iid: "2") { userPermissions {
adminPipeline
destroyPipeline
updatePipeline
}
detailedStatus {
group
icon
favicon
detailsPath
hasDetails
label
text
tooltip
action {
buttonTitle
icon
method
title
}
}
stages {
pageInfo {
hasNextPage
hasPreviousPage
startCursor
endCursor
}
edges {
cursor
}
nodes {
name
}
}
user {
userPermissions {
createSnippet
}
bot
username
name
state
email
publicEmail
avatarUrl
webUrl
webPath
groupCount
location
namespace {
name
fullName
fullPath
description
descriptionHtml
visibility
lfsEnabled
requestAccessEnabled
sharedRunnersSetting
additionalPurchasedStorageSize
totalRepositorySizeExcess
totalRepositorySize
containsLockedProjects
repositorySizeExcessProjectCount
actualRepositorySizeLimit
storageSizeLimit
isTemporaryStorageIncreaseEnabled
temporaryStorageIncreaseEndsOn
}
authoredMergeRequests {
count
totalTimeToMerge
}
assignedMergeRequests {
count
totalTimeToMerge
}
reviewRequestedMergeRequests {
count
totalTimeToMerge
}
}
jobs {
pageInfo {
hasNextPage
hasPreviousPage
startCursor
endCursor
}
count
edges {
cursor
}
nodes {
name
allowFailure
tags
queuedAt
scheduledAt
shortSha
schedulingType
refName
refPath
playable
stuck
createdByTag
manualJob
triggered
}
}
job {
userPermissions {
readJobArtifacts
readBuild
updateBuild
}
name
stage {
name
}
allowFailure
tags
queuedAt
scheduledAt
detailedStatus {
group
icon
favicon
detailsPath
hasDetails
label
text
tooltip
}
shortSha
schedulingType
refName
refPath
playable
stuck
createdByTag
manualJob
triggered
}
sourceJob {
userPermissions {
readJobArtifacts
readBuild
updateBuild
}
name
stage {
name
}
allowFailure
tags
queuedAt
scheduledAt
detailedStatus {
group
icon
favicon
detailsPath
hasDetails
label
text
tooltip
}
shortSha
schedulingType
refName
refPath
playable
stuck
createdByTag
manualJob
triggered
}
downstream {
pageInfo {
hasNextPage
hasPreviousPage
startCursor
endCursor
}
count
edges {
cursor
}
}
upstream {
userPermissions {
adminPipeline
destroyPipeline
updatePipeline
}
detailedStatus {
group
icon
favicon
detailsPath
hasDetails
label
text
tooltip
}
user {
bot
username
name
state
email
publicEmail
avatarUrl
webUrl
webPath
groupCount
location
}
jobs {
count
}
job {
name
allowFailure
tags
queuedAt
scheduledAt
shortSha
schedulingType
refName
refPath
playable
stuck
createdByTag
manualJob
triggered
}
sourceJob {
name
allowFailure
tags
queuedAt
scheduledAt
shortSha
schedulingType
refName
refPath
playable
stuck
createdByTag
manualJob
triggered
}
downstream {
count
}
project {
fullPath
nameWithNamespace
name
description
descriptionHtml
tagList
topics
sshUrlToRepo
httpUrlToRepo
webUrl
starCount
forksCount
lastActivityAt
archived
v
[1] pry(#<RSpec::ExampleGroups::GettingPipelineInformationNestedInAProject::Performance::WhenPreloading>)> control.log
=> ["SELECT \"personal_access_tokens\".* FROM \"personal_access_tokens\" WHERE \"personal_access_tokens\".\"token_digest\" = 'Aie3TP3WtMYWdguLtLCeHzChjjyTk3jk8BNdIUG0xLw=' LIMIT 1 /*application:test,correlation_id:1afdc87143980885aa29e0457dc5c830,db_config_name:main*/",
"SAVEPOINT active_record_3 /*application:test,correlation_id:1afdc87143980885aa29e0457dc5c830,db_config_name:main*/",
"INSERT INTO \"personal_access_tokens\" (\"user_id\", \"name\", \"expires_at\", \"created_at\", \"updated_at\", \"scopes\", \"token_digest\") VALUES (62, 'PAT 2', '2021-11-16', '2021-11-11 14:50:03.061442', '2021-11-11 14:50:03.061442', '---\n- api\n', 'Aie3TP3WtMYWdguLtLCeHzChjjyTk3jk8BNdIUG0xLw=') RETURNING \"id\" /*application:test,correlation_id:1afdc87143980885aa29e0457dc5c830,db_config_name:main*/",
"RELEASE SAVEPOINT active_record_3 /*application:test,correlation_id:1afdc87143980885aa29e0457dc5c830,db_config_name:main*/",
"SELECT \"personal_access_tokens\".* FROM \"personal_access_tokens\" WHERE \"personal_access_tokens\".\"token_digest\" = 'Aie3TP3WtMYWdguLtLCeHzChjjyTk3jk8BNdIUG0xLw=' LIMIT 1 /*application:test,correlation_id:04bc1d96-c030-4a0c-a3cb-0c3d9844ae6b,endpoint_id:GraphqlController#execute,db_config_name:main*/",
"SELECT \"licenses\".* FROM \"licenses\" ORDER BY \"licenses\".\"id\" DESC LIMIT 100 /*application:test,correlation_id:04bc1d96-c030-4a0c-a3cb-0c3d9844ae6b,endpoint_id:GraphqlController#execute,db_config_name:main*/",
"SELECT 1 AS one FROM \"geo_nodes\" LIMIT 1 /*application:test,correlation_id:04bc1d96-c030-4a0c-a3cb-0c3d9844ae6b,endpoint_id:GraphqlController#execute,db_config_name:main*/",
"UPDATE \"personal_access_tokens\" SET \"last_used_at\" = '2021-11-11 14:50:03.426462' WHERE \"personal_access_tokens\".\"id\" = 111 /*application:test,correlation_id:04bc1d96-c030-4a0c-a3cb-0c3d9844ae6b,endpoint_id:GraphqlController#execute,db_config_name:main*/",
"SELECT \"users\".* FROM \"users\" WHERE \"users\".\"id\" = 62 LIMIT 1 /*application:test,correlation_id:04bc1d96-c030-4a0c-a3cb-0c3d9844ae6b,endpoint_id:GraphqlController#execute,db_config_name:main*/",
"SELECT \"projects\".\"id\" AS t0_r0, \"projects\".\"name\" AS t0_r1, \"projects\".\"path\" AS t0_r2, \"projects\".\"description\" AS t0_r3, \"projects\".\"created_at\" AS t0_r4, \"projects\".\"updated_at\" AS t0_r5, \"projects\".\"creator_id\" AS t0_r6, \"projects\".\"namespace_id\" AS t0_r7, \"projects\".\"last_activity_at\" AS t0_r8, \"projects\".\"import_url\" AS t0_r9, \"projects\".\"visibility_level\" AS t0_r10, \"projects\".\"archived\" AS t0_r11, \"projects\".\"avatar\" AS t0_r12, \"projects\".\"merge_requests_template\" AS t0_r13, \"projects\".\"star_count\" AS t0_r14, \"projects\".\"merge_requests_rebase_enabled\" AS t0_r15, \"projects\".\"import_type\" AS t0_r16, \"projects\".\"import_source\" AS t0_r17, \"projects\".\"approvals_before_merge\" AS t0_r18, \"projects\".\"reset_approvals_on_push\" AS t0_r19, \"projects\".\"merge_requests_ff_only_enabled\" AS t0_r20, \"projects\".\"issues_template\" AS t0_r21, \"projects\".\"mirror\" AS t0_r22, \"projects\".\"mirror_user_id\" AS t0_r23, \"projects\".\"shared_runners_enabled\" AS t0_r24, \"projects\".\"runners_token\" AS t0_r25, \"projects\".\"build_coverage_regex\" AS t0_r26, \"projects\".\"build_allow_git_fetch\" AS t0_r27, \"projects\".\"build_timeout\" AS t0_r28, \"projects\".\"mirror_trigger_builds\" AS t0_r29, \"projects\".\"pending_delete\" AS t0_r30, \"projects\".\"public_builds\" AS t0_r31, \"projects\".\"last_repository_check_failed\" AS t0_r32, \"projects\".\"last_repository_check_at\" AS t0_r33, \"projects\".\"only_allow_merge_if_pipeline_succeeds\" AS t0_r34, \"projects\".\"has_external_issue_tracker\" AS t0_r35, \"projects\".\"repository_storage\" AS t0_r36, \"projects\".\"repository_read_only\" AS t0_r37, \"projects\".\"request_access_enabled\" AS t0_r38, \"projects\".\"has_external_wiki\" AS t0_r39, \"projects\".\"ci_config_path\" AS t0_r40, \"projects\".\"lfs_enabled\" AS t0_r41, \"projects\".\"description_html\" AS t0_r42, \"projects\".\"only_allow_merge_if_all_discussions_are_resolved\" AS t0_r43, \"projects\".\"repository_size_limit\" AS t0_r44, \"projects\".\"printing_merge_request_link_enabled\" AS t0_r45, \"projects\".\"auto_cancel_pending_pipelines\" AS t0_r46, \"projects\".\"service_desk_enabled\" AS t0_r47, \"projects\".\"cached_markdown_version\" AS t0_r48, \"projects\".\"delete_error\" AS t0_r49, \"projects\".\"last_repository_updated_at\" AS t0_r50, \"projects\".\"disable_overriding_approvers_per_merge_request\" AS t0_r51, \"projects\".\"storage_version\" AS t0_r52, \"projects\".\"resolve_outdated_diff_discussions\" AS t0_r53, \"projects\".\"remote_mirror_available_overridden\" AS t0_r54, \"projects\".\"only_mirror_protected_branches\" AS t0_r55, \"projects\".\"pull_mirror_available_overridden\" AS t0_r56, \"projects\".\"jobs_cache_index\" AS t0_r57, \"projects\".\"external_authorization_classification_label\" AS t0_r58, \"projects\".\"mirror_overwrites_diverged_branches\" AS t0_r59, \"projects\".\"pages_https_only\" AS t0_r60, \"projects\".\"external_webhook_token\" AS t0_r61, \"projects\".\"packages_enabled\" AS t0_r62, \"projects\".\"merge_requests_author_approval\" AS t0_r63, \"projects\".\"pool_repository_id\" AS t0_r64, \"projects\".\"runners_token_encrypted\" AS t0_r65, \"projects\".\"bfg_object_map\" AS t0_r66, \"projects\".\"detected_repository_languages\" AS t0_r67, \"projects\".\"merge_requests_disable_committers_approval\" AS t0_r68, \"projects\".\"require_password_to_approve\" AS t0_r69, \"projects\".\"emails_disabled\" AS t0_r70, \"projects\".\"max_pages_size\" AS t0_r71, \"projects\".\"max_artifacts_size\" AS t0_r72, \"projects\".\"remove_source_branch_after_merge\" AS t0_r73, \"projects\".\"marked_for_deletion_at\" AS t0_r74, \"projects\".\"marked_for_deletion_by_user_id\" AS t0_r75, \"projects\".\"autoclose_referenced_issues\" AS t0_r76, \"projects\".\"suggestion_commit_message\" AS t0_r77, \"projects\".\"project_namespace_id\" AS t0_r78, \"routes\".\"id\" AS t1_r0, \"routes\".\"source_id\" AS t1_r1, \"routes\".\"source_type\" AS t1_r2, \"routes\".\"path\" AS t1_r3, \"routes\".\"created_at\" AS t1_r4, \"routes\".\"updated_at\" AS t1_r5, \"routes\".\"name\" AS t1_r6 FROM \"projects\" LEFT OUTER JOIN \"routes\" ON \"routes\".\"source_type\" = 'Project' AND \"routes\".\"source_id\" = \"projects\".\"id\" WHERE ((LOWER(routes.path) = LOWER('namespace1/project1'))) /*application:test,correlation_id:04bc1d96-c030-4a0c-a3cb-0c3d9844ae6b,endpoint_id:GraphqlController#execute,db_config_name:main*/",
"SELECT \"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\".\"description_html\", \"namespaces\".\"lfs_enabled\", \"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\" FROM \"namespaces\" WHERE \"namespaces\".\"type\" = 'Group' AND \"namespaces\".\"id\" = 61 LIMIT 1 /*application:test,correlation_id:04bc1d96-c030-4a0c-a3cb-0c3d9844ae6b,endpoint_id:GraphqlController#execute,db_config_name:main*/",
"SELECT \"project_features\".* FROM \"project_features\" WHERE \"project_features\".\"project_id\" = 40 LIMIT 1 /*application:test,correlation_id:04bc1d96-c030-4a0c-a3cb-0c3d9844ae6b,endpoint_id:GraphqlController#execute,db_config_name:main*/",
"SELECT \"ci_pipelines\".* FROM \"ci_pipelines\" WHERE \"ci_pipelines\".\"project_id\" = 40 AND \"ci_pipelines\".\"iid\" = 1 ORDER BY \"ci_pipelines\".\"id\" DESC /*application:test,correlation_id:04bc1d96-c030-4a0c-a3cb-0c3d9844ae6b,endpoint_id:GraphqlController#execute,db_config_name:main*/",
"SELECT \"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\".\"description_html\", \"namespaces\".\"lfs_enabled\", \"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\" FROM \"namespaces\" WHERE \"namespaces\".\"id\" = 61 LIMIT 1 /*application:test,correlation_id:04bc1d96-c030-4a0c-a3cb-0c3d9844ae6b,endpoint_id:GraphqlController#execute,db_config_name:main*/",
"SELECT MAX(\"project_authorizations\".\"access_level\") AS maximum_access_level, \"project_authorizations\".\"user_id\" AS project_authorizations_user_id FROM \"project_authorizations\" WHERE \"project_authorizations\".\"project_id\" = 40 AND \"project_authorizations\".\"user_id\" = 62 GROUP BY \"project_authorizations\".\"user_id\" /*application:test,correlation_id:04bc1d96-c030-4a0c-a3cb-0c3d9844ae6b,endpoint_id:GraphqlController#execute,db_config_name:main*/",
"SELECT \"users\".* FROM \"users\" WHERE \"users\".\"id\" = 61 LIMIT 1 /*application:test,correlation_id:04bc1d96-c030-4a0c-a3cb-0c3d9844ae6b,endpoint_id:GraphqlController#execute,db_config_name:main*/",
"SELECT \"merge_requests\".* FROM \"merge_requests\" WHERE \"merge_requests\".\"source_project_id\" = 40 AND (\"merge_requests\".\"state_id\" IN (1)) AND \"merge_requests\".\"allow_maintainer_to_push\" = TRUE AND \"merge_requests\".\"source_branch\" = 'master' /*application:test,correlation_id:04bc1d96-c030-4a0c-a3cb-0c3d9844ae6b,endpoint_id:GraphqlController#execute,db_config_name:main*/",
"SELECT \"protected_branches\".* FROM \"protected_branches\" WHERE \"protected_branches\".\"project_id\" = 40 /*application:test,correlation_id:04bc1d96-c030-4a0c-a3cb-0c3d9844ae6b,endpoint_id:GraphqlController#execute,db_config_name:main*/",
"SELECT \"routes\".* FROM \"routes\" WHERE \"routes\".\"source_id\" = 61 AND \"routes\".\"source_type\" = 'Namespace' LIMIT 1 /*application:test,correlation_id:04bc1d96-c030-4a0c-a3cb-0c3d9844ae6b,endpoint_id:GraphqlController#execute,db_config_name:main*/",
"SELECT 1 AS one FROM \"ci_stages\" WHERE \"ci_stages\".\"pipeline_id\" = 70 LIMIT 1 OFFSET 100 /*application:test,correlation_id:04bc1d96-c030-4a0c-a3cb-0c3d9844ae6b,endpoint_id:GraphqlController#execute,db_config_name:main*/",
"SELECT \"ci_stages\".* FROM \"ci_stages\" WHERE \"ci_stages\".\"pipeline_id\" = 70 ORDER BY \"ci_stages\".\"position\" ASC, \"ci_stages\".\"id\" DESC LIMIT 100 /*application:test,correlation_id:04bc1d96-c030-4a0c-a3cb-0c3d9844ae6b,endpoint_id:GraphqlController#execute,db_config_name:main*/",
"SELECT 1 AS one FROM \"ci_builds\" WHERE \"ci_builds\".\"commit_id\" = 70 LIMIT 1 OFFSET 100 /*application:test,correlation_id:04bc1d96-c030-4a0c-a3cb-0c3d9844ae6b,endpoint_id:GraphqlController#execute,db_config_name:main*/",
"SELECT \"ci_builds\".* FROM \"ci_builds\" WHERE \"ci_builds\".\"commit_id\" = 70 ORDER BY \"ci_builds\".\"id\" DESC LIMIT 100 /*application:test,correlation_id:04bc1d96-c030-4a0c-a3cb-0c3d9844ae6b,endpoint_id:GraphqlController#execute,db_config_name:main*/",
"SELECT COUNT(*) FROM \"ci_builds\" WHERE \"ci_builds\".\"commit_id\" = 70 /*application:test,correlation_id:04bc1d96-c030-4a0c-a3cb-0c3d9844ae6b,endpoint_id:GraphqlController#execute,db_config_name:main*/",
"SELECT \"projects\".\"id\", \"projects\".\"name\", \"projects\".\"path\", \"projects\".\"description\", \"projects\".\"created_at\", \"projects\".\"updated_at\", \"projects\".\"creator_id\", \"projects\".\"namespace_id\", \"projects\".\"last_activity_at\", \"projects\".\"import_url\", \"projects\".\"visibility_level\", \"projects\".\"archived\", \"projects\".\"avatar\", \"projects\".\"merge_requests_template\", \"projects\".\"star_count\", \"projects\".\"merge_requests_rebase_enabled\", \"projects\".\"import_type\", \"projects\".\"import_source\", \"projects\".\"approvals_before_merge\", \"projects\".\"reset_approvals_on_push\", \"projects\".\"merge_requests_ff_only_enabled\", \"projects\".\"issues_template\", \"projects\".\"mirror\", \"projects\".\"mirror_user_id\", \"projects\".\"shared_runners_enabled\", \"projects\".\"runners_token\", \"projects\".\"build_coverage_regex\", \"projects\".\"build_allow_git_fetch\", \"projects\".\"build_timeout\", \"projects\".\"mirror_trigger_builds\", \"projects\".\"pending_delete\", \"projects\".\"public_builds\", \"projects\".\"last_repository_check_failed\", \"projects\".\"last_repository_check_at\", \"projects\".\"only_allow_merge_if_pipeline_succeeds\", \"projects\".\"has_external_issue_tracker\", \"projects\".\"repository_storage\", \"projects\".\"repository_read_only\", \"projects\".\"request_access_enabled\", \"projects\".\"has_external_wiki\", \"projects\".\"ci_config_path\", \"projects\".\"lfs_enabled\", \"projects\".\"description_html\", \"projects\".\"only_allow_merge_if_all_discussions_are_resolved\", \"projects\".\"repository_size_limit\", \"projects\".\"printing_merge_request_link_enabled\", \"projects\".\"auto_cancel_pending_pipelines\", \"projects\".\"service_desk_enabled\", \"projects\".\"cached_markdown_version\", \"projects\".\"delete_error\", \"projects\".\"last_repository_updated_at\", \"projects\".\"disable_overriding_approvers_per_merge_request\", \"projects\".\"storage_version\", \"projects\".\"resolve_outdated_diff_discussions\", \"projects\".\"remote_mirror_available_overridden\", \"projects\".\"only_mirror_protected_branches\", \"projects\".\"pull_mirror_available_overridden\", \"projects\".\"jobs_cache_index\", \"projects\".\"external_authorization_classification_label\", \"projects\".\"mirror_overwrites_diverged_branches\", \"projects\".\"pages_https_only\", \"projects\".\"external_webhook_token\", \"projects\".\"packages_enabled\", \"projects\".\"merge_requests_author_approval\", \"projects\".\"pool_repository_id\", \"projects\".\"runners_token_encrypted\", \"projects\".\"bfg_object_map\", \"projects\".\"detected_repository_languages\", \"projects\".\"merge_requests_disable_committers_approval\", \"projects\".\"require_password_to_approve\", \"projects\".\"emails_disabled\", \"projects\".\"max_pages_size\", \"projects\".\"max_artifacts_size\", \"projects\".\"remove_source_branch_after_merge\", \"projects\".\"marked_for_deletion_at\", \"projects\".\"marked_for_deletion_by_user_id\", \"projects\".\"autoclose_referenced_issues\", \"projects\".\"suggestion_commit_message\", \"projects\".\"project_namespace_id\" FROM \"projects\" WHERE \"projects\".\"id\" = 40 LIMIT 1 /*application:test,correlation_id:04bc1d96-c030-4a0c-a3cb-0c3d9844ae6b,endpoint_id:GraphqlController#execute,db_config_name:main*/",
"SELECT \"tags\".* FROM \"tags\" INNER JOIN \"taggings\" ON \"tags\".\"id\" = \"taggings\".\"tag_id\" WHERE \"taggings\".\"taggable_id\" = 119 AND \"taggings\".\"taggable_type\" = 'CommitStatus' AND \"taggings\".\"context\" = 'tags' /*application:test,correlation_id:04bc1d96-c030-4a0c-a3cb-0c3d9844ae6b,endpoint_id:GraphqlController#execute,db_config_name:main*/",
"SELECT \"tags\".* FROM \"tags\" INNER JOIN \"taggings\" ON \"tags\".\"id\" = \"taggings\".\"tag_id\" WHERE \"taggings\".\"taggable_id\" = 118 AND \"taggings\".\"taggable_type\" = 'CommitStatus' AND \"taggings\".\"context\" = 'tags' /*application:test,correlation_id:04bc1d96-c030-4a0c-a3cb-0c3d9844ae6b,endpoint_id:GraphqlController#execute,db_config_name:main*/",
"SELECT \"project_ci_cd_settings\".* FROM \"project_ci_cd_settings\" WHERE \"project_ci_cd_settings\".\"project_id\" = 40 LIMIT 1 /*application:test,correlation_id:04bc1d96-c030-4a0c-a3cb-0c3d9844ae6b,endpoint_id:GraphqlController#execute,db_config_name:main*/",
"SELECT \"ci_runners\".* FROM ((SELECT \"ci_runners\".* FROM \"ci_runners\" INNER JOIN \"ci_runner_projects\" ON \"ci_runners\".\"id\" = \"ci_runner_projects\".\"runner_id\" WHERE \"ci_runner_projects\".\"project_id\" = 40)\nUNION\n(SELECT \"ci_runners\".* FROM \"ci_runners\" INNER JOIN \"ci_runner_namespaces\" ON \"ci_runner_namespaces\".\"runner_id\" = \"ci_runners\".\"id\" INNER JOIN \"namespaces\" ON \"namespaces\".\"id\" = \"ci_runner_namespaces\".\"namespace_id\" AND \"namespaces\".\"type\" = 'Group' WHERE \"namespaces\".\"id\" IN (WITH RECURSIVE \"base_and_ancestors\" AS ((SELECT \"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\".\"description_html\", \"namespaces\".\"lfs_enabled\", \"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\" FROM \"namespaces\" INNER JOIN \"projects\" ON \"projects\".\"namespace_id\" = \"namespaces\".\"id\" WHERE \"namespaces\".\"type\" = 'Group' AND \"projects\".\"id\" = 40)\nUNION\n(SELECT \"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\".\"description_html\", \"namespaces\".\"lfs_enabled\", \"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\" FROM \"namespaces\", \"base_and_ancestors\" WHERE \"namespaces\".\"type\" = 'Group' AND \"namespaces\".\"id\" = \"base_and_ancestors\".\"parent_id\")) SELECT \"namespaces\".\"id\" FROM \"base_and_ancestors\" AS \"namespaces\"))\nUNION\n(SELECT \"ci_runners\".* FROM \"ci_runners\" WHERE \"ci_runners\".\"runner_type\" = 1)) ci_runners WHERE \"ci_runners\".\"active\" = TRUE AND (contacted_at > '2021-11-11 12:50:03.650771') /*application:test,correlation_id:04bc1d96-c030-4a0c-a3cb-0c3d9844ae6b,endpoint_id:GraphqlController#execute,db_config_name:main*/",
"SELECT \"ci_builds\".* FROM \"ci_builds\" INNER JOIN \"ci_sources_pipelines\" ON \"ci_builds\".\"id\" = \"ci_sources_pipelines\".\"source_job_id\" WHERE \"ci_sources_pipelines\".\"pipeline_id\" = 70 LIMIT 1 /*application:test,correlation_id:04bc1d96-c030-4a0c-a3cb-0c3d9844ae6b,endpoint_id:GraphqlController#execute,db_config_name:main*/",
"SELECT 1 AS one FROM \"ci_pipelines\" INNER JOIN \"ci_sources_pipelines\" ON \"ci_pipelines\".\"id\" = \"ci_sources_pipelines\".\"pipeline_id\" WHERE \"ci_sources_pipelines\".\"source_pipeline_id\" = 70 LIMIT 1 OFFSET 100 /*application:test,correlation_id:04bc1d96-c030-4a0c-a3cb-0c3d9844ae6b,endpoint_id:GraphqlController#execute,db_config_name:main*/",
"SELECT \"ci_pipelines\".* FROM \"ci_pipelines\" INNER JOIN \"ci_sources_pipelines\" ON \"ci_pipelines\".\"id\" = \"ci_sources_pipelines\".\"pipeline_id\" WHERE \"ci_sources_pipelines\".\"source_pipeline_id\" = 70 ORDER BY \"ci_pipelines\".\"id\" DESC LIMIT 100 /*application:test,correlation_id:04bc1d96-c030-4a0c-a3cb-0c3d9844ae6b,endpoint_id:GraphqlController#execute,db_config_name:main*/",
"SELECT COUNT(*) FROM \"ci_pipelines\" INNER JOIN \"ci_sources_pipelines\" ON \"ci_pipelines\".\"id\" = \"ci_sources_pipelines\".\"pipeline_id\" WHERE \"ci_sources_pipelines\".\"source_pipeline_id\" = 70 /*application:test,correlation_id:04bc1d96-c030-4a0c-a3cb-0c3d9844ae6b,endpoint_id:GraphqlController#execute,db_config_name:main*/",
"SELECT \"ci_pipelines\".* FROM \"ci_pipelines\" INNER JOIN \"ci_sources_pipelines\" ON \"ci_pipelines\".\"id\" = \"ci_sources_pipelines\".\"source_pipeline_id\" WHERE \"ci_sources_pipelines\".\"pipeline_id\" = 70 LIMIT 1 /*application:test,correlation_id:04bc1d96-c030-4a0c-a3cb-0c3d9844ae6b,endpoint_id:GraphqlController#execute,db_config_name:main*/",
"SELECT 1 AS one FROM \"merge_requests\" WHERE \"merge_requests\".\"source_project_id\" = 40 AND (\"merge_requests\".\"state_id\" IN (1)) AND \"merge_requests\".\"allow_maintainer_to_push\" = TRUE AND (EXISTS (SELECT 1 FROM \"project_authorizations\" WHERE \"project_authorizations\".\"user_id\" = 62 AND (access_level >= 30 ) AND (project_authorizations.project_id = merge_requests.target_project_id) LIMIT 1)) LIMIT 1 /*application:test,correlation_id:04bc1d96-c030-4a0c-a3cb-0c3d9844ae6b,endpoint_id:GraphqlController#execute,db_config_name:main*/",
"SELECT \"topics\".* FROM \"topics\" INNER JOIN \"project_topics\" ON \"topics\".\"id\" = \"project_topics\".\"topic_id\" WHERE \"project_topics\".\"project_id\" = 40 ORDER BY \"project_topics\".\"id\" ASC /*application:test,correlation_id:04bc1d96-c030-4a0c-a3cb-0c3d9844ae6b,endpoint_id:GraphqlController#execute,db_config_name:main*/",
"SELECT COUNT(*) AS count_all, \"fork_network_members\".\"forked_from_project_id\" AS fork_network_members_forked_from_project_id FROM \"fork_network_members\" WHERE \"fork_network_members\".\"forked_from_project_id\" = 40 GROUP BY \"fork_network_members\".\"forked_from_project_id\" /*application:test,correlation_id:04bc1d96-c030-4a0c-a3cb-0c3d9844ae6b,endpoint_id:GraphqlController#execute,db_config_name:main*/",
"SELECT COUNT(*) AS count_all, \"issues\".\"project_id\" AS issues_project_id FROM \"issues\" WHERE (NOT EXISTS (SELECT 1 FROM \"banned_users\" WHERE (issues.author_id = banned_users.user_id))) AND \"issues\".\"confidential\" = FALSE AND (\"issues\".\"state_id\" IN (1)) AND \"issues\".\"issue_type\" IN (0, 1) AND \"issues\".\"project_id\" = 40 GROUP BY \"issues\".\"project_id\" /*application:test,correlation_id:04bc1d96-c030-4a0c-a3cb-0c3d9844ae6b,endpoint_id:GraphqlController#execute,db_config_name:main*/",
"SELECT \"project_mirror_data\".* FROM \"project_mirror_data\" WHERE \"project_mirror_data\".\"project_id\" = 40 LIMIT 1 /*application:test,correlation_id:04bc1d96-c030-4a0c-a3cb-0c3d9844ae6b,endpoint_id:GraphqlController#execute,db_config_name:main*/",
"SELECT \"jira_imports\".* FROM \"jira_imports\" WHERE \"jira_imports\".\"project_id\" = 40 ORDER BY jira_imports.created_at DESC LIMIT 1 /*application:test,correlation_id:04bc1d96-c030-4a0c-a3cb-0c3d9844ae6b,endpoint_id:GraphqlController#execute,db_config_name:main*/",
"SELECT \"project_settings\".* FROM \"project_settings\" WHERE \"project_settings\".\"project_id\" = 40 LIMIT 1 /*application:test,correlation_id:04bc1d96-c030-4a0c-a3cb-0c3d9844ae6b,endpoint_id:GraphqlController#execute,db_config_name:main*/",
"SELECT COUNT(*) FROM \"merge_requests\" WHERE \"merge_requests\".\"target_project_id\" = 40 /*application:test,correlation_id:04bc1d96-c030-4a0c-a3cb-0c3d9844ae6b,endpoint_id:GraphqlController#execute,db_config_name:main*/",
"SELECT EXTRACT(epoch FROM SUM(AGE(merge_request_metrics.merged_at, merge_request_metrics.created_at))) FROM \"merge_requests\" INNER JOIN \"merge_request_metrics\" ON \"merge_request_metrics\".\"merge_request_id\" = \"merge_requests\".\"id\" WHERE \"merge_request_metrics\".\"target_project_id\" = 40 AND \"merge_request_metrics\".\"merged_at\" > \"merge_request_metrics\".\"created_at\" /*application:test,correlation_id:04bc1d96-c030-4a0c-a3cb-0c3d9844ae6b,endpoint_id:GraphqlController#execute,db_config_name:main*/",
"SELECT COUNT(*) FROM \"issues\" WHERE (NOT EXISTS (SELECT 1 FROM \"banned_users\" WHERE (issues.author_id = banned_users.user_id))) AND (\n issues.confidential IS NOT TRUE\n OR (issues.confidential = TRUE\n AND (issues.author_id = 62\n OR EXISTS (SELECT TRUE FROM issue_assignees WHERE user_id = 62 AND issue_id = issues.id)\n OR EXISTS (SELECT 1 FROM \"project_authorizations\" WHERE \"project_authorizations\".\"user_id\" = 62 AND (project_authorizations.project_id = issues.project_id) AND (project_authorizations.access_level >= 20))))) AND \"issues\".\"project_id\" = 40 /*application:test,correlation_id:04bc1d96-c030-4a0c-a3cb-0c3d9844ae6b,endpoint_id:GraphqlController#execute,db_config_name:main*/",
"SELECT SUM(\"issues\".\"weight\") FROM \"issues\" WHERE (NOT EXISTS (SELECT 1 FROM \"banned_users\" WHERE (issues.author_id = banned_users.user_id))) AND (\n issues.confidential IS NOT TRUE\n OR (issues.confidential = TRUE\n AND (issues.author_id = 62\n OR EXISTS (SELECT TRUE FROM issue_assignees WHERE user_id = 62 AND issue_id = issues.id)\n OR EXISTS (SELECT 1 FROM \"project_authorizations\" WHERE \"project_authorizations\".\"user_id\" = 62 AND (project_authorizations.project_id = issues.project_id) AND (project_authorizations.access_level >= 20))))) AND \"issues\".\"project_id\" = 40 /*application:test,correlation_id:04bc1d96-c030-4a0c-a3cb-0c3d9844ae6b,endpoint_id:GraphqlController#execute,db_config_name:main*/",
"SELECT COUNT(*) AS count_all, \"issues\".\"state_id\" AS issues_state_id FROM \"issues\" WHERE (NOT EXISTS (SELECT 1 FROM \"banned_users\" WHERE (issues.author_id = banned_users.user_id))) AND (\n issues.confidential IS NOT TRUE\n OR (issues.confidential = TRUE\n AND (issues.author_id = 62\n OR EXISTS (SELECT TRUE FROM issue_assignees WHERE user_id = 62 AND issue_id = issues.id)\n OR EXISTS (SELECT 1 FROM \"project_authorizations\" WHERE \"project_authorizations\".\"user_id\" = 62 AND (project_authorizations.project_id = issues.project_id) AND (project_authorizations.access_level >= 20))))) AND \"issues\".\"project_id\" = 40 GROUP BY \"issues\".\"state_id\" /*application:test,correlation_id:04bc1d96-c030-4a0c-a3cb-0c3d9844ae6b,endpoint_id:GraphqlController#execute,db_config_name:main*/",
"SELECT \"environments\".* FROM \"environments\" WHERE \"environments\".\"project_id\" = 40 ORDER BY \"environments\".\"id\" ASC LIMIT 1 /*application:test,correlation_id:04bc1d96-c030-4a0c-a3cb-0c3d9844ae6b,endpoint_id:GraphqlController#execute,db_config_name:main*/",
"SELECT \"issues\".* FROM \"issues\" WHERE (NOT EXISTS (SELECT 1 FROM \"banned_users\" WHERE (issues.author_id = banned_users.user_id))) AND (\n issues.confidential IS NOT TRUE\n OR (issues.confidential = TRUE\n AND (issues.author_id = 62\n OR EXISTS (SELECT TRUE FROM issue_assignees WHERE user_id = 62 AND issue_id = issues.id)\n OR EXISTS (SELECT 1 FROM \"project_authorizations\" WHERE \"project_authorizations\".\"user_id\" = 62 AND (project_authorizations.project_id = issues.project_id) AND (project_authorizations.access_level >= 20))))) AND \"issues\".\"project_id\" = 40 ORDER BY \"issues\".\"created_at\" DESC, \"issues\".\"id\" DESC LIMIT 1 /*application:test,correlation_id:04bc1d96-c030-4a0c-a3cb-0c3d9844ae6b,endpoint_id:GraphqlController#execute,db_config_name:main*/",
"SELECT COUNT(*) FROM \"packages_packages\" WHERE \"packages_packages\".\"project_id\" = 40 AND \"packages_packages\".\"version\" IS NOT NULL AND \"packages_packages\".\"package_type\" != 12 AND \"packages_packages\".\"status\" IN (0, 3) /*application:test,correlation_id:04bc1d96-c030-4a0c-a3cb-0c3d9844ae6b,endpoint_id:GraphqlController#execute,db_config_name:main*/",
"SELECT COUNT(*) FROM \"ci_builds\" WHERE \"ci_builds\".\"type\" = 'Ci::Build' AND \"ci_builds\".\"project_id\" = 40 AND (\"ci_builds\".\"status\" NOT IN ('created')) /*application:test,correlation_id:04bc1d96-c030-4a0c-a3cb-0c3d9844ae6b,endpoint_id:GraphqlController#execute,db_config_name:main*/",
"SELECT COUNT(*) FROM \"ci_pipelines\" WHERE \"ci_pipelines\".\"project_id\" = 40 AND \"ci_pipelines\".\"source\" != 12 /*application:test,correlation_id:04bc1d96-c030-4a0c-a3cb-0c3d9844ae6b,endpoint_id:GraphqlController#execute,db_config_name:main*/",
"SELECT \"grafana_integrations\".* FROM \"grafana_integrations\" WHERE \"grafana_integrations\".\"project_id\" = 40 LIMIT 1 /*application:test,correlation_id:04bc1d96-c030-4a0c-a3cb-0c3d9844ae6b,endpoint_id:GraphqlController#execute,db_config_name:main*/",
"SELECT \"project_error_tracking_settings\".* FROM \"project_error_tracking_settings\" WHERE \"project_error_tracking_settings\".\"project_id\" = 40 LIMIT 1 /*application:test,correlation_id:04bc1d96-c030-4a0c-a3cb-0c3d9844ae6b,endpoint_id:GraphqlController#execute,db_config_name:main*/",
"SELECT COUNT(*) FROM \"releases\" WHERE \"releases\".\"project_id\" = 40 AND \"releases\".\"tag\" IS NOT NULL /*application:test,correlation_id:04bc1d96-c030-4a0c-a3cb-0c3d9844ae6b,endpoint_id:GraphqlController#execute,db_config_name:main*/",
"SELECT \"container_expiration_policies\".* FROM \"container_expiration_policies\" WHERE \"container_expiration_policies\".\"project_id\" = 40 LIMIT 1 /*application:test,correlation_id:04bc1d96-c030-4a0c-a3cb-0c3d9844ae6b,endpoint_id:GraphqlController#execute,db_config_name:main*/",
"SELECT COUNT(*) FROM \"container_repositories\" WHERE \"container_repositories\".\"project_id\" = 40 /*application:test,correlation_id:04bc1d96-c030-4a0c-a3cb-0c3d9844ae6b,endpoint_id:GraphqlController#execute,db_config_name:main*/",
"SELECT COUNT(\"ci_pipelines\".\"created_at\") AS count_created_at, date_trunc('day', ci_pipelines.created_at) AS date_trunc_day_ci_pipelines_created_at FROM \"ci_pipelines\" WHERE \"ci_pipelines\".\"project_id\" = 40 AND \"ci_pipelines\".\"created_at\" >= '2021-11-04 00:00:00' AND \"ci_pipelines\".\"created_at\" <= '2021-11-11 23:59:59.999999' GROUP BY date_trunc('day', ci_pipelines.created_at) /*application:test,correlation_id:04bc1d96-c030-4a0c-a3cb-0c3d9844ae6b,endpoint_id:GraphqlController#execute,db_config_name:main*/",
"SELECT COUNT(\"ci_pipelines\".\"created_at\") AS count_created_at, date_trunc('day', ci_pipelines.created_at) AS date_trunc_day_ci_pipelines_created_at FROM \"ci_pipelines\" WHERE \"ci_pipelines\".\"project_id\" = 40 AND \"ci_pipelines\".\"created_at\" >= '2021-11-04 00:00:00' AND \"ci_pipelines\".\"created_at\" <= '2021-11-11 23:59:59.999999' AND (\"ci_pipelines\".\"status\" IN ('success')) GROUP BY date_trunc('day', ci_pipelines.created_at) /*application:test,correlation_id:04bc1d96-c030-4a0c-a3cb-0c3d9844ae6b,endpoint_id:GraphqlController#execute,db_config_name:main*/",
"SELECT COUNT(\"ci_pipelines\".\"created_at\") AS count_created_at, date_trunc('day', ci_pipelines.created_at) AS date_trunc_day_ci_pipelines_created_at FROM \"ci_pipelines\" WHERE \"ci_pipelines\".\"project_id\" = 40 AND \"ci_pipelines\".\"created_at\" >= '2021-10-11 00:00:00' AND \"ci_pipelines\".\"created_at\" <= '2021-11-11 23:59:59.999999' GROUP BY date_trunc('day', ci_pipelines.created_at) /*application:test,correlation_id:04bc1d96-c030-4a0c-a3cb-0c3d9844ae6b,endpoint_id:GraphqlController#execute,db_config_name:main*/",
"SELECT COUNT(\"ci_pipelines\".\"created_at\") AS count_created_at, date_trunc('day', ci_pipelines.created_at) AS date_trunc_day_ci_pipelines_created_at FROM \"ci_pipelines\" WHERE \"ci_pipelines\".\"project_id\" = 40 AND \"ci_pipelines\".\"created_at\" >= '2021-10-11 00:00:00' AND \"ci_pipelines\".\"created_at\" <= '2021-11-11 23:59:59.999999' AND (\"ci_pipelines\".\"status\" IN ('success')) GROUP BY date_trunc('day', ci_pipelines.created_at) /*application:test,correlation_id:04bc1d96-c030-4a0c-a3cb-0c3d9844ae6b,endpoint_id:GraphqlController#execute,db_config_name:main*/",
"SELECT COUNT(\"ci_pipelines\".\"created_at\") AS count_created_at, date_trunc('month', ci_pipelines.created_at) AS date_trunc_month_ci_pipelines_created_at FROM \"ci_pipelines\" WHERE \"ci_pipelines\".\"project_id\" = 40 AND \"ci_pipelines\".\"created_at\" >= '2020-11-01 00:00:00' AND \"ci_pipelines\".\"created_at\" <= '2021-11-30 23:59:59.999999' GROUP BY date_trunc('month', ci_pipelines.created_at) /*application:test,correlation_id:04bc1d96-c030-4a0c-a3cb-0c3d9844ae6b,endpoint_id:GraphqlController#execute,db_config_name:main*/",
"SELECT COUNT(\"ci_pipelines\".\"created_at\") AS count_created_at, date_trunc('month', ci_pipelines.created_at) AS date_trunc_month_ci_pipelines_created_at FROM \"ci_pipelines\" WHERE \"ci_pipelines\".\"project_id\" = 40 AND \"ci_pipelines\".\"created_at\" >= '2020-11-01 00:00:00' AND \"ci_pipelines\".\"created_at\" <= '2021-11-30 23:59:59.999999' AND (\"ci_pipelines\".\"status\" IN ('success')) GROUP BY date_trunc('month', ci_pipelines.created_at) /*application:test,correlation_id:04bc1d96-c030-4a0c-a3cb-0c3d9844ae6b,endpoint_id:GraphqlController#execute,db_config_name:main*/",
"SELECT \"ci_pipelines\".* FROM \"ci_pipelines\" WHERE \"ci_pipelines\".\"project_id\" = 40 ORDER BY \"ci_pipelines\".\"id\" DESC LIMIT 30 /*application:test,correlation_id:04bc1d96-c030-4a0c-a3cb-0c3d9844ae6b,endpoint_id:GraphqlController#execute,db_config_name:main*/",
"SELECT COUNT(*) FROM \"labels\" WHERE \"labels\".\"type\" = 'ProjectLabel' AND \"labels\".\"project_id\" = 40 /*application:test,correlation_id:04bc1d96-c030-4a0c-a3cb-0c3d9844ae6b,endpoint_id:GraphqlController#execute,db_config_name:main*/",
"SELECT \"ci_pipelines\".* FROM \"ci_pipelines\" WHERE \"ci_pipelines\".\"project_id\" = 40 AND (\"ci_pipelines\".\"source\" IN (1, 2, 3, 4, 5, 6, 7, 8, 10, 11) OR \"ci_pipelines\".\"source\" IS NULL) AND \"ci_pipelines\".\"ref\" = 'master' AND \"ci_pipelines\".\"sha\" = 'b83d6e391c22777fca1ed3012fce84f633d7fed0' AND \"ci_pipelines\".\"id\" IN (SELECT \"ci_pipelines\".\"id\" FROM \"ci_pipelines\" WHERE \"ci_pipelines\".\"project_id\" = 40 AND (\"ci_pipelines\".\"source\" IN (1, 2, 3, 4, 5, 6, 7, 8, 10, 11) OR \"ci_pipelines\".\"source\" IS NULL) AND \"ci_pipelines\".\"ref\" = 'master' AND \"ci_pipelines\".\"sha\" = 'b83d6e391c22777fca1ed3012fce84f633d7fed0' ORDER BY \"ci_pipelines\".\"id\" DESC LIMIT 100) ORDER BY \"ci_pipelines\".\"id\" DESC LIMIT 1 /*application:test,correlation_id:04bc1d96-c030-4a0c-a3cb-0c3d9844ae6b,endpoint_id:GraphqlController#execute,db_config_name:main*/",
"SELECT \"ci_builds\".\"status\", \"ci_builds\".\"finished_at\", \"ci_builds\".\"trace\", \"ci_builds\".\"created_at\", \"ci_builds\".\"updated_at\", \"ci_builds\".\"started_at\", \"ci_builds\".\"runner_id\", \"ci_builds\".\"coverage\", \"ci_builds\".\"commit_id\", \"ci_builds\".\"name\", \"ci_builds\".\"options\", \"ci_builds\".\"allow_failure\", \"ci_builds\".\"stage\", \"ci_builds\".\"trigger_request_id\", \"ci_builds\".\"stage_idx\", \"ci_builds\".\"tag\", \"ci_builds\".\"ref\", \"ci_builds\".\"user_id\", \"ci_builds\".\"type\", \"ci_builds\".\"target_url\", \"ci_builds\".\"description\", \"ci_builds\".\"project_id\", \"ci_builds\".\"erased_by_id\", \"ci_builds\".\"erased_at\", \"ci_builds\".\"artifacts_expire_at\", \"ci_builds\".\"environment\", \"ci_builds\".\"when\", \"ci_builds\".\"yaml_variables\", \"ci_builds\".\"queued_at\", \"ci_builds\".\"token\", \"ci_builds\".\"lock_version\", \"ci_builds\".\"coverage_regex\", \"ci_builds\".\"auto_canceled_by_id\", \"ci_builds\".\"retried\", \"ci_builds\".\"protected\", \"ci_builds\".\"failure_reason\", \"ci_builds\".\"scheduled_at\", \"ci_builds\".\"token_encrypted\", \"ci_builds\".\"upstream_pipeline_id\", \"ci_builds\".\"resource_group_id\", \"ci_builds\".\"waiting_for_resource_at\", \"ci_builds\".\"processed\", \"ci_builds\".\"scheduling_type\", \"ci_builds\".\"id\", \"ci_builds\".\"stage_id\" FROM \"ci_builds\" INNER JOIN \"ci_builds_metadata\" ON \"ci_builds_metadata\".\"build_id\" = \"ci_builds\".\"id\" WHERE \"ci_builds\".\"type\" = 'Ci::Build' AND \"ci_builds\".\"commit_id\" = 74 AND (ci_builds_metadata.config_options -> 'artifacts' -> 'reports' ?| array['sast','dast','dependency_scanning','container_scanning','secret_detection','coverage_fuzzing','api_fuzzing','cluster_image_scanning']) /*application:test,correlation_id:04bc1d96-c030-4a0c-a3cb-0c3d9844ae6b,endpoint_id:GraphqlController#execute,db_config_name:main*/",
"SELECT \"ci_builds\".\"status\", \"ci_builds\".\"finished_at\", \"ci_builds\".\"trace\", \"ci_builds\".\"created_at\", \"ci_builds\".\"updated_at\", \"ci_builds\".\"started_at\", \"ci_builds\".\"runner_id\", \"ci_builds\".\"coverage\", \"ci_builds\".\"commit_id\", \"ci_builds\".\"name\", \"ci_builds\".\"options\", \"ci_builds\".\"allow_failure\", \"ci_builds\".\"stage\", \"ci_builds\".\"trigger_request_id\", \"ci_builds\".\"stage_idx\", \"ci_builds\".\"tag\", \"ci_builds\".\"ref\", \"ci_builds\".\"user_id\", \"ci_builds\".\"type\", \"ci_builds\".\"target_url\", \"ci_builds\".\"description\", \"ci_builds\".\"project_id\", \"ci_builds\".\"erased_by_id\", \"ci_builds\".\"erased_at\", \"ci_builds\".\"artifacts_expire_at\", \"ci_builds\".\"environment\", \"ci_builds\".\"when\", \"ci_builds\".\"yaml_variables\", \"ci_builds\".\"queued_at\", \"ci_builds\".\"token\", \"ci_builds\".\"lock_version\", \"ci_builds\".\"coverage_regex\", \"ci_builds\".\"auto_canceled_by_id\", \"ci_builds\".\"retried\", \"ci_builds\".\"protected\", \"ci_builds\".\"failure_reason\", \"ci_builds\".\"scheduled_at\", \"ci_builds\".\"token_encrypted\", \"ci_builds\".\"upstream_pipeline_id\", \"ci_builds\".\"resource_group_id\", \"ci_builds\".\"waiting_for_resource_at\", \"ci_builds\".\"processed\", \"ci_builds\".\"scheduling_type\", \"ci_builds\".\"id\", \"ci_builds\".\"stage_id\" FROM \"ci_builds\" INNER JOIN \"ci_builds_metadata\" ON \"ci_builds_metadata\".\"build_id\" = \"ci_builds\".\"id\" WHERE \"ci_builds\".\"type\" = 'Ci::Build' AND \"ci_builds\".\"commit_id\" = 74 AND (ci_builds_metadata.config_options -> 'artifacts' -> 'reports' ?| array['license_scanning']) /*application:test,correlation_id:04bc1d96-c030-4a0c-a3cb-0c3d9844ae6b,endpoint_id:GraphqlController#execute,db_config_name:main*/",
"SELECT \"push_rules\".* FROM \"push_rules\" WHERE \"push_rules\".\"project_id\" = 40 LIMIT 1 /*application:test,correlation_id:04bc1d96-c030-4a0c-a3cb-0c3d9844ae6b,endpoint_id:GraphqlController#execute,db_config_name:main*/",
"SELECT \"ci_build_report_results\".* FROM \"ci_build_report_results\" INNER JOIN \"ci_builds\" ON \"ci_build_report_results\".\"build_id\" = \"ci_builds\".\"id\" WHERE \"ci_builds\".\"type\" = 'Ci::Build' AND \"ci_builds\".\"commit_id\" = 70 AND (\"ci_builds\".\"retried\" = FALSE OR \"ci_builds\".\"retried\" IS NULL) /*application:test,correlation_id:04bc1d96-c030-4a0c-a3cb-0c3d9844ae6b,endpoint_id:GraphqlController#execute,db_config_name:main*/",
"SELECT \"security_scans\".* FROM \"security_scans\" WHERE \"security_scans\".\"pipeline_id\" = 70 AND \"security_scans\".\"scan_type\" IN (1, 2, 3, 4, 5, 6, 7, 8) /*application:test,correlation_id:04bc1d96-c030-4a0c-a3cb-0c3d9844ae6b,endpoint_id:GraphqlController#execute,db_config_name:main*/",
"SELECT \"ci_builds\".\"status\", \"ci_builds\".\"finished_at\", \"ci_builds\".\"trace\", \"ci_builds\".\"created_at\", \"ci_builds\".\"updated_at\", \"ci_builds\".\"started_at\", \"ci_builds\".\"runner_id\", \"ci_builds\".\"coverage\", \"ci_builds\".\"commit_id\", \"ci_builds\".\"name\", \"ci_builds\".\"options\", \"ci_builds\".\"allow_failure\", \"ci_builds\".\"stage\", \"ci_builds\".\"trigger_request_id\", \"ci_builds\".\"stage_idx\", \"ci_builds\".\"tag\", \"ci_builds\".\"ref\", \"ci_builds\".\"user_id\", \"ci_builds\".\"type\", \"ci_builds\".\"target_url\", \"ci_builds\".\"description\", \"ci_builds\".\"project_id\", \"ci_builds\".\"erased_by_id\", \"ci_builds\".\"erased_at\", \"ci_builds\".\"artifacts_expire_at\", \"ci_builds\".\"environment\", \"ci_builds\".\"when\", \"ci_builds\".\"yaml_variables\", \"ci_builds\".\"queued_at\", \"ci_builds\".\"token\", \"ci_builds\".\"lock_version\", \"ci_builds\".\"coverage_regex\", \"ci_builds\".\"auto_canceled_by_id\", \"ci_builds\".\"retried\", \"ci_builds\".\"protected\", \"ci_builds\".\"failure_reason\", \"ci_builds\".\"scheduled_at\", \"ci_builds\".\"token_encrypted\", \"ci_builds\".\"upstream_pipeline_id\", \"ci_builds\".\"resource_group_id\", \"ci_builds\".\"waiting_for_resource_at\", \"ci_builds\".\"processed\", \"ci_builds\".\"scheduling_type\", \"ci_builds\".\"id\", \"ci_builds\".\"stage_id\" FROM \"ci_builds\" WHERE \"ci_builds\".\"type\" = 'Ci::Build' AND \"ci_builds\".\"commit_id\" = 70 AND (\"ci_builds\".\"retried\" = FALSE OR \"ci_builds\".\"retried\" IS NULL) AND (EXISTS (SELECT 1 FROM \"ci_job_artifacts\" WHERE (ci_builds.id = ci_job_artifacts.job_id) AND \"ci_job_artifacts\".\"file_type\" IN (5, 6, 7, 8, 21, 23, 26, 27))) /*application:test,correlation_id:04bc1d96-c030-4a0c-a3cb-0c3d9844ae6b,endpoint_id:GraphqlController#execute,db_config_name:main*/",
"SELECT \"ci_builds\".\"status\", \"ci_builds\".\"finished_at\", \"ci_builds\".\"trace\", \"ci_builds\".\"created_at\", \"ci_builds\".\"updated_at\", \"ci_builds\".\"started_at\", \"ci_builds\".\"runner_id\", \"ci_builds\".\"coverage\", \"ci_builds\".\"commit_id\", \"ci_builds\".\"name\", \"ci_builds\".\"options\", \"ci_builds\".\"allow_failure\", \"ci_builds\".\"stage\", \"ci_builds\".\"trigger_request_id\", \"ci_builds\".\"stage_idx\", \"ci_builds\".\"tag\", \"ci_builds\".\"ref\", \"ci_builds\".\"user_id\", \"ci_builds\".\"type\", \"ci_builds\".\"target_url\", \"ci_builds\".\"description\", \"ci_builds\".\"project_id\", \"ci_builds\".\"erased_by_id\", \"ci_builds\".\"erased_at\", \"ci_builds\".\"artifacts_expire_at\", \"ci_builds\".\"environment\", \"ci_builds\".\"when\", \"ci_builds\".\"yaml_variables\", \"ci_builds\".\"queued_at\", \"ci_builds\".\"token\", \"ci_builds\".\"lock_version\", \"ci_builds\".\"coverage_regex\", \"ci_builds\".\"auto_canceled_by_id\", \"ci_builds\".\"retried\", \"ci_builds\".\"protected\", \"ci_builds\".\"failure_reason\", \"ci_builds\".\"scheduled_at\", \"ci_builds\".\"token_encrypted\", \"ci_builds\".\"upstream_pipeline_id\", \"ci_builds\".\"resource_group_id\", \"ci_builds\".\"waiting_for_resource_at\", \"ci_builds\".\"processed\", \"ci_builds\".\"scheduling_type\", \"ci_builds\".\"id\", \"ci_builds\".\"stage_id\" FROM \"ci_builds\" WHERE \"ci_builds\".\"type\" = 'Ci::Build' AND \"ci_builds\".\"commit_id\" = 70 AND (\"ci_builds\".\"retried\" = FALSE OR \"ci_builds\".\"retried\" IS NULL) AND (EXISTS (SELECT 1 FROM \"ci_job_artifacts\" WHERE (ci_builds.id = ci_job_artifacts.job_id) AND \"ci_job_artifacts\".\"file_type\" = 9)) /*application:test,correlation_id:04bc1d96-c030-4a0c-a3cb-0c3d9844ae6b,endpoint_id:GraphqlController#execute,db_config_name:main*/",
"SELECT \"dast_profiles_pipelines\".\"dast_profile_id\" FROM \"dast_profiles_pipelines\" WHERE \"dast_profiles_pipelines\".\"ci_pipeline_id\" = 70 /*application:test,correlation_id:04bc1d96-c030-4a0c-a3cb-0c3d9844ae6b,endpoint_id:GraphqlController#execute,db_config_name:main*/",
"SELECT \"users\".* FROM \"users\" WHERE \"users\".\"id\" = 0 /*application:test,correlation_id:04bc1d96-c030-4a0c-a3cb-0c3d9844ae6b,endpoint_id:GraphqlController#execute,db_config_name:main*/",
"SELECT \"project_statistics\".* FROM \"project_statistics\" WHERE \"project_statistics\".\"project_id\" = 40 /*application:test,correlation_id:04bc1d96-c030-4a0c-a3cb-0c3d9844ae6b,endpoint_id:GraphqlController#execute,db_config_name:main*/",
"WITH \"latest_by_project\" AS MATERIALIZED (SELECT \"ci_daily_build_group_report_results\".\"project_id\", MAX(date) AS date FROM \"ci_daily_build_group_report_results\" WHERE \"ci_daily_build_group_report_results\".\"project_id\" = 40 AND ((data->'coverage') IS NOT NULL) AND \"ci_daily_build_group_report_results\".\"default_branch\" = TRUE GROUP BY \"ci_daily_build_group_report_results\".\"project_id\") SELECT \"ci_daily_build_group_report_results\".\"project_id\", ROUND(AVG(CAST(data ->> 'coverage' AS DECIMAL)), 2)::FLOAT, COUNT(*), \"latest_by_project\".date FROM \"ci_daily_build_group_report_results\" JOIN latest_by_project ON ci_daily_build_group_report_results.date = latest_by_project.date\n AND ci_daily_build_group_report_results.project_id = latest_by_project.project_id WHERE \"ci_daily_build_group_report_results\".\"project_id\" = 40 AND ((data->'coverage') IS NOT NULL) AND \"ci_daily_build_group_report_results\".\"default_branch\" = TRUE GROUP BY \"ci_daily_build_group_report_results\".\"project_id\", \"latest_by_project\".\"date\" /*application:test,correlation_id:04bc1d96-c030-4a0c-a3cb-0c3d9844ae6b,endpoint_id:GraphqlController#execute,db_config_name:main*/"]Screenshots or screen recordings
These are strongly recommended to assist reviewers and reduce the time to merge your change.
How to set up and validate locally
Numbered steps to set up and validate the change are strongly suggested.
MR acceptance checklist
This checklist encourages us to confirm any changes have been analyzed to reduce risks in quality, performance, reliability, security, and maintainability.
-
I have evaluated the MR acceptance checklist for this MR.
Edited by Marcos Rocha