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

# query plan detail info

`POST /api/v1/sql/queryPlanDetailInfo`

query detailed statistic info of a plan

## Request body

- SqlPlanDetailParam
  - `namespace` string, required
  - `obtenant` string, required
  - `planID` integer, required
  - `svrIP` string, required
  - `svrPort` integer, required
  - `tenantID` integer, required

## Response `200`

OK

- object
  - `data` SqlPlanDetail, required
    - `generatedTime` integer, required
    - `planDetail` SqlPlanOperator, required
      - `childOperators` SqlPlanOperator[]
      - `cost` integer, required
      - `estimatedRows` integer, required
      - `name` string
      - `operator` string, required
      - `outputOrFilter` string
    - `planHash` integer, required
    - `planID` integer, required
    - `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

## Changes

- **2024-09-04** `14770a73a389` — 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/queryPlanDetailInfo/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)