Any time an admin hits the admin dashboard page it triggers two count(*) on the Image table which are slow because the Image table is large and Postgres count()s are slow on large tables. This issue is exacerbated by the dashboard reloading the image counts every 5 seconds.
Suggest making the image counts a manual load that do not refresh automatically.
Any time an admin hits the admin dashboard page it triggers two count(*) on the Image table which are slow because the Image table is large and Postgres count()s are slow on large tables. This issue is exacerbated by the dashboard reloading the image counts every 5 seconds.
Suggest making the image counts a manual load that do not refresh automatically.