statistics
AuxiliaryDatabaseStatsLogRecord

The AuxiliaryDatabaseStats object holds details of interesting auxiliary database statistics.



public class AuxiliaryDatabaseStatsLogRecord

Stats For:
db.AuxiliaryDatabase

Properties
activeSystemSessionCount The number of active system sessions.

type=long
access=read-only
rollover=false

activeSystemSessionCountPeriodic The number of active system sessions.

type=long
access=read-only

activeThreadCount The current number of active threads.

type=long
access=read-only
rollover=false

activeThreadCountPeriodic The current number of active threads.

type=long
access=read-only

activeUserSessionCount The number of active user sessions (connections).

type=long
access=read-only
rollover=false

activeUserSessionCountPeriodic The number of active user sessions (connections).

type=long
access=read-only

addressSpaceRequestedKb The address space requested in kilobytes.

type=long
access=read-only
rollover=false

addressSpaceRequestedKbPeriodic The address space requested in kilobytes.

type=long
access=read-only

averageCpuUsagePercent Average CPU usage in percent of total CPU time (0-100) sampled from latest history interval.

type=double
access=read-only
rollover=false

averageCpuUsagePercentPeriodic Average CPU usage in percent of total CPU time (0-100) sampled from latest history interval.

type=double
access=read-only

averageIoReadKbytesPerSec Average number of kilobytes received from network (incoming) per second sampled from latest history interval.

type=double
access=read-only
rollover=false

averageIoReadKbytesPerSecPeriodic Average number of kilobytes received from network (incoming) per second sampled from latest history interval.

type=double
access=read-only

averageIoWrittenKbytesPerSec Average number of kilobytes transmitting to network (outgoing) per second sampled from latest history interval.

type=double
access=read-only
rollover=false

averageIoWrittenKbytesPerSecPeriodic Average number of kilobytes transmitting to network (outgoing) per second sampled from latest history interval.

type=double
access=read-only

averageMemoryUsagePercent Average memory usage in percent of total memory (0-100) sampled from latest history interval.

type=double
access=read-only
rollover=false

averageMemoryUsagePercentPeriodic Average memory usage in percent of total memory (0-100) sampled from latest history interval.

type=double
access=read-only

averageNetRxKbytesPerSecond Disk I/O average number of kilobytes read from disk per second sampled from latest history interval.

type=double
access=read-only
rollover=false

averageNetRxKbytesPerSecondPeriodic Disk I/O average number of kilobytes read from disk per second sampled from latest history interval.

type=double
access=read-only

averageNetTxKbytesPerSecond Average number of kilobytes written to disk per second sampled from latest history interval.

type=double
access=read-only
rollover=false

averageNetTxKbytesPerSecondPeriodic Average number of kilobytes written to disk per second sampled from latest history interval.

type=double
access=read-only

catalogDiskSpaceFreeMb The number of megabytes of free storage available for catalog files.

type=long
access=read-only
rollover=false

catalogDiskSpaceFreeMbPeriodic The number of megabytes of free storage available for catalog files.

type=long
access=read-only

catalogDiskSpaceUsedMb The number of megabytes of disk storage in use for catalog files.

type=long
access=read-only
rollover=false

catalogDiskSpaceUsedMbPeriodic The number of megabytes of disk storage in use for catalog files.

type=long
access=read-only

dataDiskSpaceFreeMb The number of megabytes of free storage available for data files.

type=long
access=read-only
rollover=false

dataDiskSpaceFreeMbPeriodic The number of megabytes of free storage available for data files.

type=long
access=read-only

dataDiskSpaceUsedMb The number of megabytes of disk storage in use for data files.

type=long
access=read-only
rollover=false

dataDiskSpaceUsedMbPeriodic The number of megabytes of disk storage in use for data files.

type=long
access=read-only

databaseRawSizeBytes The number of performance stats temporary tables containing current data that are waiting to be deleted.

