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)