PSQRYSTATS

index back

Query RunTime Statistics


  • Parent record: PSQRYDEFN
  • PeopleSoft Field Name Field Type Column Type Description
    OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    QRYNAME Character(30) VARCHAR2(30) NOT NULL Query Name
    EXECCOUNT Number(15,0) DECIMAL(15) NOT NULL Count of Query Execution
    AVGEXECTIME Number(19,3) DECIMAL(18,3) NOT NULL Average Query Execution Time
    AVGFETCHTIME Number(19,3) DECIMAL(18,3) NOT NULL Average Fetch Time
    AVGNUMROWS Number(19,3) DECIMAL(18,3) NOT NULL Average Number of Rows Fetched
    LASTEXECDTTM DateTime(26) TIMESTAMP DateTime of Last Execution.
    NUMKILLS Number(3,0) SMALLINT NOT NULL Number of Times Killed
    index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
    PTRef generated on 09-JUN-19