Skip to main content

Get query

GET 
/dwsu/:dwServiceUnitId/query/detail

Gets information about the specified query.

Request​

Path Parameters

    dwServiceUnitId stringrequired

    The ID of the service unit.

    Example: dw54321

Query Parameters

    process_id stringrequired

    The process ID of the query.

    Example: 2.02310230421381e+28

Responses​

OK

Schema

    code int32

    The response code.

    data

    object

    The query record.

    detail

    object[]

  • Array [

    • Plan

    object

    Actual Loops int32
    Actual Rows int64
    Actual Startup Time double
    Actual Total Time double
    Alias string
    CTE Name string
    Catalog string
    Filter string
    Group Key string[]
    Hash Batches string
    Hash Buckets string
    Hash Cond string
    Hash Key string
    Index Cond string
    Index Name string
    Inner Unique string
    Join Filter string
    Join Type string
    Local Dirtied Blocks string
    Local Hit Blocks string
    Local Read Blocks string
    Local Written Blocks string
    Node Type string
    Original Hash Batches string
    Original Hash Buckets string
    Output string[]
    Parallel Aware string
    Parent Relationship string
    Partial Mode string
    Partitioning string
    Peak Memory Usage string
    Plan Rows string
    Plan Width string
    Plans undefined[]
    Relation Name string
    Rows Removed by Filter int32
    Rows Removed by Index Recheck string
    Rows Removed by Join Filter int32
    Scan Direction string
    Schema string
    Shared Dirtied Blocks string
    Shared Hit Blocks string
    Shared Read Blocks string
    Shared Written Blocks string
    Sort Key string[]
    Sort Method string
    Sort Space Type string
    Sort Space Used string
    Startup Cost string
    Strategy string
    Temp Read Blocks string
    Temp Written Blocks string
    Total Cost string
    aliasName string
    planNodeId string
    stageId string
    state string

  • ]

    • summary

    object

    The summary of the query.

    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
    msg string

    The response message.

Loading...