Postgres AIops

[READ] Tables with heavy sequential scans and few index scans (index hints). Args: min_seq_scan: Minimum cumulative sequential scans to flag (default 1000). min_live_tup: Minimum live tuples for a table to qualify (default 10000). target: Target name from config; omit for the default.

[READ] One-shot cluster health snapshot. Version + uptime, connections by state, idle-in-transaction count, the longest-running query, the worst dead-tuple table, and standby replay lag — each section captured defensively so one failing probe does not sink the rest. Args: target: Target name from config; omit for the default.

[WRITE][risk=medium] REINDEX an index/table/schema (rebuild in place, no undo). Rebuilds physical index storage; there is no inverse. Pass dry_run=True to preview. Args: target_name: The index/table/schema name to reindex. kind: INDEX, TABLE, or SCHEMA (default INDEX). concurrently: Rebuild with CONCURRENTLY. dry_run: If True, preview without rebuilding. target: Target name from config; omit for the default.

[READ] Replication slots, flagging inactive slots that retain WAL. Args: target: Target name from config; omit for the default.

[READ] Connected standbys and their replay lag (pg_stat_replication). Args: target: Target name from config; omit for the default.

[WRITE][risk=medium] Reset pg_stat_statements accumulators (irreversible). The counters cannot be restored, so no undo is recorded. Pass dry_run=True to preview. Args: dry_run: If True, preview without resetting. target: Target name from config; omit for the default.

[WRITE][risk=medium] ANALYZE a table to refresh planner statistics. No undo; captures prior stats for audit. Pass dry_run=True to preview. Args: table: Table name (optionally schema-qualified). dry_run: If True, preview without running. target: Target name from config; omit for the default.

[WRITE][risk=medium] VACUUM a table (optionally FULL/ANALYZE). Records prior stats. No undo (a vacuum has no inverse); the prior dead-tuple/last-vacuum stats are captured for the audit trail. VACUUM FULL takes an exclusive lock. Pass dry_run=True to preview. Args: table: Table name (optionally schema-qualified, e.g. public.orders). full: Run VACUUM FULL (rewrites the table, exclusive lock). analyze: Also refresh planner statistics (VACUUM ANALYZE). dry_run: If True, preview without running. target: Target name from config; omit for the default.

[READ] Server version, uptime, recovery state, and data directory. Args: target: Target name from config; omit for the default.

[READ] Configuration parameters from pg_settings. Args: pattern: Optional case-insensitive substring to filter setting names (e.g. 'work_mem', 'autovacuum'). target: Target name from config; omit for the default.

[READ] RCA for the worst pg_stat_statements entry, with cause + action. Picks the statement with the greatest total execution time and maps its numbers (mean time, cache-hit ratio, temp spill, calls) — plus an optional EXPLAIN plan — to cited causes and concrete actions. Pass 'statements' for pure/offline analysis, or omit to pull the top statements live. Args: statements: Injected pg_stat_statements rows (as from top_queries); if omitted, the worst statements are pulled live. explain_sql: Optional SQL to EXPLAIN so plan node types feed the RCA. limit: How many statements…

[READ] Dead-tuple bloat proxy per table (dead / (live + dead)), worst first. Args: limit: Number of tables to inspect (default 50). target: Target name from config; omit for the default.

[READ] Largest tables by total relation size (table + indexes + TOAST). Args: limit: Number of tables to return, largest first (default 20). target: Target name from config; omit for the default.

[WRITE][risk=high] Terminate a backend (pg_terminate_backend). No safe inverse. Captures the backend's pid + query for the audit trail; a terminate cannot be undone, so no undo is offered. Pass dry_run=True to preview. Refuses this tool's own backend pid — including under dry_run, which must report a refusal rather than preview a call that will be refused. Args: pid: Backend process id (from list_activity). dry_run: If True, preview without terminating. target: Target name from config; omit for the default.

[READ] Top statements from pg_stat_statements by a whitelisted metric. Args: order_by: One of total_time, mean_time, calls, rows, io. limit: Number of statements to return (1..200, default 20). target: Target name from config; omit for the default.

[WRITE][risk=medium] Apply a recorded undo by dispatching its inverse tool. The inverse runs through its own governed tool, so its risk tier and audit row are recorded there. Pass dry_run=True to preview the inverse call without executing it. A token can only be applied once. Args: undo_id: The undoId from undo_list (or an ``_undo_id`` in a write result). dry_run: If True, preview the inverse tool + params without running it. target: Passed through to the inverse tool when it accepts a target.

[READ] List recorded, not-yet-applied undo tokens (most recent first). Each entry names the original tool, the inverse tool that ``undo_apply`` would run, and a human note. Use the ``undoId`` with ``undo_apply``. Each entry carries ``effectVerified``. False means the original write lost its response, so the change it reverses is PROBABLE, not confirmed — check the live state before applying, and do not report the result as a restore of a state that may never have been reached. Args: limit: Max rows to return (default 50). target: Unused (undo state is host-local); accepted for CLI u…

[READ] Non-unique, non-primary indexes with zero scans (drop candidates). Args: min_size_bytes: Only report indexes at least this large (default 0). target: Target name from config; omit for the default.

[WRITE][risk=medium] ALTER SYSTEM SET (or RESET) a parameter. Reversible. Writes postgresql.auto.conf; most parameters need SELECT pg_reload_conf() (or a restart for postmaster-context settings) to take effect — reported but NOT performed automatically. The prior state is captured so the harness records an undo. Pass dry_run=True to preview. reset=True issues ALTER SYSTEM RESET, dropping the parameter's auto.conf entry so postgresql.conf or the built-in default applies again. That is the recorded inverse when the parameter had no auto.conf entry to begin with: writing the prior value back wo…

[READ] WAL position, level, size settings and archiver health. Args: target: Target name from config; omit for the default.