SOQL Extractor and Analyzer for SalesForce

Extract SOQL queries with their execution counts from Debug Logs of Salesforce. Helps you analyze the 'Too Many SOQLs' error.

What is SOQL Extractor and Analyzer for SalesForce?

'SOQL Extractor and Analyzer for Salesforce' is a Chrome extension that simplifies the process of analyzing SOQL queries within Salesforce Debug Logs. This tool is particularly vital when dealing with 'Too Many SOQLs' errors as it displays all queries and their frequency, along with the Objects (Standard/Custom) they hit. It aids in optimizing code and enhancing performance by proposing a single intensive query over multiple lighter ones. This Chrome extension works in synergy with Salesforce, although exclusively in Classic mode as of the latest update.

Download

Stats

By: Rajiv Bhatt

View on Chrome Web Store

Users: 6,000+

Rating: 4.88 (16)

Version: 2.0.0.0 (Last updated: 2019-04-15)

Creation date: 2019-04-15

Risk impact: Moderate risk impact

Risk likelihood: Low risk likelihood

Manifest version: 2

Permissions:

https://*.salesforce.com/
https://*.force.com/*

Size: 57.60K

Stats date:

Chrome-Stats Rank

# 13065 ▼ 109

Other rankings

#10926 in Workflow & Planning ▲ 21 #67 in query keyword 5 ▼ 3 #76 in recommend keyword 26 ▼ 2 #129 in salesforce keyword 40 ▼ 18 #134 in debug keyword 30 ▼ 11

Other platforms

Not available on Firefox

Not available on Edge

Want to check extension ranking and stats more quickly for other Chrome extensions? Install Chrome-Stats extension to view Chrome-Stats data as you browse the Chrome Web Store.

Summary

Analyze keywords

Update 2.0.0.0: Works only with Classic mode of Salesforce. Users complained about not being able to install the extension. Updated manifest.json file so this should be resolved.

Update 0.0.0.9: Manifest.json permissions were updated to enable the extension for lightning

Update 0.0.0.8: Uploading the same package to make the extension available on the new version of webstore. No changes in functionality.

Update 0.0.0.5: Added two new features

Added an option to view nested method calls and the ability to expand and collapse them. Please note that it would display only user debug and soql statements between the method entry exits. This is a Beta release of this feature and I am looking forward for some feedback as to what are the other details that would be helpful to developers.
Ability to filter the log files. When the "Filter Log Type" is checked, it would show you further checkboxes which you can use to filter the contents of the log file. It would show you only those statements.

Update 0.0.0.3: The extension icon will now be visible only after you open a debug log. This is based on the best practice (memory optimization) recommended by chrome docs.

User reviews

User reviews summary

These summaries are automatically generated weekly using AI based on recent user reviews. Chrome Web Store does not verify user reviews, so some user reviews may be inaccurate, spammy, or outdated.

Pros

Saves time in debugging
Useful for dealing with 101 SOQL issue
Helpful for extracting SOQL manually
Makes debugging easier

Cons

Does not work in Salesforce Lightning, only in Salesforce Classic

Most mentioned

Time saving
Useful for 101 SOQL issue
Makes debugging of SOQL easier

Recent reviews

This works in Salesforce classic not in lightning. But an amazing tool which identifies which SOQL ran how many times. Great tool to debug 101 exception

Chinmaya Rath, 2023-08-10

Great extension. Very much helpful in troubleshooting 101 soql error. Thank you.

Amol Joshi, 2017-10-11

Very useful for 101 SOQL issue..

Jyoti Singh, 2016-03-21

View all user reviews

Safety

Risk impact

SOQL Extractor and Analyzer for SalesForce may not be safe to use and it requires some risky permissions. Exercise caution when installing this extension. Review carefully before installing.