GET_PROJECTIONS

Returns information about projections that are anchored to the specified table, as follows:

Contextual information Projection data
  • Database K-safety
  • The number of nodes in the database
  • Number of projections for this table

For each projection anchored to this table:

  • The projection's buddy projections
  • Whether the projection is segmented
  • Whether the projection is safe
  • Whether the projection is up-to-date

You can use GET_PROJECTIONS to monitor the progress of a projection data refresh.

Syntax

GET_PROJECTIONS ( '[schema-name.]table' )

Parameters

schema

Specifies a schema. If multiple schemas are defined in the database, include the schema name. For example:

myschema.thisDbObject
table

The table whose projections you want to list.

Privileges

None

Examples

The following example gets information about the store_dimension table in the VMart schema:

=>  SELECT GET_PROJECTIONS('store.store_dimension'); 
                                        GET_PROJECTIONS                                                                               
----------------------------------------------------------------------------------------------------
 Current system K is 1.
# of Nodes: 3.
Table store.store_dimension has 3 projections.

Projection Name: [Segmented] [Seg Cols] [# of Buddies] [Buddy Projections] [Safe] [UptoDate] [Stats]
----------------------------------------------------------------------------------------------------
store.store_dimension_unseg [Segmented: No] [Seg Cols: ] [K: 2] [store.store_dimension_unseg] [Safe: Yes] [UptoDate: Yes] [Stats: Yes]
store.store_dimension_p_b1 [Segmented: Yes] [Seg Cols: "store.store_dimension.store_key"] [K: 1] [store.store_dimension_p_b0] [Safe: Yes] [UptoDate: Yes] [Stats: Yes]
store.store_dimension_p_b0 [Segmented: Yes] [Seg Cols: "store.store_dimension.store_key"] [K: 1] [store.store_dimension_p_b1] [Safe: Yes] [UptoDate: Yes] [Stats: Yes]

(1 row)