TOOLS to use to TUNE SLOW QUERIES in Postgresql CLOUD SQL ?

42 views
Skip to first unread message

Harrison Akum

unread,
Mar 30, 2020, 9:06:31 AM3/30/20
to Google Cloud SQL discuss
Hi guys,

Apart from using "EXPLAIN ANALYZE". Is there another tool that can be used to ANALYZE slow queries in postgres cloud sql and the provides RECOMMENDATIONS on where to create indexes, partitioning table, modifying query etc

Thank you for your suggestions 

Thanks
Harry

Katayoon (Cloud Platform Support)

unread,
Apr 1, 2020, 9:52:54 AM4/1/20
to Google Cloud SQL discuss
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. 



 


Reply all
Reply to author
Forward
0 new messages