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!
About the Author
Phil Molea
Sr. Information Developer, Vertica
Phil developed technical documentation in the areas of security and diagnostics for the Vertica Analytics Platform that enabled companies to extract value from their data at the speed and scale they need to thrive in today’s economy.
(Sadly, Phil passed away recently. He will be missed.)
