PSQRYSTATS

index back

Query RunTime Statistics


  • Parent record: PSQRYDEFN
  • PeopleSoft Field NameField TypeColumn TypeDescription
    OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).
    QRYNAMECharacter(30)VARCHAR2(30) NOT NULLQuery Name
    EXECCOUNTNumber(15,0)DECIMAL(15) NOT NULLCount of Query Execution
    AVGEXECTIMENumber(19,3)DECIMAL(18,3) NOT NULLAverage Query Execution Time
    AVGFETCHTIMENumber(19,3)DECIMAL(18,3) NOT NULLAverage Fetch Time
    AVGNUMROWSNumber(19,3)DECIMAL(18,3) NOT NULLAverage Number of Rows Fetched
    LASTEXECDTTMDateTime(26)TIMESTAMPDateTime of Last Execution.
    NUMKILLSNumber(3,0)SMALLINT NOT NULLNumber of Times Killed
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19