PS Query Logging Information does not reflect actual run time.
A PS Schedule Query ran for over 2 hours From the time query submitted To the records returned, but Query Log (PSQRYEXECLOG) only show the query took less than 20 seconds as following:
Execute Time: 14.500 seconds
Fetch Time is: 0.640 Second
Is there a way to make the Query Logging information reflect real run time? Anybody had experience to change PS Query Logging configuration or such setting can be adjusted?
Thank you very much in advance!
Wendy