Stay organized with collections
Save and categorize content based on your preferences.
Monitor BigQuery reservations
As a BigQuery administrator, you can monitor reservations in your
project by viewing the project and reservation slot usage and also view
your capacity-based bill.
View project and reservation slot usage
You can view the project and reservation slot usage in the following ways:
INFORMATION_SCHEMA views. To retrieve project and reservation usage
information, query the INFORMATION_SCHEMA.JOBS* views.
The reservation_id field
in the INFORMATION_SCHEMA.JOBS* views contains the reservation name.
Google Cloud console. The Google Cloud console includes charts that
display slot usage. For more information, see Use administrative
resource charts.
Audit logs. Use audit logs to
view metrics about slot usage.
The Jobs method. Use the Jobs API method
to view metrics about slot usage for a job.
Cloud Monitoring. You can use Cloud Monitoring to create dashboards to monitor your allocated slots. With a Cloud Monitoring dashboard, you can view your slot usage for each reservation and for each job type, across all projects within the reservation. For more information about the metrics available for the Cloud Monitoring dashboard, see Metrics available for visualization.
View your capacity-based bill
To view your capacity-based bill in real time, follow these steps:
In the Google Cloud console, go to the Billing page.
Select the billing account project for which you want to view the bill.
Navigate to the Reports section and then in the Filters section, do
the following:
From the Services list, select BigQuery and select all that's
applicable.
Select All SKUs from the SKUs list.
Reservation cost attribution
This feature lets you attribute reservation fees back to the specific query
usage across any projects that used the reservation. This results in more
accurate net costs for each project basis.
All BigQuery Reservations API
customers have an "Analysis Slots Attribution" line item in their
Cloud Billing data. This line item is included on the Billing page
and in the Cloud Billing export.
This line item shows slot hours used per project. It incurs no cost and doesn't
affect your invoice totals.
Audit logs
Creating, deleting, and updating resources related to
BigQuery reservations are
recorded in the project owner's audit logs.
For more information, see Audit log.
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-08-25 UTC."],[[["\u003cp\u003eBigQuery administrators can monitor project and reservation slot usage through \u003ccode\u003eINFORMATION_SCHEMA\u003c/code\u003e views, the Google Cloud console, audit logs, the \u003ccode\u003eJobs\u003c/code\u003e API method, and Cloud Monitoring.\u003c/p\u003e\n"],["\u003cp\u003eYou can view your real-time capacity-based bill in the Google Cloud console's Billing page by filtering for BigQuery services and SKUs.\u003c/p\u003e\n"],["\u003cp\u003eBigQuery's "Analysis Slots Attribution" feature provides a breakdown of reserved slot usage across projects in Cloud Billing data without affecting invoice totals.\u003c/p\u003e\n"],["\u003cp\u003eAudit logs record the creation, deletion, and updates of BigQuery reservation resources, providing a detailed history of changes.\u003c/p\u003e\n"],["\u003cp\u003eThe amount of slots that are in use might appear to be higher than the reservation slot count due to how BigQuery provisions resources, however, users will not be charged for the slots that go beyond their reservation slot count.\u003c/p\u003e\n"]]],[],null,["# Monitor BigQuery reservations\n=============================\n\nAs a BigQuery administrator, you can monitor reservations in your\nproject by viewing the project and reservation slot usage and also view\nyour capacity-based bill.\n\nView project and reservation slot usage\n---------------------------------------\n\nYou can view the project and reservation slot usage in the following ways:\n\n- **`INFORMATION_SCHEMA` views.** To retrieve project and reservation usage\n information, query the [`INFORMATION_SCHEMA.JOBS*` views](/bigquery/docs/information-schema-jobs#examples).\n\n The [`reservation_id`](/bigquery/docs/information-schema-jobs#schema) field\n in the `INFORMATION_SCHEMA.JOBS*` views contains the reservation name.\n- **Google Cloud console.** The Google Cloud console includes charts that\n display slot usage. For more information, see [Use administrative\n resource charts](/bigquery/docs/admin-resource-charts).\n\n- **Audit logs.** Use [audit logs](/bigquery/docs/reference/auditlogs) to\n view metrics about slot usage.\n\n- **The `Jobs` method.** Use the [`Jobs` API method](/bigquery/docs/reference/rest/v2/jobs)\n to view metrics about slot usage for a job.\n\n- **Cloud Monitoring.** You can use [Cloud Monitoring](/bigquery/docs/monitoring-dashboard) to create dashboards to monitor your allocated slots. With a Cloud Monitoring dashboard, you can view your slot usage for each reservation and for each job type, across all projects within the reservation. For more information about the metrics available for the Cloud Monitoring dashboard, see [Metrics available for visualization](/bigquery/docs/monitoring-dashboard#metrics).\n\n| **Note:** The number of slots in use might appear higher than your reservation slot count because of how BigQuery provisions resources to reservations. You are not charged for slots beyond your reservation slot count.\n\nView your capacity-based bill\n-----------------------------\n\nTo view your capacity-based bill in real time, follow these steps:\n\n1. In the Google Cloud console, go to the **Billing** page.\n\n [Go to **Billing**](https://console.cloud.google.com/billing).\n2. Select the billing account project for which you want to view the bill.\n\n3. Navigate to the **Reports** section and then in the **Filters** section, do\n the following:\n\n 1. From the **Services** list, select **BigQuery** and select all that's applicable.\n 2. Select **All SKUs** from the **SKUs** list.\n\n| **Note:** BigQuery annual and three-year commitments are priced by months. Your bill doesn't change due to variability in the month length. If your slot usage remains unchanged, the rate remains the same every month.\n\nReservation cost attribution\n----------------------------\n\nThis feature lets you attribute reservation fees back to the specific query\nusage across any projects that used the reservation. This results in more\naccurate net costs for each project basis.\n\nAll [BigQuery Reservations API](/bigquery/docs/reservations-commitments#enabling-reservations-api)\ncustomers have an **\"Analysis Slots Attribution\"** line item in their\nCloud Billing data. This line item is included on the **Billing** page\nand in the Cloud Billing export.\n\nThis line item shows slot hours used per project. It incurs no cost and doesn't\naffect your invoice totals.\n\nAudit logs\n----------\n\nCreating, deleting, and updating resources related to\n[BigQuery reservations](/bigquery/docs/reservations-concepts) are\nrecorded in the project owner's audit logs.\nFor more information, see [Audit log](/bigquery/docs/reference/auditlogs#auditlog_format).\n\nWhat's next\n-----------\n\n- Learn about [capacity commitment plans](/bigquery/docs/reservations-workload-management#slot_commitments).\n- Learn how to [use administrative resource charts](/bigquery/docs/admin-resource-charts).\n- Learn about [BigQuery pricing](/bigquery/pricing)."]]
