How to enable slow query log on Google cloud postgres

Question

The documentation says how to enable slow query log for MySQL but there is nothing for Postgres.

How can I enable the Postgres slow query log to debug slow queries? If there is no explicit option, how can I modify the postgres config file to add this myself?

Answer 1

It's not currently possible to enable the log_min_duration_statement flag for Postgres on Cloud SQL.

This feature is being worked on and you can follow its progress here. You can click on the star icon on the top left corner to get email notifications when some news about this feature becomes available.