---
title: "query SQL history info"
method: POST
path: "/api/v1/sql/querySqlHistoryInfo"
tags: ["Sql"]
---

# query SQL history info

`POST /api/v1/sql/querySqlHistoryInfo`

query history statistic info of a SQL

## Request body

- SqlSqlHistoryParam
  - `database` string
  - `endTime` integer
  - `includeInnerSql` boolean
  - `interval` integer, required
  - `namespace` string, required
  - `obtenant` string, required
  - `outputColumns` string[]
  - `sqlId` string, required
  - `startTime` integer
  - `user` string

## Response `200`

OK

- object
  - `data` SqlSqlHistoryInfo, required
    - `executionTrend` ResponseMetricData[], required
      - `metric` ResponseMetric, required
        - `labels` CommonKVPair[]
          - `key` string, required
          - `value` string, required
        - `name` string
      - `values` ResponseMetricValue[], required
        - `timestamp` number, required
        - `value` number, required
    - `latencyTrend` ResponseMetricData[], required
      - `metric` ResponseMetric, required
        - `labels` CommonKVPair[]
          - `key` string, required
          - `value` string, required
        - `name` string
      - `values` ResponseMetricValue[], required
        - `timestamp` number, required
        - `value` number, required
  - `message` string, required
  - `successful` boolean, required

## Other responses

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

## Changes

- **2026-07-17** `fa579fa6f72d` — 1 info
  - endpoint added
- **2024-02-27** `643ae3c8d824` — 1 breaking
  - api path removed without deprecation

[Change history](https://skmtc.dev/oceanbase/apis/oceanbase-dashboard-api/changes/api/v1/sql/querySqlHistoryInfo/post.md)

---

[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)