The following table lists the fields available for population in DBQLSummaryTbl rows.
|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.|
|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||Number of queries run in the last 10 minutes.|
|QuerySeconds||Total run time of queries in this period for this histogram. Calculated to the nearest hundredth of a second.|
|ReqPhysIO||The total number of physical I/Os for the whole request in summary mode.|
|ReqPhysIOKB||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||The name of the user who submitted the queries that are summarized in each row.|
|ValueType||The THRESHOLD criterion is as follows: