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

[Harrison Akum]

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)]

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.