Postgresql configuration changed info
Postgres Database configuration change has occurred
>>>
{__name__=~"pg_settings_.*"} != ON(__name__, instance) {__name__=~"pg_settings_([^t]|t[^r]|tr[^a]|tra[^n]|tran[^s]|trans[^a]|transa[^c]|transac[^t]|transact[^i]|transacti[^o]|transactio[^n]|transaction[^_]|transaction_[^r]|transaction_r[^e]|transaction_re[^a]|transaction_rea[^d]|transaction_read[^_]|transaction_read_[^o]|transaction_read_o[^n]|transaction_read_on[^l]|transaction_read_onl[^y]).*"} OFFSET 5m
The query compares the current values of all pg_settings_* metrics (except the pg_settings_transaction_read_only family) with their values from 5 minutes ago; if any of those settings differ, the expression evaluates to true and the alert fires, indicating a PostgreSQL configuration change.
Get Alert✕
Download
Copy to Clipboard