Tuesday, February 13, 2018

[google-cloud-sql-discuss] How to know if throttling occured?

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

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/62da476d-5f3e-440c-b141-3b22bc4f7a9c%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

No comments:

Post a Comment