Skip to main content

INFORMATION.SCHEMA.STATEMENTHOURLYSTATS

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

Per hour light weight statistics of this SQL statement

Parameters​

READONLY​

Parameter READONLY = 1;

Properties​

Hour​

Property Hour As %Integer [ Required, SqlColumnNumber = 2 ];

Hour these stats were recorded on, this is an integer 0-23 so 0 is after midnight up to 1am and 1 is from 1am up to 2am, etc.

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 from running this query

Day​

Relationship Day As INFORMATION.SCHEMA.STATEMENTDAILYSTATS [ Cardinality = parent, Internal, Inverse = Hours ];

Reference to the daily stats class

Date​

Property Date As %Date [ Calculated, SqlColumnNumber = 8, SqlComputeCode = {set {*} = $p({Day},"||",2)}, SqlComputed ];

Day these stats were recorded on