OCI PostgreSQL DB Systems

OCI PostgreSQL DB Systems provide managed PostgreSQL database infrastructure observability.

Use the Oracle Cloud integration to discover and collect metrics against the OCI PostgreSQL DB Systems.

Setup

To set up the Oracle Cloud integration and discover the OCI PostgreSQL DB Systems service, do the following:

Create an Oracle Cloud (OCI) integration if not available in your installed integrations.
You can select OCI PostgreSQL DB Systems during integration or you can edit the existing integration and select OCI PostgreSQL DB Systems.
Scan to discover the resources at any time independent of the predefined schedule.
Once the scan is completed, you can view the OCI PostgreSQL DB Systems resource under Infrastructure > Resources > Oracle Cloud category.
Create a template. See Create a Template for more information on how to create a template.
Refer to Assign a Template on how to assign a template to a resource.

Supported metrics

OpsRamp Metric	Oracle Cloud Metric	Metric Display Name	Unit	Description	Aggregation Type
oci_postgresql_CpuUtilization	CpuUtilization	CPU Utilization	%	The average CPU utilization expressed as a percentage, aggregated across all cores in the DB system.	MEAN
oci_postgresql_MemoryUtilization	MemoryUtilization	Memory Utilization	%	The average amount of memory used as a percentage of total memory available in the DB system.	MEAN
oci_postgresql_Connections	Connections	Connections	count	The average number of active and idle client connections to the DB system.	MEAN
oci_postgresql_UsedStorage	UsedStorage	Used Storage	Bytes	The average amount of storage currently used by the DB system.	MEAN
oci_postgresql_ReadIops	ReadIops	Read IOPS	ops/s	The average number of disk read operations per second.	MEAN
oci_postgresql_WriteIops	WriteIops	Write IOPS	ops/s	The average number of disk write operations per second.	MEAN
oci_postgresql_ReadLatency	ReadLatency	Read Latency	ms	The average latency of read operations in milliseconds.	MEAN
oci_postgresql_WriteLatency	WriteLatency	Write Latency	ms	The average latency of write operations in milliseconds.	MEAN
oci_postgresql_ReplicationLag	ReplicationLag	Replication Lag	s	The average delay in seconds between primary and replica DB instances.	MEAN
oci_postgresql_ActiveSessions	ActiveSessions	Active Sessions	count	The average number of sessions that are actively running queries.	MEAN
oci_postgresql_BufferCacheHitRatio	BufferCacheHitRatio	Buffer Cache Hit Ratio	%	The percentage of read requests served from memory rather than disk.	MEAN
oci_postgresql_Deadlocks	Deadlocks	Deadlocks	count	The average number of deadlocks detected in the DB system.	MEAN
oci_postgresql_WriteThroughput	WriteThroughput	Write Throughput	B/s	The average amount of data written per second.	MEAN
oci_postgresql_ReadThroughput	ReadThroughput	Read Throughput	B/s	The average amount of data read per second.	MEAN
oci_postgresql_InactiveReplicationSlots	InactiveReplicationSlots	Inactive Replication Slots	count	The average number of replication slots that are inactive.	MEAN
oci_postgresql_IdleSessions	IdleSessions	Idle Sessions	count	The average number of sessions that are currently idle.	MEAN
oci_postgresql_IdleInTransactions	IdleInTransactions	Idle In Transactions	count	The average number of sessions idle while holding open transactions.	MEAN
oci_postgresql_BlockedQueries	BlockedQueries	Blocked Queries	count	The average number of queries blocked by locks or resource contention.	MEAN
oci_postgresql_LongRunningQueriesOverFiveMinutes	LongRunningQueriesOverFiveMinutes	Long Running Queries Over Five Minutes	count	The average number of queries running longer than five minutes.	MEAN
oci_postgresql_AverageReadLatency	AverageReadLatency	Average Read Latency	ms	The average read latency across operations in milliseconds.	MEAN
oci_postgresql_WalUsedStorage	WalUsedStorage	WAL Used Storage	Bytes	The average amount of storage used by Write-Ahead Logging (WAL) files.	MEAN