Amazon Web Services (AWS) Redshift queries are slow
Never forget the golden rule of AWS Redshift.
“Whenever you add, delete, or modify a significant number of rows, you should run a VACUUM command and then an ANALYZE command.”
This will speed up your queries.
Vacuum command will clear any deleted space and tune the database.