By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

Vacuum command stuck for hours

0

vacuum is taking too much time on any table. Even on a table with just 36 records, it didn't succeed even after executing for more than 2.5 hours and I had to cancel the query.

How can I resolve this?

Thank you

Topics
DatabaseAnalytics
Tags
DatabaseAmazon Redshift
Language
English
Pandy
asked 3 months ago421 views
1 Answer
0

Hello,

Can you monitor the progress of vacuum using below query to get estimate.

SELECT * FROM svv_vacuum_progress;

Check the cluster performance health while the vacuum running to check if hitting with any cpu bottleneck or storage issues etc. refer Viewing cluster performance data

Also take a look at How do I troubleshoot performance issues with VACUUM in Amazon Redshift? and follow the vacuum best practices.

AWS
gokul_guna
answered 3 months ago
  • Pandy
    3 months ago

    There is no bottleneck, CPU is around 50% also the health status is healthy. Everything seems to be normal. svv_vacuum_progress - Does give output expect in my case. While I am executing vacuum for table 'A'. I getting result only for table 'X' as complete.

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions

Relevant content