Related

Join the DigitalOcean Community Community

Join 1M+ other developers and:

  • Get help and share knowledge in Q&A
  • Subscribe to topics of interest
  • Get courses & tools that help you grow as a developer or small business owner
 Join Now
How much database space remains available? Question Question
Is it possible to set trusted sources for managed databases from the API or doctl? Question Question

Question

Is there a slow query log for a managed database?

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

Add a comment
phoebebright310
By:
phoebebright310

Related

Join the DigitalOcean Community Community

Join 1M+ other developers and:

  • Get help and share knowledge in Q&A
  • Subscribe to topics of interest
  • Get courses & tools that help you grow as a developer or small business owner
 Join Now
How much database space remains available? Question Question
Is it possible to set trusted sources for managed databases from the API or doctl? Question Question

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
ognjen December 17, 2019

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.

Reply Report

Related

Looking for something else?

Ask a new question Search for more help