Clientell AI

Find Slow Queries Fast

Use Cases:

  • Quickly spot flows or Apex causing slow queries over 5 seconds in the last day.
  • Pinpoint exact automations or code to optimize for faster Salesforce performance.
  • Identify inefficient queries to improve selectivity and reduce execution time.
  • Use this data to prevent hitting governor limits by fixing costly queries early.
TroubleshootConsultant

Prompt

Identify queries in the last 24 h whose execution time > 5 s and list caller (flow, apex).

Related use cases

~1 min

Update a Picklist Instantly

Add or remove values without touching Setup.

“Add the value Pilot and deactivate Proof of Concept in the picklist Opportunity_Type__c.”

Opportunity_Type__cPicklist
New BusinessActive
ExpansionActive
+Pilot
New
Proof of ConceptDeactivated
RenewalActive
1 added · 1 deactivated

Create a Formula Field

Describe the math in English. Skip the syntax.

“Create a formula field Margin_Percent__c on Opportunity: (Amount – Cost__c) / Amount.”

f
Formula Field
Percent
API Name
Margin_Percent__c
(Amount - Cost__c) / Amount
Syntax valid
Object: Opportunity

Debug a Salesforce Error

Paste an error. Get the root cause in seconds.

“Apex error ‘FIELD_CUSTOM_VALIDATION_EXCEPTION’ on saving Opportunity — identify which validation rule fired and why.”

FIELD_CUSTOM_VALIDATION_EXCEPTION
Object: Opportunity
Action: Save record
Root Cause
Rule: Require_Amount
Amount must be > 0 when Stage ≠ Prospecting
Set Amount > 0 or change Stage to Prospecting
1 validation rule identified

Related Salesforce Errors

Query Exception

QUERY_EXCEPTION

Governor Limit Exceeded

GOVERNOR_LIMIT_EXCEEDED

Related How-To Guides

How to Optimize Slow Queries in Salesforce

Learn how to identify and fix slow-running queries that impact performance and may hit governor limits.