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.
×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.
Question