GET_PROJECTION_STATUS

Returns information relevant to the status of a projection:

  • The current K-safety status of the database
  • The number of nodes in the database
  • Whether the projection is segmented
  • The number and names of buddy projections
  • Whether the projection is safe
  • Whether the projection is up to date
  • Whether statistics have been computed for the projection

Use GET_PROJECTION_STATUS to monitor the progress of a projection data refresh.

Syntax

GET_PROJECTION_STATUS ( '[[database.]schema.]projection' );

Parameters

[database.]schema

Specifies a schema, by default public. If schema is any schema other than public, you must supply the schema name. For example:

myschema.thisDbObject

If you specify a database, it must be the current database.
projection

The projection for which to display status.

Examples

=> SELECT GET_PROJECTION_STATUS('public.customer_dimension_site01');
                                     GET_PROJECTION_STATUS
-----------------------------------------------------------------------------------------------
 Current system K is 1.
# of Nodes: 4.
public.customer_dimension_site01 [Segmented: No] [Seg Cols: ] [K: 3] [public.customer_dimension_site04, public.customer_dimension_site03, 
public.customer_dimension_site02]
[Safe: Yes] [UptoDate: Yes][Stats: Yes]