LinkedIn

Salesforce - How to Track Record Save Performance Details Using Log Inspector

-
When your Salesforce instance is growing with lots of customization, there are high chances that you might hit performance issues with respect to Record save time. Salesforce is providing with out of the box approaches to track and find out time consumed by each of your operation. Let us see how we can track that - with the help of a sample scenario - Contact record save operation.

Scenario - Customization On Contact Object

Let us consider 2 Customization on Contact Object.

1. Assign Task to Account Owner - Process Builder

When a new Contact is created, assign a task to Account Owner asking to reach out to that Contact to get some additional details about him.

This can be achieved through a Process Builder as shown below:




2. Update Account Country from Contact to Country field in Account - Contact Trigger

Example :

Account - Account ABC
Contact 1 -> Country ->India
Contact 2-> Country->United States

Once the contacts are saved, Account Country value should be -> India, United States

This can be achieved using multiple approaches like Process builder+Flow, Process builder+Invocable Apex, Queueable Apex etc. Since we want to track performance of different solution scenarios, let us consider Trigger as a solution option for this.

Please see the Trigger Solution Below:


How to Track Performance Details

Follow below Steps to Capture Performance Details:

  1. Create new Debug Level
Make sure to follow below debug levels:

  • Database - > FINEST
  • Workflow -> FINER
  • Apex Code-> FINEST
  • Apex Profiling -> FINEST

2. How to Capture Performance Details

  • Once a new Contact is Saved, open the debug in Developer Console
  • Go to Debug->Switch Perspective->Analysis(PreDefined)
Debug View - Log Inspector Details

Once you are switched to this view, you will be able to see below details

1. Stack Tree - Execution Tree & Performance Tree

Stack Tree contains 2 views - Execution Tree and Performance Tree

Execution Tree



Execution tree shows time consumed by each statement. For example if we have a For loop inside a trigger, execution tree shows time consumed by each of these iteration .

Performance Tree



Performance Tree shows duration and heap details at operation Level. For example if we have a workflow and a trigger, we can see an aggregated view for each of this.

2. Execution Stack



If we select a row from Performance Tree or Execution Tree - Execution Stack shows the bottom up view of that selected Row.

3. Execution Overview

Execution Overview has multiple tabs under it.

Save Order


Save Order shows color coded operation order Details:

 COLOR TYPE
  Red            Before Trigger        
 Orange        After Trigger           
  Green          Validation Rule       
 Blue            Assignment Rule    
 Purple         Workflow Rule        

Limits


Limits tab shows details of Governor Limits consumed by your current transaction.

TimeLine



Timeline shows a visual representation of time consumed by each operation

Executed Units



This shows the system resources consumed by each of the process. This includes - number of times the statement got executed, time consumed, number of rows got processed, Heap consumed, Query type(SOQL Vs SOSL) etc.

Now lets us see how we can capture all these details in our Contact Save scenario. Watch the below video.


Let me know your questions/Comments about this post.
 

