Monitoring metrics in Amazon Redshift Spectrum - Amazon Redshift

Monitoring metrics in Amazon Redshift Spectrum

You can monitor Amazon Redshift Spectrum queries using the following system views:

  • SVL_S3QUERY

    Use the SVL_S3QUERY view to get details about Redshift Spectrum queries (S3 queries) at the segment and node slice level.

  • SVL_S3QUERY_SUMMARY

    Use the SVL_S3QUERY_SUMMARY view to get a summary of all Amazon Redshift Spectrum queries (S3 queries) that have been run on the system.

The following are some things to look for in SVL_S3QUERY_SUMMARY:

  • The number of files that were processed by the Redshift Spectrum query.

  • The number of bytes scanned from Amazon S3. The cost of a Redshift Spectrum query is reflected in the amount of data scanned from Amazon S3.

  • The number of bytes returned from the Redshift Spectrum layer to the cluster. A large amount of data returned might affect system performance.

  • The maximum duration and average duration of Redshift Spectrum requests. Long-running requests might indicate a bottleneck.