Statistics Table

From truxwiki.com
Jump to navigation Jump to search

The [Statistics] table records information about a load in Truxton.

Contents

SQL

CREATE TABLE "Statistics"
(
  "ID" uuid NOT NULL,
  "MediaID" uuid NOT NULL,
  "NumberOfFileBytes" bigint DEFAULT 0 NOT NULL,
  "NumberOfFiles" bigint DEFAULT 0 NOT NULL,
  "DepotInsertMs" bigint DEFAULT 0 NOT NULL,
  "FileInsertMs" bigint DEFAULT 0 NOT NULL,
  "MediaInsertMs" bigint DEFAULT 0 NOT NULL,
  "IDQInsertMs" bigint DEFAULT 0 NOT NULL,
  "LoadMs" bigint DEFAULT 0 NOT NULL,
  "NumberOfCPUs" integer DEFAULT 0 NOT NULL,
  "ActiveProcessorMask" integer DEFAULT 0 NOT NULL,
  "ProcessorArchitecture" integer DEFAULT 0 NOT NULL,
  "ProcessorLevel" integer DEFAULT 0 NOT NULL,
  "ProcessorRevision" integer DEFAULT 0 NOT NULL,
  "MemoryAllocationGranularity" integer DEFAULT 0 NOT NULL,
  "NumberOfBytesInMemoryPage" integer DEFAULT 0 NOT NULL,
  "UserName" text NOT NULL,
  "OSMajorVersion" integer DEFAULT 0 NOT NULL,
  "OSMinorVersion" integer DEFAULT 0 NOT NULL,
  "OSBuild" integer DEFAULT 0 NOT NULL,
  "PlatformID" integer DEFAULT 0 NOT NULL,
  "ServicePackMajor" integer DEFAULT 0 NOT NULL,
  "ServicePackMinor" integer DEFAULT 0 NOT NULL,
  "SuiteMask" integer DEFAULT 0 NOT NULL,
  "ProductType" integer DEFAULT 0 NOT NULL,
  "LoaderMajorVersion" integer DEFAULT 0 NOT NULL,
  "LoaderMinorVersion" integer DEFAULT 0 NOT NULL,
  "LoaderBuildVersion" integer DEFAULT 0 NOT NULL,
  "TotalPhysicalRAM" bigint DEFAULT 0 NOT NULL,
  "BeginningMemoryLoad" integer DEFAULT 0 NOT NULL,
  "BeginningAvailablePhysicalRAM" bigint DEFAULT 0 NOT NULL,
  "BeginningTotalPageFile" bigint DEFAULT 0 NOT NULL,
  "BeginningAvailablePageFile" bigint DEFAULT 0 NOT NULL,
  "BeginningTotalVirtual" bigint DEFAULT 0 NOT NULL,
  "BeginningAvailableVirtual" bigint DEFAULT 0 NOT NULL,
  "BeginningAvailableExtendedVirtual" bigint DEFAULT 0 NOT NULL,
  "EndingMemoryLoad" integer DEFAULT 0 NOT NULL,
  "EndingAvailablePhysicalRAM" bigint DEFAULT 0 NOT NULL,
  "EndingTotalPageFile" bigint DEFAULT 0 NOT NULL,
  "EndingAvailablePageFile" bigint DEFAULT 0 NOT NULL,
  "EndingTotalVirtual" bigint DEFAULT 0 NOT NULL,
  "EndingAvailableVirtual" bigint DEFAULT 0 NOT NULL,
  "EndingAvailableExtendedVirtual" bigint DEFAULT 0 NOT NULL,
  "PhysicalRAMInstalled" bigint DEFAULT 0 NOT NULL,
  "Begun" timestamp without time zone NOT NULL,
  "MaximumDepotInsertMs" integer DEFAULT 0 NOT NULL,
  "MaximumFileInsertMs" integer DEFAULT 0 NOT NULL,
  "MaximumMediaInsertMs" integer DEFAULT 0 NOT NULL,
  "MaximumIDQInsertMs" integer DEFAULT 0 NOT NULL,
  "NumberOfBytesToLoad" bigint DEFAULT 0 NOT NULL,
  "NumberOfDepotBytesUsed" bigint DEFAULT 0 NOT NULL,
  "NumberOfEmptyBytes" bigint DEFAULT 0 NOT NULL,
  "NumberOfEliminatedFiles" bigint DEFAULT 0 NOT NULL,
  "NumberOfDuplicateFiles" bigint DEFAULT 0 NOT NULL,
  "NumberOfDuplicateBytes" bigint DEFAULT 0 NOT NULL,
  "NumberOfWellKnownHashes" bigint DEFAULT 0 NOT NULL,
  "NumberOfHashHits" bigint DEFAULT 0 NOT NULL,
  "NumberOfHashHitBytes" bigint DEFAULT 0 NOT NULL,
  "LongCallsToInsertFiles" integer DEFAULT 0 NOT NULL,
  "MachineID" uuid NOT NULL,
  "NumberOfFreespaceBytes" bigint DEFAULT 0 NOT NULL,
  "DeviceID" uuid NOT NULL,
  "LoadConfigurationID" integer DEFAULT 0 NOT NULL,
  "LoadTypeID" integer DEFAULT 0 NOT NULL
);

