In the gpperfmon DB, there are 3 tables involved in recording alert log information from the pg_log files for a Greenplum DB. These tables are:
log_alert_now: Current pg_log errors and warnings data is stored in log_alert_now during the period between data collection from the Command Center agents and automatic commitment to the log_alert_history table.log_alert_tail: This is the transitional table for query workload data that has been cleared from log_alert_now but has not yet been committed to log_alert_history. It typically only contains a few minutes of worth of data.
log_alert_history: This is the regular table that stores historical database-wide errors and warnings data.
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/26477398/viewspace-2127562/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
