statistics
AuxiliaryDatabaseStatsLogPolicy

The AuxiliaryDatabaseStats object holds details of interesting auxiliary database statistics.



public class AuxiliaryDatabaseStatsLogPolicy

Stats For:
db.AuxiliaryDatabase

Properties
activeSystemSessionCountPeriodicThreshold The number of active system sessions.

type=long
access=read-only
rollover=false

activeSystemSessionCountPeriodicThresholdEnabled

type=boolean
access=read-only
default=false
rollover=false

activeThreadCountPeriodicThreshold The current number of active threads.

type=long
access=read-only
rollover=false

activeThreadCountPeriodicThresholdEnabled

type=boolean
access=read-only
default=false
rollover=false

activeUserSessionCountPeriodicThreshold The number of active user sessions (connections).

type=long
access=read-only
rollover=false

activeUserSessionCountPeriodicThresholdEnabled

type=boolean
access=read-only
default=false
rollover=false

addressSpaceRequestedKbPeriodicThreshold The address space requested in kilobytes.

type=long
access=read-only
rollover=false

addressSpaceRequestedKbPeriodicThresholdEnabled

type=boolean
access=read-only
default=false
rollover=false

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

type=double
access=read-only
rollover=false

averageCpuUsagePercentPeriodicThresholdEnabled

type=boolean
access=read-only
default=false
rollover=false

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

type=double
access=read-only
rollover=false

averageIoReadKbytesPerSecPeriodicThresholdEnabled

type=boolean
access=read-only
default=false
rollover=false

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

type=double
access=read-only
rollover=false

averageIoWrittenKbytesPerSecPeriodicThresholdEnabled

type=boolean
access=read-only
default=false
rollover=false

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

type=double
access=read-only
rollover=false

averageMemoryUsagePercentPeriodicThresholdEnabled

type=boolean
access=read-only
default=false
rollover=false

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

type=double
access=read-only
rollover=false

averageNetRxKbytesPerSecondPeriodicThresholdEnabled

type=boolean
access=read-only
default=false
rollover=false

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

type=double
access=read-only
rollover=false

averageNetTxKbytesPerSecondPeriodicThresholdEnabled

type=boolean
access=read-only
default=false
rollover=false

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

type=long
access=read-only
rollover=false

catalogDiskSpaceFreeMbPeriodicThresholdEnabled

type=boolean
access=read-only
default=false
rollover=false

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

type=long
access=read-only
rollover=false

catalogDiskSpaceUsedMbPeriodicThresholdEnabled

type=boolean
access=read-only
default=false
rollover=false

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

type=long
access=read-only
rollover=false

dataDiskSpaceFreeMbPeriodicThresholdEnabled

type=boolean
access=read-only
default=false
rollover=false

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

type=long
access=read-only
rollover=false

dataDiskSpaceUsedMbPeriodicThresholdEnabled

type=boolean
access=read-only
default=false
rollover=false

databaseRawSizeBytesPeriodicThreshold 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

databaseRawSizeBytesPeriodicThresholdEnabled

type=boolean
access=read-only
default=false
rollover=false

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

type=long
access=read-only
rollover=false

diskSpaceFreeMbPeriodicThresholdEnabled

type=boolean
access=read-only
default=false
rollover=false

diskSpaceRequestRejectCountPeriodicThreshold The number of rejected disk write requests.

type=long
access=read-only
rollover=false

diskSpaceRequestRejectCountPeriodicThresholdEnabled

type=boolean
access=read-only
default=false
rollover=false

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

type=long
access=read-only
rollover=false

diskSpaceTotalMbPeriodicThresholdEnabled

type=boolean
access=read-only
default=false
rollover=false

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

type=long
access=read-only
rollover=false

diskSpaceUsedMbPeriodicThresholdEnabled

type=boolean
access=read-only
default=false
rollover=false

executedQueryCountPeriodicThreshold The total number of queries that ran.

type=long
access=read-only
rollover=false

executedQueryCountPeriodicThresholdEnabled

type=boolean
access=read-only
default=false
rollover=false

failedVolumeRejectCountPeriodicThreshold The number of rejections due to a failed volume.

type=long
access=read-only
rollover=false

