Postgres operations

Install

emisar pack install validates the pack and verifies its content hash before copying it into /etc/emisar/packs. The --hash below pins the install to the exact bytes on this page — a tampered copy is rejected. After install, reload the runner; it re-reads the catalog and advertises every action.

content hash: sha256:7075feb9e2841efd79f3a3a2d84aa030420fa8c69f5ba410517ccc35a9c81c85

sudo emisar pack install postgres \
  --hash sha256:7075feb9e2841efd79f3a3a2d84aa030420fa8c69f5ba410517ccc35a9c81c85 \
  --dest /etc/emisar/packs

# Reload so the runner re-reads the catalog:
sudo systemctl reload emisar

• postgres.activity_detail exec low

  pg_stat_activity (per-backend)

• postgres.activity_states exec low

  Backend counts by state

• postgres.analyze_table exec medium

  ANALYZE <schema>.<table>

• postgres.backend_holding_xmin exec low

  Backend holding the oldest xmin

• postgres.bgwriter_stats exec low

  pg_stat_bgwriter

• postgres.cancel_query exec high

  Cancel a running query

• postgres.connections exec low

  Postgres connection summary

• postgres.database_stats exec low

  pg_stat_database

• postgres.db_sizes exec low

  All databases by size

• postgres.dead_tuples_top exec low

  Top tables by dead-tuple ratio

• postgres.duplicate_indexes exec low

  Duplicate indexes (same column set)

• postgres.explain_analyze exec high

  EXPLAIN ANALYZE (FORMAT JSON) <query>

• postgres.explain_query exec low

  EXPLAIN (FORMAT JSON) <query>

• postgres.extensions_installed exec low

  Installed extensions

• postgres.hot_update_ratio exec low

  HOT update ratio per table

• postgres.idle_in_transaction exec low

  Idle-in-transaction backends

• postgres.index_sizes exec low

  Top 50 indexes by size

• postgres.invalid_indexes exec low

  Invalid indexes (indisvalid = false)

• postgres.is_in_recovery exec low

  pg_is_in_recovery()

• postgres.kill_idle exec high

  Terminate idle-in-transaction backends

• postgres.largest_tables_full exec low

  Largest tables with vacuum/dead-tuple info

• postgres.last_vacuum_per_table exec low

  Last vacuum/analyze per table

• postgres.lock_blocking_chains exec low

  Blocker → blocked chains

• postgres.locks exec low

  Blocking lock graph

• postgres.longest_running_queries exec low

  Top 20 by query age

• postgres.pg_hba_rules exec low

  pg_hba_file_rules

• postgres.pg_stat_statements_reset exec medium

  pg_stat_statements_reset()

• postgres.pg_stat_statements_top exec low

  Top statements by total time

• postgres.progress_create_index exec low

  pg_stat_progress_create_index

• postgres.progress_vacuum exec low

  pg_stat_progress_vacuum

• postgres.reindex_concurrent exec high

  REINDEX INDEX CONCURRENTLY <schema>.<index>

• postgres.reload_conf exec high

  Reload postgresql.conf

• postgres.replication_lag exec low

  Replication lag (primary view)

• postgres.replication_slots exec low

  pg_replication_slots

• postgres.seq_scan_offenders exec low

  Tables with high seq-scan ratio

• postgres.settings_non_default exec low

  pg_settings (non-default)

• postgres.slow_queries exec low

  Top slow queries from pg_stat_statements

• postgres.ssl_connections exec low

  pg_stat_ssl

• postgres.table_io exec low

  pg_statio_user_tables

• postgres.table_sizes exec low

  Top tables by total size

• postgres.terminate_backend exec high

  pg_terminate_backend(pid)

• postgres.unused_indexes exec low

  Unused indexes (idx_scan = 0)

• postgres.uptime exec low

  Postgres uptime and version

• postgres.vacuum_status exec low

  Autovacuum + bloat snapshot

• postgres.vacuum_table exec high

  VACUUM <schema>.<table>

• postgres.wal_archive_status exec low

  pg_stat_archiver

• postgres.wal_status exec low

  Current WAL LSN + recovery state

• postgres.xid_wraparound_proximity exec low

  How close are we to XID wraparound?