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, 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.

🚧Metric prefixes

🚧
Metric prefixes