type=long
access=read-only
default=0
rollover=false

databaseRawSizeBytesPeriodic The number of performance stats temporary tables containing current data that are waiting to be deleted.

type=long
access=read-only
default=0

diskSpaceFreeMb The free disk space available, in megabytes, for all storage location file systems (data directories).

type=long
access=read-only
rollover=false

diskSpaceFreeMbPeriodic The free disk space available, in megabytes, for all storage location file systems (data directories).

type=long
access=read-only

diskSpaceRequestRejectCount The number of rejected disk write requests.

type=long
access=read-only
rollover=false

diskSpaceRequestRejectCountPeriodic The number of rejected disk write requests.

type=long
access=read-only

diskSpaceTotalMb The total free disk space available, in megabytes, for all storage location file systems.

type=long
access=read-only
rollover=false

diskSpaceTotalMbPeriodic The total free disk space available, in megabytes, for all storage location file systems.

type=long
access=read-only

diskSpaceUsedMb The disk space used, in megabytes, for all storage location file systems.

type=long
access=read-only
rollover=false

diskSpaceUsedMbPeriodic The disk space used, in megabytes, for all storage location file systems.

type=long
access=read-only

executedQueryCount The total number of queries that ran.

type=long
access=read-only
rollover=false

executedQueryCountPeriodic The total number of queries that ran.

type=long
access=read-only

failedVolumeRejectCount The number of rejections due to a failed volume.

type=long
access=read-only
rollover=false

failedVolumeRejectCountPeriodic The number of rejections due to a failed volume.

type=long
access=read-only

localRequestCount The cumulative number of local requests.

type=long
access=read-only
rollover=false

localRequestCountPeriodic The cumulative number of local requests.

type=long
access=read-only

markedAsDeletedRowCountTotal The sum of the number of rows marked for deletion for all projections.

type=long
access=read-only
rollover=false

markedAsDeletedRowCountTotalPeriodic The sum of the number of rows marked for deletion for all projections.

type=long
access=read-only

markedAsDeletedUsedBytesTotal The sum of the number of bytes used to store the deletion for all projections.

type=long
access=read-only
rollover=false

markedAsDeletedUsedBytesTotalPeriodic The sum of the number of bytes used to store the deletion for all projections.

type=long
access=read-only

memoryRequestedKb The memory requested in kilobytes.

type=long
access=read-only
rollover=false

memoryRequestedKbPeriodic The memory requested in kilobytes.

type=long
access=read-only

openFileHandleCount The current number of open file handles.

type=long
access=read-only
rollover=false

openFileHandleCountPeriodic The current number of open file handles.

type=long
access=read-only

openedFileCount The total number of open files on the node.

type=long
access=read-only
rollover=false

openedFileCountPeriodic The total number of open files on the node.

type=long
access=read-only

openedNonfileNonsocketCount The total number of other file descriptions open in which 'other' could be a directory or FIFO. It is not an open file or socket.

type=long
access=read-only
rollover=false

openedNonfileNonsocketCountPeriodic The total number of other file descriptions open in which 'other' could be a directory or FIFO. It is not an open file or socket.

type=long
access=read-only

openedSocketCount The total number of open sockets on the node.

type=long
access=read-only
rollover=false

openedSocketCountPeriodic The total number of open sockets on the node.

type=long
access=read-only

processDataMemorySizeBytes The amount of physical memory, in pages, used for performing processes. This does not include the executable code.

type=long
access=read-only
rollover=false

processDataMemorySizeBytesPeriodic The amount of physical memory, in pages, used for performing processes. This does not include the executable code.

type=long
access=read-only

processDirtyMemorySizeBytes The number of pages that have been modified since they were last written to disk.

type=long
access=read-only
rollover=false

processDirtyMemorySizeBytesPeriodic The number of pages that have been modified since they were last written to disk.

type=long
access=read-only

