Contents

The pgmemento.transaction_log table stores metadata about each transaction. It is filled by the pgmemento.log_transaction function (via pgmemento.log_table_event) that is called whenever a table trigger or event trigger is fired. This can happen multiple time during one transaction, but the details are only logged once. The log table contains the following columns: * id SERIAL: The Primary Key * txid BIGINT NOT NULL: The internal transaction ID by PostgreSQL (can cycle) * txid_time TIMESTAMP WITH TIME ZONE NOT NULL: Stores the result of transaction_timestamp() function * process_id INTEGER: Stores the result of pg_backend_pid() function * user_name TEXT: Stores the result of current_user function * client_name TEXT: Stores the result of inet_client_addr() function * client_port INTEGER: Stores the result of inet_client_port() function * application_name TEXT: Stores the output of current_setting('application_name') * session_info JSONB: Stores any infos a client/user defines beforehand with set_config