Skip to main content

INFORMATION.SCHEMA.STATEMENTDAILYSTATS

Class INFORMATION.SCHEMA.STATEMENTDAILYSTATS Extends (%Persistent, %XML.Adaptor) [ Final, Owner = {_PUBLIC}, SqlRowIdPrivate, SqlTableName = STATEMENT_DAILY_STATS, StorageStrategy = SQLStorage, System = 4 ]

Per day light weight statistics of this SQL statement

Parameters​

READONLY​

Parameter READONLY = 1;

Properties​

Day​

Property Day As %Date [ Required, SqlColumnNumber = 2 ];

Day these stats were recorded on

StatCount​

Property StatCount As %Integer [ SqlColumnNumber = 3 ];

Total number of times we have recorded this query being run

StatTotal​

Property StatTotal As %Double [ SqlColumnNumber = 4 ];

Total time spent running this query

StatVariance​

Property StatVariance As %Double [ SqlColumnNumber = 5 ];

Variance in time from running this query

StatRowCount​

Property StatRowCount As %Integer [ SqlColumnNumber = 6 ];

Total %ROWCOUNT from running this query

StatCommands​

Property StatCommands As %Integer [ SqlColumnNumber = 7 ];

Total ObjectScript commands executed from running this query

Statement​

Relationship Statement As INFORMATION.SCHEMA.STATEMENTS [ Cardinality = parent, Inverse = Days ];

Hours​

Relationship Hours As INFORMATION.SCHEMA.STATEMENTHOURLYSTATS(XMLPROJECTION = "NONE") [ Cardinality = children, Inverse = Day ];

Breakdown of light weight SQL stats per hour within the day

Parameters​

Relationship Parameters As INFORMATION.SCHEMA.STATEMENTPARAMETERSTATS(XMLPROJECTION = "NONE") [ Cardinality = children, Inverse = Day ];