Created
April 22, 2018 18:14
-
-
Save cdcarter/ff39e4eac4bf7ef3366ccad0464f3ba6 to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| (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