failedVolumeRejectCountPeriodicThresholdEnabled

type=boolean
access=read-only
default=false
rollover=false

localRequestCountPeriodicThreshold The cumulative number of local requests.

type=long
access=read-only
rollover=false

localRequestCountPeriodicThresholdEnabled

type=boolean
access=read-only
default=false
rollover=false

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

type=long
access=read-only
rollover=false

markedAsDeletedRowCountTotalPeriodicThresholdEnabled

type=boolean
access=read-only
default=false
rollover=false

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

type=long
access=read-only
rollover=false

markedAsDeletedUsedBytesTotalPeriodicThresholdEnabled

type=boolean
access=read-only
default=false
rollover=false

memoryRequestedKbPeriodicThreshold The memory requested in kilobytes.

type=long
access=read-only
rollover=false

memoryRequestedKbPeriodicThresholdEnabled

type=boolean
access=read-only
default=false
rollover=false

openFileHandleCountPeriodicThreshold The current number of open file handles.

type=long
access=read-only
rollover=false

openFileHandleCountPeriodicThresholdEnabled

type=boolean
access=read-only
default=false
rollover=false

openedFileCountPeriodicThreshold The total number of open files on the node.

type=long
access=read-only
rollover=false

openedFileCountPeriodicThresholdEnabled

type=boolean
access=read-only
default=false
rollover=false

openedNonfileNonsocketCountPeriodicThreshold 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

openedNonfileNonsocketCountPeriodicThresholdEnabled

type=boolean
access=read-only
default=false
rollover=false

openedSocketCountPeriodicThreshold The total number of open sockets on the node.

type=long
access=read-only
rollover=false

openedSocketCountPeriodicThresholdEnabled

type=boolean
access=read-only
default=false
rollover=false

processDataMemorySizeBytesPeriodicThreshold 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

processDataMemorySizeBytesPeriodicThresholdEnabled

type=boolean
access=read-only
default=false
rollover=false

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

type=long
access=read-only
rollover=false

processDirtyMemorySizeBytesPeriodicThresholdEnabled

type=boolean
access=read-only
default=false
rollover=false

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

type=long
access=read-only
rollover=false

processLibraryMemorySizeBytesPeriodicThresholdEnabled

type=boolean
access=read-only
default=false
rollover=false

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

type=long
access=read-only
rollover=false

processResidentSetSizeBytesPeriodicThresholdEnabled

type=boolean
access=read-only
default=false
rollover=false

processSharedMemorySizeBytesPeriodicThreshold The amount of shared memory used.

type=long
access=read-only
rollover=false

processSharedMemorySizeBytesPeriodicThresholdEnabled

type=boolean
access=read-only
default=false
rollover=false

processSizeBytesPeriodicThreshold The total size of the program.

type=long
access=read-only
rollover=false

processSizeBytesPeriodicThresholdEnabled

type=boolean
access=read-only
default=false
rollover=false

processTextMemorySizeBytesPeriodicThreshold 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

processTextMemorySizeBytesPeriodicThresholdEnabled

type=boolean
access=read-only
default=false
rollover=false

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

type=long
access=read-only
rollover=false

requestCountPeriodicThresholdEnabled

type=boolean
access=read-only
default=false
rollover=false

requestQueueDepthPeriodicThreshold The current request queue depth.

type=long
access=read-only
rollover=false

requestQueueDepthPeriodicThresholdEnabled

type=boolean
access=read-only
default=false
rollover=false

resourceRequestCancelCountPeriodicThreshold The number of resource request cancelations.

type=long
access=read-only
rollover=false

resourceRequestCancelCountPeriodicThresholdEnabled

type=boolean
access=read-only
default=false
rollover=false

resourceRequestRejectCountPeriodicThreshold The number of rejected plan requests.

type=long
access=read-only
rollover=false

resourceRequestRejectCountPeriodicThresholdEnabled

type=boolean
access=read-only
default=false
rollover=false

resourceRequestTimeoutCountPeriodicThreshold The number of resource request timeouts.

type=long
access=read-only
rollover=false

resourceRequestTimeoutCountPeriodicThresholdEnabled

type=boolean
access=read-only
default=false
rollover=false

