STV_SLICES
Use the STV_SLICES table to view the current mapping of a slice to a node.
The information in STV_SLICES is used mainly for investigation purposes.
STV_SLICES is visible to all users. Superusers can see all rows; regular users can see only their own data. For more information, see Visibility of data in system tables and views.
Table columns
Column name | Data type | Description |
---|---|---|
node | integer | Cluster node where the slice is located. |
slice | integer | Node slice. |
localslice | integer | This information is for internal use only. |
type | character(1) | This information is for internal use only. |
Sample query
To view which cluster nodes are managing which slices, type the following query:
select node, slice from stv_slices;
This query returns the following sample output:
node | slice ------+------- 0 | 2 0 | 3 0 | 1 0 | 0 (4 rows)