[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
5 Replies
optimistic-gold•2y ago
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 […]
optimistic-gold•2y ago
Having a UI feature for this would be awesome, I'll ask around internally
fascinating-indigoOP•2y ago
yeah, having a UI for it would be amazing!
extended-salmon•2y ago
It's definitely on the list of features we want to support
extended-salmon•2y ago
If you are interested in looking at
pg_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.
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.