[google-cloud-sql-discuss] Re: Cloud SQL Postgres log_min_duration_statement

Hello,

Now the flag "log_min_duration_statement" is available, according to this: https://cloud.google.com/sql/docs/postgres/flags

Also, thanks Taher for the link to the Feature Request, I starred it!

Best Regards,

On Tuesday, March 20, 2018 at 8:52:35 PM UTC-3, Taher (Cloud Platform Support) wrote:

Hello Jesse,

Unfortunately, on CloudSQL for PostgreSQL, there is no slow query log supported flag.  Moreover, I believe the flag log_min_duration_statement requires SUPER privilege to change the setting which is not allowed in CloudSQL.

However, there is an open feature request for allowing slow query logging support for PostgreSQL. I would suggest you comment on the feature request and star it to attract more attention to it.

That said, I would also suggest going over our performance documentation for PostgreSQL instances which might help you resolve the slow query issue. If there are specific queries which are causing the performance issue, you can run EXPLAIN on those slow queries to find out where to add indexes.

Hope this helps.

--
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/608514d1-9caa-4da5-900e-93fa73a4832d%40googlegroups.com.