Updated on 2023-10-23 GMT+08:00

GS_GLOBAL_CHAIN

GS_GLOBAL_CHAIN records information about modification operations performed by users on the tamper-proof user table. Each record corresponds to a table-level modification operation. Users with the audit administrator permission can query this system catalog, but no user is allowed to modify this system catalog.

Table 1 GS_GLOBAL_CHAIN columns

Name

Type

Description

blocknum

bigint

Block number, which is the sequence number of the current user operation recorded in the ledger

dbname

name

Name of the database, to which the modified tamper-proof user table belongs

username

name

Username, which is the name of the user who performs the operation of modifying the user table

starttime

timestamp with time zone

Latest timestamp when a user performs an operation

relid

oid

OID of the modified tamper-proof user table

relnsp

name

OID of the namespace to which the modified tamper-proof user table belongs

relname

name

User table name, which is the name of the modified tamper-proof user table

relhash

hash16

Table-level hash change amount generated by the current operation

globalhash

hash32

Global digest, which is calculated based on the information of the current row and the globalhash of the previous row. It connects the entire table to verify the integrity of GS_GLOBAL_CHAIN data.

txcommand

text

SQL statement whose operations are recorded