Question

Is there a slow query log for a managed database?

Posted December 2, 2019 316 views
DigitalOcean Managed PostgreSQL Database

I want to tune my application and for this I want to see the slow running queries. Is this available for a postgres managed database?

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

×
1 answer

Contacted support regarding this. Their answer:

Since the database is managed on our end it isn’t possible to access the cluster to enable slow_query_log directly.

The general_log and slow_query_log_file can be seen under the “Queries” sub-tab of your database cluster.

The long_query_time is set to 10.000000

Regarding changing long_query_time:

Currently, it is not possible to edit the the same. We are looking at this for the future but at this time it’s not possible.

Submit an Answer