Columns

ID

The globally unique identifier for this load of the data. There can be multiple load processes for a single piece of Media.

MediaID

The globally unique identifier of the Media that was loaded. This corresponds to the [ID] column of the [Media] table.

NumberOfFileBytes

The number of bytes in file contents processed.

NumberOfFiles

The number of files processed.

DepotInsertMs

The number of milliseconds spent inserting records into the [Depot] table.

FileInsertMs

The number of milliseconds spent inserting records into the [File] table.

MediaInsertMs

The number of milliseconds spent inserting records into the [Media] table.

IDQInsertMs

The number of milliseconds spent inserting records into the Identification Queue.

LoadMs

The number of milliseconds spent Loading. This is the total number of milliseconds spent in the load process.

NumberOfCPUs

The number of CPUs in the loader machine.

ActiveProcessorMask

The active processor bitmask. A one bit means the load process was authorized to run on that CPU. Bit 0 is processor 0; bit 31 is processor 31.

ProcessorArchitecture

The processor architecture of the installed operating system. This member can be one of the following values: 0 for x86, 6 for Intel Itanium or 9 for x64.

ProcessorLevel

The level of the processor.

ProcessorRevision

The revision of the processor.

MemoryAllocationGranularity

The granularity of memory allocation on the loader machine. The granularity for the starting address at which virtual memory can be allocated.

NumberOfBytesInMemoryPage

The number of bytes in a single page of memory and the granularity of page protection and commitment in the loader machine.

UserName

The name of the user under which the load process ran.

OSMajorVersion

The major version of the operating system on the loader machine.

OSMinorVersion

The minor version of the operating system on the loader machine.

OSBuild

The build number of the operating system on the loader machine.

PlatformID

The platform identifier of the operating system on the loader machine.

ServicePackMajor

The major portion of the service pack number applied to the operating system on the loader machine.

ServicePackMinor

The minor portion of the service pack number applied to the operating system on the loader machine.

SuiteMask

The suite mask for the operating system installed on the loader machine.

ProductType

The product type of the operating system installed on the loader machine.

LoaderMajorVersion

The major version number of the loader.

LoaderMinorVersion

The minor version number of the loader.

LoaderBuildVersion

The build number of the loader.

TotalPhysicalRAM

The amount of physical RAM, in bytes, installed on the loader machine.

BeginningMemoryLoad

A number between 0 and 100 that specifies the approximate percentage of physical memory that is in use on the loader machine at the beginning of a load. 0 indicates no memory use and 100 indicates full memory use.

BeginningAvailablePhysicalRAM

