Users::RefreshAuthorizedProjectsService consumes 40% of all rows returned from the primary database instance
-
queryID
5005987689040900854
-
Table:
project_authorizations
-
TPS
https://thanos-query.ops.gitlab.net/graph?g0.range_input=2d&g0.end_input=2021-02-05%2013%3A35&g0.step_input=30&g0.moment_input=2021-02-01%2011%3A00%3A00&g0.max_source_resolution=0s&g0.expr=rate(pg_stat_statements_calls%7Bqueryid%3D%225005987689040900854%22%7D%5B1m%5D)&g0.tab=0
-
Duration
https://thanos-query.ops.gitlab.net/graph?g0.range_input=2d&g0.end_input=2021-02-05%2013%3A35&g0.step_input=30&g0.moment_input=2021-02-01%2011%3A00%3A00&g0.max_source_resolution=0s&g0.expr=rate(pg_stat_statements_seconds_total%7Bqueryid%3D%225005987689040900854%22%7D%5B10m%5D)&g0.tab=0
-
Query ID - 5005987689040900854
-
SQL Statement -
SELECT "project_authorizations"."project_id", "project_authorizations"."access_level"
FROM "project_authorizations" WHERE "project_authorizations"."user_id" = $1
/*application:sidekiq,correlation_id:e1fa81c126e0c13db94f7c7a23d83ee7,jid:ba730571a1aef0f7a7f41565,job_class:AuthorizedProjectUpdate::UserRefreshWithLowUrgencyWorker*/
- Query Plan
- Query Example
Edited by Andrew Newdigate