search

bensheldon / good_job

Multithreaded, Postgres-based, Active Job backend for Ruby on Rails.
https://goodjob-demo.herokuapp.com/
MIT License
2.69k stars 200 forks source link

Can't load Dashboard #1532

Closed alienxp03 closed 1 day ago

alienxp03 commented 1 week ago

I can't seems to load my main dashboard located at /jobs due to it's taking too long to load. Previously I had 3.5millions job. And now it's down to 700k after I manually run cleanup_preserved_jobs. However the issue still persist. Is there any configuration that I need to be aware of. My current config is pretty simple, just enabled cron and setup few crons to run every few minutes.

Screenshot 2024-10-31 at 9 31 22 AM

Screenshot 2024-10-31 at 9 54 43 AM

GoodJob Version: 3.99

bensheldon commented 2 days ago

Hmmm. Could you try running REINDEX TABLE good_jobs and REINDEX TABLE good_job_executions on your database. There's been reports that helps.

I also wonder if the counts in counts in the Dashboard need to all be moved async. This was done to some of the tabs, but not the dropdowns or the chart (#1231)

alienxp03 commented 1 day ago

Thanks for the tips Ben. Unfortunately I've moved away from using GoodJob for now, so won't be able to confirm the suggested solution 😅

bensheldon commented 1 day ago

No worries 💖