Ambil statistik log kueri lambat melalui DescribeSlowLogStatistic - Database Autonomy Service - Alibaba Cloud - Database Autonomy Service

Mengambil statistik log kueri lambat.

Deskripsi operasi

Before you call this operation, make sure that you understand the billing methods and pricing of Database Autonomy Service (DAS).

Before you call this operation, make sure that the following requirements are met:

Alibaba Cloud Managed Services is enabled for the instance.
Use the latest version of the Alibaba Cloud SDK or DAS SDK.
When you use an SDK to call the DAS service, set the region to cn-shanghai.

This operation is asynchronous and does not return the complete result immediately. If the `isFinish` parameter in the response is `false`, wait 1 second and send the request again. Repeat the request until the `isFinish` parameter is `true` to retrieve the complete result.

Coba sekarang

Coba API ini di OpenAPI Explorer tanpa perlu penandatanganan manual. Panggilan yang berhasil akan secara otomatis menghasilkan contoh kode SDK sesuai dengan parameter Anda. Unduh kode tersebut dengan kredensial bawaan yang aman untuk penggunaan lokal.

Test

RAM authorization

Tabel berikut menjelaskan otorisasi yang diperlukan untuk memanggil API ini. Anda dapat menentukannya dalam kebijakan Resource Access Management (RAM). Kolom pada tabel dijelaskan sebagai berikut:

Action: Aksi yang dapat digunakan dalam elemen Action pada pernyataan kebijakan izin RAM untuk memberikan izin guna melakukan operasi tersebut.
API: API yang dapat Anda panggil untuk melakukan aksi tersebut.
Access level: Tingkat akses yang telah ditentukan untuk setiap API. Nilai yang valid: create, list, get, update, dan delete.
Resource type: Jenis resource yang mendukung otorisasi untuk melakukan aksi tersebut. Ini menunjukkan apakah aksi tersebut mendukung izin tingkat resource. Resource yang ditentukan harus kompatibel dengan aksi tersebut. Jika tidak, kebijakan tersebut tidak akan berlaku.
- Untuk API dengan izin tingkat resource, jenis resource yang diperlukan ditandai dengan tanda bintang (*). Tentukan Nama Sumber Daya Alibaba Cloud (ARN) yang sesuai dalam elemen Resource pada kebijakan.
- Untuk API tanpa izin tingkat resource, ditampilkan sebagai All Resources. Gunakan tanda bintang (*) dalam elemen Resource pada kebijakan.
Condition key: Kunci kondisi yang didefinisikan oleh layanan. Kunci ini memungkinkan kontrol granular, berlaku baik hanya untuk aksi maupun untuk aksi yang terkait dengan resource tertentu. Selain kunci kondisi spesifik layanan, Alibaba Cloud menyediakan serangkaian common condition keys yang berlaku di semua layanan yang didukung RAM.
Dependent action: Aksi dependen yang diperlukan untuk menjalankan aksi tersebut. Untuk menyelesaikan aksi tersebut, pengguna RAM atau role RAM harus memiliki izin untuk melakukan semua aksi dependen.

Action

Access level

Resource type

Condition key

Dependent action

hdm:DescribeSlowLogStatistic

get

*全部资源

*

None

Parameter permintaan

