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

# query SQL detail info

`POST /api/v1/sql/querySqlDetailInfo`

query detailed statistic info of a SQL

## Request body

- SqlSqlDetailParam
  - `database` string
  - `endTime` integer
  - `includeInnerSql` boolean
  - `namespace` string, required
  - `obtenant` string, required
  - `sqlId` string, required
  - `startTime` integer
  - `user` string

## Response `200`

OK

- object
  - `data` SqlSqlDetailedInfo, required
    - `diagnoseInfo` SqlSqlDiagnoseInfo[]
      - `level` string
      - `reason` string
      - `ruleName` string
      - `suggestion` string
    - `indexies` SqlIndexInfo[]
      - `columns` string[], required
      - `indexName` string, required
      - `indexType` string, required
      - `status` string, required
      - `tableName` string, required
      - `uniqueness` string, required
    - `plans` SqlPlanStatistic[], required
      - `cost` integer
      - `cpuCost` integer
      - `generatedTime` integer, required
      - `ioCost` integer
      - `planHash` integer, required
      - `planID` integer, required
      - `realCost` integer
      - `svrIP` string, required
      - `svrPort` integer, required
      - `tenantID` integer, 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)