Agent prerequisites

Infosec whitelisting

Please ask your infosec department to whitelist the following URL for external access: https://app.dbtune.com.

Required PostgreSQL extensions

pg_stat_statements (ensure version compatibility with your PostgreSQL installation):

• To install:

  CREATE EXTENSION IF NOT EXISTS pg_stat_statements;
• Important:
  If manually installing by copying the .control, .sql, and .so files, make sure you use files that match your PostgreSQL version.
  Using incompatible versions (e.g., pg_stat_statements 1.4 with PostgreSQL 16) can cause errors, such as missing columns like total_exec_time.

System requirements

• Superuser access to PostgreSQL;
• PostgreSQL versions > 12;
• OS: Any Linux system;
• Server hosting the database: On-prem server or self-managed cloud instance, e.g., EC2, GCE, Azure VM.