Parameter	Type	Required	Description	Example
InstanceId	string	Yes	ID Instans.	rm-2ze1jdv45i7l6****
NodeId	string	No	ID node. Untuk RDS for MySQL dan PolarDB Basis Data Relasional Cloud-Native for MySQL, parameter ini hanya berlaku untuk instans kluster. Jika Anda tidak menentukan parameter ini, log kueri lambat dari node utama akan dikueri secara default. Untuk PolarDB Basis Data Relasional Cloud-Native-X 2.0, tentukan polarx_cn untuk node komputasi atau polarx_dn untuk node data.	r-x****-db-0
Type	string	No	Tipe Tugas. Untuk mesin SQL: SlowLogRequestOrigin: Mengagregasi log berdasarkan alamat IP sumber. SlowLogRequestUser: Mengagregasi log berdasarkan pengguna sumber. SQL: Mengagregasi log berdasarkan ID SQL. Untuk mesin Database Apsara for MongoDB: SlowLogRequestOrigin: Mengagregasi log berdasarkan alamat IP sumber. SlowLogRequestUser: Mengagregasi log berdasarkan pengguna sumber. SQL: Mengagregasi log berdasarkan ID kueri. SlowLogRequestOpType: Mengagregasi log berdasarkan tipe operasi. SlowLogRequestNamespace: Mengagregasi log berdasarkan namespace. Untuk mesin Redis: SlowLogRequestNodeId: Mengagregasi log berdasarkan ID node. SlowLogRequestHostInsId: Mengagregasi log berdasarkan ID instans host. Valid values: SlowLogRequestOrigin : SlowLogRequestOrigin. OriginHost : OriginHost. SlowLogRequestUser : SlowLogRequestUser. SQL : SQL.	SQL
TemplateId	string	No	ID Templat.	04ea3310df40c3fa8a6b4854db49f79a
StartTime	integer	Yes	Pengatur waktu mulai kueri. Nilai ini adalah Stempel waktu UNIX dalam UTC. Unit: milidetik.	1568269711000
EndTime	integer	Yes	Pengatur waktu akhir kueri. Nilai ini adalah Stempel waktu UNIX dalam UTC. Unit: milidetik.	1608888296000
OrderBy	string	No	Metode Pengurutan. Nilai valid: Count QueryTime LockTime RowsExamined RowsSent.	count
Asc	boolean	No	Apakah akan mengurutkan hasil dalam Pesanan menaik. Nilai default adalah false.	true
PageNumber	integer	No	Nomor halaman. Nilai harus berupa bilangan bulat positif. Nilai default adalah 1.	1
PageSize	integer	No	Jumlah entri yang dikembalikan di setiap halaman. Nilai default adalah 10.	20
Filters	array<object>	No	Kondisi filter.
	object	No	The supported keys and their value formats are as follows: hostAddress: The source IP address. Separate multiple IP addresses with commas (,). sqlId: The SQL ID. Separate multiple SQL IDs with commas (,). user: The user. Separate multiple users with commas (,). dbName: The database name. Separate multiple database names with commas (,). keyWord: The keyword. Separate multiple keywords with spaces. tags: The tag. Separate multiple tags with commas (,).
Key	string	No	The filter parameter.	KeyWords
Value	string	No	The value of the filter parameter.	select

Elemen respons

Element	Type	Description	Example
	object
Code	string	The HTTP status code returned.	200
Message	string	The returned message. Catatan If the request is successful, Successful is returned. If the request fails, an error message, such as an error code, is returned.	Successful
RequestId	string	The request ID.	52D540CF-C517-1F57-BB42-9035F96******
Success	string	Indicates whether the request was successful. Valid values: true false	true
Data	object	AsyncResult<DBLogRecords<SlowLogStat>>
RequestKey	string	The key of the request parameter.	123456789
ResultId	string	The result ID.	async__665ee69612f1627c7fd9f3c85075****
State	string	The status of the asynchronous request. Valid values: -RUNNING: The request is in progress. -SUCCESS: The request is successful. -FAIL: The request failed.	SUCCESS
IsFinish	boolean	Indicates whether the asynchronous request is complete.	true
Data	object	The data.
DbInstanceName	string	The instance ID.	0
NodeId	string	The node ID. For ApsaraDB for MongoDB instances, you can use this parameter to specify a node for storage analysis. You can call the DescribeRoleZoneInfo operation to query the details of the nodes in an ApsaraDB for MongoDB instance. If you specify the InsName (node ID) of the destination node, such as `d-bp1872fa24d5**`, the system analyzes the corresponding hidden node. If you specify `InsName#RoleId` of the destination node, such as `d-bp1872fa24d5#2995`, the system analyzes the specified node. Penting** For an ApsaraDB for MongoDB replica set instance, if you do not specify this parameter, the system analyzes the only hidden node by default. For an ApsaraDB for MongoDB sharded cluster instance, specify this parameter to select a destination node.	pi-wz99g5rn7w1x8h0sf
ItemsNumbers	integer	The number of items in the slow query log list on the current page.	10
StartTime	string	The start time. This value is a UNIX timestamp. Unit: milliseconds.	2024-10-08T02:01:00Z
EndTime	string	The end time of the query. This value is a UNIX timestamp. Unit: milliseconds. Catatan The end time must be later than the start time.	2024-08-08T02:15:00Z
DbInstanceId	integer	The numeric ID of the instance.	rm-k2ja51w7cnusg5a1x
TotalRecords	integer	The total number of entries.	13
PageNumbers	integer	The page number of the paged query. Pages start from 1. Default value: 1.	1
MaxRecordsPerPage	integer	The maximum number of entries to return on each page of the paged query. Valid values: 5 to 100.	10
Logs	array<object>	The name of the object.
	array<object>	The log details.
