Google Cloud Monitoring Metrics

Metric Type
Display Name

Kind, Type, Unit

Description

Labels

Updates

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