Statistics Table

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

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
);