Como administrador do BigQuery, você pode usar a Análise de jobs administrativos para monitorar a atividade de jobs na sua organização. O explorador de jobs também oferece uma variedade de opções de filtros e classificação para solucionar problemas e identificar jobs problemáticos.
Com o explorador de jobs, você não precisa mais ter um conhecimento profundo de INFORMATION_SCHEMA e visualiza rapidamente informações do job, como proprietário, projeto, uso de slot, duração, entre outras, sem a necessidade de criar consultas de INFORMATION_SCHEMA.
O BigQuery fornece detalhes e insights de jobs pelas seguintes visualizações INFORMATION_SCHEMA:
Esse papel predefinido contém
as permissões necessárias para usar o explorador de jobs administrativos. Para conferir as permissões exatas
necessárias, expanda a seção Permissões necessárias:
Permissões necessárias
As seguintes permissões são necessárias para usar o explorador de jobs administrativos:
Para conferir dados no nível do projeto:
bigquery.jobs.listAll
no projeto
Para ver os dados no nível da organização:
bigquery.jobs.listAll
na organização
Para filtrar por reservas na sua organização:
bigquery.reservations.list
na organização
No painel de navegação, selecione Administração > Análise de jobs.
Na lista Local, selecione o local onde você quer visualizar os
jobs.
Aplique Filtros opcionais conforme necessário:
Escopo do job. Como o projeto atual, a organização e seus jobs.
Status. como "Concluído", "Erro", "Ativo" e "Na fila".
Prioridade de job. como jobs interativos ou em lote.
ID do job.
Proprietário. ID de e-mail do proprietário do trabalho (aplicável apenas quando o escopo do trabalho é projeto ou organização).
ID do projeto. (Aplicável apenas quando o escopo do trabalho é organização)
ID da reserva. (Aplicável apenas quando o escopo do trabalho é organização)
Tempo do slot maior que. Os jobs que levaram mais tempo do que o horário de slot especificado.
Duração superior a. Jobs que levaram mais tempo do que a duração especificada.
Bytes processados acima de. Jobs que processaram mais bytes do que os bytes processados especificados.
Query Insights. Tipos de insights de consulta, como contenção de slot,
capacidade de embaralhamento de memória excedida e mudança na escala de entrada de dados.
Hash de consulta. O hash de consulta contém os hashes da consulta. É um hash STRING hexadecimal que ignora comentários, valores de parâmetros, UDFs e literais.
Esse campo aparece para consultas bem-sucedidas do GoogleSQL que não são ocorrências em cache.
Rótulos. Pares de key:value que podem ser atribuídos a um job. É possível filtrar usando uma chave, um valor ou uma combinação de key:value.
Mais detalhes da execução da consulta
Para visualizar os detalhes da execução da consulta dos jobs, faça o seguinte:
O Jobs Explorer está disponível
sem custo adicional. As consultas usadas para preencher esses gráficos não são faturadas e não usam slots em reservas de usuários. As consultas que processam muitos dados expiram.
[[["Fácil de entender","easyToUnderstand","thumb-up"],["Meu problema foi resolvido","solvedMyProblem","thumb-up"],["Outro","otherUp","thumb-up"]],[["Não contém as informações de que eu preciso","missingTheInformationINeed","thumb-down"],["Muito complicado / etapas demais","tooComplicatedTooManySteps","thumb-down"],["Desatualizado","outOfDate","thumb-down"],["Problema na tradução","translationIssue","thumb-down"],["Problema com as amostras / o código","samplesCodeIssue","thumb-down"],["Outro","otherDown","thumb-down"]],["Última atualização 2024-12-22 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)."]]
