Posts

long-running-queries-redshift

 SELECT     i.pid,     s.user_name,     i.query AS query_id,     substring(s.query_text,1,100) AS short_query,     s.elapsed_time/1000000 AS duration_sec FROM stv_inflight i JOIN sys_query_history s     ON i.query = s.query_id ORDER BY duration_sec DESC; ========================================== SELECT     i.pid,     s.user_name,     s.query_id,     substring(s.query_text,1,100) AS short_query,     s.elapsed_time/1000000 AS duration_sec FROM stv_inflight i JOIN sys_query_history s     ON i.query = s.query_id WHERE s.status = 'running' ORDER BY duration_sec DESC; ============================================= SELECT      i.pid,     u.usename AS user_name,     s.query_id,     substring(s.query_text, 1, 100) AS short_query,     s.elapsed_time / 1000000 AS duration_sec FROM stv_inflight i JOIN sys_query_history s ...
Post a Comment
Read more

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...
Post a Comment
Read more