Expose Postgres Logs
complete
A
Avi Itskovich
We'd like to have access to the logs emitted by Postgres for a variety of reasons including:
* Audit Logging
* Performance Debugging
* Observability
Biggest motivator here is audit logging. A plus would be having these logs automatically piped to LogDNA.
Log In
H
Hari Demirev
complete
Postgres logs are now available for all new databases, both via the dashboard and Render Log Streams [0].
For existing databases, a configuration change is required in order to enable logs, and this necessitates a restart of the database with limited downtime. If you would like to have logs enabled for an existing database, please contact us at support@render.com so that we can coordinate an update to your database.
a
alex.lesman
Being able to identify specific slow queries and dig into them is huge for improving database performance, logging slow queries (and even auto-explaining slow queries) is super helpful. Article summarizing some applications:
Anurag Goel
Merged in a post:
Record database connection information
d
danielle
It would be nice to record connection attempts and connection duration to databases.
Anurag Goel
planned