---
title: "list request statistics"
method: POST
path: "/api/v1/sql/requestStatistics"
tags: ["Sql"]
---

# list request statistics

`POST /api/v1/sql/requestStatistics`

list request statistics

## Request body

- SqlSqlRequestStatisticParam
  - `database` string
  - `endTime` integer
  - `includeInnerSql` boolean
  - `namespace` string, required
  - `obtenant` string, required
  - `pageNum` integer
  - `pageSize` integer
  - `sortColumn` string
  - `sortOrder` string
  - `startTime` integer
  - `statisticScopes` string[], required
  - `user` string

## Response `200`

OK

- object
  - `data` SqlRequestStatisticInfo[], required
    - `averageLatency` number, required
    - `database` string, required
    - `executionTrend` ResponseMetricValue[], required
      - `timestamp` number, required
      - `value` number, required
    - `failedExecutions` number, required
    - `latencyTrend` ResponseMetricValue[], required
      - `timestamp` number, required
      - `value` number, required
    - `planCategoryStatistics` SqlSqlStatisticMetric[], required
      - `name` string, required
      - `value` number, required
    - `tenant` string, required
    - `totalExecutions` number, required
    - `totalLatency` number, required
    - `user` string, required
  - `message` string, required
  - `successful` boolean, required

## Other responses

- `400` — Bad Request
- `401` — Unauthorized
- `500` — Internal Server Error

---

[API](https://skmtc.dev/oceanbase/apis/oceanbase-dashboard-api.md) · [All operations](https://skmtc.dev/oceanbase/apis/oceanbase-dashboard-api/llms.txt) · [OpenAPI document](https://skmtc-service-production.skmtc.workers.dev/v1/apis/oceanbase/oceanbase-dashboard-api/revisions/fa579fa6f72d/schema)