System view mapping for migrating to SYS monitoring views
When you migrate your Amazon Redshift provisioned cluster to Amazon Redshift Serverless, your monitoring or diagnostic queries might reference system views that are only available on provisioned clusters. You can update your queries to use the SYS monitoring views. This page provides provisioned-only to SYS view mappings for you to reference when updating your queries.
Topics
- SYS_QUERY_HISTORY
- SYS_QUERY_DETAIL
- SYS_RESTORE_LOG
- SYS_RESTORE_STATE
- SYS_TRANSACTION_HISTORY
- SYS_QUERY_TEXT
- SYS_CONNECTION_LOG
- SYS_SESSION_HISTORY
- SYS_LOAD_DETAIL
- SYS_LOAD_HISTORY
- SYS_LOAD_ERROR_DETAIL
- SYS_UNLOAD_HISTORY
- SYS_UNLOAD_DETAIL
- SYS_COPY_REPLACEMENTS
- SYS_DATASHARE_USAGE_CONSUMER
- SYS_DATASHARE_USAGE_PRODUCER
- SYS_DATASHARE_CROSS_REGION_USAGE
- SYS_DATASHARE_CHANGE_LOG
- SYS_EXTERNAL_QUERY_DETAIL
- SYS_EXTERNAL_QUERY_ERROR
- SYS_VACUUM_HISTORY
- SYS_ANALYZE_HISTORY
- SYS_ANALYZE_COMPRESSION_HISTORY
- SYS_MV_REFRESH_HISTORY
- SYS_MV_STATE
- SYS_PROCEDURE_CALL
- SYS_PROCEDURE_MESSAGES
- SYS_UDF_LOG
- SYS_USERLOG
- SYS_SCHEMA_QUOTA_VIOLATIONS
- SYS_SPATIAL_SIMPLIFY
SYS_QUERY_HISTORY
Some or all of the columns in the following tables are also defined in SYS_QUERY_HISTORY.
SYS_QUERY_DETAIL
Some or all of the columns in the following tables are also defined in SYS_QUERY_DETAIL.
SYS_RESTORE_LOG
Some or all of the columns in the following table are also defined in SYS_RESTORE_LOG.
SYS_RESTORE_STATE
Some or all of the columns in the following table are also defined in SYS_RESTORE_STATE.
SYS_TRANSACTION_HISTORY
Some or all of the columns in the following tables are also defined in SYS_TRANSACTION_HISTORY.
SYS_QUERY_TEXT
Some or all of the columns in the following table are also defined in SYS_QUERY_TEXT.
SYS_CONNECTION_LOG
Some or all of the columns in the following table are also defined in SYS_CONNECTION_LOG.
SYS_SESSION_HISTORY
Some or all of the columns in the following tables are also defined in SYS_SESSION_HISTORY.
SYS_LOAD_DETAIL
Some or all of the columns in the following table are also defined in SYS_LOAD_DETAIL.
SYS_LOAD_HISTORY
Some or all of the columns in the following table are also defined in SYS_LOAD_HISTORY.
SYS_LOAD_ERROR_DETAIL
Some or all of the columns in the following tables are also defined in SYS_LOAD_ERROR_DETAIL.
SYS_UNLOAD_HISTORY
Some or all of the columns in the following table are also defined in SYS_UNLOAD_HISTORY.
SYS_UNLOAD_DETAIL
Some or all of the columns in the following table are also defined in SYS_UNLOAD_DETAIL.
SYS_COPY_REPLACEMENTS
Some or all of the columns in the following table are also defined in SYS_COPY_REPLACEMENTS.
SYS_DATASHARE_USAGE_CONSUMER
Some or all of the columns in the following table are also defined in SYS_DATASHARE_USAGE_CONSUMER.
SYS_DATASHARE_USAGE_PRODUCER
Some or all of the columns in the following table are also defined in SYS_DATASHARE_USAGE_PRODUCER.
SYS_DATASHARE_CROSS_REGION_USAGE
Some or all of the columns in the following table are also defined in SYS_DATASHARE_CROSS_REGION_USAGE.
SYS_DATASHARE_CHANGE_LOG
Some or all of the columns in the following table are also defined in SYS_DATASHARE_CHANGE_LOG.
SYS_EXTERNAL_QUERY_DETAIL
Some or all of the columns in the following tables are also defined in SYS_EXTERNAL_QUERY_DETAIL.
SYS_EXTERNAL_QUERY_ERROR
Some or all of the columns in the following tables are also defined in SYS_EXTERNAL_QUERY_ERROR.
SYS_VACUUM_HISTORY
Some or all of the columns in the following tables are also defined in SYS_VACUUM_HISTORY.
SYS_ANALYZE_HISTORY
Some or all of the columns in the following tables are also defined in SYS_ANALYZE_HISTORY.
SYS_ANALYZE_COMPRESSION_HISTORY
Some or all of the columns in the following tables are also defined in SYS_ANALYZE_COMPRESSION_HISTORY.
SYS_MV_REFRESH_HISTORY
Some or all of the columns in the following tables are also defined in SYS_MV_REFRESH_HISTORY.
SYS_MV_STATE
Some or all of the columns in the following tables are also defined in SYS_MV_STATE.
SYS_PROCEDURE_CALL
Some or all of the columns in the following tables are also defined in SYS_PROCEDURE_CALL.
SYS_PROCEDURE_MESSAGES
Some or all of the columns in the following tables are also defined in SYS_PROCEDURE_MESSAGES.
SYS_UDF_LOG
Some or all of the columns in the following tables are also defined in SYS_UDF_LOG.
SYS_USERLOG
Some or all of the columns in the following tables are also defined in SYS_USERLOG.
SYS_SCHEMA_QUOTA_VIOLATIONS
Some or all of the columns in the following tables are also defined in SYS_SCHEMA_QUOTA_VIOLATIONS.
SYS_SPATIAL_SIMPLIFY
Some or all of the columns in the following tables are also defined in SYS_SPATIAL_SIMPLIFY.