PSQRYSTATS table tells you about when a particular query last executed and more details. This PSQRYSTATS table has following fields.
• OPRID
• QRYNAME
• EXECCOUNT – Count of Query Execution
• AVGEXECTIME – Average Query Execution Time
• AVGFETCHTIME – Average Fetch Time
• LASTEXECDTTM – DateTime of Last Execution
• AVGNUMROWS – Average Number of Rows Fetched
• NUMKILLS – Number of Times Killed
• OPRID
• QRYNAME
• EXECCOUNT – Count of Query Execution
• AVGEXECTIME – Average Query Execution Time
• AVGFETCHTIME – Average Fetch Time
• LASTEXECDTTM – DateTime of Last Execution
• AVGNUMROWS – Average Number of Rows Fetched
• NUMKILLS – Number of Times Killed
