Wednesday, April 1, 2020

[google-cloud-sql-discuss] Re: TOOLS to use to TUNE SLOW QUERIES in Postgresql CLOUD SQL ?

Hi Harrison,

You may consider using a pipeline with Cloud Stackdriver Logging and Cloud Monitoring to identify slow queries. This article explains how to spot slow MySQL queries fast with Stackdriver Monitoring, and you may take similar steps for your Cloud PostgreSQL queries.

I also recommend to take a look at Performance tips where it gives some tips on how to improve the performance of slow database queries. As noted in the general performance tips, you may use EXPLAIN to pinpoint where to add indexes to tables to improve query performance. 



 


--
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/37ca37f1-b7e3-4ea7-a0fe-1809b5b8351e%40googlegroups.com.

No comments:

Post a Comment