Menu
Is there any way out to get query execution plans in big query and it's performance analysis.
752
Viewing information with the Google Cloud console In the Google Cloud console, you can see details of the query plan for a completed query by clicking the Execution Details button (near the Results button).
Using the SHOWPLAN command Besides the graphical query plans, we can obtain the execution plans in text or XML format with help of the SET SHOWPLAN command.
To display the estimated execution plan for a queryOn the Query menu, click Display Estimated Execution Plan or click the Display Estimated Execution Plan toolbar button. The estimated execution plan is displayed on the Execution Plan tab in the results pane.
To understand BigQuery tuning, we first need to be fluent in reading BigQuery execution plans. In the UI, the execution plan can be found under the query window by clicking “execution details.” A more detailed execution plan is available through the API, but we'll focus our discussion on the Web UI.
BigQuery now has a query explanation built into the web UI. This is what I think you're after.
92
UPDATE 2021
This is possible now. From CLI:
$ bq show -j --format=prettyjson FULL_JOB_ID
API Call:
GET https://bigquery.googleapis.com/bigquery/v2/projects/{projectId}/jobs/{jobId}
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
