Cloud DB for PostgreSQL (VPC)指標

Prev Next

VPC環境で利用できます。

Cloud DB for PostgreSQLサービスのパフォーマンス/運用指標(メトリック)関連情報の説明です。パフォーマンス/運用指標は、NAVERクラウドプラットフォームの Cloud Insightサービスを通じて統合管理することができ、さまざまなモニタリングに活用できます。

参考

パフォーマンス/運用指標をモニタリングに活用する方法は、Cloud Insight APIガイドをご参照ください。

基本情報

パフォーマンス/運用指標を活用するための Cloud DB for PostgreSQLサービスの基本情報は次の通りです。

  • 商品名(prodName)
    • System/Cloud DB for PostgreSQL(VPC)
  • 商品キー(cw_key)
    • 680818728480411648

パフォーマンス/運用指標

Cloud DB for PostgreSQLサービスのパフォーマンス/運用指標は次の通りです。

  • 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