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 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]