Google Cloud Monitoring Metrics
Key | |
---|---|
Metric Type | |
Kind, Type, Unit | Description |
Labels | |
Updates |
Metric prefixes
All metrics listed below are prefixed with
external.googleapis.com/bluemedora/generic_node/postgresql
except for the metrics that are also listed in the associated Stackdriver Agent Migration page. If the collector is installed on the PostgreSQL host system, the metrics listed there will be prefixed withagent.googleapis.com/postgresql
Google Cloud Monitoring Metrics | |
---|---|
| |
CUMULATIVE, INT64, Rows | Number of operations performed on rows for the database. |
operation: Operation performed ('del', 'fetch', 'ins', 'return', 'upd'). | |
| |
CUMULATIVE, INT64, n/a | Number of queries in this database that have been canceled. |
reason: Reason for query cancellation ('conflict', 'deadlock', 'dropped_tablespace', 'lock_timeout', 'old_snapshot', 'pinned_buffer'). | |
| |
GAUGE, INT64, Sessions | Number of sessions on the database. |
state: The state of the session ('active', 'disabled', 'idle', 'waiting', 'fast_path_function_call', 'idle_in_aborted_transaction', 'idle_in_transaction'). | |
| |
CUMULATIVE, INT64, Blocks | Number of buffer hits from all sequences in this database. |
| |
CUMULATIVE, INT64, Blocks | Number of disk blocks read from all sequences in this database. |
| |
CUMULATIVE, INT64, By | Total amount of data written to temporary files by queries in this database. All temporary files are counted, regardless of why the temporary file was created, and regardless of the log_temp_files setting. |
| |
CUMULATIVE, INT64, n/a | Number of temporary files created by queries in this database. All temporary files are counted, regardless of why the temporary file was created (e.g., sorting or hashing), and regardless of the log_temp_files setting. |
| |
CUMULATIVE, INT64, ms | Time spent reading data file blocks by backends in this database. |
| |
CUMULATIVE, INT64, ms | Time spent writing data file blocks by backends in this database. |
| |
CUMULATIVE, INT64, Transactions | Number of rollbacks. |
database: The name of the database. | |
| |
CUMULATIVE, INT64, Transactions | Number of commits. |
database: The name of the database. | |
| |
GAUGE, DOUBLE, By | Database disk usage. |
database: The name of the database. | |
| |
CUMULATIVE, INT64, Locks | Number of deadlocks detected in this database. |
| |
CUMULATIVE, INT64, Reads | Number of times disk blocks were found already in the buffer cache, so that a read was not necessary (this only includes hits in the PostgreSQL buffer cache, not the operating system's file system cache). |
| |
GAUGE, DOUBLE, % | Number of disk blocks read in this database. |
| |
CUMULATIVE, INT64, Reads | Number of blocks read. |
| |
GAUGE, DOUBLE, Sessions | Number of backends. |
database: The name of the database. | |
| |
GAUGE, DOUBLE, ms | Average time spent in this function and all other functions called by it. |
| |
CUMULATIVE, INT64, Calls | Number of times this function has been called. |
| |
CUMULATIVE, INT64, ms | Total time spent in this function itself, not including other functions called by it. |
| |
CUMULATIVE, INT64, ms | Total time spent in this function and all other functions called by it. |
| |
CUMULATIVE, INT64, Reads | Number of disk blocks read from this index. |
| |
CUMULATIVE, INT64, Reads | Number of buffer hits for this index. |
| |
CUMULATIVE, INT64, Rows | Number of index entries returned by scans on this index. |
| |
CUMULATIVE, INT64, Scans | Number of index scans initiated on this index. |
| |
CUMULATIVE, INT64, Fetches | Number of live table rows fetched by simple index scans using this index. |
| |
CUMULATIVE, INT64, n/a | Number of buffers allocated. |
| |
CUMULATIVE, INT64, n/a | Number of buffers written directly by a backend. |
| |
CUMULATIVE, INT64, n/a | Number of buffers written by the background writer. |
| |
CUMULATIVE, INT64, n/a | Number of buffers written during checkpoints. |
| |
GAUGE, INT64, s | Time since last replayed transaction timestamp from the replication master. |
| |
CUMULATIVE, INT64, Checkpoints | Number of requested checkpoints that have been performed. |
| |
CUMULATIVE, INT64, Checkpoints | Number of scheduled checkpoints that have been performed. |
| |
CUMULATIVE, INT64, ms | Total amount of time that has been spent in the portion of checkpoint processing where files are synchronized to disk. |
| |
CUMULATIVE, INT64, ms | Total amount of time that has been spent in the portion of checkpoint processing where files are written to disk. |
| |
CUMULATIVE, INT64, n/a | Number of times a backend had to execute its own fsync call (normally the background writer handles those even when the backend does its own write). |
| |
CUMULATIVE, INT64, n/a | Number of times the background writer stopped a cleaning scan because it had written too many buffers. |
| |
CUMULATIVE, INT64, n/a | Number of failed attempts for archiving WAL files. |
| |
CUMULATIVE, INT64, n/a | Number of WAL files that have been successfully archived. |
| |
CUMULATIVE, INT64, Blocks | Total number of blocks dirtied by the statement. |
type: Type of block ('local', 'shared'). | |
| |
CUMULATIVE, INT64, Reads | Total number of block cache hits by the statement. |
type: Type of block ('local', 'shared'). | |
| |
CUMULATIVE, INT64, Blocks | Number of blocks written and read. |
operation: Operation performed ('read', 'write'). | |
type: Type of block ('local', 'shared', 'temporary'). | |
| |
CUMULATIVE, INT64, Calls | Number of times query was executed. |
| |
GAUGE, DOUBLE, ms | Average time spent in the statement per execution. |
| |
CUMULATIVE, INT64, Rows | Total number of rows retrieved or affected by the statement. |
| |
GAUGE, INT64, By | Amount of data that has not been replayed into database on the standby server. |
| |
GAUGE, INT64, n/a | Priority of this standby server for being chosen as the synchronous standby. |
| |
CUMULATIVE, INT64, Blocks | Number of disk blocks read from this sequence. |
| |
CUMULATIVE, INT64, Reads | Number of buffer hits for this sequence. |
| |
CUMULATIVE, INT64, n/a | Number of times this table has been analyzed by the autovacuum daemon. |
| |
CUMULATIVE, INT64, Blocks | Number of blocks read. |
database: The name of the database. | |
table: The name of the table. | |
| |
CUMULATIVE, INT64, Scans | Number of index scans initiated on this table. |
| |
CUMULATIVE, INT64, n/a | Number of times this table has been manually analyzed. |
| |
CUMULATIVE, INT64, n/a | Number of times this table has been manually vacuumed (not counting VACUUM FULL). |
| |
GAUGE, DOUBLE, Rows | Number of tuples (rows) in the database. |
state: Tuple (row) state (either 'dead' or 'live'). | |
table: The name of the table. | |
| |
CUMULATIVE, INT64, Rows | Number of db row operations. |
database: The name of the database. | |
table: The name of the table. | |
| |
CUMULATIVE, INT64, Rows | Number of live rows fetched by index scans. |
| |
CUMULATIVE, INT64, Rows | Number of live rows fetched by sequential scans. |
| |
GAUGE, INT64, Rows | Estimated number of rows modified since this table was last analyzed. |
| |
CUMULATIVE, INT64, Scans | Number of sequential scans initiated on this table. |
| |
GAUGE, INT64, By | Disk space used by the table. |
| |
CUMULATIVE, INT64, n/a | Number of times this table has been vacuumed by the autovacuum daemon. |
| |
GAUGE, INT64, By | Size of the tablespace on disk. |
Updated about 2 years ago