Queries details of a slice.

A slice indicates a portion of the query plan in AnalyticDB for PostgreSQL.

Debugging

OpenAPI Explorer automatically calculates the signature value. For your convenience, we recommend that you call this operation in OpenAPI Explorer. OpenAPI Explorer dynamically generates the sample code of the operation for different SDKs.

Request parameters

Parameter Type Required Example Description
Action String Yes DescribeSQLLogsOnSlice

The operation that you want to perform. Set the value to DescribeSQLLogsOnSlice.

PageSize Integer No 30

The number of entries to return on each page. Default value: 30. Valid values:

  • 30
  • 50
  • 100
PageNumber Integer Yes 1

The number of the page to return. The value must be a positive integer. Default value: 1.

MaxExecuteCost String No 1000

The maximum amount of time consumed by a slow query. Minimum value: 0. Unit: seconds.

MinExecuteCost String No 10

The minimum amount of time consumed by a slow query. Minimum value: 0. Unit: seconds.

ExecuteState String No success

The execution state of the query. Valid values:

  • success
  • fail
DBInstanceId String Yes gp-xxxxxxxx

The ID of the instance.

Note You can call the DescribeDBInstances operation to query details of all AnalyticDB for PostgreSQL instances in a specific region, including instance IDs.
QueryId String Yes 11111

The query ID.

Note You can call the DescribeSlowSQLLogs operation to query the SQL query ID.
SliceId String Yes 1

The slice ID.

Note You can call the DescribeSQLLogByQueryId operation to query the slice ID.

Response parameters

Parameter Type Example Description
RequestId String 07F6177E-6DE4-408A-BB4F-xxxxxxxxxxxx

The ID of the request.

PageRecordCount Integer 1

The number of entries returned per page.

PageNumber Integer 1

The page number of the returned page.

SliceLogItems Array of SQLLogsSliceItem

Details of the slice.

ExecuteStatus String success

The execution state of the query.

  • success
  • fail
ExecuteCost Float 100

The execution duration of the query. Unit: seconds.

ReturnRowCounts Long 1

The number of entries returned.

OperationExecuteTime String 2021-08-12T04:37:02Z

The start time of the query.

SegmentId String gp-xxxxxxxxxx

The ID of the compute node.

PeakMemory Float 128B

The peak memory usage.

OperationExecuteEndTime String 2021-08-12T04:37:02Z

The end time of the query.

SegmentName String gp-xxxxxxxxxx

The name of the compute node.

Examples

Sample requests

http(s)://gpdb.aliyuncs.com/?Action=DescribeSQLLogsOnSlice
&PageNumber=1
&DBInstanceId=gp-xxxxxxxx
&QueryId=11111
&SliceId=1
&<Common request parameters>

Sample success responses

XML format 

HTTP/1.1 200 OK
Content-Type:application/xml

<DescribeSQLLogsOnSliceResponse>
    <RequestId>07F6177E-6DE4-408A-BB4F-xxxxxxxxxxxx</RequestId>
    <PageRecordCount>1</PageRecordCount>
    <PageNumber>1</PageNumber>
    <SliceLogItems>
        <ExecuteStatus>success</ExecuteStatus>
        <ExecuteCost>100</ExecuteCost>
        <ReturnRowCounts>1</ReturnRowCounts>
        <OperationExecuteTime>2021-08-12T04:37:02Z</OperationExecuteTime>
        <SegmentId>gp-xxxxxxxxxx</SegmentId>
        <PeakMemory>128B</PeakMemory>
        <OperationExecuteEndTime>2021-08-12T04:37:02Z</OperationExecuteEndTime>
        <SegmentName>gp-xxxxxxxxxx</SegmentName>
    </SliceLogItems>
</DescribeSQLLogsOnSliceResponse>

JSON format 

HTTP/1.1 200 OK
Content-Type:application/json

{
  "RequestId" : "07F6177E-6DE4-408A-BB4F-xxxxxxxxxxxx",
  "PageRecordCount" : 1,
  "PageNumber" : 1,
  "SliceLogItems" : [ {
    "ExecuteStatus" : "success",
    "ExecuteCost" : 100,
    "ReturnRowCounts" : 1,
    "OperationExecuteTime" : "2021-08-12T04:37:02Z",
    "SegmentId" : "gp-xxxxxxxxxx",
    "PeakMemory" : "128B",
    "OperationExecuteEndTime" : "2021-08-12T04:37:02Z",
    "SegmentName" : "gp-xxxxxxxxxx"
  } ]
}

Error codes

For a list of error codes, visit the API Error Center.