Count	integer	The number of elements that correspond to the key.	12
MaxLockTime	number	This parameter is deprecated.	-
MaxQueryTime	number	This parameter is deprecated.	-
MaxRowsExamined	integer	The maximum number of scanned rows.	318613
MaxRowsSent	integer	The maximum number of returned rows.	256
AvgQueryTime	number	This parameter is deprecated.	-
QueryTimeRate	number	The ratio of the query time.	0.1018
CountRate	number	The ratio of the number of executions.	0.2034
AvgRowsExamined	number	The average number of scanned rows.	53421.0
OriginAlias	string	The alias of the source.	order-1
User	string	The user.	user-1
SqlTag	object	The tag.
SqlId	string	The SQL ID.	a3931d8c3a9315dd5ed016d71cf*****
Tags	string	The tags. Multiple tags are separated by commas (,).	DAS_IN_PLAN
Comments	string	The remarks. The remarks can be 1 to 300 characters in length. The remarks can be 1 to 300 characters in length.	dba 归档
Trend	array<object>	The slow log trends.
	object	The slow log trends.
Timestamp	integer	The time when the task was run. This value is a UNIX timestamp. Unit: milliseconds (ms).	1723775362
Value	any	The value of the filter parameter.	tf-testacc-oos-parameter
Database	string	The database name.	work-wechat-api
Histogram	object	The data of the trend chart.
Total	integer	The total number of entries returned for the query.	7
Count	array	The number of slow query logs.
	integer	The number of slow query logs.	100
Ts	array	The timestamp of the execution.
	integer	The time when the event occurred. This value is a UNIX timestamp. Unit: seconds.	1715220818
TsEnd	array	This parameter is deprecated.
	integer	This parameter is deprecated.	-
Item	array<object>	The task status.
	object	The error code.
NodeId	string	The node ID.	r-bp1s1m8hwzrm77kfvz-db-0
Count	array	The number of slow query logs.
	integer	The number of elements that correspond to the Key.	100
Rt	array	The execution time. Unit: seconds.
	number	The execution time. Unit: seconds.	1854
AvgRt	array	The average execution time.
	number	The average execution time.	3709
MaxRt	array	The maximum response time (RT). Unit: ms.
	number	The maximum response time (RT). Unit: ms.	2516.0
LockTime	array	The lock wait time. Unit: milliseconds.
	number	The lock wait time. Unit: milliseconds.	300
AvgLockTime	array	The average lock wait time. Unit: seconds.
	number	The average lock wait time. Unit: seconds.	15
MaxLockTime	array	The maximum lock wait time. Unit: seconds.
	number	The maximum lock wait time. Unit: seconds.	1051
RowsExamined	array	The total number of scanned rows. Catatan This parameter is supported by ApsaraDB RDS for MySQL, ApsaraDB RDS for PostgreSQL, and PolarDB for MySQL.
	integer	The total number of scanned rows. Catatan This parameter is supported by ApsaraDB RDS for MySQL, ApsaraDB RDS for PostgreSQL, and PolarDB for MySQL.	641057
AvgRowsExamined	array	The average number of scanned rows.
	number	The average number of scanned rows.	222189
