Table: sl_log_1

8.10. Table: sl_log_1

Stores each change to be propagated to subscriber nodes

Structure of sl_log_1

log_origin

integer

Origin node from which the change came

log_txid

bigint

Transaction ID on the origin node

log_tableid

integer

The table ID (from sl_table.tab_id) that this log entry is to affect

log_actionseq

bigint

The sequence number in which actions will be applied on replicas

log_tablenspname

text

The schema name of the table affected

log_tablerelname

text

The table name of the table affected

log_cmdtype

"char"

Replication action to take. U = Update, I = Insert, D = DELETE, T = TRUNCATE

log_cmdupdncols

integer

For cmdtype=U the number of updated columns in cmdargs

log_cmdargs

text[]

The data needed to perform the log action on the replica

Indexes on sl_log_1

sl_log_1_idx1

log_origin, log_txid, log_actionseq