More than 1 year has passed since last update.

BigQueryの使用スロット数と処理時間を求めるクエリ

BigQuery
GoogleCloud

Posted at 2023-09-27

SELECT
  job_id,
  SAFE_DIVIDE(total_slot_ms, TIMESTAMP_DIFF(end_time,start_time,MILLISECOND)) AS num_slot,
  TIMESTAMP_DIFF(end_time, start_time, SECOND) AS elapsed_time
FROM
  `region-asia-northeast1.INFORMATION_SCHEMA.JOBS`
WHERE
  job_id = "foobar"

You get articles that match your needs
You can efficiently read back useful information
You can use dark theme

What you can do with signing up