华为云首页用户手册

云日志服务 LTS-云数据库GaussDB接入LTS:结构化模板日志详情

时间：2024-07-04 10:52:13

云日志服务 LTS

结构化模板日志详情

GAUSSV5审计日志示例

表1 结构化模板示例
模板名称	示例日志
GAUSSV5审计日志	{ "username": "rdsAdmin", "client_conninfo": "cm_agent@10.254.95.70", "instanceId": "96e86f462bbc4f2286d7c8274815d0fein14", "detail_info": "xid=30818, SET statement_timeout = 10000000;n", "thread_id": "140463114942208@713872403507507", "result": "ok", "database": "postgres", "local_port": "8001", "userid": "10", "nodeId": "06c267fad8054a0abcb17cfa3b8f260cno14", "node_name": "dn_6001_6002_6003", "object_name": "statement_timeout", "time": "2022-08-15 17:53:23+08", type: "set_parameter", "remote_port": "50952" }

表1 结构化模板示例

模板名称

示例日志

GAUSSV5审计日志

{ "username": "rdsAdmin", "client_conninfo": "cm_agent@10.254.95.70", "instanceId": "96e86f462bbc4f2286d7c8274815d0fein14", "detail_info": "xid=30818, SET statement_timeout = 10000000;n", "thread_id": "140463114942208@713872403507507", "result": "ok", "database": "postgres", "local_port": "8001", "userid": "10", "nodeId": "06c267fad8054a0abcb17cfa3b8f260cno14", "node_name": "dn_6001_6002_6003", "object_name": "statement_timeout", "time": "2022-08-15 17:53:23+08", type: "set_parameter", "remote_port": "50952" }

结构化字段及字段说明

表2 结构化字段
字段	示例	描述	类型
username	rdsAdmin	用户名	string
client_conninfo	cm_agent@10.254.95.70	客户端连接信息	string
instanceId	96e86f462bbc4f2286d7c8274815d0fein14	实例ID	string
detail_info	xid=30818, SET statement_timeout = 10000000;n	执行的SQL语句	string
thread_id	140463114942208@713872403507507	线程ID	string
result	ok	SQL执行结果	string
database	postgres	使用的数据库	string
local_port	8001	本地端口	string
userid	10	用户ID	string
nodeId	06c267fad8054a0abcb17cfa3b8f260cno14	节点ID	string
node_name	dn_6001_6002_6003	节点名称	string
object_name	statement_timeout	对象的名称	string
time	2022-08-15 17:53:23+08	审计日志时间	string
type	set_parameter	SQL开始执行时间	string
remote_port	50952	远程端口	string