14 March 2024

XAP

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.