explain_sql
Analyze and display the execution plan for SQL queries on Alibaba Cloud RDS, helping optimize database performance by identifying query inefficiencies.
Instructions
show sql execute plan
Args:
dbinstance_id (str): The ID of the RDS instance.
region_id(str): the region id of instance.
db_name(str): the db name for table.
sql(str): the target sql.
Returns:
the sql execute plan.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| db_name | Yes | ||
| dbinstance_id | Yes | ||
| region_id | Yes | ||
| sql | Yes |
Input Schema (JSON Schema)
{
"properties": {
"db_name": {
"title": "Db Name",
"type": "string"
},
"dbinstance_id": {
"title": "Dbinstance Id",
"type": "string"
},
"region_id": {
"title": "Region Id",
"type": "string"
},
"sql": {
"title": "Sql",
"type": "string"
}
},
"required": [
"region_id",
"dbinstance_id",
"db_name",
"sql"
],
"title": "explain_sqlArguments",
"type": "object"
}