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

Latest Version

Version
2.0.0.0
Update
April 15, 2019
Size
56.25KiB
Developer
Category
Users
5,000+
Rating
4.875 ★
Manifest Version
2
Web Store Status
Languages Support
English
See more
Permissions
Https://*.salesforce.com/
Https://*.force.com/*
See more

SOQL Extractor and Analyzer for SalesForce Extension

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
1. 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.
2. 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.

This extension helps you extract and analyze the SOQL queries from the debug logs of Salesforce. Open up any Debug Log on Salesforce and then on just \"One-Click\" of the extension it would display the following information:

1. All the SOQL queries along with their execution count.

2. The extension would also display all the Objects (Standard/Custom) on which these SOQL queries are executed.
For ex: If you have got queries that hit the Account object 5 times, you might want to have a relook at the code and optimize the code in a way that you get all the data from the Account object in single SOQL query (instead of querying it 5 times).

- These statistics usually help in debugging the error \"Too Many SOQLs\".
- They would also help you to optimize the performance of your application.

Do recommend the extension with you friends and colleagues if you like it.

Also, if you like the extension, please don't forget to Rate it on the Chrome Extension Webstore.

Currently Working on Future Enhancements:
1. Extracting specific category of statements (debug/approvals etc) from the log file.

Feedback/Suggestions/Ideas/Comments most welcome.

Thanks again and I hope this extension saves your time and makes you more productive!

For any queries: [email protected]
Read more

Source Manifest.json

{"update_url": "https://clients2.google.com/service/update2/crx", "name": "SOQL Extractor and Analyzer for SalesForce", "short_name": "Extract SOQL", "version": "2.0.0.0", "manifest_version": 2, "description": "Extract SOQL queries with their execution counts from Debug Logs of Salesforce. Helps you analyze the 'Too Many SOQLs' error.", "background": { "scripts": ["background.js"], "persistent": false}, "permissions": ["https://*.salesforce.com/","https://*.force.com/*"], "content_scripts": [{ "matches": ["https://*/*","https://*.salesforce.com/*", "https://*.visual.force.com/*", "https://*.lightning.force.com/*"], "js": ["jquery-1.4.2.min.js","content_script.js","CollapsibleLists.compressed.js"], "css" : ["collapse.css"]}],"web_accessible_resources": [ "img/*.png", "content_script.js","jquery-1.4.2.min.js","CollapsibleLists.compressed.js" ], "page_action": { "default_icon": "sfglass19x19.png", "default_popup": "popup.html" }, "icons": { "16": "sfglass16x16.png", "48": "sfglass48x48.png", "128": "sfglass128x128.png" }}
Read more

How to download and manually install SOQL Extractor and Analyzer for SalesForce extension for Chrome

Looking for a way to install SOQL Extractor and Analyzer for SalesForce extensions for Chrome, you can search for them in the Chrome Web Store, clicking the "Add to Chrome" button, and following the straightforward process.

However, you may need to install SOQL Extractor and Analyzer for SalesForce extensions manually, this article outlines two simple methods to effortlessly install SOQL Extractor and Analyzer for SalesForce extensions, whether they come as unpacked folders in compressed formats like .zip or as .crx files.

Method 1: Download SOQL Extractor and Analyzer for SalesForce extension and manually install through Drag &Drop

If you ever need to manually install a SOQL Extractor and Analyzer for SalesForce extension for Chrome, don't worry, it's a simple process. Just follow these easy steps, and you will have your extension ready to use in no time.

Step 1: Download the SOQL Extractor and Analyzer for SalesForce Extension by clicking the "Download CRX" button on the website.

Look for the SOQL Extractor and Analyzer for SalesForce extension you wish to install. Go to the website and download the SOQL Extractor and Analyzer for SalesForce extension package, which is usually a .CRX file and comes in a zipped file. Here ".crx" file is the format for SOQL Extractor and Analyzer for SalesForce extension that contains all the data.

Step 2: Extract &Arrange Files

Once the file is downloaded, extract that file into its own folder. Similarly, give that extension files a permanent home. In other words, keep it in a folder that you don't accidentally delete it because these files will be needed to make that extension work.

Step 3: Go to the Chrome Extensions Page

Open Google Chrome and in the address bar, type chrome://extensions; it will open the Google Chrome extensions page. Make sure that "My extensions" is selected in the sidebar.

Step 4: Drag and Drop the Extension

Now, go to the folder where you extracted the SOQL Extractor and Analyzer for SalesForce extension and drag &drop the extension file from there anywhere onto the extension page within Google Chrome.

Step 5: Complete the Installation

Once you drag and drop the extension file, follow the steps that Google Chrome takes you through. Similarly, if the extension file is of .crx file format, you will be required to review the permissions and then add the extension.

Now, you can manage that added extension as you would like to with any other Chrome extension that you added through Chrome Webstore. Its icon will also appear in the Google Chrome Menu on the right side of the address bar once you activate it.

Method 2: Download SOQL Extractor and Analyzer for SalesForce extension for Chrome and install in Developer Mode

