Monitoring number of connections
I choose Neon hoping to make use of scaling to zero.
However, Neon compute never gets idle with my application.
It is not Neon's fault, but our application seems not to close idle DB connections.
However, I cannot verify it because I have no way to monitor the number of active DB connections on Neon's side.
It would be great if Neon also supports number of DB connections in the endpoint metrics. It will help users fine-tune their DB connections and serverless compute a lot.
2 Replies
like-gold•2y ago
Hey, thanks for the feedback! This is on the way. In the meantime, here are some queries you can use:
https://neon.tech/docs/postgres/query-reference#connections
There's also this open source third-party tool that offers connection monitoring:
https://neon.tech/docs/introduction/monitoring#pghero
Neon
Postgres query reference - Neon Docs
Create a table See CREATE TABLE for more information. Add, rename, drop a column See ALTER TABLE for more information. Insert, update, delete data See INSERT, UPDATE, and DELETE for more information. ...
Neon
Monitoring in Neon - Neon Docs
Overview To find out what's going on with your Neon projects and databases, Neon offers several ways to visualize your usage and track your metrics Project dashboard &8212; Find widgets that display t...
fair-roseOP•2y ago
Glad to hear you guys are working on it, thanks!