Mengkueri informasi eksekusi tentang tugas terdistribusi dalam suatu tahap kueri.
Coba sekarang
Test
RAM authorization
|
Action |
Access level |
Resource type |
Condition key |
Dependent action |
|
adb:DescribeDiagnosisTasks |
get |
*DBCluster
|
None | None |
Parameter permintaan
|
Parameter |
Type |
Required |
Description |
Example |
| DBClusterId |
string |
Yes |
ID kluster. Catatan
Anda dapat memanggil operasi DescribeDBClusters untuk mengkueri ID semua kluster Database Analitik for MySQL Data Warehouse Edisi (V3.0) dalam suatu wilayah. |
am-bp1r053byu48p**** |
| RegionId |
string |
No |
ID wilayah kluster. Catatan
Anda dapat memanggil operasi DescribeRegions untuk mengkueri daftar wilayah terbaru. |
cn-hangzhou |
| ProcessId |
string |
Yes |
ID kueri. Catatan
Anda dapat memanggil operasi DescribeProcessList untuk mengkueri ID kueri yang sedang dieksekusi. |
202011191048151921681492420315100**** |
| StageId |
string |
Yes |
ID tahap dalam kueri yang ditentukan oleh parameter |
Stage[26] |
| Order |
string |
No |
Urutan pengurutan tugas berdasarkan bidang. Tentukan nilai dalam format JSON. Contoh: [{"Field":"CreateTime", "Type":"desc"}]. Catatan
|
[{"Field":"StartTime", "Type": "desc" }] |
| PageNumber |
integer |
No |
Nomor halaman. |
1 |
| PageSize |
integer |
No |
Jumlah entri per halaman. Nilai valid:
|
30 |
| State |
string |
No |
Status tugas impor atau ekspor asinkron yang akan dikueri. Nilai valid:
Valid values:
|
RUNNING |
| Host |
string |
No |
Alamat IP tempat kueri dimulai. |
192.168.XX.XX |
Elemen respons
|
Element |
Type |
Description |
Example |
|
object |
The response parameters. |
||
| RequestId |
string |
The request ID. |
F0983B43-B2EC-536A-8791-142B5CF1E9B6 |
| TaskList |
array<object> |
The queried tasks. |
|
|
object |
The queried task. |
||
| ScanCost |
integer |
The amount of time that is consumed to scan data from a data source in the task. Unit: milliseconds. |
0 |
| OutputDataSize |
integer |
The amount of output data in the task. Unit: bytes. |
123 |
| InputDataSize |
integer |
The amount of input data in the task. Unit: bytes. |
123 |
| State |
string |
The final execution state of the task. Valid values:
|
FINISHED |
| OperatorCost |
integer |
The total amount of time that is consumed by all operators in the task on a node. This parameter can be used to determine whether long tails occur in computing. Unit: milliseconds. |
3 |
| OutputRows |
integer |
The number of output rows in the task. |
105 |
| ScanDataSize |
integer |
The amount of scanned data in the task. Unit: bytes. |
123 |
| ElapsedTime |
integer |
The amount of time that elapsed from when the task was created to when the task was completed. Unit: milliseconds. |
456 |
| ScanRows |
integer |
The number of rows that are scanned from a data source in the task. |
0 |
| PeakMemory |
integer |
The peak memory of the task. Unit: bytes. |
234 |
| TaskId |
string |
The task ID. |
22568**** |
| InputRows |
integer |
The number of input rows in the task. |
105 |
| TaskCreateTime |
integer |
The timestamp when the task was created. |
2022-12-12 00:00:12 |
| TaskEndTime |
integer |
The timestamp when the task ends. |
2022-12-22 00:00:00 |
| TaskHost |
string |
The IP address of the host where the task was executed. |
192.168.XX.XX |
| Drivers |
string |
The number of tasks that can be executed concurrently. |
16 |
| QueuedTime |
string |
The queuing duration of the task. Unit: milliseconds. |
12 |
| ComputeTimeRatio |
string |
The compute time ratio, which can be used to determine whether the task is really time-consuming. This parameter can be calculated by using the following formula: OperatorCost/Drivers/ElapsedTime. A greater value indicates that the task was executed for computing for most of the task time. A less value indicates that the task was waiting for scheduling or blocked due to other reasons for most of the task time. |
0.89 |
| TotalCount |
integer |
The total number of tasks in the stage. |
33 |
Contoh
Respons sukses
JSONformat
{
"RequestId": "F0983B43-B2EC-536A-8791-142B5CF1E9B6",
"TaskList": [
{
"ScanCost": 0,
"OutputDataSize": 123,
"InputDataSize": 123,
"State": "FINISHED",
"OperatorCost": 3,
"OutputRows": 105,
"ScanDataSize": 123,
"ElapsedTime": 456,
"ScanRows": 0,
"PeakMemory": 234,
"TaskId": "22568****",
"InputRows": 105,
"TaskCreateTime": 0,
"TaskEndTime": 0,
"TaskHost": "192.168.XX.XX",
"Drivers": "16",
"QueuedTime": "12",
"ComputeTimeRatio": "0.89"
}
],
"TotalCount": 33
}Kode kesalahan
Lihat Error Codes untuk daftar lengkap.
Catatan rilis
Lihat Release Notes untuk daftar lengkap.