Jobs
The package contains 28 system jobs. Four jobs maintain module data; the others detect operational issues and register incidents.
| Job | Purpose | Result |
|---|---|---|
db_00_lookup_refresh | updates the technical part of the instance registry | Service job |
db_00_thresholds_seed | records initial thresholds | Service job |
db_02_instance_asset | creates a snapshot of Inventory assets | Service job |
db_10_instance_availability | detects an unavailable instance | Registers an incident |
db_11_connection_saturation | monitors connection saturation | Registers an incident |
db_12_transaction_rollback_rate | monitors the rollback rate | Incident example |
db_13_cache_hit_degradation | detects a decline in the cache hit rate | Incident example |
db_14_connection_errors | detects connection failures | Registers an incident |
db_20_top_queries_aggregate | creates an hourly baseline for query cost | Service job |
db_21_query_regression | compares a query with the baseline | Registers an incident |
db_23_plan_explain_ai | explains a slow query plan using AI | Registers an incident |
db_30_lock_wait_long | detects a long lock wait | Incident example |
db_31_deadlock_detected | registers a deadlock and its participants | Registers an incident |
db_32_idle_in_transaction | finds a session with an open transaction | Registers an incident |
db_33_long_transaction | detects a long-running transaction | Registers an incident |
db_40_replication_lag | monitors replication lag | Registers an incident |
db_41_replication_broken | detects a replication stream interruption | Registers an incident |
db_42_slot_inactive | monitors an inactive slot and retained WAL | Registers an incident |
db_43_cluster_role_change | registers a node role change | Registers an incident |
db_44_pooler_saturation | detects a PgBouncer client queue | Registers an incident |
db_45_wal_archiver_failure | detects WAL archiving errors | Registers an incident |
db_50_disk_forecast | estimates database size growth over seven days | Registers an incident |
db_51_xid_wraparound_risk | monitors XID consumption | Registers an incident |
db_52_autovacuum_lag | detects autovacuum lag | Registers an incident |
db_53_temp_files_spike | detects a spike in temporary files | Registers an incident |
db_54_database_growth_anomaly | detects anomalous database growth | Registers an incident |
db_70_incident_ai_summary | creates an AI summary of changes in load | Registers an incident |
db_90_collection_health | detects a halt or partial loss of data collection | Registers an incident |