processLibraryMemorySizeBytes The total number of library pages that the process has in physical memory.

type=long
access=read-only
rollover=false

processLibraryMemorySizeBytesPeriodic The total number of library pages that the process has in physical memory.

type=long
access=read-only

processResidentSetSizeBytes The total number of pages that the process has in memory.

type=long
access=read-only
rollover=false

processResidentSetSizeBytesPeriodic The total number of pages that the process has in memory.

type=long
access=read-only

processSharedMemorySizeBytes The amount of shared memory used.

type=long
access=read-only
rollover=false

processSharedMemorySizeBytesPeriodic The amount of shared memory used.

type=long
access=read-only

processSizeBytes The total size of the program.

type=long
access=read-only
rollover=false

processSizeBytesPeriodic The total size of the program.

type=long
access=read-only

processTextMemorySizeBytes The total number of text pages that the process has in physical memory. This does not include any shared libraries.

type=long
access=read-only
rollover=false

processTextMemorySizeBytesPeriodic The total number of text pages that the process has in physical memory. This does not include any shared libraries.

type=long
access=read-only

requestCount The cumulative number of requests for threads, file handles, and memory (in kilobytes).

type=long
access=read-only
rollover=false

requestCountPeriodic The cumulative number of requests for threads, file handles, and memory (in kilobytes).

type=long
access=read-only

requestQueueDepth The current request queue depth.

type=long
access=read-only
rollover=false

requestQueueDepthPeriodic The current request queue depth.

type=long
access=read-only

resourceRequestCancelCount The number of resource request cancelations.

type=long
access=read-only
rollover=false

resourceRequestCancelCountPeriodic The number of resource request cancelations.

type=long
access=read-only

resourceRequestRejectCount The number of rejected plan requests.

type=long
access=read-only
rollover=false

resourceRequestRejectCountPeriodic The number of rejected plan requests.

type=long
access=read-only

resourceRequestTimeoutCount The number of resource request timeouts.

type=long
access=read-only
rollover=false

resourceRequestTimeoutCountPeriodic The number of resource request timeouts.

type=long
access=read-only

rosRowCount The number of rows in the ROS.

type=long
access=read-only
rollover=false

rosRowCountPeriodic The number of rows in the ROS.

type=long
access=read-only

rosUsedBytes The size of the ROS in bytes.

type=long
access=read-only
rollover=false

rosUsedBytesPeriodic The size of the ROS in bytes.

type=long
access=read-only

runningQueryCount The number of queries currently running.

type=long
access=read-only
rollover=false

runningQueryCountPeriodic The number of queries currently running.

type=long
access=read-only

samTotalSessions The total number of active sessions.

type=long
access=read-only
default=0
rollover=false

samTotalSessionsPeriodic The total number of active sessions.

type=long
access=read-only
default=0

samauxdbSessions The number of active DBA user sessions.

type=long
access=read-only
default=0
rollover=false

samauxdbSessionsPeriodic The number of active DBA user sessions.

type=long
access=read-only
default=0

samuserSessions The number of active NFM-P user sessions.

type=long
access=read-only
default=0
rollover=false

samuserSessionsPeriodic The number of active NFM-P user sessions.

type=long
access=read-only
default=0

tmpDiskSpaceFreeMb The number of megabytes of free storage available for temporary files.

type=long
access=read-only
rollover=false

tmpDiskSpaceFreeMbPeriodic The number of megabytes of free storage available for temporary files.

type=long
access=read-only

tmpDiskSpaceUsedMb The number of megabytes of disk storage in use for temporary files.

type=long
access=read-only
rollover=false

tmpDiskSpaceUsedMbPeriodic The number of megabytes of disk storage in use for temporary files.

type=long
access=read-only

totalActiveSessionCount The total number of active user and system sessions.

type=long
access=read-only
rollover=false

totalActiveSessionCountPeriodic The total number of active user and system sessions.

