Cloud DB for PostgreSQL (VPC) metrics
- Print
- PDF
Cloud DB for PostgreSQL (VPC) metrics
- Print
- PDF
Article summary
Did you find this summary helpful?
Thank you for your feedback
Available in VPC
This section provides information on the performance and operational metrics of the Cloud DB for PostgreSQL service. Performance/operational metrics can be managed in an integrated manner through NAVER Cloud Platform's Cloud Insight service and can be used for various monitoring purposes.
Note
See the Cloud Insight API Guide for information on how to use performance/operational metrics for monitoring.
Basic information
The following is the basic information of the Cloud DB for PostgreSQL service for using performance/operational metrics.
- Product name (
prodName
)- System/Cloud DB for PostgreSQL(VPC)
- Product key (
cw_key
)- 680818728480411648
Performance/operation metrics
The performance/operational metrics of the Cloud DB for PostgreSQL service are as follows.
- Metric
Metric name Data type Unit Metric type Description Interval Aggregation cpu_user FLOAT % Basic, Default CPU user(%) Min1,Min5,Min30,Hour2,Day1 cpu_sys FLOAT % Basic CPU kernel(%) Min1,Min5,Min30,Hour2,Day1 cpu_iowait FLOAT % Basic CPU iowait(%) Min1,Min5,Min30,Hour2,Day1 cpu_total FLOAT % Basic, Default CPU Used : (total cpu time - idle time) / (total cpu time) *100 Min1,Min5,Min30,Hour2,Day1 cpu_load_1 FLOAT avg Basic, Default Load avg 1min Min1,Min5,Min30,Hour2,Day1 cpu_load_5 FLOAT avg Basic Load avg 5min Min1,Min5,Min30,Hour2,Day1 cpu_load_15 FLOAT avg Basic Load avg 15min Min1,Min5,Min30,Hour2,Day1 mem_used FLOAT % Basic, Default Memory used(%) Min1,Min5,Min30,Hour2,Day1 swap_used FLOAT % Basic Swap used(%) Min1,Min5,Min30,Hour2,Day1 nic_tx FLOAT bytes/sec Basic NIC send bytes per sec Min1,Min5,Min30,Hour2,Day1 nic_rx FLOAT bytes/sec Basic NIC receive bytes per sec Min1,Min5,Min30,Hour2,Day1 nic_total FLOAT bytes/sec Basic, Default NIC total bytes per sec Min1,Min5,Min30,Hour2,Day1 disk_usage FLOAT bytes Basic, Default Disk usage of "/data" Min1,Min5,Min30,Hour2,Day1 disk_read FLOAT bytes/sec Basic Disk I/O Read bytes Min1,Min5,Min30,Hour2,Day1 disk_write FLOAT bytes/sec Basic Disk I/O Write bytes Min1,Min5,Min30,Hour2,Day1 disk_total FLOAT bytes/sec Basic, Default Disk I/O Total Byte Min1,Min5,Min30,Hour2,Day1 active_session_count INTEGER gauge Basic, Default Active session count of pg_stat_activiy Min1,Min5,Min30,Hour2,Day1 total_session_count INTEGER gauge Basic Total session count of pg_stat_activity Min1,Min5,Min30,Hour2,Day1 tup_returned LONG counter Basic, Default Number of rows returned by queries in this database Min1,Min5,Min30,Hour2,Day1 tup_fetched LONG counter Basic, Default Number of rows fetched by queries in this database Min1,Min5,Min30,Hour2,Day1 tup_inserted LONG counter Basic, Default Number of rows inserted by queries in this database Min1,Min5,Min30,Hour2,Day1 tup_updated LONG counter Basic, Default Number of rows updated by queries in this database Min1,Min5,Min30,Hour2,Day1 tup_deleted LONG counter Basic, Default Number of rows deleted by queries in this database Min1,Min5,Min30,Hour2,Day1 temp_bytes LONG count Basic Total amount of data written to temporary files by queries in this database. Min1,Min5,Min30,Hour2,Day1 deadlocks LONG count Basic Number of deadlocks detected in this database Min1,Min5,Min30,Hour2,Day1 conflicts LONG count Basic Number of queries canceled due to conflicts with recovery in this database. Min1,Min5,Min30,Hour2,Day1 xact_commit LONG count Basic, Default Number of transactions in this database that have been committed Min1,Min5,Min30,Hour2,Day1 xact_rollback LONG count Basic Number of transactions in this database that have been rolled back Min1,Min5,Min30,Hour2,Day1 access_share LONG count Basic Access share lock count Min1,Min5,Min30,Hour2,Day1 row_share LONG count Basic Row share lock count Min1,Min5,Min30,Hour2,Day1 row_exclusive LONG count Basic Row exclusive lock count Min1,Min5,Min30,Hour2,Day1 share_update_exclusive LONG count Basic Share update exclusive lock count Min1,Min5,Min30,Hour2,Day1 share LONG count Basic Share lock count Min1,Min5,Min30,Hour2,Day1 share_row_exclusive LONG count Basic Share row exclusive lock count Min1,Min5,Min30,Hour2,Day1 exclusive LONG count Basic Exclusive lock count Min1,Min5,Min30,Hour2,Day1 access_exclusive LONG count Basic Access exclusive lock count Min1,Min5,Min30,Hour2,Day1 checkpoint_write_time LONG miliseconds Basic Total amount of time that has been spent in the portion of checkpoint processing where files are written to disk, in milliseconds Min1,Min5,Min30,Hour2,Day1 checkpoint_sync_time LONG miliseconds Basic Total amount of time that has been spent in the portion of checkpoint processing where files are synchronized to disk, in milliseconds Min1,Min5,Min30,Hour2,Day1 buffers_checkpoint LONG count Basic Number of buffers written during checkpoints Min1,Min5,Min30,Hour2,Day1 buffers_clean LONG count Basic Number of buffers written by the background writer Min1,Min5,Min30,Hour2,Day1 buffers_backend LONG count Basic Number of buffers written directly by a backend Min1,Min5,Min30,Hour2,Day1 buffers_backend_fsync LONG count Basic Number of times a backend had to execute its own fsync call Min1,Min5,Min30,Hour2,Day1 buffers_alloc LONG count Basic Number of buffers allocated Min1,Min5,Min30,Hour2,Day1 replication_lag FLOAT seconds Basic Replication delay Min1,Min5,Min30,Hour2,Day1 database_size LONG bytes Basic, Default Database size Min1,Min5,Min30,Hour2,Day1 slowquery LONG count Basic, Default Number of slow queries being performed for more than 1 second Min1,Min5,Min30,Hour2,Day1 buffer_hit_ratio FLOAT % Basic buffer cache hit ratio Min1,Min5,Min30,Hour2,Day1 pg_up INTEGER - Basic Database Up if it's 1, database down if it's 0. Min1,Min5,Min30,Hour2,Day1 - Dimension
Dimension name Data type instanceNo
Was this article helpful?