Query Statistics

PeopleSoft provides the ability to track query statistics for PeopleSoft Queries such as the number of times the query has been executed, the average execute time, average fetch time, average number of rows returned, the last time it was executed and the number of times it has been killed.

This is all very useful information for two major things; evaluating query performance and determining how often a query is being used (e.g. when you are evaluating keeping the query on an upgrade or patching project).

To enable query statistics / view query statistics the navigation is:
PeopleTools > Utilties > Administration > Query Administration

The Run Query Statistics option needs to be set for PeopleSoft to start recording and keeping query statistics.

run-query-statistics.png

Once enabled, use the same navigation to view query statistics.

This is also where you can change private queries to public queries or vice versa (Admin tab > Assign New Owner)

The executing tab allows you to see which queries are running at the moment.

Behind the scenes, you can view this data in the table, PSQRYSTATS.

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License