云数据库 GAUSSDB-查询事务列表 - QueryingTransactions:响应示例

时间:2025-11-13 15:20:19

响应示例

{
    "total" : 1,
    "rows" : [ {
      "sessionid" : 25347,
      "pid" : 140625211029248,
      "query_id" : 0,
      "datname" : "postgres",
      "client_addr" : "127.0.0.1",
      "client_port" : 60256,
      "usename" : "root",
      "query" : "start transaction isolation level repeatable read;",
      "backend_start" : "2023-12-11 15:10:21.553063+08",
      "xact_start" : "2023-12-11 15:10:29.671267+08",
      "application_name" : "gsql",
      "state" : "idle in transaction",
      "state_change" : "2023-12-11 15:10:29.671345+08",
      "query_start" : "2023-12-11 15:10:29.671267+08",
      "waiting" : "f",
      "unique_sql_id" : 0,
      "top_xid" : "0",
      "current_xid" : "0",
      "exec_time" : "232",
      "xlog_quantity" : 0
    } ]
  }
support.huaweicloud.com/api-gaussdb/gaussdb_api_530.html