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.
|Column Name||Data Type||Description|
|node||integer||Cluster node where the slice is located.|
To view which cluster nodes are managing which slices, type the following query:
select * from stv_slices;
This query returns the following sample output:
node | slice ------+------- 0 | 2 0 | 3 0 | 1 0 | 0 (4 rows)