Postgres::Vacuum::Monitor

gem 'postgres-vacuum-monitor'

Postgres::Vacuum::Monitor.configure do |config|
  config.monitor_reporter_class_name = 'MetricsReporter'
  # Optionally change the default threshold of 5 minutes for reporting long running transactions
  config.long_running_transaction_threshold_seconds = 10 * 60
  # Optionally change `max_attempts` of the monitor job (default 1)
  config.monitor_max_attempts = 3
  # Optionally change `max_run_time` of the monitor job (default 60 seconds)
  config.monitor_max_run_time_seconds = 5
  # Optionally change the statement timeout of queries (default 10 seconds)
  config.monitor_statement_timeout_seconds = 5
end

class MetricsReporter
  def report_event(name, attributes)
  end
end

{
  database_name: # The name of the database.
  start_time: # When the transaction started .
  running_time: # How long has it been running in seconds.
  application_name: # What's the application name that is running the query.
  most_recent_query: # The last query started by the transaction
  state: # The state of the transaction - either "active" or "idle in transaction"
  wait_event_type: # The type of lock the transaction is waiting for if applicable
  transaction_id: # The transaction_id which will be null for read-only transactions
  min_transaction_id: # The mininum transaction id horizon
}

{
  database_name: # The name of the database.
  table: # Table name.
  table_size: # How big is the table.
  dead_tuples: # How many dead tuples are in the table.
  tuples_over_limit: # How many dead tuples are over the auto vacuumer threshold.
}