log_alert_*
A newer version of this documentation is available. Use the version menu above to view the most up-to-date release of the Greenplum 6.x documentation.
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 |