Neon•2y ago

[Feature Request] - Query insights

it would be great to have a log of all queries that are being made to the database in realtime and see past queries as well

also, i would LOVE if there was an anomalies feature like planetscale to check for underperforming queries: https://planetscale.com/docs/concepts/anomalies

static-pink•3/5/24, 1:14 PM

Did you see our recent article about query performance? Try enable the pg_stat_statements extension! https://neon.tech/blog/postgres-support-recap-investigating-postgres-query-performance#strategy-1-analyzing-query-performance-with-pgstatstatements

Neon

Postgres Support Recap: Investigating Postgres Query Performance - ...

Neon Support often receives support tickets related to Postgres query performance. Such issues could result from a myriad of factors ranging from missing indexes or lack of database maintenance to ineffective queries and joins or system resource limitations. Where should you start when trying to get to the bottom of an issue with such a […]

static-pink•3/5/24, 1:15 PM

Having a UI feature for this would be awesome, I'll ask around internally

worthy-azureOP•3/7/24, 7:51 AM

yeah, having a UI for it would be amazing!

precious-lavender•3/7/24, 2:14 PM

It's definitely on the list of features we want to support

incredible-moccasin•3/7/24, 5:00 PM

If you are interested in looking at pg_stat_statementspg_stat_statements more visually, take a look at pghero, an open source project that works well with Neon:

https://github.com/ankane/pghero

If you are using Docker, it can be a 2 line setup and will leverage those pg_stat_statements tables for deeper insight.

docker pull ankane/pghero
docker run -ti -e DATABASE_URL=$NEON_DB -p 8080:8080 ankane/pghero

docker pull ankane/pghero
docker run -ti -e DATABASE_URL=$NEON_DB -p 8080:8080 ankane/pghero

GitHub

GitHub - ankane/pghero: A performance dashboard for Postgres

A performance dashboard for Postgres. Contribute to ankane/pghero development by creating an account on GitHub.

[Feature Request] - Query insights

Similar Threads

Similar Threads

Similar Threads