PostgreSQL

Integration Installation

1. Install the Astradot Infra Agent on your server

2. Create a user that has permission to read pg_stat_database

   CREATE USER astradot WITH password 'xx';
   grant SELECT ON pg_stat_database TO astradot;

3. Edit /etc/astradot-infra/integrations/postgresql.toml

   #For every postgres instance to monitor, add an [[instance]] block
   [[instance]]
   host = "localhost"
   port = 5432
   database = "mydb"
   username = "astradot"
   password = "xx"

4. Restart astradot-infra agent

   service astradot-infra restart

Metrics

Metric	Description
Connections	Number of active connections to the database
Max Connections	Maximum connections allowed
Database Size	Size of database
Table Count	Number of user defined tables in the database
Disk blocks read	Number of disk blocks read
Disk Buffer Cache hits	Number of times disk blocks were found already in the postgres buffer cache, so that a read was not necessary
Txn Commits	Number of transactions committed
Txn Rollbacks	Number of transactions rolled back
Locks	Number of locks held open by transactions (sampled every data sent interval)
Deadlocks	Number of deadlocks detected
Bgwriter - Checkpoints requested	Number of requested checkpoints that have been performed
Bgwriter - Checkpoints scheduled	Number of scheduled checkpoints that have been performed
Bgwriter - Buffers checkpoint	Number of buffers written during checkpoints
Bgwriter - Buffers clean	Number of buffers written by the background writer
Bgwriter - Buffers allocated	Number of buffers allocated
Bgwriter - Buffers backend	Number of buffers written directly by a backend
Bgwriter - Buffers backend fsync	Number of times a backend had to execute its own fsync call
Bgwriter - maxwritten_clean	Number of times the background writer stopped a cleaning scan because it had written too many buffers
Bgwriter - checkpoint_write_time	amount of time that has been spent in the portion of checkpoint processing where files are written to disk, in milliseconds
Bgwriter - checkpoint_sync_time	amount of time that has been spent in the portion of checkpoint processing where files are synchronized to disk, in milliseconds
Archiver - Archived count	Number of WAL files that have been successfully archived
Archiver - Failed count	Number of failed attempts for archiving WAL files
Temp files created	Number of temporary files created by queries
Temp data written	Amount of data written to temporary files by queries
Rows - Inserted	Number of rows inserted by queries
Rows - Updated	Number of rows updated by queries
Rows - Deleted	Number of rows deleted by queries
Rows - Fetched	Number of rows fetched by queries
Rows - Returned	Number of rows returned by queries