The amount of physical memory available, in bytes, on the loader machine at the beginning of the load. This is the amount of physical memory that can be immediately reused without having to write its contents to disk first. It is the sum of the size of the standby, free, and zero lists.

BeginningTotalPageFile

The current committed memory limit for the system or the loader process at the beginning of the load, whichever is smaller, in bytes.

BeginningAvailablePageFile

The maximum amount of memory the loader process can commit, in bytes, at the beginning of a load.

BeginningTotalVirtual

The size of the user-mode portion of the virtual address space of the loader process, in bytes, at the beginning of a load.

BeginningAvailableVirtual

The amount of unreserved and uncommitted memory currently in the user-mode portion of the virtual address space of the loader process, in bytes, at the beginning of a load.

BeginningAvailableExtendedVirtual

The amount of extended virtual memory at the beginning of a load.

EndingMemoryLoad

A number between 0 and 100 that specifies the approximate percentage of physical memory that is in use on the loader machine at the end of a load. 0 indicates no memory use and 100 indicates full memory use.

EndingAvailablePhysicalRAM

The amount of physical memory available, in bytes, on the loader machine at the end of the load. This is the amount of physical memory that can be immediately reused without having to write its contents to disk first. It is the sum of the size of the standby, free, and zero lists.

EndingTotalPageFile

The current committed memory limit for the system or the loader process at the end of the load, whichever is smaller, in bytes.

EndingAvailablePageFile

The maximum amount of memory the loader process can commit, in bytes, at the end of a load.

EndingTotalVirtual

The size of the user-mode portion of the virtual address space of the loader process, in bytes, at the end of a load.

EndingAvailableVirtual

The amount of unreserved and uncommitted memory currently in the user-mode portion of the virtual address space of the loader process, in bytes, at the end of a load.

EndingAvailableExtendedVirtual

The amount of extended virtual memory at the end of a load.

PhysicalRAMInstalled

This is the amount of physically installed RAM from the SMBIOS firmware tables on the loader machine. This can differ from the amount recorded in the TotalPhysicalRAM column, which records the amount of physical memory that is available for the operating system to use.

Begun

The UTC date and time of when the load process began.

MaximumDepotInsertMs

The maximum number of milliseconds spent inserting a record into the [Depot] table.

MaximumFileInsertMs

The maximum number of milliseconds spent inserting a record into the [File] table.

MaximumMediaInsertMs

The maximum number of milliseconds spent inserting a record into the [Media] table.

MaximumIDQInsertMs

The maximum number of milliseconds spent inserting a record into the Identification Queue.

NumberOfBytesToLoad

The total number of bytes to load. For example, the number of bytes in the hard disk image.

NumberOfDepotBytesUsed

The number of bytes in all Depot files.

NumberOfEmptyBytes

Number of bytes in "empty" space.

NumberOfEliminatedFiles

The number of files that were eliminated due to hash match or Entropy zero.

NumberOfDuplicateFiles

The number of identical files in this load.

NumberOfDuplicateBytes

The number of bytes in duplicate files.

NumberOfWellKnownHashes

The number of Hash in the file elimination hash sets.

NumberOfHashHits

The number of Hash that were found in the hash sets.

NumberOfHashHitBytes

The number of bytes of file contents that were successfully eliminated by hash set hits.

LongCallsToInsertFiles

The number of calls inserting data into the [File] table that took longer than one second to complete.

MachineID

The globally unique identifier for the machine that started the load process. This comes from the TruxtonObject#machineid:_str variable in the TruxtonSetting.xml file in the installation directory.

NumberOfFreespaceBytes

The number of bytes in free space processed.

DeviceID

The globally unique identifier for the device the machine is running on. This usually comes from the BIOS of the computer.

LoadConfigurationID

The configuration used to load the data. This corresponds to the [ID] column of the [LoadConfiguration] table.

LoadTypeID

The type of load that was performed. This corresponds to the [ID] column of the [LoadType] table.

Retrieved from "https://truxwiki.com/index.php?title=Statistics_Table&oldid=7126"