Conveniently Display Key Projection Info

Jim_Knicely · October 2018

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/9.1.x/HTML/index.htm#Authoring/SQLReferenceManual/Functions/VerticaFunctions/GET_PROJECTION_STATUS.htm

Have fun!