Function documentationQuery Statistics

 

You can use this function to monitor and analyze the execution and processing of queries.

Prerequisites

You have the necessary authorizations, which are granted to you in one of the following ways:

  • In the Role Maintenance (PFCG) transaction, you are assigned to the PLM PCV Administrator (SAP_PLMWUI_PCV_ADMIN) role.

  • On the SAP NetWeaver Portal, you are assigned to the PCV Administrator role.

Features

Query statistics provides you with the following information about the execution and processing of a query:

  • Minimum processing time

  • Maximum processing time

  • Average processing time

  • Last processing time

  • First execution date

  • Last execution date

  • Number of executions

  • Minimum number of retrieved result records

  • Maximum number of retrieved result records

  • Average number of retrieved result records

  • Number of retrieved result records from last execution

  • Minimum processing time per record

  • Maximum processing time per record

  • Average processing time per record

  • Processing time per record during last execution

Activities

You can execute the program for query statistics in the following ways:

  • On the SAP Easy Access screen, choose Start of the navigation path PCV Administration Next navigation step Query Statistics End of the navigation path.

  • On the Web user interface, choose Start of the navigation path PCV Administration Next navigation step Query Statistics End of the navigation path.