Get the latest news about SolarWinds Database Performance Analyzer (DPA)
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 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…
Description It's important to identify and investigate if there are any long running 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 non "autovacuum"…
Description ANALYZE gathers statistics for the query planner to create the most efficient query execution paths. Per PostgreSQL documentation, accurate statistics will help the planner to choose the most appropriate query plan, and thereby improve the speed of query processing. This alert utilizes pg_stat_user_tables to…
Description As a PostgreSQL administrator, you may be responsible for creating user accounts and groups. You may also be responsible for granting and revoking privileges. The alert will notify you when a user role is about to expire in N days. Alert Definition To create the alert, click on Alerts > Manage Alerts tab and…
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 (in all…
It looks like you're new here. Sign in or register to get started.