MaxRowsExamined	array	The maximum number of scanned rows.
	integer	The maximum number of scanned rows.	878511
RowsSent	array	The number of returned rows.
	integer	The number of returned rows.	4
AvgRowsSent	array	The average number of returned rows.
	number	The average number of returned rows.	2.0
MaxRowsSent	array	The maximum number of returned rows.
	integer	The maximum number of returned rows.	256
SqlId	string	The SQL ID.	2dca88762ec6b3812504ab8a4b******
Scheme	string	HTTP or HTTPS.	HTTP
SubInstanceId	string	The ID of the child instance.	r-8vba51c588ba3a94
DbInstanceName	string	The instance ID.	0
InsName	string	The name of the shard.	rm-uf6zix1z2jh1y6fe5
AccountName	string	The database account.	edu_admin
HostAddress	string	The client IP address.	172.23.142.178
QueryStartTime	string	The time when the query started. The time is in the yyyy-MM-dd hh:mm:ss format and is displayed in UTC.	2024-12-25T03:00:00Z
SQLText	string	The details of the SQL statement.	SELECT 'Hello, World!' FROM DUAL
Psql	string	The SQL template.	SELECT b?.id,b?.t?,b?.id,b?.t? FROM testtb? b? JOIN testtb? b? ON b?.id=b?.id WHERE b?.t? LIKE ? ORDER BY b?.id DESC
DBName	string	The database name.	member_score
QueryTime	integer	The query execution time. Unit: milliseconds (ms).	272.444
ReturnItemNumbers	string	The number of returned items.	暂无
DocsExamined	integer	The number of documents scanned during the operation on the MongoDB instance.	1
KeysExamined	integer	The number of index scans on the MongoDB instance.	20000
TableName	string	The name of the table.	users\nifconfig\n
LockTime	number	This parameter is deprecated.	-
RowsExamined	integer	The total number of scanned rows. Catatan This parameter is supported by ApsaraDB RDS for MySQL, ApsaraDB RDS for PostgreSQL, and PolarDB for MySQL.	2444081
RowsSent	integer	The number of returned rows.	772
ThreadId	string	The thread ID. This parameter is returned only for PolarDB for MySQL instances.	1
Timestamp	integer	The time when the task was run. This value is a UNIX timestamp. Unit: milliseconds (ms).	1708568930
AvgLockTime	number	This parameter is deprecated.	-
AvgRowsSent	number	The average number of returned rows.	2.0
LockTimeSeconds	number	The lock wait time. Unit: seconds.	0.0
QueryTimeSeconds	number	The query time. Unit: seconds.	25.472
AvgLockTimeSeconds	number	The average lock wait time. Unit: seconds.	0.0
MaxLockTimeSeconds	number	The maximum lock wait time. Unit: seconds.	0.0
MaxQueryTimeSeconds	number	The maximum query time. Unit: seconds.	14.402
AvgQueryTimeSeconds	number	The average query time. Unit: seconds.	6.211
SqlType	string	The type of the SQL statement.	LOGIN
QueryId	string	The query ID. Catatan This parameter is supported only by ApsaraDB for MongoDB instances.	sq-1pzcdMwRb
NodeType	string	The node type. Catatan This parameter is supported by ApsaraDB for MongoDB and Tair (Redis OSS-compatible).	DLNode
HostInsId	string	The ID of the host instance. Catatan This parameter is supported only by ApsaraDB for MongoDB instances.	mongo-abc123456
InsRole	string	The instance role. Catatan This parameter is supported only by ApsaraDB for MongoDB instances.	__system
OpType	string	The operation type. Catatan This parameter is supported only by ApsaraDB for MongoDB instances.	Insert
Namespace	string	The namespace. Catatan This parameter is supported only by ApsaraDB for MongoDB instances.	database.collection
AvgKeysExamined	number	The average number of index scans. Catatan This parameter is supported only by ApsaraDB for MongoDB instances.	20000
AvgDocExamined	number	The average number of scanned documents. Catatan This parameter is supported only by ApsaraDB for MongoDB instances.	10000
AvgReturnNum	number	The average number of returned rows. Catatan This parameter is supported only by ApsaraDB for MongoDB instances.	1
MaxKeysExamined	integer	The maximum number of index scans. Catatan This parameter is supported only by ApsaraDB for MongoDB instances.	2000000
MaxDocExamined	integer	The maximum number of scanned documents. Catatan This parameter is supported only by ApsaraDB for MongoDB instances.	1000000
MaxReturnNum	integer	The maximum number of returned rows. Catatan This parameter is supported only by ApsaraDB for MongoDB instances.	1
ReturnNum	integer	The number of returned rows. Catatan This parameter is supported only by ApsaraDB for MongoDB instances.	1
DocExamined	integer	The number of scanned documents. Catatan This parameter is supported only by ApsaraDB for MongoDB instances.	2000000
Command	string	The slow query statement. Catatan This parameter is supported only by Tair (Redis OSS-compatible) instances.	SELECT b?.id,b?.t?,b?.id,b?.t? FROM testtb? b? JOIN testtb? b? ON b?.id=b?.id WHERE b?.t? LIKE ? ORDER BY b?.t? DESC
IOWrites	integer	The number of I/O writes. Catatan This parameter is supported only by ApsaraDB RDS for SQL Server instances.	1000
MaxIOWrites	integer	The maximum number of I/O writes. Catatan This parameter is supported only by ApsaraDB RDS for SQL Server instances.	1000
LastRowsCountAffected	integer	The number of rows affected by the last SQL statement. Catatan This parameter is supported only by ApsaraDB RDS for SQL Server instances.	1000
MaxLastRowsCountAffected	integer	The maximum number of rows affected by the last SQL statement. Catatan This parameter is supported only by ApsaraDB RDS for SQL Server instances.	1000
LogicalIOReads	integer	The number of logical reads. Catatan This parameter is supported only by ApsaraDB RDS for SQL Server instances.	1000
MaxLogicalIOReads	integer	The maximum number of logical reads. Catatan This parameter is supported only by ApsaraDB RDS for SQL Server instances.	1000
PhysicalIOReads	integer	The number of physical reads. Catatan This parameter is supported only by ApsaraDB RDS for SQL Server instances.	1000
MaxPhysicalIOReads	integer	The maximum number of physical reads. Catatan This parameter is supported only by ApsaraDB RDS for SQL Server instances.	1000
RowsCountAffected	integer	The number of affected rows. Catatan This parameter is supported only by ApsaraDB RDS for SQL Server instances.	1000
MaxRowsCountAffected	integer	The maximum number of affected rows. Catatan This parameter is supported only by ApsaraDB RDS for SQL Server instances.	1000
CPUTime	number	This parameter is deprecated.	-
AvgCPUTime	number	This parameter is deprecated.	-
MaxCPUTime	number	This parameter is deprecated.	-
AvgIOWrites	number	The average number of I/O writes. Catatan This parameter is supported only by ApsaraDB RDS for SQL Server instances.	1000
AvgLastRowsCountAffected	number	The average number of rows affected by the last SQL statement. Catatan This parameter is supported only by ApsaraDB RDS for SQL Server instances.	1000
AvgLogicalIOReads	number	The average number of logical reads. Catatan This parameter is supported only by ApsaraDB RDS for SQL Server instances.	1000
AvgPhysicalIOReads	number	The average number of physical reads. Catatan This parameter is supported only by ApsaraDB RDS for SQL Server instances.	1000
AvgRowsCountAffected	number	The average number of affected rows. Catatan This parameter is supported only by ApsaraDB RDS for SQL Server instances.	1000
AvgCPUTimeSeconds	number	The average CPU query time. Unit: seconds.	456
MaxCPUTimeSeconds	number	The longest CPU query time. Unit: seconds.	456
CPUTimeSeconds	number	The CPU query time. Unit: seconds. Catatan This parameter is supported only by ApsaraDB RDS for SQL Server instances.	456
Rows	integer	The total number of rows updated or returned by the compute nodes of the PolarDB-X 2.0 instance. Catatan This parameter is supported only by PolarDB-X 2.0 instances.	105
AvgRows	number	The average number of rows.	10
MaxRows	integer	The maximum number of rows.	10
Frows	integer	The number of rows pulled by the compute nodes (CNs) of the PolarDB-X 2.0 instance. Catatan This parameter is supported only by PolarDB-X 2.0 instances.	10
AvgFrows	number	The average number of pulled rows.	10
MaxFrows	integer	The maximum number of pulled rows.	10
Scnt	integer	The number of requests sent from the compute nodes (CNs) to data nodes (DNs) in the PolarDB-X 2.0 instance. Catatan This parameter is supported only by PolarDB-X 2.0 instances.	10
AvgScnt	number	The average number of requests.	10
MaxScnt	integer	The maximum number of requests.	10
RuleId	string	The ID of the rule. For more information, see Query administration.	181**47
AvgRt	number
MaxRt	number
AvgRequestSize	number
MaxRequestSize	number
AvgResponseSize	number
MaxResponseSize	number
TotalCount	integer		0
Cmd	string		systemctl restart nginx.service
ClientIp	string		10.57.84.109
DbId	string		0
ErrorCode	integer	The error code.	10910
Message	string	The error message.	Successful
Timestamp	integer	The timestamp of the request.	1735104224250

