System monitoring (provisioned only) - Amazon Redshift

System monitoring (provisioned only)

The following system tables and views can be queried on provisioned clusters. STL and STV tables and views contain a subset of data found in several of the system tables. These provide quicker and easier access to commonly queried data found in those tables.

SVCS views provide details about queries on both the main and concurrency scaling clusters. SVL views provide information only for queries run on the main cluster, with the exception of SVL_STATEMENTTEXT. SVL_STATEMENTTEXT can contain information for queries run on concurrency scaling clusters as well as the main cluster.