Tips for debugging/optimizing slow dashboard? (45 second response time)

bensheldon / good_job

Multithreaded, Postgres-based, Active Job backend for Ruby on Rails.

https://goodjob-demo.herokuapp.com/

MIT License

2.53k stars 190 forks source link

Tips for debugging/optimizing slow dashboard? (45 second response time) #1366

Closed marckohlbrugge closed 1 month ago

marckohlbrugge commented 1 month ago

GoodJob's dashboard for one of my larger apps (with many background jobs) takes a long time to load. I just checked and it takes 45 seconds to load it right now.

I think it's worse depending on whether I'm filtering the jobs.

Performance of the background jobs seems fine. It's just that the dashboard seems to have very slow database queries.

Is this a common issue?
Are there ways to fix this?

marckohlbrugge commented 1 month ago

Moving this to Discussions instead. https://github.com/bensheldon/good_job/discussions/1367