Contoh

Respons sukses

JSONformat

{
  "Code": "200",
  "Message": "Successful",
  "RequestId": "52D540CF-C517-1F57-BB42-9035F96******",
  "Success": "true",
  "Data": {
    "RequestKey": "123456789",
    "ResultId": "async__665ee69612f1627c7fd9f3c85075****",
    "State": "SUCCESS",
    "IsFinish": true,
    "Data": {
      "DbInstanceName": "0",
      "NodeId": "pi-wz99g5rn7w1x8h0sf",
      "ItemsNumbers": 10,
      "StartTime": "2024-10-08T02:01:00Z",
      "EndTime": "2024-08-08T02:15:00Z",
      "DbInstanceId": 0,
      "TotalRecords": 13,
      "PageNumbers": 1,
      "MaxRecordsPerPage": 10,
      "Logs": [
        {
          "Count": 12,
          "MaxLockTime": 0,
          "MaxQueryTime": 0,
          "MaxRowsExamined": 318613,
          "MaxRowsSent": 256,
          "AvgQueryTime": 0,
          "QueryTimeRate": 0.1018,
          "CountRate": 0.2034,
          "AvgRowsExamined": 53421,
          "OriginAlias": "order-1",
          "User": "user-1",
          "SqlTag": {
            "SqlId": "a3931d8c3a9315dd5ed016d71cf*****",
            "Tags": "DAS_IN_PLAN",
            "Comments": "dba 归档"
          },
          "Trend": [
            {
              "Timestamp": 1723775362,
              "Value": "tf-testacc-oos-parameter"
            }
          ],
          "Database": "work-wechat-api",
          "Histogram": {
            "Total": 7,
            "Count": [
              100
            ],
            "Ts": [
              1715220818
            ],
            "TsEnd": [
              0
            ],
            "Item": [
              {
                "NodeId": "r-bp1s1m8hwzrm77kfvz-db-0",
                "Count": [
                  100
                ]
              }
            ],
            "Rt": [
              1854
            ],
            "AvgRt": [
              3709
            ],
            "MaxRt": [
              2516
            ],
            "LockTime": [
              300
            ],
            "AvgLockTime": [
              15
            ],
            "MaxLockTime": [
              1051
            ],
            "RowsExamined": [
              641057
            ],
            "AvgRowsExamined": [
              222189
            ],
            "MaxRowsExamined": [
              878511
            ],
            "RowsSent": [
              4
            ],
            "AvgRowsSent": [
              2
            ],
            "MaxRowsSent": [
              256
            ]
          },
          "SqlId": "2dca88762ec6b3812504ab8a4b******",
          "Scheme": "HTTP",
          "SubInstanceId": "r-8vba51c588ba3a94",
          "DbInstanceName": "0",
          "InsName": "rm-uf6zix1z2jh1y6fe5",
          "AccountName": "edu_admin",
          "HostAddress": "172.23.142.178",
          "QueryStartTime": "2024-12-25T03:00:00Z",
          "SQLText": "SELECT 'Hello, World!' FROM DUAL",
          "Psql": "SELECT b?.id,b?.t?,b?.id,b?.t? FROM testtb? b? JOIN testtb? b? ON b?.id=b?.id WHERE b?.t? LIKE ? ORDER BY b?.id DESC",
          "DBName": "member_score",
          "QueryTime": 272.444,
          "ReturnItemNumbers": "暂无",
          "DocsExamined": 1,
          "KeysExamined": 20000,
          "TableName": "users\\nifconfig\\n",
          "LockTime": 0,
          "RowsExamined": 2444081,
          "RowsSent": 772,
          "ThreadId": "1",
          "Timestamp": 1708568930,
          "AvgLockTime": 0,
          "AvgRowsSent": 2,
          "LockTimeSeconds": 0,
          "QueryTimeSeconds": 25.472,
          "AvgLockTimeSeconds": 0,
          "MaxLockTimeSeconds": 0,
          "MaxQueryTimeSeconds": 14.402,
          "AvgQueryTimeSeconds": 6.211,
          "SqlType": "LOGIN",
          "QueryId": "sq-1pzcdMwRb",
          "NodeType": "DLNode",
          "HostInsId": "mongo-abc123456",
          "InsRole": "__system",
          "OpType": "Insert",
          "Namespace": "database.collection",
          "AvgKeysExamined": 20000,
          "AvgDocExamined": 10000,
          "AvgReturnNum": 1,
          "MaxKeysExamined": 2000000,
          "MaxDocExamined": 1000000,
          "MaxReturnNum": 1,
          "ReturnNum": 1,
          "DocExamined": 2000000,
          "Command": "SELECT b?.id,b?.t?,b?.id,b?.t? FROM testtb? b? JOIN testtb? b? ON b?.id=b?.id WHERE b?.t? LIKE ? ORDER BY b?.t? DESC",
          "IOWrites": 1000,
          "MaxIOWrites": 1000,
          "LastRowsCountAffected": 1000,
          "MaxLastRowsCountAffected": 1000,
          "LogicalIOReads": 1000,
          "MaxLogicalIOReads": 1000,
          "PhysicalIOReads": 1000,
          "MaxPhysicalIOReads": 1000,
          "RowsCountAffected": 1000,
          "MaxRowsCountAffected": 1000,
          "CPUTime": 0,
          "AvgCPUTime": 0,
          "MaxCPUTime": 0,
          "AvgIOWrites": 1000,
          "AvgLastRowsCountAffected": 1000,
          "AvgLogicalIOReads": 1000,
          "AvgPhysicalIOReads": 1000,
          "AvgRowsCountAffected": 1000,
          "AvgCPUTimeSeconds": 456,
          "MaxCPUTimeSeconds": 456,
          "CPUTimeSeconds": 456,
          "Rows": 105,
          "AvgRows": 10,
          "MaxRows": 10,
          "Frows": 10,
          "AvgFrows": 10,
          "MaxFrows": 10,
          "Scnt": 10,
          "AvgScnt": 10,
          "MaxScnt": 10,
          "RuleId": "181**47",
          "AvgRt": 0,
          "MaxRt": 0,
          "AvgRequestSize": 0,
          "MaxRequestSize": 0,
          "AvgResponseSize": 0,
          "MaxResponseSize": 0,
          "TotalCount": 0,
          "Cmd": "systemctl restart nginx.service",
          "ClientIp": "10.57.84.109",
          "DbId": "0"
        }
      ]
    },
    "ErrorCode": 10910,
    "Message": "Successful",
    "Timestamp": 1735104224250
  }
}

Kode kesalahan

HTTP status code	Error code	Error message	Description
400	InvalidParams	The request parameters are invalid.
403	NoPermission	You are not authorized to do this action.

Lihat Error Codes untuk daftar lengkap.

Catatan rilis

Lihat Release Notes untuk daftar lengkap.