The QryLogSummary[V] view of DBQLSummaryTbl holds the counts logged for queries of users with THRESHOLD or SUMMARY rules. It is only populated if summary information is requested or a threshold value is used.
|AcctString||The unexpanded account name under which the query is submitted.|
|AMPCPUTime||Total AMP CPU seconds.|
|AMPCPUTimeNorm||Normalized AMP CPU seconds for co-existence systems only.|
|AppID||The application ID under which the query is submitted.|
|AverageAmpCPU||The average AMP CPU of the queries that ran in the last 10 minutes.|
|AverageAmpCPUNorm||The average normalized AMP CPU seconds for the queries run in the last 10 minutes on a coexistence system.|
|AverageIO||The average logical I/O count for the queries run in the last 10 minutes.|
|AverageParserCPU||The average CPU seconds to parse the queries that ran in the last 10 minutes.|
|AverageParserCPUNorm||The average normalized CPU seconds to parse the queries run in the last 10 minutes on a coexistence system.|
|AverageTime||The average run time for queries run in the last 10 minutes, calculated to the nearest hundredth of a second.|
|ClientAddr||The client IP address of the submitted query.|
|ClientID||The client ID under which the query is submitted.|
|CollectTimeStamp||Time that the row was inserted into the database. This field is also part of the multi-column NUPI (also see ProcID).
For more information on CollectTimeStamp, see Comparing CollectTimeStamp Value Between Tables.
|LogicalHostID||Unique identifier of the logon source for the logged query. A value of 0 indicates an internal session.|
|ParserCPUTime||CPU seconds to parse queries.|
|ParserCPUTimeNorm||Normalized CPU seconds to parse queries.
Normalized columns, such as ParserCPUTimeNorm, are for co-existence systems only.
|ProcID||Unique processor ID of the Dispatcher and part of the multi-column NUPI (also see CollectTimeStamp).|
|ProfileID||The profile ID under which the user is submitting queries.|
|ProfileName||The name of the profile, if any, under which the user submitted the query.|
|QueryCount||The name of the profile associated with the log.|
|QuerySeconds||Total run time of queries in this period for this histogram. Calculated to the nearest hundredth of a second.|
|ReqPhysIO||Returns the total number of physical I/Os for the whole request in summary mode.|
|ReqPhysIOKB||Returns the total physical I/Os in kilobytes for the whole request in summary mode.|
|SessionID||Identifies the session for which queries are being summarized (counted).|
|StartTime||Records the timestamp of the first query included for this summary row.|
|StopTime||Records the timestamp of the last query included for this summary row.|
|TotalIOCount||The total logical I/O count.
Logical I/O and CPU may not be accurate for aborted queries.
|Usediota||I/O tokens used by the requests that are logged in summary mode.|
|UserID||The unique ID of the user whose query is logged.|
|UserName||Returns the name of the user who submitted the queries that are summarized in each row.|
|ValueType||The THRESHOLD criterion is as follows: