Redshift troubleshooting
Amazon Redshift Troubleshooting Checklist – DBA Guide Amazon Redshift Troubleshooting Checklist (Production DBA Guide) This guide provides a structured, real-world troubleshooting checklist for Amazon Redshift performance and stability issues. 1. Cluster Health Check (Always First) ☐ Cluster status = Available ☐ No resize operation running ☐ No maintenance in progress ☐ No node replacement events Check Recent System Alerts: SELECT event_time, event, solution FROM stl_alert_event_log ORDER BY event_time DESC LIMIT 20; 2. Running & Long Queries Check Running Queries: SELECT pid, user_name, starttime, datediff(seconds, starttime, getdate()) AS runtime_sec, substring(querytxt,1,200) FROM stv_recents WHERE status = 'Running' ORDER BY runtime_sec DESC; Check Historical Slow Queries: SELECT query, total_exec_time/1000000 AS exec_time_sec, rows FROM stl_query ORDER BY exec_time_sec DESC L...