Get the latest news about SolarWinds Database Performance Analyzer (DPA)
DESCRIPTION This alert works in conjunction with the COLLECT DATABASE SIZE - POSTGRES alert in this same section. Please install that alert as a requirement for this alert. This alert will review the last 2 days of data from the collector alert and calculate the growth. You can use the thresholds in the alert to get warned…
DESCRIPTION This alert will collect the size of each relation (table) in a Postgres Cluster. This example alert is used only for collecting data and would never alert anyone. This data is provided as input for another custom alert named "Postgres Relation Percent Growth". Also shown below is a query that will allow you to…
DESCRIPTION This alert will collect the size of each database in a Postgres Cluster. This example alert is used only for collecting data and would never alert anyone. This data is provided as input for another custom alert named "Postgres Database Percent Growth". Also shown below is a query that will allow you to report…
In DPA there is an option to set custom privileges and roles to a DPA user. This is discussed here https://documentation.solarwinds.com/en/Success_Center/dpa/Content/DPA-DPA_Roles_Privileges.htm What is some cumbersome in DPA however is getting an audit of these custom permissions for a large list of users. In the options…
Hi all, we have activated with DPA ver. 2020.2 the monitoring of some Postgres instances, anyway we've noticed in Postgres daily logs that there is a query of DPA returning syntax error: STATEMENT: SELECT sysdate FROM dual ERROR: relation "dual" does not exist at character 21 That is because there is no DUAL in Postgres,…
Description In PostgreSQL, an UPDATE or DELETE of a row does not immediately remove the old version of the row. This approach is necessary to gain the benefits of multi-version concurrency control (MVCC) - the row version must not be deleted while it is still potentially visible to other transactions. But eventually, an…
Description Keeping your connection limits in check should lead to a much healthier performing database and application. PostgreSQL has a lot of metadata about both historical and current activity against a system. This custom alert utilized pg_stat_activity to help provide insight into how many total connections ('idle in…
Description This alert utilizes a very popular query used by PostgreSQL administrators to periodically monitor database table bloat. How often you check database table bloat is dependent on your application, but every month or two is a reasonable time-frame. Alert Definition To create the alert, click on Alerts > Manage…
Description It's important to identify and investigate if there are any long running vacuum queries in your PostgreSQL database(s). These long running queries may interfere in overall database performance and could be the result of a stuck background process. This alert utilizes pg_stat_activity to monitor all vacuum…
It looks like you're new here. Sign in or register to get started.