Help Center> Log Tank Service> User Guide> Log Ingestion> Collecting Logs from Cloud Services> Collecting Logs from GaussDB
Updated on 2024-01-25 GMT+08:00
View PDF

Collecting Logs from GaussDB

LTS can collect logs from GaussDB. For details, see LTS Logs.

Structuring Template Details

  • GAUSSV5 audit log example
    Table 1 Structuring template example

    Template Name

    Example Log

    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" }
  • Structuring fields and description
    Table 2 Structuring fields

    Field

    Example

    Description

    Type

    username

    rdsAdmin

    Username.

    string

    client_conninfo

    cm_agent@10.254.95.70

    Client connection information.

    string

    instanceId

    96e86f462bbc4f2286d7c8274815d0fein14

    Instance ID.

    string

    detail_info

    xid=30818, SET statement_timeout = 10000000;n

    Executed SQL statement.

    string

    thread_id

    140463114942208@713872403507507

    Thread ID.

    string

    result

    ok

    SQL execution result.

    string

    database

    postgres

    Used database.

    string

    local_port

    8001

    Local port.

    string

    userid

    10

    User ID.

    string

    nodeId

    06c267fad8054a0abcb17cfa3b8f260cno14

    Node ID.

    string

    node_name

    dn_6001_6002_6003

    Node name.

    string

    object_name

    statement_timeout

    Object name.

    string

    time

    2022-08-15 17:53:23+08

    Audit log time.

    string

    type

    set_parameter

    SQL execution start time.

    string

    remote_port

    50952

    Remote port.

    string