Query analytics
It would be great to have query analytics. The best example is PlanetScale their analytics are really good and informative!
5 Replies
rare-sapphireOP•2y ago
Turso recently launched a similar service: https://turso.tech/blog/database-analytics-with-ai-insights
Launch Week Day 5: Database Analytics with AI Insights
Database analytics are available to all Turso users.
rare-sapphireOP•2y ago
Query Insights
Find and optimize long-running queries in your application, anomalies in your database, and more.
absent-sapphire•2y ago
We agree completely. Observability is a high-priority item for us. You can expect some features in this area in the near future. In the meantime, the pg_stat_statements extension might be useful to you. There's an intro in this blog post:
https://neon.tech/blog/postgres-support-recap-investigating-postgres-query-performance
There's also an open-source third-party app called PgHero, if you prefer a visual monitoring/observability tool. That's covered in the blog as well.
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 […]
dependent-tan•2y ago
Others, such as dexter, can provide some good insights: https://github.com/ankane/dexter
GitHub
GitHub - ankane/dexter: The automatic indexer for Postgres
The automatic indexer for Postgres. Contribute to ankane/dexter development by creating an account on GitHub.
dependent-tan•2y ago
GitHub
GitHub - supabase/index_advisor: PostgreSQL Index Advisor
PostgreSQL Index Advisor. Contribute to supabase/index_advisor development by creating an account on GitHub.