Sebagai administrator BigQuery, Anda dapat menggunakan penjelajah tugas administratif untuk membantu Anda memantau aktivitas tugas di seluruh organisasi. Penjelajah tugas juga menyediakan berbagai filter dan opsi pengurutan untuk memecahkan masalah dan mengidentifikasi tugas yang bermasalah.
Penjelajah tugas menghilangkan kebutuhan Anda untuk memiliki pemahaman mendalam tentang INFORMATION_SCHEMA, dan memungkinkan Anda melihat informasi tugas dengan cepat seperti pemilik, project, penggunaan slot, durasi, dan lainnya, tanpa perlu menulis kueri INFORMATION_SCHEMA.
BigQuery memberikan detail dan insight tugas melalui tampilan INFORMATION_SCHEMA berikut:
Untuk mendapatkan izin yang
diperlukan untuk menggunakan penjelajah tugas administratif,
minta administrator Anda untuk memberi Anda
peran IAM BigQuery Resource Viewer (roles/bigquery.resourceViewer)
di organisasi atau project Anda.
Untuk mengetahui informasi selengkapnya tentang cara memberikan peran, lihat Mengelola akses ke project, folder, dan organisasi.
Peran bawaan ini berisi
izin yang diperlukan untuk menggunakan penjelajah tugas administratif. Untuk melihat izin yang benar-benar diperlukan, luaskan bagian Izin yang diperlukan:
Izin yang diperlukan
Izin berikut diperlukan untuk menggunakan penjelajah tugas administratif:
Untuk melihat data di tingkat project:
bigquery.jobs.listAll
di project
Untuk melihat data di tingkat organisasi:
bigquery.jobs.listAll
di organisasi
Untuk memfilter menurut reservasi di organisasi Anda:
bigquery.reservations.list
di organisasi
Dari daftar Lokasi, pilih lokasi tempat Anda ingin melihat
tugas.
Terapkan Filter opsional sesuai kebutuhan:
Cakupan tugas. Seperti project saat ini, organisasi, dan pekerjaan Anda.
Status. Seperti selesai, error, aktif, dan dalam antrean.
Prioritas tugas. Seperti tugas interaktif atau batch.
ID Tugas.
Pemilik. ID email pemilik tugas (hanya berlaku jika cakupan tugas adalah project atau organisasi).
Project ID. (Hanya berlaku jika cakupan tugas adalah organisasi)
ID Reservasi. (Hanya berlaku jika cakupan tugas adalah organisasi)
Waktu slot lebih dari. Tugas yang memerlukan waktu lebih lama daripada waktu slot yang ditentukan.
Durasi lebih dari. Tugas yang memerlukan waktu lebih lama dari durasi yang ditentukan.
Byte yang diproses lebih dari. Tugas yang memproses lebih banyak byte daripada byte diproses yang ditentukan.
Insight Kueri. Jenis query insights, seperti pertentangan slot,
kapasitas shuffle memori terlampaui, dan perubahan skala input data.
Hash Kueri. Hash kueri berisi hash dari kueri. Ini adalah hash STRING heksadesimal
yang mengabaikan komentar, nilai parameter, UDF, dan literal.
GoogleSQL yang berhasil dan tidak ditemukan dalam cache.
Label. Pasangan key:value yang dapat ditetapkan ke tugas. Anda dapat memfilter menggunakan kombinasi kunci, nilai, atau key:value.
Kategori pekerjaan. Jenis kueri, seperti Standar atau Kueri berkelanjutan.
Melihat detail eksekusi kueri
Untuk melihat detail eksekusi kueri tugas, lakukan hal berikut:
Penjelajah tugas tersedia tanpa biaya
tambahan. Kueri yang digunakan untuk mengisi diagram ini tidak ditagih dan tidak menggunakan slot di
pemesanan milik pengguna. Waktu kueri yang memproses terlalu banyak data akan habis.
[[["Mudah dipahami","easyToUnderstand","thumb-up"],["Memecahkan masalah saya","solvedMyProblem","thumb-up"],["Lainnya","otherUp","thumb-up"]],[["Informasi yang saya butuhkan tidak ada","missingTheInformationINeed","thumb-down"],["Terlalu rumit/langkahnya terlalu banyak","tooComplicatedTooManySteps","thumb-down"],["Sudah usang","outOfDate","thumb-down"],["Masalah terjemahan","translationIssue","thumb-down"],["Masalah kode / contoh","samplesCodeIssue","thumb-down"],["Lainnya","otherDown","thumb-down"]],["Terakhir diperbarui pada 2025-08-17 UTC."],[[["\u003cp\u003eThe administrative jobs explorer in BigQuery allows administrators to monitor job activity across their organization without needing to write complex \u003ccode\u003eINFORMATION_SCHEMA\u003c/code\u003e queries.\u003c/p\u003e\n"],["\u003cp\u003eUsers can filter jobs by various criteria, including job scope, status, priority, owner, project ID, reservation ID, slot time, duration, bytes processed, query insights, query hash, and labels.\u003c/p\u003e\n"],["\u003cp\u003eTo utilize the administrative jobs explorer, users require the \u003ccode\u003eroles/bigquery.resourceViewer\u003c/code\u003e IAM role and specific permissions like \u003ccode\u003ebigquery.jobs.listAll\u003c/code\u003e and \u003ccode\u003ebigquery.reservations.list\u003c/code\u003e depending on the level of access needed.\u003c/p\u003e\n"],["\u003cp\u003eJobs explorer is offered at no additional cost, and the queries that populate the charts neither use slots in user-owned reservations nor incur billing charges.\u003c/p\u003e\n"],["\u003cp\u003eUsers can access detailed query execution information through the "Execution graph" tab after filtering and selecting a specific job within the Jobs explorer interface.\u003c/p\u003e\n"]]],[],null,["# Use administrative jobs explorer\n================================\n\nAs a BigQuery administrator, you can use the administrative jobs explorer to help you monitor jobs activity across your organization. Jobs explorer also provides an array of filters and sorting options to troubleshoot and identify problematic jobs.\nJobs explorer removes the need for you to have a deep understanding of `INFORMATION_SCHEMA`, and lets you quickly view job information such as owner, project, slot usage, duration, and more, without the need to write `INFORMATION_SCHEMA` queries.\n\nBigQuery provides job details and insights through the following `INFORMATION_SCHEMA` views:\n\n- [`INFORMATION_SCHEMA.JOBS_BY_PROJECT`](/bigquery/docs/information-schema-jobs)\n- [`INFORMATION_SCHEMA.JOBS_BY_ORGANIZATION`](/bigquery/docs/information-schema-jobs-by-organization)\n- [`INFORMATION_SCHEMA.JOBS_BY_USER`](/bigquery/docs/information-schema-jobs-by-user)\n\n| **Note:** If you use organization restrictions, see [Enable access to Google-owned resources](/resource-manager/docs/organization-restrictions/additional-considerations#google-owned-resources).\n\n### Required roles\n\n\nTo get the permissions that\nyou need to use administrative jobs explorer,\n\nask your administrator to grant you the\n\n\n[BigQuery Resource Viewer](/iam/docs/roles-permissions/bigquery#bigquery.resourceViewer) (`roles/bigquery.resourceViewer`)\nIAM role on your organization or project.\n\n\nFor more information about granting roles, see [Manage access to projects, folders, and organizations](/iam/docs/granting-changing-revoking-access).\n\n\nThis predefined role contains\n\nthe permissions required to use administrative jobs explorer. To see the exact permissions that are\nrequired, expand the **Required permissions** section:\n\n\n#### Required permissions\n\nThe following permissions are required to use administrative jobs explorer:\n\n- To see data at project level: ` bigquery.jobs.listAll` on the project\n- To see data at organization level: ` bigquery.jobs.listAll` on the organization\n- To filter by reservations in your organization: ` bigquery.reservations.list` on the organization\n\n\nYou might also be able to get\nthese permissions\nwith [custom roles](/iam/docs/creating-custom-roles) or\nother [predefined roles](/iam/docs/roles-overview#predefined).\n| **Note:** This organization view is only available if you have defined Google Cloud organizations.\n\n### Filter jobs\n\nTo filter jobs for queries that are contained in the\n`INFORMATION_SCHEMA.JOBS*` views, do the following:\n\n1. In the Google Cloud console, go to the **BigQuery** page.\n\n [Go to BigQuery](https://console.cloud.google.com/bigquery)\n2. In the navigation menu, click **Jobs explorer**.\n\n3. From the **Location** list, select the location for which you want to view the\n jobs.\n\n4. Apply optional **Filters** as needed:\n\n - **Job scope**. Such as the current project, organization, and your jobs.\n - **Status**. Such as completed, error, active, and queued.\n - **Job priority**. Such as interactive or batch jobs.\n - **Job ID**.\n - **Owner**. Email ID of the job's owner (only applicable when job scope is project or organization).\n - **Project ID**. (Only applicable when job scope is organization)\n - **Reservation ID**. (Only applicable when job scope is organization)\n - **Slot time more than**. Jobs that took more time than the specified slot time.\n - **Duration more than**. Jobs that took longer than the specified duration.\n - **Bytes processed more than**. Jobs that processed more bytes than the specified processed bytes.\n - **Query Insights**. Types of query insights, such as slot contention, memory shuffle capacity exceeded, and data input scale change.\n - **Query Hash** . Query hash contains the hashes of the query. It is a hexadecimal STRING hash that ignores comments, parameter values, UDFs, and literals. This field appears for successful [GoogleSQL](/bigquery/docs/reference/standard-sql/query-syntax) queries that are not cache hits.\n - **Labels** . `key:value` pairs that can be assigned to a job. You can filter using a key, value, or `key:value` combination.\n - **Job category** . The type of query, such as **Standard** or **Continuous query**.\n\n### View query execution details\n\nTo view query execution details of jobs, do the following:\n\n1. Go to the **Jobs explorer** page.\n\n [Go to Jobs explorer](https://console.cloud.google.com/bigquery/admin/jobs-explorer)\n2. To view jobs, click **Jobs explorer**.\n\n3. [Filter jobs](#filter-jobs) to view limited jobs.\n\n4. Click a job for which you want to view the query execution details.\n\n5. In the **Query results** pane, click the **Execution graph** tab to see the execution details of your job.\n\nFor information about how to interpret insights, see\n[Interpret query performance insights](/bigquery/docs/query-insights#interpret_query_performance_insights).\n\nPricing\n-------\n\nJobs explorer is available at no additional\ncost. Queries that are used to populate these charts aren't billed and don't use slots in\nuser-owned reservations. Queries that process too much data are timed out.\n\nWhat's next\n-----------\n\n- Learn about [reservations](/bigquery/docs/reservations-intro).\n- Learn about [purchasing slots](/bigquery/docs/reservations-commitments).\n- Learn how to [estimate slot capacity requirements](/bigquery/docs/slot-estimator).\n- Learn how to [view slot recommendations and insights](/bigquery/docs/slot-recommender)."]]
