https://dagster.io/ logo
#ask-community
Title
# ask-community
e

Eduardo Muñoz

05/04/2023, 1:03 PM
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:
Copy code
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?
image.png
c

chris

05/04/2023, 4:32 PM
This is sensors + schedules - do you have a ton of these active?
e

Eduardo Muñoz

05/09/2023, 8:45 AM
What would you consider "a ton"?
c

chris

05/10/2023, 8:02 PM
thousands - but ultimately depends on what type of storage you’re using
e

Eduardo Muñoz

05/15/2023, 8:20 AM
around 50 or so we are using an aws rds
db.t3.micro
2 Views