Viewing Data Types

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.

Press on the SQL Editor tab to see a SQL SELECT statement for the selected Object Type.

Press Run Query. The results will appear in the Query Results table on the bottom of the page.

An example query is as follows:

SELECT * FROM "com.mycompany.app.model.Persons" LIMIT 10

This example query can be seen in the Ops Manager screen:

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.

Space data details

Command:

gs.{sh/bat} space info --type-stats <name>

Description:

This command shows data type information for the specified Space: Entry class, number of entries, notify templates.

Input Example:

<GS_HOME>/bin/gs space info --type-stats mySpace

<GS_HOME>/bin/gs.sh space info --type-stats mySpace

Output Example:

Parameters and Options:

Space instance data details

Command:

gs.{sh/bat} space info-instance --type-stats <instance ID>

Description:

This command shows data type information for the specified Space instance: Entry class, number of entries, notify templates.

Input Example:

<GS_HOME>/bin/gs space info-instance --type-stats mySpace~1_1

<GS_HOME>/bin/gs.sh space info-instance --type-stats mySpace~1_1

Output Example:

Parameters and Options:

To view Space data types:

Path

GET /spaces/{id}/statistics/types

Description:

The data entries in the Space are listed.

Example Request:

curl -X GET --header 'Accept: application/json' 'http://localhost:8090/v2/spaces/alertSpace/statistics/types'

Example Response:

{
  "java.lang.Object": {
    "entries": 0,
    "notifyTemplates": 0
  }
}

Options:

To view Space Instance data types:

Path

GET /spaces/{id}/instances/{instanceId}/statistics/types

Description:

The data entries in the Space instance are listed.

Example Request:

curl -X GET --header 'Accept: application/json' 'http://localhost:8090/v2/spaces/alertSpace/instances/alertSpace~1/statistics/types'

Example Response:

{
  "java.lang.Object": {
    "entries": 0,
    "notifyTemplates": 0
  }
}

Options:

1. In the Spaces view, highlight the Space or Space instance where you want to see the data types.
2. Display the Types pane in the lower area of the view.

3. You can view the following information per data type:

   Item	Description
   Data Type Name	Name of the data type.
   Instances Count	How many instances of this data type are currently in the Space.
   Templates Count	How many instances of this data type match a template in an event container.
   Space ID	Pointer to the primary key of the data type in the Space.
   Space Routing	Pointer to the field that identifies the Space partition.
   Indexes	Displays which fields of the data type are indexed.

   Additionally, when you drill through a data type, you can see the following additional information:

   Item	Description
   Member Name	Name of the field in the data type.
   Member Type	Type of field.
   Storage Type	How the data type is stored (object, binary, or compressed).
   Indexes	Index type for the member of the data type.

4. To filter the data type table, type an alphanumeric value in the Filter box.

Refer to the Admin API topics in the Developer Guide.