Table: sl_log_2

8.11. Table: sl_log_2

Stores each change to be propagated to subscriber nodes

Structure of sl_log_2

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. S = Script statement, s = Script complete

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_2

sl_log_2_idx1

log_origin, log_txid, log_actionseq