We recently announced our PostgreSQL Monitoring integration and now we have a PostgreSQL Logs integration to complement it. Logagent can be easily set up to parse the main log file and send the resulting JSON logs to your PostgreSQL Logs App.
Once data is in, you can create your own dashboards or use the built-in ones. We particularly like the Statements report, because it allows you to correlate metrics about rows, indexes and buffers (from our PostgreSQL Monitoring integration) with the actual queries and how long they took:
Feel free to create a new PostgreSQL Logs App or check out the documentation to learn more. In Troubleshooting PostgreSQL: How to Use Logs and Metrics to Fix Slow Queries we described a real-life scenario where we used this new functionality along with Split Screen to identify slow queries and fix them after spotting database performance metric spikes.