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 ( '[schema-name.]projection' );
Parameters
schema |
Specifies a schema. If multiple schemas are defined in the database, include the schema name. For example: myschema.thisDbObject |
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]