That viz is very light to render, and it should return quickly. So yeah, having it take that long is concerning. From the last question you filed, I'm assuming that both environments are showing an issue because the VizAlertsConfig connection still points to your PROD postgresql repository database, and not that of the NEW PROD environment. Make sure it's switched, then this should go away for the new prod environment.
As for PROD, I would absolutely check your CPU utilization on the repository host, because if a simple query like that is taking a long time to run, that's no bueno, I'd say you've got scaling or degradation issues to deal with.
You know, I changed all my VA workbook's data connections to point at the QA server but totally forgot about the actual VA workbook Thanks Matt.
And yes, definitely having some capacity issues.