Hi all,
I have a question regarding Postgres SQL.
A long-running query ran three times over the last couple of days. The first time it took about 20 minutes, the next time about 4 hours, the last time, well (my measurement timed out), longer than 4 hours.
Now I am working my way through
https://cloud.google.com/sql/docs/postgres/diagnose-issues and stumbled across this line:
If your workload consists of CPU intensive queries (sorting, regexes, other complex functions), your instance might be throttled; add vCPUs.
Is this saying that active throttling might occur if I max out the CPUs?
If so, how do I find out whether I am being throttled?
The reason I am asking is that over the last couple of days my CPU usage did look like this (and my slow queries occured after the big 95% block). After the block no query bumps the load over 20%...
Thanks!
Stephan