Is there a slow query log for a managed database?

Question

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?

Answer 1

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

mpaiva July 14, 2021

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.
Reply Report

Answer 2

mpaiva July 14, 2021

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.
Reply Report

Related