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