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. |