Comments

  1. Vamsi Krishna Vadipalli8 June 2020 at 02:10

    Thanks for valuable information

    ReplyDelete
  2. Surendranath Ponnaganti10 June 2020 at 19:41

    Thanks for providing great information 👍

    ReplyDelete
  3. Abhinav Sharma5 March 2021 at 16:21

    valuable information!!

    ReplyDelete
  4. sindhuja cynixit14 May 2021 at 01:58

    Nice information, this is will helpfull a lot, Thank for sharing, Keep do posting i like to follow this
    salesforce billing admin training online

    ReplyDelete
  5. Manoj21 July 2021 at 06:19

    thanks for valiable sales force information

    Salesforce Billing Online Training. Contact us @ +91 9550102466.

    ReplyDelete
  6. bhanu13 September 2021 at 03:05

    Thank you so much for sharing this valuable information.
    Salesforce CPQ Training
    Salesforce CPQ Online Training

    ReplyDelete
  7. Lavanya4 February 2022 at 18:23

    Thanks for your information. very good article.
    CPQ Salesforce Training
    Salesforce CPQ Course

    ReplyDelete
  8. Sales Tracking Software20 April 2022 at 22:47

    Thank you for sharing n wonderful post with us.
    Sales Force tracker

    ReplyDelete
  9. Gracie22 August 2023 at 02:22

    Thanks for sharing this informative article on Salesforce - How to Track Record Save Performance Details Using Log Inspector. If you want to Salesforce Services for your project. Please visit us.

    ReplyDelete
  10. Flowace20 September 2023 at 04:01

    I have read many articles here and learned many things from them, this was really helpful for me. Thank you so much for sharing this info with us and keep sharing your ideas with us.
    I want to introduce the Salesforce tool FLOWACE.
    Tracking record save performance details in Salesforce is crucial for optimizing system efficiency. Flowace, integrated with Salesforce, provides advanced tools like Log Inspector to monitor and analyze these details. It enhances your ability to fine-tune Salesforce performance, ensuring a seamless experience for users and efficient data management

    ReplyDelete
  11. sreedhar11 December 2023 at 22:57

    Nice blog
    Managing Staff Augmentation Services for Success | TechTriad

    ReplyDelete
  12. Thanisha Nair16 April 2024 at 03:55

    Nice blog, thank you for sharing this information with us.
    Leading Staff Augmentation Services In The USA.

    ReplyDelete

Post a Comment

Popular posts from this blog

Subscribing to Salesforce Platform Events using External Java Client - CometD

-
Image
Platform Events follow event based Architecture, where multiple subscribers can subscribe to a published event in real time manner.  Below diagram shows the basic Architecture of the event-based communication Model: Event - This is a change in state for a business process Event Message - Data about the event Producer - Publisher of the event Event Bus - A communication and storage service for published events Event Consumer - A subscriber to the channel Platform events can be subscribed internally and also externally Platfrom events  - Internal Subscription Below are some scenarios in which you can consume platform events internally: 1. When we need to execute functionalities asynchronously to save govornor limits 2. To build a proper exception logging framework - You can find more details here  How to subscribe Internally? we can see more details about this in a different blogpost. Platfrom events  - External Consumption Many Organizations are moving to event-based integration appr
Read more

Salesforce Security - Restriction Rules and Scoping Rules

-
Image
1. Overview Salesforce provides a very effective security model where we always start with the most restrictive access and then open up access using additional mechanisms like sharing rules, and manual sharing based on the requirements.   But there might be scenarios where we need to restrict access based on specific criteria. Salesforce recently introduced 2 approaches to support this requirement. Those are restriction rules and scoping rules. Let us see this in detail. 2. Restriction Rules - Overview Using restriction rules we can apply an additional level of filter on top of records to which a specific user is having access. 3. Scoping Rules - Overview Scoping rules help to filter the default records visible for a user based on specific criteria. But it is not preventing access to other records. 4. Compare Restriction Rules and Scoping Rules 5. Restriction Rule - Example Company ABC is having Job Applications getting created through their company portal and synched to Salesforce. T
Read more

How to develop reusable Invocable Apex methods for Flows

-
Image
 Salesforce is adding many new features and capabilities to Flows. But there are still some scenarios where you need to call apex methods from Flows to execute complex operations - when Flow is not capable of doing that or the performance will be low when you implement that using flows. Let us see how we can build reusable apex methods for Flows. For this let us consider 2 sample scenarios: Scenario 1 - Quick Create Account/Contact I want to build a screen, where the user can select the object needs to be created, and then create a record of that object by entering the required details. Also if the record creation is getting failed, I want to create an exception record with details. Solution Let us see how we can utilize Apex action for this. For this first let us create an Apex Invocable method, which can accept a list of wrapper class as shown below: You can see, this invocable method is accepting a List of wrapper class variables and also returning a list of wrapper class variables.
Read more