14 March 2024
Viewing Data Types
To view data types in the Space:
In the Space overview page, click a Space to drill down.
Within this page, the IT administrator or developer can review the Object Type properties and metrics related to size, distribution per partition etc.
At the top of the page, it is possible to review the Object Type name and data related to the number of entries, indexes, and Notify Contains generated by the Object Type. A summary of the information available is given below.
Parameter | Description |
---|---|
Name | Name of the data object |
Number of entries | The Object Type data distribution between the deployed partitions of the service. It is possible to review the number of entries per partition and identify situations where the data partitioning is unbalanced. |
Number of reads | The distribution of application reads to the Object Type and split between the deployed partitions |
ID | Pointer to the primary key of the data type in the Space |
Indexes | By clicking on the indexes tab, it is possible to review the list of indexes defined for the Object Type. Also shows used properties per each index and its type - e.g. regular, composite etc. |
Routing | Pointer to the field that identifies the Space partition. |
Notify containers | How many instances of this object type match a template in an event container. |
SQL editor |
Press on the SQL Editor tab to see a SQL SELECT statement for the selected Object Type. The user can edit the query, for example:
|
Explain Plan |
The Explain Plan of a query can be viewed In the Ops Manager when running a query in the SQL Query Editor. The output of the query explain plan is shown in a collapsible view above the query results table. To enable the Explain Plan feature, check the Run with Explain Plan check box. . Running a query with an Explain Plan may impact the query performance.
|