Shared Files for Database Performance Analyzer
  • Long Running Queries

    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" related queries and notifies you if there are queries running longer than the defined thresholds. Alert Definition To create the alert, click on Alerts > Manage Alerts tab...
    • 1 Apr 2021