Replacement System Tables for Amazon Redshift now available
Not a question, but I thought it would be of interest to Redshift uses - re:Post admin, if not, and this is not permitted content, please delete.
I run www.redshift-observatory.ch and I started working on my own set of replacement system tables back in 2017. Six months I started afresh, and I've just published. There are about 780 views at the moment, with massive ongoing development. They are to the Redshift system tables what molten chocolate covered chocolate sponge dessert with cherry liquor is is to cardboard :-)
- Topics
- Analytics
- Tags
- Amazon Redshift
- Language
- English
- Newest
- Most votes
- Most comments
Amazon Redshift provides a comprehensive set of system tables and views that offer valuable information about how the system is functioning. These system tables and views can be queried like regular database tables, allowing administrators and users to gain insights into the database's operations.
There are several types of system tables and views in Amazon Redshift, including:
- SVV views: Contain information about database objects with references to transient STV tables.
- SYS views: Used to monitor query and workload usage for provisioned clusters and serverless workgroups.
- STL views: Generated from logs and provide a history of the system.
- STV tables: Virtual system tables that contain snapshots of the current system data.
- SVCS views: Provide details about queries on both main and concurrency scaling clusters.
- SVL views: Provide details about queries on main clusters.
It's important to note that system tables and views have different visibility levels. Some are visible to all users, while others are only visible to superusers. Regular users can be granted access to superuser-visible tables by being given SELECT privilege on those tables.
Amazon Redshift also includes system catalog tables with a PG prefix, which store schema metadata such as information about tables and columns. These are based on PostgreSQL system catalogs and are accessible to Amazon Redshift users.
For users looking to analyze system performance or troubleshoot issues, these built-in system tables and views provide a wealth of information. They can be used to monitor query performance, track system usage, and gain insights into database operations.
While third-party tools or custom views may offer additional functionality, it's always recommended to refer to the official Amazon Redshift documentation for the most up-to-date and accurate information about system tables and views.
Sources
System tables and views reference - Amazon Redshift
System catalog tables - Amazon Redshift
Relevant content
- asked a year ago
- asked 2 years ago
- AWS OFFICIALUpdated 5 months ago
