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.