Query the performance indicator trend of an execution plan

Description

You can call this operation to query the performance trend of an execution plan associated with a specified SQL statement.

Call description

Prerequisite

You have the read privilege on the specified tenant.

Request path

GET /api/v2/ob/clusters/{clusterId}/tenants/{tenantId}/plans/{uid}/trends

Request parameters

Response parameters

• Basic data structure

  Parameter	Type	Description
  data	Object	The request data.
  ├─ contents	Array	The array of planned performance sampling data. For more information about its data structure, see the following table.
  successful	Boolean	Whether the request is successful.
  timestamp	Datetime	The timestamp when the server completes the request.
  duration	Integer	The time that the server takes to process the request, in milliseconds.
  status	Integer	The encoding in compliance with the HTTP Status specification.
  traceId	String	The trace ID of the request. This trace ID is used for troubleshooting.
  server	String	The address of the application server that responds to the request.

• Data structure of planned performance sampling data

  Parameter	Type	Description
  timestamp	Datetime	The timestamp of the sampling.
  executions	Integer	The number of times the plan is executed during the execution period of the plan.
  execPs	Float	The average number of times the plan is executed every second during the execution period of the plan.
  maxExecTime	Float	The longest plan execution time during the execution period of the plan, in milliseconds.
  avgDiskReads	Float	The average disk read times during the execution period of the plan.
  avgDiskWrites	Float	The average disk write times during the execution period of the plan.
  avgBufferGets	Float	The average cache read times during the execution period of the plan.
  avgApplicationWaitTime	Float	The average Application wait time during the execution period of the plan, in milliseconds.
  avgConcurrencyWaitTime	Float	The average Concurrency wait time during the execution period of the plan, in milliseconds.
  avgUserIoWaitTime	Float	The average UserIO wait time during the execution period of the plan, in milliseconds.
  avgRowProcessed	Float	The average rows processed during the execution period of the plan.
  avgElapsedTime	Float	The average response time during the execution period of the plan.
  avgCpuTime	Float	The average CPU time during the execution period of the plan.
  largeQueryPercentage	Float	The percentage of large queries during the execution period of the plan.
  delayedLargeQueryPercentage	Float	The percentage of queued large queries during the execution period of the plan.
  timeoutPercentage	Float	The percentage of timed out executions during the execution period of the plan.
  tableScan	Boolean	Whether to include full table scan in the plan.

Examples

Sample request

Query the performance trend of the plan with a UID of AAAAAAAAAAEAAAAAAAAJ_AAFszE_cnfR based on the cluster ID 1 and tenant ID 1001, and set the time range to 2020-11-03T19:00:00+08:00 to 2020-11-03T20:00.

/api/v2/ob/clusters/1/tenants/1001/plans/AAAAAAAAAAEAAAAAAAAJ_AAFszE_cnfR/trends?startTime=2020-11-03T19%3A00%3A00%2B08%3A00&endTime=2020-11-03T20%3A00%3A00%2B08%3A00

Sample response

{
    "duration": 818,
    "server": "a83ad33525",
    "status": 200,
    "successful": true,
    "timestamp": "2020-11-03T21:21:49.554+08:00",
    "traceId": "ebb7f4eb8c984e12",
    "data": {
        "contents": [
            {
                "avgApplicationWaitTime": 0.00,
                "avgBufferGets": 0.00,
                "avgConcurrencyWaitTime": 0.00,
                "avgCpuTime": 0.00,
                "avgDiskReads": 0.00,
                "avgDiskWrites": 0.00,
                "avgElapsedTime": 1.11,
                "avgRowProcessed": 7.65,
                "avgUserIoWaitTime": 0.00,
                "execPs": 4.63,
                "executions": 3,
                "tableScan": false,
                "timestamp": "2020-11-03T19:00:00.00Z"
            },
            {
                "avgApplicationWaitTime": 0.00,
                "avgBufferGets": 0.00,
                "avgConcurrencyWaitTime": 0.00,
                "avgCpuTime": 0.00,
                "avgDiskReads": 0.00,
                "avgDiskWrites": 0.00,
                "avgElapsedTime": 1.09,
                "avgRowProcessed": 7.69,
                "avgUserIoWaitTime": 0.00,
                "execPs": 4.63,
                "executions": 4,
                "tableScan": false,
                "timestamp": "2020-11-03T19:00:30Z"
            }
        ]
    }
}