Tetap teratur dengan koleksi
Simpan dan kategorikan konten berdasarkan preferensi Anda.
Memantau reservasi BigQuery
Sebagai administrator BigQuery, Anda dapat memantau reservasi di project dengan melihat penggunaan slot reservasi dan project, serta melihat tagihan berdasarkan kapasitas.
Melihat penggunaan slot reservasi dan project
Anda dapat melihat penggunaan slot reservasi dan project dengan cara berikut:
Tampilan INFORMATION_SCHEMA. Untuk mengambil informasi penggunaan project dan reservasi, buat kueri tampilan INFORMATION_SCHEMA.JOBS*.
Kolom reservation_id dalam tampilan INFORMATION_SCHEMA.JOBS* berisi nama reservasi.
Google Cloud console. Google Cloud console menyertakan diagram yang menampilkan penggunaan slot. Untuk informasi selengkapnya, lihat Menggunakan diagram resource
administratif.
Log audit. Gunakan log audit untuk melihat metrik tentang penggunaan slot.
Metode Jobs. Gunakan metode API Jobs
untuk melihat metrik tentang penggunaan slot untuk tugas.
Cloud Monitoring. Anda dapat menggunakan Cloud Monitoring untuk membuat dasbor guna memantau slot yang dialokasikan. Dengan dasbor Cloud Monitoring, Anda dapat melihat penggunaan slot untuk setiap reservasi dan setiap jenis tugas, di semua project dalam reservasi. Untuk informasi selengkapnya tentang metrik yang tersedia untuk dasbor Cloud Monitoring, lihat Metrik yang tersedia untuk visualisasi.
Melihat tagihan berbasis kapasitas
Untuk melihat tagihan berbasis kapasitas secara real time, ikuti langkah-langkah berikut:
Pilih project akun penagihan yang tagihannya ingin Anda lihat.
Buka bagian Laporan, lalu di bagian Filter, lakukan hal berikut:
Dari daftar Layanan, pilih BigQuery, lalu pilih semua yang
berlaku.
Pilih Semua SKU dari daftar SKU.
Atribusi biaya reservasi
Dengan fitur ini, Anda dapat mengatribusikan biaya reservasi kembali ke penggunaan kueri tertentu di seluruh project yang menggunakan reservasi. Hal ini menghasilkan biaya bersih yang lebih akurat untuk setiap basis proyek.
Semua pelanggan BigQuery Reservations API memiliki item baris "Atribusi Slot Analisis" di data Penagihan Cloud mereka. Item baris ini disertakan di halaman Penagihan dan dalam ekspor Penagihan Cloud.
Item baris ini menunjukkan jam slot yang digunakan per project. Hal ini tidak dikenai biaya dan tidak
memengaruhi total invoice Anda.
Log audit
Membuat, menghapus, dan memperbarui resource yang terkait dengan reservasi BigQuery dicatat dalam log audit pemilik project.
Untuk informasi selengkapnya, lihat Log audit.
[[["Mudah dipahami","easyToUnderstand","thumb-up"],["Memecahkan masalah saya","solvedMyProblem","thumb-up"],["Lainnya","otherUp","thumb-up"]],[["Sulit dipahami","hardToUnderstand","thumb-down"],["Informasi atau kode contoh salah","incorrectInformationOrSampleCode","thumb-down"],["Informasi/contoh yang saya butuhkan tidak ada","missingTheInformationSamplesINeed","thumb-down"],["Masalah terjemahan","translationIssue","thumb-down"],["Lainnya","otherDown","thumb-down"]],["Terakhir diperbarui pada 2025-08-17 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)."]]
