A Redshift cluster has many system tables and views you can query to understand how your system behaves. However, before we start, here are some naming conventions. There are two types of system tables: STL and STV tables. There are also some Views. Let’s see:
STL tables: (Tables with stl_ prefix) These system tables have logs, provide a history of the system, and persist.
STV tables: (Tables with stv_ prefix) They are virtual tables with snapshots of the current system state data.
SVL views: (Views with svl_ prefix) They are system views that contain references to STL tables and logs for more detailed information.
SVV views: (Views with svv_ prefix) They are system views that contain references to STV tables and snapshots for more detailed information.: (Views with svv_ prefix) They are system views that contain references to STV tables and snapshots for more detailed information.