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. |
| DBMS uptime | Collects database uptime statistics. |
| dbWatch engine alert | Collects database uptime statistics. |
| Capacity | |
| Database growth rate and info | Collects detailed growth rate information. |
| Log size statistics | Checks the size of the log file. |
| Max connections | Checks the size of the log file. |
| Schema growth collector | Checks the size of the log file. |
| Vacuum alert | Checks the size of the log file. |
| Schema growth statistics | Collects and analyzes schema growth statistics from data collected by |
| Tablespace growth and information | Shows an overview of tablespace growth and statistics. |
| Cluster | |
| BDR Replication lag | Checks for BDR replication lag |
| Replication delay alert | Checks for BDR replication lag |
| Replication slave client alert | Checks for BDR replication lag |
| Replication slave client alert | Checks for BDR replication lag |
| 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 | |
| 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. |
| Test DML performance | Runs performance test. Procedure executes SELECT, INSERT, UPDATE, DELETE and TRUNCATE statements on schema test tables. |
| 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 | Gathers information on commits and rollbacks in the databases and generates statistics. |
| Performance_licenced | |
| SQL statistics | Collects performance statistics for the SQL statements. |
| SQL statistics | Collects performance statistics for the SQL statements. |