rosRowCountPeriodicThreshold The number of rows in the ROS.

type=long
access=read-only
rollover=false

rosRowCountPeriodicThresholdEnabled

type=boolean
access=read-only
default=false
rollover=false

rosUsedBytesPeriodicThreshold The size of the ROS in bytes.

type=long
access=read-only
rollover=false

rosUsedBytesPeriodicThresholdEnabled

type=boolean
access=read-only
default=false
rollover=false

runningQueryCountPeriodicThreshold The number of queries currently running.

type=long
access=read-only
rollover=false

runningQueryCountPeriodicThresholdEnabled

type=boolean
access=read-only
default=false
rollover=false

samTotalSessionsPeriodicThreshold The total number of active sessions.

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

samTotalSessionsPeriodicThresholdEnabled

type=boolean
access=read-only
default=false
rollover=false

samauxdbSessionsPeriodicThreshold The number of active DBA user sessions.

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

samauxdbSessionsPeriodicThresholdEnabled

type=boolean
access=read-only
default=false
rollover=false

samuserSessionsPeriodicThreshold The number of active NFM-P user sessions.

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

samuserSessionsPeriodicThresholdEnabled

type=boolean
access=read-only
default=false
rollover=false

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

type=long
access=read-only
rollover=false

tmpDiskSpaceFreeMbPeriodicThresholdEnabled

type=boolean
access=read-only
default=false
rollover=false

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

type=long
access=read-only
rollover=false

tmpDiskSpaceUsedMbPeriodicThresholdEnabled

type=boolean
access=read-only
default=false
rollover=false

totalActiveSessionCountPeriodicThreshold The total number of active user and system sessions.

type=long
access=read-only
rollover=false

totalActiveSessionCountPeriodicThresholdEnabled

type=boolean
access=read-only
default=false
rollover=false

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

type=long
access=read-only
rollover=false

totalBufferMemoryBytesPeriodicThresholdEnabled

type=boolean
access=read-only
default=false
rollover=false

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

type=long
access=read-only
rollover=false

totalMemoryBytesPeriodicThresholdEnabled

type=boolean
access=read-only
default=false
rollover=false

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

type=long
access=read-only
rollover=false

totalMemoryCacheBytesPeriodicThresholdEnabled

type=boolean
access=read-only
default=false
rollover=false

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

type=long
access=read-only
rollover=false

totalMemoryFreeBytesPeriodicThresholdEnabled

type=boolean
access=read-only
default=false
rollover=false

totalRowCountPeriodicThreshold 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

totalRowCountPeriodicThresholdEnabled

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

totalSessionCountPeriodicThreshold The total number of user and system sessions.

type=long
access=read-only
rollover=false

totalSessionCountPeriodicThresholdEnabled

type=boolean
access=read-only
default=false
rollover=false

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

type=long
access=read-only
rollover=false

totalSwapMemoryBytesPeriodicThresholdEnabled

type=boolean
access=read-only
default=false
rollover=false

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

type=long
access=read-only
rollover=false

totalSwapMemoryFreeBytesPeriodicThresholdEnabled

type=boolean
access=read-only
default=false
rollover=false

totalSystemSessionCountPeriodicThreshold The total number of system sessions.

type=long
access=read-only
rollover=false

totalSystemSessionCountPeriodicThresholdEnabled

type=boolean
access=read-only
default=false
rollover=false

totalUsedBytesPeriodicThreshold 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

totalUsedBytesPeriodicThresholdEnabled

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

totalUserSessionCountPeriodicThreshold The total number of user sessions.

type=long
access=read-only
rollover=false

totalUserSessionCountPeriodicThresholdEnabled

type=boolean
access=read-only
default=false
rollover=false

wosRowCountPeriodicThreshold 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

wosRowCountPeriodicThresholdEnabled

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

wosUsedBytesPeriodicThreshold 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

wosUsedBytesPeriodicThresholdEnabled

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

  
Properties inherited from log.LogPolicy
administrativeState, retentionTime, thresholdReportingState
 
Properties inherited from ManagedObject
actionMask, children-Set, deploymentState, isFaultSquelched, name, objectFullName, selfAlarmed
 
Methods inherited from log.LogPolicy
purge