There is one document page per Redshift Workbench page.
| Page | Description |
|---|---|
| Databases v1 | List of, and information about, each database in the cluster. |
| Groups (users) v1 | List of every user in each group. |
| Groups (cluster) v1 | List of, and cluster-level information about, each group in the cluster. |
| Locks (cluster) v1 | List of, and information about, each worker-node lock in the cluster. |
| Nodes (cluster) v1 | List of, and cluster-level information about, each node in the cluster. |
| Queries (running) v1 | List of, and information about, each running query, both leader node and worker node, in the cluster. |
| Queries v1 | List of, and information about, each running and each completed query, both leader node and worker node, in the cluster. |
| Compile Plan v1 | List of, and information about, the compilation work performed for a query. |
| Step Plan v1 | List of, and information about, the work performed by a query. |
| Query Text (fast) v1 | The full text of DDL and MDL queries, and the first 4000 bytes of SQL queries (and it’s fast). |
| Query Text (slow) v1 | The full text of SQL queries (but it’s glacially slow). |
| Queues (routing) v1 | List of, and information about every routing rule, including the number of queries routed by each rule, in the cluster. |
| Queues (throughput) v1 | List of per-queue query throughput, on a per minute basis. Useful to rapidly observe if WLM configuration changes have helped or hindered. |
| Queues v1 | List of, and information about, each queue in the cluster. |
| Roles (privs) v1 | List of the cumulative privs held by every role, and the list of granted roles, and their privs, which contribute. |
| Sessions v1 | List of, and information about, each session in the cluster. |
| Slices (cluster) v1 | List of, and cluster-wide information about, each slice in the cluster. |
| Transaction v1 | List of, and information about, all the queries in a transaction. This page is also used to find the underlying SQL of a cursor. |
| Transactions v1 | List of, and information about, all transactions with two or more queries. |
| Users (groups) v1 | List for each user of every group the user is in. |
| Users (cluster) v1 | List of, and cluster-wide information about, each user in the cluster. |
| Cluster v1 | Information about the cluster. |
| Change Database v1 | Redshift Workbench connects to a single database at a time. Use this page to select which database. |
| Default Privs v1 | List of, and information about, each default privilege in the current database. |
| Dependencies v1 | This page shows dependency graphs. |
| Function Text v1 | The text (which is to say, the code, in whatever language) of a function. |
| Functions v1 | List of, and information about, each function in the current database. |
| Groups (privs) v1 | List of each privilege held by each group, including the identity of the user who granted the privilege, in the current database. |
| Groups (database) v1 | List of, and database-level information about, each group in the cluster. |
| Locks (blocked) v1 | List of, and information about, all blocked and blocking transactions, in the current database. |
| Locks (database) v1 | List of, and information about, each lock in the current database. |
| Nodes (database) v1 | List of, and database-level information about, each node in the cluster. |
| Procedures Text v1 | The text (which is to say, the PL/pgSQL) of a procedure. |
| Procedures v1 | List of, and information about, each procedure in the current database. |
| Schemas v1 | List of, and information about, each schema in the current database. |
| Slices (database) v1 | List of, and database-level information about, each slice in the cluster. |
| Table (analysis) v1 | Analysis of each column in a table. Analysis validates constraints (unique, foreign keys, etc), computes the optimal data type choices, and the information necessary for humans to make optimal encoding choices. |
| Table (history) v1 | List of events in the history of a table. |
| Table (slices, blocks) v1 | List of blocks, on a per slice basis, for a table. This page polls, and is intended for real-time monitoring of a table, useful during vacuum operations. |
| Table (slices, columns, blocks) v1 | List of blocks, on a per slice, per-column basis, for a table. This page does not poll, but rather is intended to provide complete information about the state of the blocks in a table. |
| Tables (columns) v1 | List of, and information about, every column in each table in the current database. |
| Tables (constraints) v1 | List of, and information about, each constraint (both single and multi-column) on each table in the current database. |
| Tables v1 | List of, and information about, each table in the current database. |
| Users (privs) v1 | List of every privilege held by each user, including the identity of the entity which granted the privilege, in the current database. |
| Users (database) v1 | List of, and database-level information about, each user in the cluster. |
| View Text v1 | The text (which is to say, the SQL) of a view. |
| Views (late-binding, columns) v1 | List of, and information about, every column in each late-binding view in the current database. |
| Views (late-binding) v1 | List of, and information about, each late-binding view in the current database. |
| Views (materialized, columns) v1 | List of, and information about, every column in each materialized view in the current database. |
| Views (materialized) v1 | List of, and information about each materialized view, including information about the underlying table, in the current database. |
| Views (normal, columns) v1 | List of, and information about, every column in each normal view in the current database. |
| Views (normal) v1 | List of, and information about each normal view, including information about the set of tables used by the view, in the current database. |