Add a PostgreSQL database instance
To monitor your PostgreSQL database instance with SolarWinds Observability, complete the following:
-
In SolarWinds Observability, click Add Data at the top.
-
On the Add Data dialog, click Database.
-
Click Self-hosted, Amazon RDS, Amazon Aurora, Google Cloud SQL, or Azure DB from the PostgreSQL drop-down menu.
-
Choose an existing SolarWinds Observability Agent on a monitored host. Click Next to continue.
For more information about installing the SolarWinds Observability Agent on your host, see Add a self-managed host or Install SolarWinds Observability Agent as a Docker image.
-
Enter the database instance address, database, database username, and database password for your database instance. Click Next to continue.
Click the Enable SSL toggle and enter your SSL credentials to enable SSL.
-
Copy and execute the installation script on your PostgreSQL instance. The script will ensure that the correct privileges are set up on your instance.
The monitoring user must have theSUPERUSER
,rds_superuser
, orpg_monitor
role. See PostgreSQL system requirements for more information. -
Click whether to enable or disable packet capture.
Packet Capture is only available for Self-hosted PostgreSQL database instances. -
Copy and execute the configuration script on your PostgreSQL database instance.
-
Copy and execute the
pg_stat_statements
on your PostgreSQL database instance to enable the extension to collect query data.You must enable thepg_stats_statements
extension to capture query performance statistics for all versions of PostgreSQL. See enabling pg_stat_statments for more information. -
Click I have performed all of the above tasks. Click Next to continue.
-
Verify the information entered on the Summary tab. Click Finish.
To view data collected for the newly configured entity in the Entity Explorer, click the name of the Database Instance in the confirmation dialog in the lower-left corner. It may take a few seconds for data to appear for the newly created entity. See Entity Explorer for details.
See Entities in SolarWinds Observability for an overview of Database Instance entities and how they work in SolarWinds Observability.