Google Cloud SQL (PostgreSQL) Container (GCP_GCSQL_SQL_POSTGRESQL_CNTR)
This monitor type contains attributes that indicates the PostgreSQL database performance of the cloud SQL (PostgreSQL) instance.
Attributes (parameters)
The following attributes are available for this monitor type:
Name | Description | Unit | Default Key Performance Indicator (KPI) | Value set by |
---|---|---|---|---|
Data (in bytes) written to temporary (DatainbytesWrittenToTemp) | This attribute displays the total amount of data (in bytes) written to temporary files by the queries per database. | # | No | |
Deadlocks count (DeadlocksCount) | This attribute displays the number of deadlocks detected for this database. | # | No | |
Initial sync complete (InitialSyncComplete) | This attribute indicates whether all databases on the Postgres External Server (ES) replica have completed the initial sync and are replicating changes from the source. | 0 -TRUE, 1 - FALSE | No | |
Lag bytes (LagBytes) | This attribute displays the replication lag in bytes. Reported from the master per replica. | GB | No | |
Max lag bytes (MaxLagBytes) | This attribute displays the replication lag in bytes for Postgres External Server (ES) replicas. Aggregated across all DBs on the replica. | GB | No | |
Number of disk blocks read (NumberOfDiskBlocksRead) | This attribute displays the number of disk blocks read by this database. The source field distinguishes actual reads from disk versus reads from buffer cache. | # | No | |
Number of rows processed (NumberOfRowsProcessed) | This attribute displays the number of tuples(rows) processed for a given database for operations like insert, update or delete. | # | No | |
Number of transactions (NumberOfTransactions) | This attribute displays the delta count of number of transactions. | # | Yes | |
Number of tuples fetched (NumberOfTuplesFetched) | This attribute displays the total number of rows fetched as a result of queries per database in the PostgreSQL instance. | # | No | |
Number of tuples returned (NumberOfTuplesReturned) | This attribute displays the total number of rows scanned while processing the queries per database in the PostgreSQL instance. | # | No | |
Number of tuples (rows) in the database (NumberOfTuplesrowsInTheDB) | This attribute displays the number of tuples (rows) in the database. | # | No | |
Oldest transaction age (OldestTransactionAge) | This attribute displays the age of the oldest transaction yet to be vacuumed in the Cloud SQL PostgreSQL instance, measured in number of transactions that have happened since the oldest transaction. | # | No | |
PostgreSQL backends in wait (PostgreSQLBackendsInWait) | This attribute displays the number of backends in wait in postgres instance. | # | No | |
PostgreSQL Connections (PostgreSQLConnections) | This attribute displays the number of connections to the Cloud SQL PostgreSQL instance. | # | No | |
PostgreSQL connections by application (PostgreSQLConnsByApplication) | This attribute displays the number of connections to the Cloud SQL PostgreSQL instance, grouped by applications. | # | No | |
PostgreSQL Connections by State (PostgreSQLConnectionsByState) | This attribute displays the number of connections to the Cloud SQL PostgreSQL instance, grouped by its state. | # | No | |
PostgreSQL new connections count (PostgreSQLNewConnectionsCount) | This attribute displays the count of new connections added to the postgres instance. | # | No | |
Temporary files used for writing data (TempFilesUsedForWritingData) | This attribute displays the total number of temporary files used for writing data while performing algorithms such as join and sort. | # | No | |
Transaction ID count (TransactionIDCount) | This attribute displays the delta count of transaction ID. | # | No | |
Transaction ID utilization (TransactionIDUtilization) | This attribute displays the current utilization represented as a percentage of transaction IDs consumed by the Cloud SQL PostgreSQL instance. | % | Yes |