
The Vertica GET_PROJECTION_STATUS function can be called to quickly display key projection facts such as segmentation columns, verified fault tolerance, and statistics status.
Examples:
dbadmin=> SELECT get_projection_status('segs_b0');
get_projection_status
--------------------------------------------------------------------------------
Current system K is 1.
# of Nodes: 3.
public.segs_b0 [Segmented: Yes] [Seg Cols: "public.segs.c"] [K: 1] [public.segs_b1] [Safe: Yes] [UptoDate: Yes] [Stats: RowCounts]
(1 row)
dbadmin=> SELECT get_projection_status('reps_super');
get_projection_status
-----------------------------------------------------------------------
Current system K is 1.
# of Nodes: 3.
public.reps_super [Segmented: No] [Seg Cols: ] [K: 2] [public.reps_super] [Safe: Yes] [UptoDate: Yes] [Stats: Yes]
(1 row)
Helpful Link:https://www.vertica.com/docs/latest/HTML/index.htm#Authoring/SQLReferenceManual/Functions/VerticaFunctions/GET_PROJECTION_STATUS.htm
Have fun!