- Newest
- Most votes
- Most comments
Hello,
That table redshift_auto_health_check_99999999
is an internal table used by internal Redshift monitoring tool to periodically monitor the health of the cluster.
You can disregard this table from the output of the query. In your particular case, since it returned only this table, it means the statistic of recent queried tables is up to date.
There are other factors that may affect the query performance, such as uneven data distribution, unsorted rows, cluster node configuration, WLM configuration, etc. This doc addresses most of this factors. Additionally, you can also refer to this article with some recommended actions to troubleshoot cluster or query performance.
You are also welcome to open a support case with AWS using the following link so that a Support Engineer will be able to investigate details of your cluster workload to provide a more accurate recommendation.
Relevant content
- Accepted Answerasked 2 months ago
- Accepted Answerasked 2 months ago
- asked a year ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 2 months ago
- AWS OFFICIALUpdated 2 years ago