Hi , I am using the following table to collect performance statistics on a query, but getting no rows.
SELECT CollectTimeStamp, SessionID, UserName, DefaultDatabase as DatabaseName, StartTime, FirstRespTime, (FirstRespTime - StartTime) hour to second(4) as FirstRespElapsedTime, TotalIOCount, AMPCPUTime+ParserCPUTime TotalCPUTime, SpoolUsage/(1024*1024*1024) as Spool_GB, 100-(nullifzero(AMPCPUTime/HASHAMP())/(MaxAMPCPUTime)*100) "Skew Factor", delaytime, errorcode, ErrorText, QueryText FROM dbc.dbqlogtbl where sessionid=123567 order by CollectTimeStamp desc ;
How to get the performance stats? Is there any threshold limit set for any query stats to be collected in dbc.dbqlogtbl ? How to check that? How to get the stats , if the query is light?
You'll need to begin dbql logging for any users/accounts you want to log. to determine what you have now: sel * from dbc.dbqlrules; After logging has been enabled your query will return results, for another session of course.