This alert works in conjunction with the COLLECT DATABASE SIZE - POSTGRESalert 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 when a database grows by more than 10% is a given day as an example.
To create this alert, click on Alerts > Manage Alerts tab and create a Custom Alert of type Custom SQL Alert - Multiple Numeric Return making it look similar to this example.
Alert Name: Database Growth Alert - Postgres
Execution Interval: 1 Day
Notification Text: The following databases have grown by more than X% in the last day
Available Instances: <choose any Postgres instances>
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community.
More than 150,000 members are here to solve problems, share technology and best practices, and directly
contribute to our product development process.