Skip to main content

List queries

GET 
/unit/query/history

Lists the queries run in the service unit.

Request​

Query Parameters

    queryId string

    The ID of the query.

    Example: 20231010_164555_00813_mj7qq
    user string

    The DW user that performs the query.

    dpsName string

    The name of the PDS cluster that is used to run the query.

    Example: dps1
    startTime int64

    The start time of the query.

    Example: 1685510869834
    endTime int64

    The end time of the query.

    Example: 1694410869000
    queryState string

    The query status.

    Example: FAIL
    queryText string

    The query text.

    Example: SELECT
    startDuration string

    The minimum execution duration.

    Example: 120
    endDuration string

    The maximum execution duration.

    Example: 300
    isAqsQuery string

    Whether Adaptive Query Scaling is enabled.

    Example: true
    pageSize string

    Possible values: >= 1

    Default value: 10

    The number of items returned per page.

    pageNumber string

    Possible values: >= 1

    Default value: 1

    The sequence number of the current page.

Responses​

OK

Schema

    code int32

    The response code.

    data

    object

    The summary of the query.

    pageNumber int64

    The sequence number of the current page.

    pageSize int64

    The number of items displayed per page.

    records

    object[]

    The records in the current page.

  • Array [

    • catalog string
    createTime int64
    cumulativeUserMemory string
    database string
    debug string
    debugInfo string
    details string
    dpsName string
    elapsedTime int64
    endTime int64
    engineType string
    executionTime string
    instanceId string
    nodeIp string
    nodeType string
    processId string

    queryBaseInfo

    object

    completedDrivers int32
    cumulativeUserMemory string
    elapsedTime string
    executionTime string
    peakUserMemoryReservation string
    totalCpuTime string
    userMemoryReservation string
    queryBossInfo string
    queryHash string
    queryId string
    queryPattenHash string
    queryState string
    queryText string
    queryType string
    schema string
    timestamp string
    totalCpuTime string
    user string
    version string

  • ]

    • total int64

    The number of pages in total.

    msg string

    The response message.

Loading...