This is another method to install SOQL Extractor and Analyzer for SalesForce extension manually, but the twist is that here, you install by enabling the developer mode option provided in Google Chrome. This mode is commonly used for testing extensions or running unpublished tools.

Step 1: Download the SOQL Extractor and Analyzer for SalesForce extension file

Select and download the SOQL Extractor and Analyzer for SalesForce extension by clicking the 'Download CRX' button on the website.

Step 2: Extract the downloaded contents

Convert the file to a ZIP file if it is in CRX format then extract the SOQL Extractor and Analyzer for SalesForce extension zip file or folder that you downloaded. Make sure you extract it using the same folder name and keep it safely in another folder, so you don't delete it by mistake. The extracted folder will be needed to keep your SOQL Extractor and Analyzer for SalesForce extension running.

Step 3: Open Chrome Extension Setting Page

In the address bar of Google Chrome, type chrome://extensions and open the Chrome Extension Page.

Step 4: Enable Developer Mode

After opening the Chrome Extension page, look at the top right side, and you will find the toggle option of "Developer mode."Simply enable that developer mode option.

Step 5: Load the Unpacked Extension

Once you enable the developer mode option, you will see the menu of Load Unpacked, Pack Extensions and Update. From that, select the option "Load unpacked."

Step 6: Select the Extension Folder

Once the pop-up opens upon clicking Load unpacked, select the SOQL Extractor and Analyzer for SalesForce extension directory and click on the "Select Folder "button.

Step 7: Confirm and Install

After you select an extension folder of a Google Chrome extension you're installing manually, confirm its installation for the final time and let the installation complete.

Conclusion

Here we've made a step-by-step guide on How to manually install SOQL Extractor and Analyzer for SalesForce extension in 2 ways. We hope this guide proves helpful.

Similar Extensions

icon

Lightning Studio Extension · Developer Tools 5,000+ 266 ★ 27.88MiB

icon

Salesforce DevTools Extension · Developer Tools 5,000+ 48 ★ 4.6MiB

icon

Apex Debugger Extension · Developer Tools 5,000+ 30 ★ 881KiB

icon

Salesforce SObject2Apex code generator Extension · Developer Tools 5,000+ 3 ★ 2.17MiB

icon

Salesforce Simplified Extension · Developer Tools 5,000+ 46 ★ 609KiB

icon

Record and Metadata Comparator for Salesforce Extension · Productivity 5,000+ 39 ★ 65.29KiB

icon

Salesforce Enhanced Code Searcher Extension · Developer Tools 5,000+ 21 ★ 1.65MiB

icon

Salesforce Debug Log viewer Extension · Productivity 5,000+ 2 ★ 24.87KiB

icon

Salesforce advanced Code searcher Extension · Developer Tools 5,000+ 183 ★ 21.36MiB

icon

Salesforce Show Api Name Extension · Developer Tools 5,000+ 26 ★ 13.77KiB

icon

Salesforce Colored Favicons Extension · Productivity 5,000+ 97 ★ 13.41KiB

icon

ORGanizer for Salesforce Extension · Developer Tools 5,000+ 244 ★ 1.44MiB

icon

Salesforce Tool Suite Extension · Developer Tools 5,000+ 103 ★ 4.66MiB

icon

Salesforce Lightning Inspector Extension · Developer Tools 5,000+ 48 ★ 8.72MiB

icon

salesforce-tool Extension · Developer Tools 5,000+ 15 ★ 48.0KiB

icon

Salesforce inspector Extension · Developer Tools 5,000+ 330 ★ 422KiB

icon

Salesforce code coverage monitor Extension · Developer Tools 5,000+ 6 ★ 2.83MiB

icon

Salesforce Navigator for Lightning Extension · Productivity 5,000+ 22 ★ 253KiB

icon

SFDC Magic Toolkit Extension · Developer Tools 5,000+ 16 ★ 170KiB

icon

Salesforce Inspector Reloaded Extension · Developer Tools 5,000+ 153 ★ 1.01MiB

icon

Salesforce Change Set Helper Extension · Productivity 5,000+ 59 ★ 1.51MiB

icon

Salesforce Data/Metadata Utility Extension · Productivity 5,000+ 10 ★ 50.11KiB

icon

Org Header for Salesforce® Extension · Developer Tools 5,000+ 15 ★ 14.58KiB

icon

Boostr for Salesforce Extension · Productivity 5,000+ 34 ★ 1.17MiB

User reviews

icon

Chinmaya Rath (ID: 0000001fb9282c0d) Voted 4 ★ - Updated 08/10/2023 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

icon

Amol Joshi (ID: 000000116782579c) Voted 5 ★ - Updated 10/11/2017 Great extension. Very much helpful in troubleshooting 101 soql error. Thank you.

icon

Jyoti Singh (ID: 0000003fc3b3b2f2) Voted 5 ★ - Updated 03/21/2016 Very useful for 101 SOQL issue..

icon

Tejas Kapasi (ID: 0000009fe19040d7) Voted 5 ★ - Updated 04/19/2015 very cool and useful. It really saves a time. Thank you!

icon

mausam padhiyar (ID: 0000001b161935ee) Voted 5 ★ - Updated 11/11/2014 Amazing..! Makes life easier while debugging. :)