Vertica integration metrics

The official Datadog integration for monitoring Vertica. It collects 82 metrics.

Official summary

Monitor Vertica projection storage, license usage, and more.

Metric types

  • gauge (value at a point in time): 80
  • count (occurrences in the interval): 2

Metrics

Descriptions are the official definitions, unedited.

MetricTypeUnit
vertica.connection.activeThe current number of connections to a node.gaugeconnection
vertica.connection.totalThe total number of connections to a node.countconnection
vertica.delete_vectorsThe total number of delete vectors.gaugeitem
vertica.disk.usedThe total disk space (compressed) used in bytes.gaugebyte
vertica.disk.used.ros[Only versions <= 10] The total ROS disk space (compressed) used in bytes.gaugebyte
vertica.disk.used.wos[Only versions <= 10] The total WOS disk space (compressed) used in bytes.gaugebyte
vertica.epoch.ahmThe current epoch number.gaugetime
vertica.epoch.currentThe AHM epoch number.gaugetime
vertica.epoch.last_goodThe smallest (min) of all the checkpoint epochs on the cluster.gaugetime
vertica.file.maxThe maximum number of files that can be open at one time.gaugefile
vertica.file.openThe number of open files.gaugefile
vertica.ksafety.currentThe number of node failures the cluster can tolerate before it shuts down automatically.gaugenode
vertica.ksafety.intendedThe designed or intended K-safety level.gaugenode
vertica.license.expirationThe time until license expiration.gaugesecond
vertica.license.latest_auditThe time elapsed since the latest license audit was triggered.gaugesecond
vertica.license.sizeThe total size of the license in bytes.gaugebyte
vertica.license.usableThe total usable size of the license in bytes.gaugebyte
vertica.license.usedThe total used size of the license in bytes.gaugebyte
vertica.license.utilizedThe utilization of the license as a percentage.gaugepercent
vertica.memory.swap.totalThe total amount of swap memory in bytes.gaugebyte
vertica.memory.swap.usableThe total usable amount of swap memory in bytes.gaugebyte
vertica.memory.swap.usedThe total used amount of swap memory in bytes.gaugebyte
vertica.memory.swap.utilizedThe utilization of swap memory as a percentage.gaugepercent
vertica.memory.totalThe total amount of physical RAM in bytes.gaugebyte
vertica.memory.usableThe total usable amount of physical RAM in bytes.gaugebyte
vertica.memory.usedThe total used amount of physical RAM in bytes.gaugebyte
vertica.memory.utilizedThe utilization of physical RAM as a percentage.gaugepercent
vertica.node.allowedThe number of nodes permitted for use by the license.gaugenode
vertica.node.availableThe number of available nodes remaining based on the license limit.gaugenode
vertica.node.delete_vectorsThe number of delete vectors in nodes.gaugeitem
vertica.node.disk.usedThe total disk space used by nodes in bytes.gaugebyte
vertica.node.disk.used.ros[Only versions <= 10] The ROS disk space used by nodes in bytes.gaugebyte
vertica.node.disk.used.wos[Only versions <= 10] The WOS disk space used by nodes in bytes.gaugebyte
vertica.node.downThe number of nodes that are currently down.gaugenode
vertica.node.resource_requestsThe cumulative number of requests for threads, file handles, and memory (in kilobytes).gaugeresource
vertica.node.ros.containersThe number of ROS containers in nodes.gaugeresource
vertica.node.row.ros[Only versions <= 10] The number of ROS rows in nodes.gaugerow
vertica.node.row.totalThe total number of rows in nodes.gaugerow
vertica.node.row.wos[Only versions <= 10] The number of WOS rows in nodes.gaugerow
vertica.node.totalThe number of nodes currently in use.gaugenode
vertica.processor.coreThe number of processor cores in the system.gaugecore
vertica.processor.cpuThe number of system processors.gaugecpu
vertica.projection.delete_vectorsThe number of delete vectors in projections.gaugeitem
vertica.projection.disk.usedThe total disk space used by projections in bytes.gaugebyte
vertica.projection.disk.used.ros[Only versions <= 10] The ROS disk space used by projections in bytes.gaugebyte
vertica.projection.disk.used.wos[Only versions <= 10] The WOS disk space used by projections in bytes.gaugebyte
vertica.projection.ros.containersThe number of ROS containers in projections.gaugeresource
vertica.projection.row.ros[Only versions <= 10] The number of ROS rows in projections.gaugerow
vertica.projection.row.totalThe total number of rows in projections.gaugerow
vertica.projection.row.wos[Only versions <= 10] The number of WOS rows in projections.gaugerow
vertica.projection.totalThe total number of projections.gaugetable
vertica.projection.unsafeThe number of projections that are not up to date.gaugetable
vertica.projection.unsafe_percentThe percentage of projections that are not up to date.gaugepercent
vertica.projection.unsegmentedThe number of projections that are not segmented.gaugetable
vertica.projection.unsegmented_percentThe percentage of projections that are not segmented.gaugepercent
vertica.query.activeThe current number of queries running on a node.gaugequery
vertica.query.totalThe total number of queries executed on a node.countquery
vertica.resource_pool.memory.borrowedThe amount of memory borrowed from the GENERAL pool by requests running against pools.gaugebyte
vertica.resource_pool.memory.maxThe value of the MAXMEMORYSIZE parameter as defined for pools.gaugebyte
vertica.resource_pool.memory.usedThe amount of memory acquired by requests running against pools.gaugebyte
vertica.resource_pool.query.runningThe number of queries currently executing in pools.gaugequery
vertica.ros.containersThe total number of ROS containers.gaugeresource
vertica.row.ros[Only versions <= 10] The total number of ROS rows.gaugerow
vertica.row.totalThe total number of rows.gaugerow
vertica.row.wos[Only versions <= 10] The total number of WOS rows.gaugerow
vertica.socket.openThe number of open sockets.gaugefile
vertica.storage.latencyThe latency of a storage location in seeks per second.gaugeread/second
vertica.storage.sizeThe total size of a storage location in bytes.gaugebyte
vertica.storage.speedThe time (in seconds) it takes to read 1 mebibyte from a storage location.gaugesecond
vertica.storage.throughputThe throughput of a storage location in mebibytes per second.gaugemebibyte/second
vertica.storage.usableThe total usable size of a storage location in bytes.gaugebyte
vertica.storage.usedThe total used size of a storage location in bytes.gaugebyte
vertica.storage.utilizedThe utilization of a storage location as a percentage.gaugepercent
vertica.table.disk.usedThe total disk space used by tables in bytes.gaugebyte
vertica.table.disk.used.ros[Only versions <= 10] The ROS disk space used by tables in bytes.gaugebyte
vertica.table.disk.used.wos[Only versions <= 10] The WOS disk space used by tables in bytes.gaugebyte
vertica.table.ros.containersThe number of ROS containers in tables.gaugeresource
vertica.table.row.ros[Only versions <= 10] The number of ROS rows in tables.gaugerow
vertica.table.row.totalThe total number of rows in tables.gaugerow
vertica.table.row.wos[Only versions <= 10] The number of WOS rows in tables.gaugerow
vertica.thread.activeThe number of active threads.gaugethread
vertica.thread.maxThe maximum number of threads that can coexist.gaugethread

Official documentation

Official documentation for the Vertica integration

Metric names and descriptions are the official Datadog integration definitions (Copyright Datadog, Inc., BSD-3-Clause), reproduced unedited. The full license terms are on the About page.