Cost Saving Report
Warehouse Availability
Cost savings reports are currently only available for BigQuery connectors. Snowflake reports are coming soon!
Cost-saving plans estimate the savings you can achieve by utilizing pre-calculated versions of your metrics. You can generate a cost savings report for a query audit group with common computation logic: if there is no common computation for a group, you cannot generate a cost savings plan for that group. Perform this action by choosing the "Generate Cost Saving Plan" action on an audit group's detail page.
Run Options
We create a temporary table based on the common computation logic when you generate a cost-saving report. If you choose the "dry run" option, then:
- we perform a dry run of the original queries in the group that match the common logic
- we perform a dry run of the same queries rewritten to use the common logic (temporary table)
- we then compare the performance of the rewritten queries to the original queries
If you choose the "real run" option, then:
- we run the original queries in the group that match the common logic
- we run the same queries rewritten to use the common logic (temporary table)
- we then compare the performance of the rewritten queries to the original queries
Dry run or real run?
A dry run is cheaper in BigQuery since you are not charged for performing a dry run; however, a dry run can only estimates the number of bytes read by the query. Other statistics like query duration are not available
Cost Saving Results
The way to read a row in the "Rewritten queries" table is the following:
- For the query with index 123 in the query collection that was audited:
- the Duration of the original query was 248 ms
- the Duration of the rewritten query was 222 ms
- the rewritten query was 222 - 248 = -26 ms faster, so the duration of the rewritten query is 11% faster than the duration of the original query
- Processed Bytes and Output Rows are interpreted in the same way as Duration:
- the original query output 4 rows
- the rewritten query output 4 rows
- the rewritten query output 4 - 4 = 0 additional rows, for a change of 0%
The "Savings Summary" stats take the max (average) across the values in each row. For example, if one row has (-10%) and one row has (-6%), then the average across the two rows is -8%. Note that changes between the original and rewritten queries can be noisy for small queries (short duration or few processed bytes).
BigQuery FAQ
- Temporary tables are stored in a
singleorigin
schema that we create in the project you have connected to. - When you perform a "dry run" report, we will only surface the Processed Bytes stat provided by BigQuery - not all stats are available since queries are not executed.
Updated 10 days ago