How can I find information about large objects in a tenant that can impact performance?

Question

How can I find information about large objects in a tenant?  Large objects can impact performance.  NOTE: I need to add additional information to explain the result output.  Please do not share with customer until that is completed.

Answer

• Search for large objects in a tenant.

GET https://<environment>.reltio.com/reltio/api/<tenantId>/entities?filter=gte(entity_size, 2000000)&select=uri

• Look at an individual large object.

GET https://<environment>.reltio.com/reltio/api/<tenantId>/entities/<entityID/statistic

Response

{
    "is_large_object": true,
    "entity_size": 2938384,
    "entity_json_size": 1389909,
    "event_size": 390154,
    "crosswalks_count": 3,
    "max_simple_values_per_attribute": 1,
    "max_nested_values_per_attribute": 1,
    "max_reference_values_per_attribute": 1,
    "sub_nested_attribute_values_count": 27,
    "sub_reference_attribute_values_count": 947,
    "reference_crosswalks_count": 507,  <<<== crosswalk size of reference entities
    "verification_result": [
        "VALID"
    ]
}

• Deeper analysis of a large object

GET https://<environment>.reltio.com/reltio/monitoring/_objectInfo?tenantId=<tenantId>&id=<entityID>

Result

{
"Entity type": "Quote",
"Raw version": "1000000000::025248ce-03fc-4c28-84b4-90883538ee95::1",
"Entity consistency": true,
"Potential match consistency": true,
"Entity version": {
"EntityVersion": 1000000963,
"ESVersion": 1000000963,
"MatchDocumentVersion": "No version, match rules not exists"
},
"Potential match version": {
"CassandraVersion": 0,
"ESVersion": 0
},
"Deleted": false,
"Linked": false,
"Business addition conflict": false,
"Commit time": 1668595659319,
"Updated time": "16/11/2022 10:47:39 Coordinated Universal Time (1668595659319)",
"Exceeded max reference updated time": "01/01/1970 12:00:00 Coordinated Universal Time (0)",
"Updated by": "DL_reltio_boomiuser_prd",
"Unable to publish": false,
"Operation id": "025248ce-03fc-4c28-84b4-90883538ee95",
"Entity size": 2938384,
"CRUD message size": 390154,
"Latest reference updated time": "19/01/2023 07:46:41 Coordinated Universal Time (1674157601681)",
"Latest reference updated by": "DL_reltio_infuser_prd",
"Versions from reference objects": {
"Ju4zRO0": {
"entities/Ju4zRO0": "1000000000::806df60a-04c2-4662-8f23-1ca61aaa7df9::1",
"relations/8IDpkCO": "1000000000::cc5f373d-29f0-42f9-9759-36cde8a938a1::1"
},
"1HjPvzQq": {
"entities/1HjPvzQq": "181000000000::ec439890-71f9-4d3b-9ace-176eab013ccf::958",
"relations/11wicvEO": "3000000000::EH.10b26491-e19b-4e4f-814e-7ddb714bed8a::3"
}
},
"Exceeded reference business addition": 0,
"Winner id": "entities/0StwCIA",
"Created time": "16/11/2022 10:47:39 Coordinated Universal Time (1668595659319)",
"Created by": "DL_reltio_boomiuser_prd",
"ID of ref object updated last": "entities/1HjPvzQq",
"Entity limits": {
"Verification Result": [
"VALID"
],
"Crosswalks Count": 3,
"Max Simple Values Per Attributes Count": 1,
"Max Nested Values Per Attributes Count": 1,
"Max Reference Values Per Attributes Count": 1,
"SubNested Attributes Count": 27,
"SubReference Attributes Count": 947,
"Reference Crosswalks Count": 507
}
}