type=long
access=read-only

totalBufferMemoryBytes The amount of physical RAM, in bytes, used for file buffers on the system

type=long
access=read-only
rollover=false

totalBufferMemoryBytesPeriodic The amount of physical RAM, in bytes, used for file buffers on the system

type=long
access=read-only

totalMemoryBytes The total amount of physical RAM, in bytes, available on the system.

type=long
access=read-only
rollover=false

totalMemoryBytesPeriodic The total amount of physical RAM, in bytes, available on the system.

type=long
access=read-only

totalMemoryCacheBytes The amount of physical RAM, in bytes, used as cache memory on the system.

type=long
access=read-only
rollover=false

totalMemoryCacheBytesPeriodic The amount of physical RAM, in bytes, used as cache memory on the system.

type=long
access=read-only

totalMemoryFreeBytes The amount of physical RAM, in bytes, left unused by the system.

type=long
access=read-only
rollover=false

totalMemoryFreeBytesPeriodic The amount of physical RAM, in bytes, left unused by the system.

type=long
access=read-only

totalRowCount The total number of rows in storage (WOS + ROS).

DEPRECATED: 23.11 - This attribute has been removed in Vertica 12
type=long
access=read-only
rollover=false

totalRowCountPeriodic The total number of rows in storage (WOS + ROS).

DEPRECATED: 23.11 - This attribute has been removed in Vertica 12
type=long
access=read-only

totalSessionCount The total number of user and system sessions.

type=long
access=read-only
rollover=false

totalSessionCountPeriodic The total number of user and system sessions.

type=long
access=read-only

totalSwapMemoryBytes The total amount of swap memory available, in bytes, on the system.

type=long
access=read-only
rollover=false

totalSwapMemoryBytesPeriodic The total amount of swap memory available, in bytes, on the system.

type=long
access=read-only

totalSwapMemoryFreeBytes The total amount of swap memory free, in bytes, on the system.

type=long
access=read-only
rollover=false

totalSwapMemoryFreeBytesPeriodic The total amount of swap memory free, in bytes, on the system.

type=long
access=read-only

totalSystemSessionCount The total number of system sessions.

type=long
access=read-only
rollover=false

totalSystemSessionCountPeriodic The total number of system sessions.

type=long
access=read-only

totalUsedBytes The total size of storage (WOS + ROS) in bytes.

DEPRECATED: 23.11 - This attribute has been removed in Vertica 12
type=long
access=read-only
rollover=false

totalUsedBytesPeriodic The total size of storage (WOS + ROS) in bytes.

DEPRECATED: 23.11 - This attribute has been removed in Vertica 12
type=long
access=read-only

totalUserSessionCount The total number of user sessions.

type=long
access=read-only
rollover=false

totalUserSessionCountPeriodic The total number of user sessions.

type=long
access=read-only

wosRowCount The number of rows in the WOS.

DEPRECATED: 23.11 - This attribute has been removed in Vertica 12
type=long
access=read-only
rollover=false

wosRowCountPeriodic The number of rows in the WOS.

DEPRECATED: 23.11 - This attribute has been removed in Vertica 12
type=long
access=read-only

wosUsedBytes The size of the WOS in bytes.

DEPRECATED: 23.11 - This attribute has been removed in Vertica 12
type=long
access=read-only
rollover=false

wosUsedBytesPeriodic The size of the WOS in bytes.

DEPRECATED: 23.11 - This attribute has been removed in Vertica 12
type=long
access=read-only

  
Properties inherited from log.LogRecord
createdOnPollType, displayedName, monitoredObjectClass, monitoredObjectPointer, monitoredObjectSiteId, monitoredObjectSiteName, periodicTime, suspect, timeCaptured, timeLogged, updatedOnPollType
 
Properties inherited from ManagedObject
actionMask, children-Set, deploymentState, isFaultSquelched, name, objectFullName, selfAlarmed