---
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
  - `database` string
  - `endTime` integer
  - `namespace` string, required
  - `obcluster` string, required
  - `obtenant` string
  - `planHash` string, required
  - `startTime` integer
  - `user` string

## Response `200`

OK

- object
  - `data` SqlPlanDetail, required
    - `category` 'local' | 'remote' | 'distributed', required
    - `generatedTime` integer, required
    - `mergedVersion` integer, required
    - `planDetail` SqlPlanOperator, required
      - `childOperators` SqlPlanOperator[]
      - `cost` integer, required
      - `estimatedRows` integer, required
      - `name` string
      - `operator` string, required
      - `outputOrFilter` string
    - `planHash` string, required
    - `planStatistics` SqlPlanStatisticByServer[], required
      - `category` 'local' | 'remote' | 'distributed', required
      - `cost` integer, required
      - `cpuTime` integer, required
      - `generatedTime` integer, required
      - `mergedVersion` integer, required
      - `planHash` string, required
      - `planId` integer, required
      - `server` string, 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/3e1a27cd744f/schema)