check for FATAL and ERROR log messages from the system

Post date: Oct 09, 2014 10:4:9 PM

Run SQL

select * from log_alert_history where logseverity in ('FATAL', 'ERROR') and logtime > (now() - interval '15 minutes');

Analyze the alert. You may want to add additional filters to the query to ignore certain messages of low interest