PostgreSQL Logs Integration
To make use of the Sematext PostgreSQL Logs integration, you'll need to install the Sematext Agent and configure it to ship PostgreSQL logs via the Logs Discovery. You will want to create or select an existing PostgreSQL Logs App because that is what will provide you with all the out of the box dashboards and alert rules, some of which you can see below.
Once data is in, you can explore it via the built-in reports:
Be sure to check out the PostgreSQL Monitoring integration as well, to get a complete view on PostgreSQL. For example, if you notice expensive queries in the logs, monitoring can tell you whether they hit the indices or they were mostly scans.
Once data is in, you can explore it using the built-in reports or create your own. For example, you can use the Statement Duration report to check on your queries:
If you are having trouble sending logs, try out the latest version of the Sematext Agent. Additionally, make sure to check out the Log Agents panel for any errors, and refer to our Sematext Logs FAQ for useful tips.