Retrieve Query Plans

Use the Query Plan tool to view, optimize, and speed up SOQL queries on large datasets.

You can retrieve a query plan for a query by using one of these methods. The query plan shows all the query operations and the cost of each. The output pane shows all the available notes for your highest ranked query plan, which is the query plan currently in use.

  • Open a query in the SOQL query builder and click Get Query Plan.

    Query plan shows in the SOQL Query Builder

  • Open a query in the text editor and select SFDX: Get SOQL Query Plan with Current File from the Command Palette.