log_alert_*

The log_alert_* tables store pg_log errors and warnings.

See Alert Log Processing and Log Rotation for information about configuring the system logger for gpperfmon.

There are three log_alert tables, all having the same columns:

• log_alert_now is an external table whose data is stored in .csv files in the $MASTER_DATA_DIRECTORY/gpperfmon/logs directory. Current pg_log errors and warnings data are available in log_alert_now during the period between data collection from the gpperfmon agents and automatic commitment to the log_alert_history table.
• log_alert_tail is an external table with data stored in $MASTER_DATA_DIRECTORY/gpperfmon/logs/alert_log_stage. This is a transitional table for data that has been cleared from log_alert_now but has not yet been committed to log_alert_history. The table includes records from all alert logs except the most recent. It typically contains only a few minutes' worth of data.
• log_alert_history is a regular table that stores historical database-wide errors and warnings data. It is pre-partitioned into monthly partitions. Partitions are automatically added in two month increments as needed.

Column	Type	Description
logtime	timestamp with time zone	Timestamp for this log
loguser	text	User of the query
logdatabase	text	The accessed database
logpid	text	Process id
logthread	text	Thread number
loghost	text	Host name or ip address
logport	text	Port number
logsessiontime	timestamp with time zone	Session timestamp
logtransaction	integer	Transaction id
logsession	text	Session id
logcmdcount	text	Command count
logsegment	text	Segment number
logslice	text	Slice number
logdistxact	text	Distributed transaction
loglocalxact	text	Local transaction
logsubxact	text	Subtransaction
logseverity	text	Log severity
logstate	text	State
logmessage	text	Log message
logdetail	text	Detailed message
loghint	text	Hint info
logquery	text	Executed query
logquerypos	text	Query position
logcontext	text	Context info
logdebug	text	Debug
logcursorpos	text	Cursor position
logfunction	text	Function info
logfile	text	Source code file
logline	text	Source code line
logstack	text	Stack trace

Parent topic: The gpperfmon Database