Class INFORMATION.SCHEMA.STATEMENTDAILYSTATS

persistent class INFORMATION.SCHEMA.STATEMENTDAILYSTATS extends %Persistent, %XML.Adaptor

SQL Table Name: STATEMENT_DAILY_STATS

Per day light weight statistics of this SQL statement

Parameters	Properties	Methods	Queries	Indices	ForeignKeys	Triggers
1	9			1

Properties
Day	Hours	Parameters	StatCommands	StatCount
StatRowCount	StatTotal	StatVariance	Statement

Methods
%AddToSaveSet	%AddToSyncSet	%BuildDeferredIndices	%BuildIndicesAsync
%BuildIndicesAsyncResponse	%CheckConstraints	%CheckConstraintsForExtent	%ClassIsLatestVersion
%ClassName	%ComposeOid	%ConstructClone	%Delete
%DeleteExtent	%DeleteId	%DispatchClassMethod	%DispatchGetModified
%DispatchGetProperty	%DispatchMethod	%DispatchSetModified	%DispatchSetMultidimProperty
%DispatchSetProperty	%Exists	%ExistsId	%Extends
%GUID	%GUIDSet	%GetLock	%GetParameter
%GetSwizzleObject	%Id	%IsA	%IsModified
%IsNull	%KillExtent	%LockExtent	%LockId
%New	%NormalizeObject	%ObjectIsNull	%ObjectModified
%Oid	%OnBeforeAddToSync	%OnDeleteFinally	%OnDetermineClass
%OnOpenFinally	%OnSaveFinally	%Open	%OpenId
%OriginalNamespace	%PackageName	%PurgeIndices	%Reload
%RemoveFromSaveSet	%ResolveConcurrencyConflict	%RollBack	%Save
%SaveDirect	%SerializeObject	%SetModified	%SortBegin
%SortEnd	%SyncObjectIn	%SyncTransport	%UnlockExtent
%UnlockId	%ValidateIndices	%ValidateObject	%ValidateTable
XMLDTD	XMLExport	XMLExportToStream	XMLExportToString
XMLNew	XMLSchema	XMLSchemaNamespace	XMLSchemaType

• parameter READONLY = 1;

READONLY = 1 means that objects can be created, opened but not saved or deleted. Tables are projected to SQL as READONLY.

• property Day as %Date [ Required ];

Day these stats were recorded on

• relationship Hours as INFORMATION.SCHEMA.STATEMENTHOURLYSTATS(XMLPROJECTION="NONE") [ Inverse = Day,Cardinality = children ];

Breakdown of light weight SQL stats per hour within the day

• relationship Parameters as INFORMATION.SCHEMA.STATEMENTPARAMETERSTATS(XMLPROJECTION="NONE") [ Inverse = Day,Cardinality = children ];

• property StatCommands as %Integer;

Total ObjectScript commands executed from running this query

• property StatCount as %Integer;

Total number of times we have recorded this query being run

• property StatRowCount as %Integer;

Total %ROWCOUNT from running this query

• property StatTotal as %Double;

Total time spent running this query

• property StatVariance as %Double;

Variance in time from running this query

• relationship Statement as INFORMATION.SCHEMA.STATEMENTS [ Inverse = Days,Cardinality = parent ];

•index (StatementDailyStatsIDKey on Day) [IdKey];

Class Reference IRIS for UNIX 2024.1.2
Documentation Search