Jobs for Postgres
| Control Center Jobs | Description |
|---|---|
| Availability | |
| Backup check – pg_dump | Checks that there exists an up to date backup file. |
| Backup check – WAL | Checks that the WAL files have been backed up. |
| Database status | This job monitors the availability status of databases in a PostgreSQL instance by checking the datallowconn column in the pg_database system catalog. |
| DBMS uptime | Collects database server uptime statistics. |
| dbWatch engine alert | Collects database server uptime statistics. |
| Database status alert | Collects database server uptime statistics. |
| pgBackRest DIFF backup status | Monitors the status and recency of PostgreSQL Differential backups performed with pgBackRest. |
| pgBackRest FULL backup status | Monitors the status and recency of PostgreSQL FULL backups performed with pgBackRest. |
| pgBackRest INCR backup status | Monitors the status and recency of PostgreSQL Incremental backups performed with pgBackRest. |
| Capacity | |
| Database growth rate and info | Collects growth rate information per database. |
| Log size statistics | Collects the size of the log file. |
| Max connections | Collects the size of the log file. |
| Schema growth collector | Collects the size of the log file. |
| Vacuum alert | Collects the size of the log file. |
| Schema growth statistics | Analyzes schema growth statistics from data collected by schema_growth_collector_* properties. |
| Tablespace growth and information | Shows an overview of tablespace growth and statistics. |
| Cluster | |
| Replication delay alert | Shows an overview of tablespace growth and statistics. |
| Replication slave client alert | Shows an overview of tablespace growth and statistics. |
| Replication slave client alert | Shows an overview of tablespace growth and statistics. |
| Maintenance | |
| Backup job – pg_dump_all | Runs a backup of all the postgres databases on an instance using pg_dumpall through an ssh connection. |
| framework | dbWatch engine framework job (for internal use only). Used for patching or upgrading of dbWatch engine framework. |
| Analyze tables | dbWatch engine framework job (for internal use only). Used for patching or upgrading of dbWatch engine framework. |
| Vaccum tables | dbWatch engine framework job (for internal use only). Used for patching or upgrading of dbWatch engine framework. |
| Performance | |
| Test DML performance | Runs performance test. Procedure executes SELECT, INSERT, UPDATE, DELETE and TRUNCATE statements on schema test tables. |
| Blocking statistics | Checks whether there exists any blocked sessions. |
| Buffer cache reads per database | Collects the number of block fetch requests for table or index per database. |
| Buffer cache statistics | Gets data cache statistics from pg_stat_database view. |
| Disk block hitrate | Checks the hitrate for disk block requests. |
| Disk block reads per database | Collects the number of disk block fetch requests for table or index per database. |
| Index block hitrate | Checks the hitrate for index disk block requests. |
| Locks held and statistics | Shows locks held statistics. |
| Table and index scan collector | Shows locks held statistics. |
| Session load | Gathers session load statistics. |
| Table and index scan statistics | This task gathers scan statistics on tables and indexes from pg_stat_all_tables view. |
| Transaction statistics | This procedure collects and stores historical snapshots of the xact_commit and xact_rollback counters from the pg_stat_database view. |
| Performance_licenced | |
| SQL statistics | Collects performance statistics for the SQL statements. |
| SQL statistics | Collects performance statistics for the SQL statements. |
| SQL statistics | Collects performance statistics for the SQL statements. |