Skip to content

Instantly share code, notes, and snippets.

@cdcarter
Created April 22, 2018 18:14
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save cdcarter/ff39e4eac4bf7ef3366ccad0464f3ba6 to your computer and use it in GitHub Desktop.
Save cdcarter/ff39e4eac4bf7ef3366ccad0464f3ba6 to your computer and use it in GitHub Desktop.
(clotf) ➜ ~ sfdx force:data:record:get -u DevHub --json --perfloglevel basic -s account -i 0014600000V8jNg | jq ".perfMetrics[1].perfMetrics" -r | jq
{
"version": "1.0.0",
"callTree": {
"name": "http-request",
"attachment": {},
"startTime": 1390938186527800,
"endTime": 1390938225452642,
"ownTime": 6874226,
"childTime": 32050616,
"totalTime": 38924842,
"children": [
{
"name": "db-exec",
"attachment": {
"sql": "{?=call cDistributedCache.init_master_version_nc(?)}"
},
"startTime": 1390938187824972,
"endTime": 1390938188112615,
"ownTime": 287643,
"childTime": 0,
"totalTime": 287643,
"children": []
},
{
"name": "rest-api",
"attachment": {
"URI": "/v42.0/sobjects/account/0014600000V8jNg",
"resource-class": "common.api.rest.SObjectRowResource",
"resource-method": "GET"
},
"startTime": 1390938195143841,
"endTime": 1390938225382060,
"ownTime": 15700137,
"childTime": 14538082,
"totalTime": 30238219,
"children": [
{
"name": "db-exec",
"attachment": {
"sql": "{?=call cDistributedCache.init_master_version_nc(?)}"
},
"startTime": 1390938195641665,
"endTime": 1390938195855913,
"ownTime": 214248,
"childTime": 0,
"totalTime": 214248,
"children": []
},
{
"name": "db-exec",
"attachment": {
"sql": "{?=call cAuthSession.get_session_nc(?,?,?)}"
},
"startTime": 1390938197002662,
"endTime": 1390938197421563,
"ownTime": 418901,
"childTime": 0,
"totalTime": 418901,
"children": []
},
{
"name": "db-exec",
"attachment": {
"sql": "{call cContext.setContextWithStatistics(?,?,?,?,?,?,?,?,?,?,?,?,?)}"
},
"startTime": 1390938203935566,
"endTime": 1390938204768013,
"ownTime": 832447,
"childTime": 0,
"totalTime": 832447,
"children": []
},
{
"name": "db-exec",
"attachment": {
"sql": "{?=call cDistributedCache.init_master_version_nc(?)}"
},
"startTime": 1390938204802673,
"endTime": 1390938205009811,
"ownTime": 207138,
"childTime": 0,
"totalTime": 207138,
"children": []
},
{
"name": "db-exec",
"attachment": {
"sql": "{call cDistributedCache.get_invalidations_nc(?,?,?,?,?,?)}"
},
"startTime": 1390938205252324,
"endTime": 1390938205538934,
"ownTime": 286610,
"childTime": 0,
"totalTime": 286610,
"children": []
},
{
"name": "db-exec",
"attachment": {
"sql": "{call cContext.getOracleStatistics_nc(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)}"
},
"startTime": 1390938205616885,
"endTime": 1390938206236810,
"ownTime": 619925,
"childTime": 0,
"totalTime": 619925,
"children": []
},
{
"name": "db-exec",
"attachment": {
"sql": "{call cContext.setContextWithStatistics(?,?,?,?,?,?,?,?,?,?,?,?,?)}"
},
"startTime": 1390938208844143,
"endTime": 1390938209623033,
"ownTime": 778890,
"childTime": 0,
"totalTime": 778890,
"children": []
},
{
"name": "db-exec",
"attachment": {
"sql": "{?=call cOauth.get_consumer_by_key_nc(?,?)}"
},
"startTime": 1390938209664636,
"endTime": 1390938210113652,
"ownTime": 449016,
"childTime": 0,
"totalTime": 449016,
"children": []
},
{
"name": "db-exec",
"attachment": {
"sql": "select /*Retrieve*/ /*+ ordered use_nl(t_mru) */\nnest.\"Id\",\nnest.\"IsDeleted\",\nnest.\"MasterRecordId\",\nnest.\"Name\",\nnest.\"Type\",\nnest.\"ParentId\",\nnest.\"BillingStreet\",\nnest.\"BillingCity\",\nnest.\"BillingState\",\nnest.\"BillingPostalCode\",\nnest.\"BillingCountry\",\nnest.\"BillingLatitude\",\nnest.\"BillingLongitude\",\nnest.\"BillingGeocodeAccuracy\",\nnest.\"BillingAddress\",\nnest.\"ShippingStreet\",\nnest.\"ShippingCity\",\nnest.\"ShippingState\",\nnest.\"ShippingPostalCode\",\nnest.\"ShippingCountry\",\nnest.\"ShippingLatitude\",\nnest.\"ShippingLongitude\",\nnest.\"ShippingGeocodeAccuracy\",\nnest.\"ShippingAddress\",\nnest.\"Phone\",\nnest.\"Fax\",\nnest.\"Website\",\nnest.\"PhotoUrl\",\nnest.\"Industry\",\nnest.\"AnnualRevenue\",\nnest.\"NumberOfEmployees\",\nnest.\"Description\",\nnest.\"t.ID\",\nnest.\"OwnerId\",\nnest.\"CreatedDate\",\nnest.\"CreatedById\",\nnest.\"LastModifiedDate\",\nnest.\"LastModifiedById\",\nnest.\"SystemModstamp\",\nnest.\"LastActivityDate\",\nt_mru.last_view_date \"LastViewedDate\",\nt_mru.entry_date \"LastReferencedDate\",\nnest.\"Jigsaw\",\nnest.\"JigsawCompanyId\",\nnest.\"AccountSource\",\nnest.\"SicDesc\",\nnest.\"RowVersion\"\nfrom (select *\nfrom (select /*+ ordered use_nl(t) index(t pkaccount) */\nt.deleted \"IsDeleted_gen_1\",\nids.num \"ids_num\",\nt.account_id \"Id\",\nt.deleted \"IsDeleted\",\nt.master_record_id \"MasterRecordId\",\nt.name \"Name\",\nt.type_enum \"Type\",\nt.parent_id \"ParentId\",\nt.address1_street \"BillingStreet\",\nt.address1_city \"BillingCity\",\nt.address1_state \"BillingState\",\nt.address1_zip \"BillingPostalCode\",\nt.address1_country \"BillingCountry\",\nt.address1_latitude \"BillingLatitude\",\nt.address1_longitude \"BillingLongitude\",\nt.address1_accuracy \"BillingGeocodeAccuracy\",\nt.address1_street || '\u001f' || t.address1_city || '\u001f' || t.address1_state || '\u001f' || t.address1_zip || '\u001f' || t.address1_country || '\u001f' || t.address1_state_code || '\u001f' || t.address1_country_code || '\u001f' || t.address1_latitude || '\u001f' || t.address1_longitude || '\u001f' || t.address1_accuracy \"BillingAddress\",\nt.address2_street \"ShippingStreet\",\nt.address2_city \"ShippingCity\",\nt.address2_state \"ShippingState\",\nt.address2_zip \"ShippingPostalCode\",\nt.address2_country \"ShippingCountry\",\nt.address2_latitude \"ShippingLatitude\",\nt.address2_longitude \"ShippingLongitude\",\nt.address2_accuracy \"ShippingGeocodeAccuracy\",\nt.address2_street || '\u001f' || t.address2_city || '\u001f' || t.address2_state || '\u001f' || t.address2_zip || '\u001f' || t.address2_country || '\u001f' || t.address2_state_code || '\u001f' || t.address2_country_code || '\u001f' || t.address2_latitude || '\u001f' || t.address2_longitude || '\u001f' || t.address2_accuracy \"ShippingAddress\",\nt.phone1 \"Phone\",\nt.phone2 \"Fax\",\nt.url \"Website\",\n'/services/images/photo/'||gUtil.getCaseSafeId(t.account_id, '1') \"PhotoUrl\",\nt.industry_enum \"Industry\",\nt.sales \"AnnualRevenue\",\nt.employees \"NumberOfEmployees\",\nt.short_description \"Description\",\nt.account_id \"t.ID\",\nt.owner \"OwnerId\",\nt.created_date \"CreatedDate\",\nt.created_by \"CreatedById\",\nt.last_update \"LastModifiedDate\",\nt.last_update_by \"LastModifiedById\",\nt.system_modstamp \"SystemModstamp\",\nt.last_activity \"LastActivityDate\",\nt.jigsaw_key \"Jigsaw\",\nt.jigsaw_key \"JigsawCompanyId\",\nt.account_source_enum \"AccountSource\",\nt.sic_desc \"SicDesc\",\nt.row_version \"RowVersion\",\nt.account_id repl__0\nfrom (select * from table(cast(? as id_num_array))) ids,\nsales.account t\nwhere (ids.id = t.account_id)\nand (t.organization_id = '00D460000017Fel')\nand (t.account_id != '000000000000000'))\nwhere (\"IsDeleted_gen_1\" = '0')\norder by \"ids_num\" asc nulls first) nest,\ncore.mru t_mru\nwhere (repl__0 = t_mru.entity_id(+))\nand (t_mru.organization_id(+) = '00D460000017Fel')\nand (t_mru.users_id(+) = ?)\nand (t_mru.key_prefix(+) = ?)\norder by nest.\"ids_num\" asc nulls first"
},
"startTime": 1390938220691515,
"endTime": 1390938221465204,
"ownTime": 773689,
"childTime": 0,
"totalTime": 773689,
"children": []
},
{
"name": "db-exec",
"attachment": {
"sql": "{call cClobUtils.get_api_lobs_nc(?,?,?,?,?)}"
},
"startTime": 1390938222320235,
"endTime": 1390938222771001,
"ownTime": 450766,
"childTime": 0,
"totalTime": 450766,
"children": []
},
{
"name": "db-exec",
"attachment": {
"sql": "{call cMru.add_to_mru_nc_auto(?,?,?,?,gUtil.gtypes_bool_to_boolean(?),gUtil.gtypes_bool_to_boolean(?),gUtil.gtypes_bool_to_boolean(?))}"
},
"startTime": 1390938223531857,
"endTime": 1390938225292637,
"ownTime": 1760780,
"childTime": 0,
"totalTime": 1760780,
"children": []
}
]
}
]
},
"summary": [
{
"metrics": "db-conn-wait",
"totalTime": 1025650,
"totalCalls": 5
},
{
"metrics": "rest-api",
"totalTime": 30238219,
"totalCalls": 1
},
{
"metrics": "db-exec",
"totalTime": 7080053,
"totalCalls": 12
},
{
"metrics": "cache-memcached",
"totalTime": 8239041,
"totalCalls": 47
},
{
"metrics": "http-request",
"totalTime": 38924842,
"totalCalls": 1
},
{
"metrics": "request-tracing-enable",
"totalTime": 5735,
"totalCalls": 5
}
]
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment