Skip to main content

SOQL

Features​

SF Explorer allows you to browse your org model with SOQL queries with the following features:

  • ability to chain queries
  • autocompletion
  • sorting
  • pivoting
  • ability to run accross multiple orgs
  • compare results
  • query analysis

Query Analysis​

/** @explain */
Select Name, Type, AnnualRevenue, BillingCity from Account limit 3
{
  "plans": [
    {
      "cardinality": 1839,
      "fields": [],
      "leadingOperationType": "TableScan",
      "notes": [
        {
          "description": "Not considering filter for optimization because unindexed",
          "fields": [
            "IsDeleted"
          ],
          "tableEnumOrId": "Account"
        }
      ],
      "relativeCost": 2.8321557971014495,
      "sobjectCardinality": 1841,
      "sobjectType": "Account"
    }
  ],
  "sourceQuery": "Select Name, Type, AnnualRevenue, BillingCity from Account limit 3"
}

Demo​

Here is a quick demo: