Query Performance Investigation - Query ID - 6386890822646776524 (users and project_authorizations tables)

Description

This query is frequently reported as top 10 in total time taken during the monitoring period.

SELECT "users".*
FROM "users" INNER JOIN "project_authorizations" ON "users"."id" = "project_authorizations"."user_id"
WHERE "project_authorizations"."project_id" = $1 
--application:web,correlation_id:1UUb7KNTS51/ 

Requested Data points

Please provide as many of these fields as possible when submitting a query performance report.

• Database time relative to total database time
• Source of calls (Sidekiq, WebAPI, etc)- --application:web,correlation_id:1UUb7KNTS51/
• Query ID - 6386890822646776524
• % of Total time - less than 1% (approximately 1 second over 15 minutes)