Hey, Our RDS instance for Dagster has been given us some performance issues. I've turned on Performance Insights and the following query seems to be the culprit:

SELECT job_ticks.id, job_ticks.tick_body
FROM job_ticks 
WHERE 
  job_ticks.selector_id = ? 
  OR 
  job_ticks.selector_id IS NULL 
  AND job_ticks.job_origin_id = ? 
ORDER BY job_ticks.timestamp DESC LIMIT ?

Is there something we can do to reduce the impact of this query?

This is sensors + schedules - do you have a ton of these active?

What would you consider "a ton"?

thousands - but ultimately depends on what type of storage you’re using

around 50 or so we are using an aws rds

db.t3.micro