Is there a slow query log for a managed database?

Posted December 2, 2019 3.2k 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.

Submit an Answer
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.

  • I can’t find where are the slow queries. I have the tab Log & Queries, but there is no separation for slow queries or even a way to sort it by time.