Best way to identify slow queries?

Hi,

What is the recommended way to identify slow queries? I’m looking for something similar to the Diagnose tab at Heroku.

People have requested slow query logs at the Render feature requests site.

Anurag mentioned a slow query list in 2020, but that doesn’t seem to have been included with the database metrics that were added in 2021.

Thanks for your time,
David

Hi David,

We currently don’t support analyzing slow queries for PostgreSQL. I’ve added your vote to the feature request on feedback.render.com to help us prioritize the work.