Query Performance Investigation - Query ID - 2730865188467600000 (notification_settings table)

Description

This query is among top 10 queries by row list

/ application : sidekiq, 
correlation_id : 01F18KS8MAT2AYD8DWKG067S67, 
jid : ac70d5995f504f34f8e62dd4, 
job_class : NewNoteWorker, 
endpoint_id : NewNoteWorker / 
SELECT 
  "notification_settings"."user_id" 
FROM 
  "notification_settings" 
WHERE 
  "notification_settings"."source_type" = $1 
  AND "notification_settings"."source_id" = $2 
  AND "notification_settings"."level" = $3

Data points

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

• rows: 251878596
• Queries per second (on average or peak):
• 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)
• Query ID
• Query Plan
• Query Example
• Total number of calls (relative)
• % of Total time

Tools for finding more information

• https://gitlab.com/gitlab-com/runbooks/-/blob/master/docs/patroni/pg_collect_query_data.md#searching-postgresql-logs-with-kibanaelasticsearch