Statistics Table - Revision history

Sam: /* LoadTypeID */

2024-02-03T11:30:01Z

LoadTypeID

Sam at 11:29, 3 February 2024

2024-02-03T11:29:31Z

Sam at 10:38, 29 January 2024

2024-01-29T10:38:01Z

Show changes

Sam: Created page with "The `[Statistics]` table records information about a load in Truxton. CREATE TABLE "Statistics" ( "ID" uuid NOT NULL, "MediaID" uuid NOT NU..."

2021-01-14T21:31:41Z

Created page with "The <code>[Statistics]</code> table records information about a load in Truxton. <source lang="SQL"> CREATE TABLE "Statistics" ( "ID" uuid NOT NULL, "MediaID" uuid NOT NU..."

New page

The <code>[Statistics]</code> table records information about a load in Truxton.

<source lang="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
);
</source>

← Older revision		Revision as of 11:30, 3 February 2024
Line 266:		Line 266:

	==<code>LoadTypeID</code>==		==<code>LoadTypeID</code>==
−	The type of load that was performed. This corresponds to the <code>[ID]</code. column of the <code>[LoadType]</code> table.	+	The type of load that was performed.
		+	This corresponds to the <code>[ID]</code> column of the <code>[LoadType]</code> table.

@@ Line 74: / Line 74: @@
 =Columns=
 ==<code>ID</code>==
-The globally unique identifier for this load of the data. There can be multiple load processes for a single piece of Media.
+The globally unique identifier for this load of the data.
 ==<code>MediaID</code>==
 The globally unique identifier of the Media that was loaded.
-This corresponds to the <code>[ID]</code> column of the <code>[Media]</code> table.
+This corresponds to the <code>[ID]</code> column of the <code><nowiki>[</nowiki>[[Media Table|Media]]<nowiki>]</nowiki></code> table.
 ==<code>NumberOfFileBytes</code>==
@@ Line 93: / Line 94: @@
 ==<code>MediaInsertMs</code>==
-The number of milliseconds spent inserting records into the <code>[Media]</code> table.
+The number of milliseconds spent inserting records into the <code><nowiki>[</nowiki>[[Media Table|Media]]<nowiki>]</nowiki></code> table.
 ==<code>IDQInsertMs</code>==

Statistics Table - Revision history

Sam: /* LoadTypeID */

Sam at 11:29, 3 February 2024

Sam at 10:38, 29 January 2024

Sam: Created page with "The [Statistics] table records information about a load in Truxton. CREATE TABLE "Statistics" ( "ID" uuid NOT NULL, "MediaID" uuid NOT NU..."

Sam: Created page with "The `[Statistics]` table records information about a load in Truxton. CREATE TABLE "Statistics" ( "ID" uuid NOT NULL, "MediaID" uuid NOT NU..."