Query Performance Investigation - Query ID 6504150523421693673 (tags table)
Description
This query is frequently reported as top 10 in total number of calls during the monitoring period.
SELECT "tags".*
FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id"
WHERE "taggings"."taggable_id" = $1 AND "taggings"."taggable_type" = $2 AND (taggings.context = $3 AND taggings.tagger_id IS NULL)
--application:web,correlation_id:dnT2GXhKuX2/
Requested Data points
Please provide as many of these fields as possible when submitting a query performance report.
- Queries per second (on average or peak) - 671
- Number of calls per second and relative to total number of calls
- Query timings (on average or peak)
- Database time relative to total database time
- Source of calls (Sidekiq, WebAPI, etc) --application:web,correlation_id:dnT2GXhKuX2/
- Query ID - 6504150523421693673
Edited by Craig Gomes