#!/usr/bin/env python3 """Проверяет отставание реплик PostgreSQL по WAL.""" from __future__ import annotations import argparse import json import shutil import subprocess import sys QUERY = """ SELECT application_name, COALESCE(client_addr::text, 'local'), state, CASE WHEN replay_lsn IS NULL THEN NULL ELSE pg_wal_lsn_diff(pg_current_wal_lsn(), replay_lsn)::bigint END FROM pg_stat_replication ORDER BY application_name; """ def main() -> int: parser = argparse.ArgumentParser(description="Отставание реплик PostgreSQL") parser.add_argument("--psql", default="psql") parser.add_argument("--warn-mb", type=float, default=64.0) parser.add_argument("--crit-mb", type=float, default=256.0) parser.add_argument("--timeout", type=float, default=15.0) parser.add_argument("--json", action="store_true") args = parser.parse_args() binary = shutil.which(args.psql) if not binary: print(f"ОШИБКА: не найден {args.psql}", file=sys.stderr) return 3 try: result = subprocess.run( [binary, "-X", "-w", "-A", "-t", "-F", "|", "-c", QUERY], capture_output=True, text=True, timeout=args.timeout, check=False, ) except (OSError, subprocess.TimeoutExpired) as error: print(f"ОШИБКА: {error}", file=sys.stderr) return 2 if result.returncode != 0: print(result.stderr.strip() or "psql завершился с ошибкой", file=sys.stderr) return 2 rows = [] for line in result.stdout.splitlines(): line = line.strip() if not line: continue parts = line.split("|") if len(parts) != 4: continue name, client, state, lag = parts lag_bytes = int(lag) if lag not in {"", "NULL"} else None rows.append( { "application_name": name, "client_addr": client, "state": state, "lag_bytes": lag_bytes, "lag_mb": round(lag_bytes / (1024 * 1024), 2) if lag_bytes is not None else None, } ) if not rows: print("CRITICAL: pg_stat_replication пуст или нет прав", file=sys.stderr) return 2 status = 0 for row in rows: if row["state"] != "streaming": status = 2 elif row["lag_mb"] is None: status = max(status, 1) elif row["lag_mb"] >= args.crit_mb: status = 2 elif row["lag_mb"] >= args.warn_mb: status = max(status, 1) if args.json: print(json.dumps({"replicas": rows, "status": status}, ensure_ascii=False, indent=2)) else: print(f"{'Replica':20} {'Client':18} {'State':12} {'Lag MB':>10}") for row in rows: lag = "unknown" if row["lag_mb"] is None else f"{row['lag_mb']:.2f}" print( f"{row['application_name'][:20]:20} " f"{row['client_addr'][:18]:18} " f"{row['state'][:12]:12} {lag:>10}" ) print("OK" if status == 0 else "WARNING" if status == 1 else "CRITICAL") return status if __name__ == "__main__": raise SystemExit(main())