Commits

Branch selector

 main

User selector

All users

Datepicker

All time

Commit History

Commits on Oct 31, 2025

• Update project_per_table_storage_model_recommendations.sql

  Show description for 6351a0a
  sayle-doit

  authored
  6351a0a

  Copy full SHA for 6351a0a

• Clarify table type filtering in SQL query

  Show description for 9eb51d4
  sayle-doit

  authored
  9eb51d4

  Copy full SHA for 9eb51d4

Commits on Oct 15, 2025

• Added a new query that will find tables referenced by jobs over an interval.

  Show description for d169738
  sayle-doit

  committed
  d169738

  Copy full SHA for d169738

Commits on Oct 7, 2025

• Merge branch 'main' of https://github.com/doitintl/bigquery-optimization-queries

  sayle-doit

  committed
  17f1a2f

  Copy full SHA for 17f1a2f

• Added a new SQL script to track table usage and costs per day.

  sayle-doit

  committed
  67b88ed

  Copy full SHA for 67b88ed

Commits on Oct 6, 2025

• Update general_job_information.sql

  Show description for efe2a73
  sayle-doit

  authored
  efe2a73

  Copy full SHA for efe2a73

Commits on Sep 25, 2025

• Update queries_and_reservation_usage_per_second.sql

  Show description for bc0f0c9
  sayle-doit

  authored
  bc0f0c9

  Copy full SHA for bc0f0c9

Commits on Sep 22, 2025

• Added an additional note about the jobs by orginization view.

  sayle-doit

  committed
  6fe809c

  Copy full SHA for 6fe809c

• Added billing data to the query.

  sayle-doit

  committed
  1ef5247

  Copy full SHA for 1ef5247

• Added some clarifications about the data retention and the jobs field.

  sayle-doit

  committed
  0bc7464

  Copy full SHA for 0bc7464

• Merge branch 'main' of https://github.com/doitintl/bigquery-optimization-queries

  sayle-doit

  committed
  bdcc925

  Copy full SHA for bdcc925

• Added a query that will show the queries running and the reservation usage per second over a time interval.

  sayle-doit

  committed
  dea15c2

  Copy full SHA for dea15c2

• Update autoscale_usage_and_costs_per_second.sql

  Show description for 3741677
  sayle-doit

  authored
  3741677

  Copy full SHA for 3741677

Commits on Sep 17, 2025

• Update top_billed_queries_deduplicated.sql

  Show description for 79e672d
  sayle-doit

  authored
  79e672d

  Copy full SHA for 79e672d

• Added autoscale_usage_and_costs_per_second.sql query which provides per-second autoscale usage and cost data from the INFORMATION_SCHEMA.RESERVATIONS_TIMELINE view.

  sayle-doit

  committed
  19dac7c

  Copy full SHA for 19dac7c

Commits on Aug 11, 2025

• Update project_storage_model_recommendation.sql

  Show description for f25ac55
  sayle-doit

  authored
  f25ac55

  Copy full SHA for f25ac55

Commits on Jul 29, 2025

• Update project_storage_model_recommendation.sql

  Show description for 31ca47d
  sayle-doit

  authored
  31ca47d

  Copy full SHA for 31ca47d

• Update billing_recommendation_per_query.sql

  Show description for a727243
  sayle-doit

  authored
  a727243

  Copy full SHA for a727243

Commits on Jun 10, 2025

• took the billing_recommendation_per_query query and stripped out the recommendations so we can just get the proper billing data

  

  Mike Royle

  authored and

  Mike Royle

  committed
  76c010a

  Copy full SHA for 76c010a

Commits on Jun 9, 2025

• updated the query to actually multiply by number of slots when calculating the slot-hours

  

  Mike Royle

  authored and

  Mike Royle

  committed
  5921a6f

  Copy full SHA for 5921a6f

• took the billing_recommendation_per_query query and modified it to look across all queries for the last 30 days and make a recommendation

  

  Mike Royle

  authored and

  Mike Royle

  committed
  0a1557c

  Copy full SHA for 0a1557c

Commits on Oct 30, 2024

• Update billing_model_cost_estimation.sql

  Show description for 3091ecb
  sayle-doit

  authored
  3091ecb

  Copy full SHA for 3091ecb

Commits on Sep 11, 2024

• Update load_slots_per_minute.sql

  Show description for a7ccf03
  sayle-doit

  authored
  a7ccf03

  Copy full SHA for a7ccf03

Commits on Aug 7, 2024

• Updated logic and cleaned up SQL to be less confusing.

  Show description for bf146c6
  sayle-doit

  committed
  bf146c6

  Copy full SHA for bf146c6

Commits on Jul 19, 2024

• Updated with a note about why the billing storage model may be incorrect

  Show description for 12ed616
  sayle-doit

  committed
  12ed616

  Copy full SHA for 12ed616

• Updated to pull the current storage billing model and factor this into

  Show description for c013f97
  sayle-doit

  committed
  c013f97

  Copy full SHA for c013f97

Commits on Jul 8, 2024

• Updated to also spit out a query the user can run to convert recommended datasets

  Show description for 5b70739
  sayle-doit

  committed
  5b70739

  Copy full SHA for 5b70739

Commits on Jul 1, 2024

• Added a query to show all projects running jobs,

  Show description for 275f99d
  sayle-doit

  committed
  275f99d

  Copy full SHA for 275f99d

Commits on Jun 17, 2024

• Updated the slots_by_* queries to utilize the timeline_jobs view since this

  Show description for 1ed00a7
  sayle-doit

  committed
  1ed00a7

  Copy full SHA for 1ed00a7

Commits on May 22, 2024

• Update project_storage_model_recommendation.sql

  Show description for 154271d
  sayle-doit

  authored
  154271d

  Copy full SHA for 154271d

Commits on Apr 29, 2024

• Added additional SQL queries for determining physical storage pricing suggestions. One does at the dataset level and the other at the table level.

  sayle-doit

  committed
  b225de7

  Copy full SHA for b225de7

• Update top_billed_labels.sql

  Show description for 4eb02b9
  sayle-doit

  authored
  4eb02b9

  Copy full SHA for 4eb02b9

• Update query_job_information.sql

  Show description for 4049184
  sayle-doit

  authored
  4049184

  Copy full SHA for 4049184

• Update top_cost_users.sql

  Show description for 7e452ee
  sayle-doit

  authored
  7e452ee

  Copy full SHA for 7e452ee

Commits on Apr 26, 2024

• Update top_billed_queries.sql

  Show description for bcf4672
  sayle-doit

  authored
  bcf4672

  Copy full SHA for bcf4672

Pagination

Previous

Next