function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
ShaneJensenShaneJensen 

SOQL Profiler on API calls

Hello,

Is there a way to capture soql queries and inserts in the debug logs.  For example, if Data Loader calls the API to export some Accounts, I'd like to see SELECT Id, Name FROM Account WHERE ID=<something> in the debug log.    

Or if someone sends an insert or update to an Account, I'd like to see the full ist of what's changed.  For example: 

INSERT (ID=<something>, Name="ABC Contracting")
UPDATE( ID=<something>, Name = "XYZ Consulting")

We have a black box application, pulling and sending data from our Financial System to Salesforce, but all I really see is validation rules, triggers and workflows firing.

I guess, I'm spoiled from MS SQL Profiler in the Database world.

Thanks,
Shane

Ramu_SFDCRamu_SFDC
Unfortunately there is no such hight level feature like a SQL profiler when it comes to Salesforce however you can do some basic profiling using developer console in salesforce. The below blog post has more information on this

http://salesforce.stackexchange.com/questions/5699/how-can-i-profile-the-performance-of-salesforce-queries