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 with agent.googleapis.com/postgresql

Google Cloud Monitoring Metrics
/database/row/operation_count
Row Operation Count
CUMULATIVE, INT64, RowsNumber 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/aNumber 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, SessionsNumber 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, BlocksNumber of buffer hits from all sequences in this database.
/database/sequence_blocks/read
Sequence Blocks Read
CUMULATIVE, INT64, BlocksNumber of disk blocks read from all sequences in this database.
/database/temporary_data_written
Temporary Data Written
CUMULATIVE, INT64, ByTotal 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/aNumber 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, msTime spent reading data file blocks by backends in this database.
/database/time_spent/writing_data
Time Spent Writing Data
CUMULATIVE, INT64, msTime spent writing data file blocks by backends in this database.
/rollback_count
Rollbacks
CUMULATIVE, INT64, TransactionsNumber of rollbacks.
database: The name of the database.
/commit_count
Commits
CUMULATIVE, INT64, TransactionsNumber of commits.
database: The name of the database.
/db_size
DB size
GAUGE, DOUBLE, ByDatabase disk usage.
database: The name of the database.
/database/deadlock_count
Deadlock Count
CUMULATIVE, INT64, LocksNumber of deadlocks detected in this database.
/database/buffer_hit_count
Buffer Hit Count
CUMULATIVE, INT64, ReadsNumber 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, ReadsNumber of blocks read.
/num_backends
Backends
GAUGE, DOUBLE, SessionsNumber of backends.
database: The name of the database.
/function/average_time
Average Time
GAUGE, DOUBLE, msAverage time spent in this function and all other functions called by it.
/function/calls
Calls
CUMULATIVE, INT64, CallsNumber of times this function has been called.
/function/self_time
Self Time
CUMULATIVE, INT64, msTotal time spent in this function itself, not including other functions called by it.
/function/total_time
Total Time
CUMULATIVE, INT64, msTotal time spent in this function and all other functions called by it.
/index/block_reads
Block Reads
CUMULATIVE, INT64, ReadsNumber of disk blocks read from this index.
/index/buffer_hits
Buffer Hits
CUMULATIVE, INT64, ReadsNumber of buffer hits for this index.
/index/entries_returned
Entries Returned
CUMULATIVE, INT64, RowsNumber of index entries returned by scans on this index.
/index/scans
Scans
CUMULATIVE, INT64, ScansNumber of index scans initiated on this index.
/index/table_rows_fetched
Table Rows Fetched
CUMULATIVE, INT64, FetchesNumber of live table rows fetched by simple index scans using this index.
/instance/buffer/allocated_count
Buffer Allocated Count
CUMULATIVE, INT64, n/aNumber of buffers allocated.
/instance/buffer/written_by_backend
Buffers Written by Backend
CUMULATIVE, INT64, n/aNumber of buffers written directly by a backend.
/instance/buffer/written_by_background_writer
Buffers Written by Background Writer
CUMULATIVE, INT64, n/aNumber of buffers written by the background writer.
/instance/buffer/written_during_checkpoint
Buffers Written During Checkpoint
CUMULATIVE, INT64, n/aNumber of buffers written during checkpoints.
/instance/estimated_replication_delay
Estimated Replication Delay
GAUGE, INT64, sTime since last replayed transaction timestamp from the replication master.
/instance/requested_checkpoints_performed
Requested Checkpoints Performed
CUMULATIVE, INT64, CheckpointsNumber of requested checkpoints that have been performed.
/instance/scheduled_checkpoints_performed
Scheduled Checkpoints Performed
CUMULATIVE, INT64, CheckpointsNumber of scheduled checkpoints that have been performed.
/instance/time_synchronizing_checkpoint_files_to_disk
Time Synchronizing Checkpoint Files to Disk
CUMULATIVE, INT64, msTotal 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, msTotal 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/aNumber 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/aNumber 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/aNumber of failed attempts for archiving WAL files.
/instance/wal_files_archived
WAL Files Archived
CUMULATIVE, INT64, n/aNumber of WAL files that have been successfully archived.
/query/block/dirty_count
Block Dirty Count
CUMULATIVE, INT64, BlocksTotal number of blocks dirtied by the statement.
type: Type of block ('local', 'shared').
/query/block/cache_hit_count
Block Cache Hit Count
CUMULATIVE, INT64, ReadsTotal number of block cache hits by the statement.
type: Type of block ('local', 'shared').
/query/block/io
Block I/O
CUMULATIVE, INT64, BlocksNumber of blocks written and read.
operation: Operation performed ('read', 'write').
type: Type of block ('local', 'shared', 'temporary').
/query/call_count
Call Count
CUMULATIVE, INT64, CallsNumber of times query was executed.
/query/average_time
Average Time
GAUGE, DOUBLE, msAverage time spent in the statement per execution.
/query/rows
Rows
CUMULATIVE, INT64, RowsTotal number of rows retrieved or affected by the statement.
/replication/delay
Delay
GAUGE, INT64, ByAmount 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/aPriority of this standby server for being chosen as the synchronous standby.
/sequence/blocks_read
Blocks Read
CUMULATIVE, INT64, BlocksNumber of disk blocks read from this sequence.
/sequence/buffer_hits
Buffer Hits
CUMULATIVE, INT64, ReadsNumber of buffer hits for this sequence.
/table/analyzes_by_auto_daemon
Analyzes by Auto Daemon
CUMULATIVE, INT64, n/aNumber of times this table has been analyzed by the autovacuum daemon.
/blocks_read_count
Blocks read
CUMULATIVE, INT64, BlocksNumber of blocks read.
database: The name of the database.
table: The name of the table.
/table/index_scans
Index Scans
CUMULATIVE, INT64, ScansNumber of index scans initiated on this table.
/table/manual_analyzes
Manual Analyzes
CUMULATIVE, INT64, n/aNumber of times this table has been manually analyzed.
/table/manual_vacuums
Manual Vacuums
CUMULATIVE, INT64, n/aNumber of times this table has been manually vacuumed (not counting VACUUM FULL).
/num_tuples
DB rows
GAUGE, DOUBLE, RowsNumber 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, RowsNumber 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, RowsNumber of live rows fetched by index scans.
/table/rows/fetched_by_sequential_scans
Rows fetched by Sequential Scans
CUMULATIVE, INT64, RowsNumber of live rows fetched by sequential scans.
/table/rows/modified_since_last_analyzed
Rows Modified Since Last Analyzed
GAUGE, INT64, RowsEstimated number of rows modified since this table was last analyzed.
/table/sequential_scans
Sequential Scans
CUMULATIVE, INT64, ScansNumber of sequential scans initiated on this table.
/table/size
Size
GAUGE, INT64, ByDisk space used by the table.
/table/vacuums_by_auto_daemon
Vacuums By Auto Daemon
CUMULATIVE, INT64, n/aNumber of times this table has been vacuumed by the autovacuum daemon.
/tablespace/size
Size
GAUGE, INT64, BySize of the tablespace on disk.