Google Cloud Monitoring Metrics
Key | |
---|---|
Metric Type Display Name | |
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 | |
---|---|
/database/row/operation_count Row Operation Count | |
CUMULATIVE, INT64, Rows | Number of operations performed on rows for the database. |
operation: Operation performed ('del', 'fetch', 'ins', 'return', 'upd'). | |
/database/query/cancel_count Query Cancel Count | |
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'). | |
/database/session/count Session Count | |
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'). | |
/database/sequence_blocks/hit Sequence Blocks Hit | |
CUMULATIVE, INT64, Blocks | Number of buffer hits from all sequences in this database. |
/database/sequence_blocks/read Sequence Blocks Read | |
CUMULATIVE, INT64, Blocks | Number of disk blocks read from all sequences in this database. |
/database/temporary_data_written Temporary Data Written | |
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. |
/database/temporary_files_created Temporary Files Created | |
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. |
/database/time_spent/reading_data Time Spent Reading Data | |
CUMULATIVE, INT64, ms | Time spent reading data file blocks by backends in this database. |
/database/time_spent/writing_data Time Spent Writing Data | |
CUMULATIVE, INT64, ms | Time spent writing data file blocks by backends in this database. |
/rollback_count Rollbacks | |
CUMULATIVE, INT64, Transactions | Number of rollbacks. |
database: The name of the database. | |
/commit_count Commits | |
CUMULATIVE, INT64, Transactions | Number of commits. |
database: The name of the database. | |
/db_size DB size | |
GAUGE, DOUBLE, By | Database disk usage. |
database: The name of the database. | |
/database/deadlock_count Deadlock Count | |
CUMULATIVE, INT64, Locks | Number of deadlocks detected in this database. |
/database/buffer_hit_count Buffer Hit Count | |
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). |
/database/buffer_hit_ratio Buffer Hit Ratio | |
GAUGE, DOUBLE, % | Number of disk blocks read in this database. |
/block_read_count Block Read Count | |
CUMULATIVE, INT64, Reads | Number of blocks read. |
/num_backends Backends | |
GAUGE, DOUBLE, Sessions | Number of backends. |
database: The name of the database. | |
/function/average_time Average Time | |
GAUGE, DOUBLE, ms | Average time spent in this function and all other functions called by it. |
/function/calls Calls | |
CUMULATIVE, INT64, Calls | Number of times this function has been called. |
/function/self_time Self Time | |
CUMULATIVE, INT64, ms | Total time spent in this function itself, not including other functions called by it. |
/function/total_time Total Time | |
CUMULATIVE, INT64, ms | Total time spent in this function and all other functions called by it. |
/index/block_reads Block Reads | |
CUMULATIVE, INT64, Reads | Number of disk blocks read from this index. |
/index/buffer_hits Buffer Hits | |
CUMULATIVE, INT64, Reads | Number of buffer hits for this index. |
/index/entries_returned Entries Returned | |
CUMULATIVE, INT64, Rows | Number of index entries returned by scans on this index. |
/index/scans Scans | |
CUMULATIVE, INT64, Scans | Number of index scans initiated on this index. |
/index/table_rows_fetched Table Rows Fetched | |
CUMULATIVE, INT64, Fetches | Number of live table rows fetched by simple index scans using this index. |
/instance/buffer/allocated_count Buffer Allocated Count | |
CUMULATIVE, INT64, n/a | Number of buffers allocated. |
/instance/buffer/written_by_backend Buffers Written by Backend | |
CUMULATIVE, INT64, n/a | Number of buffers written directly by a backend. |
/instance/buffer/written_by_background_writer Buffers Written by Background Writer | |
CUMULATIVE, INT64, n/a | Number of buffers written by the background writer. |
/instance/buffer/written_during_checkpoint Buffers Written During Checkpoint | |
CUMULATIVE, INT64, n/a | Number of buffers written during checkpoints. |
/instance/estimated_replication_delay Estimated Replication Delay | |
GAUGE, INT64, s | Time since last replayed transaction timestamp from the replication master. |
/instance/requested_checkpoints_performed Requested Checkpoints Performed | |
CUMULATIVE, INT64, Checkpoints | Number of requested checkpoints that have been performed. |
/instance/scheduled_checkpoints_performed Scheduled Checkpoints Performed | |
CUMULATIVE, INT64, Checkpoints | Number of scheduled checkpoints that have been performed. |
/instance/time_synchronizing_checkpoint_files_to_disk Time Synchronizing Checkpoint Files to Disk | |
CUMULATIVE, INT64, ms | Total amount of time that has been spent in the portion of checkpoint processing where files are synchronized to disk. |
/instance/time_writing_checkpoint_files_to_disk Time Writing Checkpoint Files 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. |
/instance/times_backend_executed_own_fsync Times Backend Executed Own fsync | |
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). |
/instance/times_background_writer_stopped_due_to_too_many_buffers Times Background Writer Stopped Due to too Many Buffers | |
CUMULATIVE, INT64, n/a | Number of times the background writer stopped a cleaning scan because it had written too many buffers. |
/instance/wal_file_archives_failed WAL File Archives Failed | |
CUMULATIVE, INT64, n/a | Number of failed attempts for archiving WAL files. |
/instance/wal_files_archived WAL Files Archived | |
CUMULATIVE, INT64, n/a | Number of WAL files that have been successfully archived. |
/query/block/dirty_count Block Dirty Count | |
CUMULATIVE, INT64, Blocks | Total number of blocks dirtied by the statement. |
type: Type of block ('local', 'shared'). | |
/query/block/cache_hit_count Block Cache Hit Count | |
CUMULATIVE, INT64, Reads | Total number of block cache hits by the statement. |
type: Type of block ('local', 'shared'). | |
/query/block/io Block I/O | |
CUMULATIVE, INT64, Blocks | Number of blocks written and read. |
operation: Operation performed ('read', 'write'). | |
type: Type of block ('local', 'shared', 'temporary'). | |
/query/call_count Call Count | |
CUMULATIVE, INT64, Calls | Number of times query was executed. |
/query/average_time Average Time | |
GAUGE, DOUBLE, ms | Average time spent in the statement per execution. |
/query/rows Rows | |
CUMULATIVE, INT64, Rows | Total number of rows retrieved or affected by the statement. |
/replication/delay Delay | |
GAUGE, INT64, By | Amount of data that has not been replayed into database on the standby server. |
/replication/priority_of_standby_server Priority of Standby Server | |
GAUGE, INT64, n/a | Priority of this standby server for being chosen as the synchronous standby. |
/sequence/blocks_read Blocks Read | |
CUMULATIVE, INT64, Blocks | Number of disk blocks read from this sequence. |
/sequence/buffer_hits Buffer Hits | |
CUMULATIVE, INT64, Reads | Number of buffer hits for this sequence. |
/table/analyzes_by_auto_daemon Analyzes by Auto Daemon | |
CUMULATIVE, INT64, n/a | Number of times this table has been analyzed by the autovacuum daemon. |
/blocks_read_count Blocks read | |
CUMULATIVE, INT64, Blocks | Number of blocks read. |
database: The name of the database. | |
table: The name of the table. | |
/table/index_scans Index Scans | |
CUMULATIVE, INT64, Scans | Number of index scans initiated on this table. |
/table/manual_analyzes Manual Analyzes | |
CUMULATIVE, INT64, n/a | Number of times this table has been manually analyzed. |
/table/manual_vacuums Manual Vacuums | |
CUMULATIVE, INT64, n/a | Number of times this table has been manually vacuumed (not counting VACUUM FULL). |
/num_tuples DB rows | |
GAUGE, DOUBLE, Rows | Number of tuples (rows) in the database. |
state: Tuple (row) state (either 'dead' or 'live'). | |
table: The name of the table. | |
/operation_count Operations | |
CUMULATIVE, INT64, Rows | Number of db row operations. |
database: The name of the database. | |
table: The name of the table. | |
/table/rows/fetched_by_index_scans Rows Fetched by Index Scans | |
CUMULATIVE, INT64, Rows | Number of live rows fetched by index scans. |
/table/rows/fetched_by_sequential_scans Rows fetched by Sequential Scans | |
CUMULATIVE, INT64, Rows | Number of live rows fetched by sequential scans. |
/table/rows/modified_since_last_analyzed Rows Modified Since Last Analyzed | |
GAUGE, INT64, Rows | Estimated number of rows modified since this table was last analyzed. |
/table/sequential_scans Sequential Scans | |
CUMULATIVE, INT64, Scans | Number of sequential scans initiated on this table. |
/table/size Size | |
GAUGE, INT64, By | Disk space used by the table. |
/table/vacuums_by_auto_daemon Vacuums By Auto Daemon | |
CUMULATIVE, INT64, n/a | Number of times this table has been vacuumed by the autovacuum daemon. |
/tablespace/size Size | |
GAUGE, INT64, By | Size of the tablespace on disk. |
Updated almost 5 years ago