MENU
      Cloud DB for PostgreSQL (VPC) metrics
        • PDF

        Cloud DB for PostgreSQL (VPC) metrics

        • PDF

        Article summary

        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 nameData typeUnitMetric typeDescriptionIntervalAggregation
          cpu_userFLOAT%Basic, DefaultCPU user(%)Min1,Min5,Min30,Hour2,Day1
          cpu_sysFLOAT%BasicCPU kernel(%)Min1,Min5,Min30,Hour2,Day1
          cpu_iowaitFLOAT%BasicCPU iowait(%)Min1,Min5,Min30,Hour2,Day1
          cpu_totalFLOAT%Basic, DefaultCPU Used : (total cpu time - idle time) / (total cpu time) *100Min1,Min5,Min30,Hour2,Day1
          cpu_load_1FLOATavgBasic, DefaultLoad avg 1minMin1,Min5,Min30,Hour2,Day1
          cpu_load_5FLOATavgBasicLoad avg 5minMin1,Min5,Min30,Hour2,Day1
          cpu_load_15FLOATavgBasicLoad avg 15minMin1,Min5,Min30,Hour2,Day1
          mem_usedFLOAT%Basic, DefaultMemory used(%)Min1,Min5,Min30,Hour2,Day1
          swap_usedFLOAT%BasicSwap used(%)Min1,Min5,Min30,Hour2,Day1
          nic_txFLOATbytes/secBasicNIC send bytes per secMin1,Min5,Min30,Hour2,Day1
          nic_rxFLOATbytes/secBasicNIC receive bytes per secMin1,Min5,Min30,Hour2,Day1
          nic_totalFLOATbytes/secBasic, DefaultNIC total bytes per secMin1,Min5,Min30,Hour2,Day1
          disk_usageFLOATbytesBasic, DefaultDisk usage of "/data"Min1,Min5,Min30,Hour2,Day1
          disk_readFLOATbytes/secBasicDisk I/O Read bytesMin1,Min5,Min30,Hour2,Day1
          disk_writeFLOATbytes/secBasicDisk I/O Write bytesMin1,Min5,Min30,Hour2,Day1
          disk_totalFLOATbytes/secBasic, DefaultDisk I/O Total ByteMin1,Min5,Min30,Hour2,Day1
          active_session_countINTEGERgaugeBasic, DefaultActive session count of pg_stat_activiyMin1,Min5,Min30,Hour2,Day1
          total_session_countINTEGERgaugeBasicTotal session count of pg_stat_activityMin1,Min5,Min30,Hour2,Day1
          tup_returnedLONGcounterBasic, DefaultNumber of rows returned by queries in this databaseMin1,Min5,Min30,Hour2,Day1
          tup_fetchedLONGcounterBasic, DefaultNumber of rows fetched by queries in this databaseMin1,Min5,Min30,Hour2,Day1
          tup_insertedLONGcounterBasic, DefaultNumber of rows inserted by queries in this databaseMin1,Min5,Min30,Hour2,Day1
          tup_updatedLONGcounterBasic, DefaultNumber of rows updated by queries in this databaseMin1,Min5,Min30,Hour2,Day1
          tup_deletedLONGcounterBasic, DefaultNumber of rows deleted by queries in this databaseMin1,Min5,Min30,Hour2,Day1
          temp_bytesLONGcountBasicTotal amount of data written to temporary files by queries in this database.Min1,Min5,Min30,Hour2,Day1
          deadlocksLONGcountBasicNumber of deadlocks detected in this databaseMin1,Min5,Min30,Hour2,Day1
          conflictsLONGcountBasicNumber of queries canceled due to conflicts with recovery in this database.Min1,Min5,Min30,Hour2,Day1
          xact_commitLONGcountBasic, DefaultNumber of transactions in this database that have been committedMin1,Min5,Min30,Hour2,Day1
          xact_rollbackLONGcountBasicNumber of transactions in this database that have been rolled backMin1,Min5,Min30,Hour2,Day1
          access_shareLONGcountBasicAccess share lock countMin1,Min5,Min30,Hour2,Day1
          row_shareLONGcountBasicRow share lock countMin1,Min5,Min30,Hour2,Day1
          row_exclusiveLONGcountBasicRow exclusive lock countMin1,Min5,Min30,Hour2,Day1
          share_update_exclusiveLONGcountBasicShare update exclusive lock countMin1,Min5,Min30,Hour2,Day1
          shareLONGcountBasicShare lock countMin1,Min5,Min30,Hour2,Day1
          share_row_exclusiveLONGcountBasicShare row exclusive lock countMin1,Min5,Min30,Hour2,Day1
          exclusiveLONGcountBasicExclusive lock countMin1,Min5,Min30,Hour2,Day1
          access_exclusiveLONGcountBasicAccess exclusive lock countMin1,Min5,Min30,Hour2,Day1
          checkpoint_write_timeLONGmilisecondsBasicTotal amount of time that has been spent in the portion of checkpoint processing where files are written to disk, in millisecondsMin1,Min5,Min30,Hour2,Day1
          checkpoint_sync_timeLONGmilisecondsBasicTotal amount of time that has been spent in the portion of checkpoint processing where files are synchronized to disk, in millisecondsMin1,Min5,Min30,Hour2,Day1
          buffers_checkpointLONGcountBasicNumber of buffers written during checkpointsMin1,Min5,Min30,Hour2,Day1
          buffers_cleanLONGcountBasicNumber of buffers written by the background writerMin1,Min5,Min30,Hour2,Day1
          buffers_backendLONGcountBasicNumber of buffers written directly by a backendMin1,Min5,Min30,Hour2,Day1
          buffers_backend_fsyncLONGcountBasicNumber of times a backend had to execute its own fsync callMin1,Min5,Min30,Hour2,Day1
          buffers_allocLONGcountBasicNumber of buffers allocatedMin1,Min5,Min30,Hour2,Day1
          replication_lagFLOATsecondsBasicReplication delayMin1,Min5,Min30,Hour2,Day1
          database_sizeLONGbytesBasic, DefaultDatabase sizeMin1,Min5,Min30,Hour2,Day1
          slowqueryLONGcountBasic, DefaultNumber of slow queries being performed for more than 1 secondMin1,Min5,Min30,Hour2,Day1
          buffer_hit_ratioFLOAT%Basicbuffer cache hit ratioMin1,Min5,Min30,Hour2,Day1
          pg_upINTEGER-BasicDatabase Up if it's 1, database down if it's 0.Min1,Min5,Min30,Hour2,Day1
        • Dimension
          Dimension nameData type
          instanceNo

        Was this article helpful?

        Changing your password will log you out immediately. Use the new password to log back in.
        First name must have atleast 2 characters. Numbers and special characters are not allowed.
        Last name must have atleast 1 characters. Numbers and special characters are not allowed.
        Enter a valid email
        Enter a valid password
        Your profile has been successfully updated.