Untitled

mail@pastecode.io avatar
unknown
plain_text
7 months ago
9.2 kB
0
Indexable
Never
{
  "creation_time": "2023-09-26 04:06:45.534 UTC",
  "project_id": "analytics-next-gen",
  "project_number": "915289909544",
  "user_email": "tanapiriyakul@snaplogic.com",
  "job_id": "job_n9rLe-b-I7lu54BdWQwlUySHlcPE",
  "job_type": "QUERY",
  "statement_type": "SELECT",
  "priority": "INTERACTIVE",
  "start_time": "2023-09-26 04:06:45.676 UTC",
  "end_time": "2023-09-26 04:06:52.227 UTC",
  "query": "SELECT * FROM (\nSELECT clmn3_, clmn0_, clmn4_, clmn6_, clmn2_, clmn5_, clmn1_, COUNT(1) AS clmn100000_ FROM (\nSELECT t0.invoker AS clmn3_, t0.month AS clmn0_, t0.num_snap AS clmn4_, t0.org AS clmn6_, t0.plex AS clmn2_, t0.snap_type AS clmn5_, t0.state AS clmn1_ FROM `analytics-next-gen.Snap_Usage.snap_execution_org_month_invoker_plex_state_type` t0\n) GROUP BY clmn3_, clmn0_, clmn4_, clmn6_, clmn2_, clmn5_, clmn1_\n) LIMIT 20000000",
  "state": "DONE",
  "total_bytes_processed": "60010549",
  "total_slot_ms": "11411",
  "cache_hit": false,
  "destination_table": {
    "project_id": "analytics-next-gen",
    "dataset_id": "_5bba798b60f4a2e732f301a18fa022fb6ce165c8",
    "table_id": "anonc0406cef12af6add8c2e35aa7eb1c347619ccba0cc55b9fc65310dcdf35126b9"
  },
  "referenced_tables": [
    {
      "project_id": "analytics-next-gen",
      "dataset_id": "Snap_Usage",
      "table_id": "snap_execution_org_month_invoker_plex_state_type"
    }
  ],
  "labels": [
    {
      "key": "requestor",
      "value": "looker_studio"
    }
  ],
  "timeline": [
    {
      "elapsed_ms": "927",
      "total_slot_ms": "61",
      "pending_units": "1",
      "completed_units": "0",
      "active_units": "1",
      "estimated_runnable_units": "0"
    },
    {
      "elapsed_ms": "1921",
      "total_slot_ms": "2287",
      "pending_units": "1",
      "completed_units": "0",
      "active_units": "1",
      "estimated_runnable_units": "0"
    },
    {
      "elapsed_ms": "2921",
      "total_slot_ms": "4309",
      "pending_units": "1",
      "completed_units": "0",
      "active_units": "1",
      "estimated_runnable_units": "0"
    },
    {
      "elapsed_ms": "4471",
      "total_slot_ms": "7332",
      "pending_units": "2",
      "completed_units": "1",
      "active_units": "2",
      "estimated_runnable_units": "0"
    },
    {
      "elapsed_ms": "6130",
      "total_slot_ms": "11411",
      "pending_units": "0",
      "completed_units": "4",
      "active_units": "1",
      "estimated_runnable_units": "1"
    }
  ],
  "job_stages": [
    {
      "name": "S00: Input",
      "id": "0",
      "start_ms": "1695701206103",
      "end_ms": "1695701209647",
      "input_stages": [],
      "wait_ratio_avg": 0.00033085194375516956,
      "wait_ms_avg": "2",
      "wait_ratio_max": 0.00033085194375516956,
      "wait_ms_max": "2",
      "read_ratio_avg": 0.0630272952853598,
      "read_ms_avg": "381",
      "read_ratio_max": 0.0630272952853598,
      "read_ms_max": "381",
      "compute_ratio_avg": 1,
      "compute_ms_avg": "6045",
      "compute_ratio_max": 1,
      "compute_ms_max": "6045",
      "write_ratio_avg": 0.0009925558312655087,
      "write_ms_avg": "6",
      "write_ratio_max": 0.0009925558312655087,
      "write_ms_max": "6",
      "shuffle_output_bytes": "49106072",
      "shuffle_output_bytes_spilled": "0",
      "records_read": "290440",
      "records_written": "290440",
      "parallel_inputs": "1",
      "completed_parallel_inputs": "1",
      "status": "COMPLETE",
      "steps": [
        {
          "kind": "READ",
          "substeps": [
            "$1:month, $2:state, $3:plex, $4:invoker, $5:num_snap, $6:snap_type, $7:org",
            "FROM analytics-next-gen.Snap_Usage.snap_execution_org_month_invoker_plex_state_type"
          ]
        },
        {
          "kind": "AGGREGATE",
          "substeps": [
            "GROUP BY $40 := $4, $41 := $1, $42 := $5, $43 := $7, $44 := $3, $45 := $6, $46 := $2",
            "$20 := COUNT($30)"
          ]
        },
        {
          "kind": "COMPUTE",
          "substeps": [
            "$30 := 1"
          ]
        },
        {
          "kind": "WRITE",
          "substeps": [
            "$41, $46, $44, $40, $42, $45, $43, $20",
            "TO __stage00_output",
            "BY HASH($40, $41, $42, $43, $44, $45, $46)"
          ]
        }
      ],
      "slot_ms": "7138",
      "compute_mode": "BIGQUERY"
    },
    {
      "name": "S01: Aggregate+",
      "id": "1",
      "start_ms": "1695701209946",
      "end_ms": "1695701210634",
      "input_stages": [
        "0"
      ],
      "wait_ratio_avg": 0.00033085194375516956,
      "wait_ms_avg": "2",
      "wait_ratio_max": 0.00033085194375516956,
      "wait_ms_max": "2",
      "read_ratio_avg": 0,
      "read_ms_avg": "0",
      "read_ratio_max": 0,
      "read_ms_max": "0",
      "compute_ratio_avg": 0.2077750206782465,
      "compute_ms_avg": "1256",
      "compute_ratio_max": 0.2077750206782465,
      "compute_ms_max": "1256",
      "write_ratio_avg": 0.0009925558312655087,
      "write_ms_avg": "6",
      "write_ratio_max": 0.0009925558312655087,
      "write_ms_max": "6",
      "shuffle_output_bytes": "49106072",
      "shuffle_output_bytes_spilled": "0",
      "records_read": "290440",
      "records_written": "290440",
      "parallel_inputs": "1",
      "completed_parallel_inputs": "1",
      "status": "COMPLETE",
      "steps": [
        {
          "kind": "READ",
          "substeps": [
            "$41, $46, $44, $40, $42, $45, $43, $20",
            "FROM __stage00_output"
          ]
        },
        {
          "kind": "LIMIT",
          "substeps": [
            "20000000"
          ]
        },
        {
          "kind": "AGGREGATE",
          "substeps": [
            "GROUP BY $50 := $40, $51 := $41, $52 := $42, $53 := $43, $54 := $44, $55 := $45, $56 := $46",
            "$10 := SUM_OF_COUNTS($20)"
          ]
        },
        {
          "kind": "WRITE",
          "substeps": [
            "$51, $56, $54, $50, $52, $55, $53, $10",
            "TO __stage01_output"
          ]
        }
      ],
      "slot_ms": "1401",
      "compute_mode": "BIGQUERY"
    },
    {
      "name": "S02: Compute",
      "id": "2",
      "start_ms": "1695701209954",
      "end_ms": "1695701210834",
      "input_stages": [
        "1"
      ],
      "wait_ratio_avg": 0.00016542597187758478,
      "wait_ms_avg": "1",
      "wait_ratio_max": 0.00016542597187758478,
      "wait_ms_max": "1",
      "read_ratio_avg": 0,
      "read_ms_avg": "0",
      "read_ratio_max": 0,
      "read_ms_max": "0",
      "compute_ratio_avg": 0.0837055417700579,
      "compute_ms_avg": "506",
      "compute_ratio_max": 0.0837055417700579,
      "compute_ms_max": "506",
      "write_ratio_avg": 0.0008271298593879239,
      "write_ms_avg": "5",
      "write_ratio_max": 0.0008271298593879239,
      "write_ms_max": "5",
      "shuffle_output_bytes": "47072992",
      "shuffle_output_bytes_spilled": "0",
      "records_read": "290440",
      "records_written": "290440",
      "parallel_inputs": "1",
      "completed_parallel_inputs": "1",
      "status": "COMPLETE",
      "steps": [
        {
          "kind": "READ",
          "substeps": [
            "$51, $56, $54, $50, $52, $55, $53, $10",
            "FROM __stage01_output"
          ]
        },
        {
          "kind": "LIMIT",
          "substeps": [
            "20000000"
          ]
        },
        {
          "kind": "WRITE",
          "substeps": [
            "$51, $56, $54, $50, $52, $55, $53, $10",
            "TO __stage02_output"
          ]
        }
      ],
      "slot_ms": "1675",
      "compute_mode": "BIGQUERY"
    },
    {
      "name": "S03: Output",
      "id": "3",
      "start_ms": "1695701211152",
      "end_ms": "1695701211710",
      "input_stages": [
        "2"
      ],
      "wait_ratio_avg": 0.021339950372208438,
      "wait_ms_avg": "129",
      "wait_ratio_max": 0.021339950372208438,
      "wait_ms_max": "129",
      "read_ratio_avg": 0,
      "read_ms_avg": "0",
      "read_ratio_max": 0,
      "read_ms_max": "0",
      "compute_ratio_avg": 0.1564929693961952,
      "compute_ms_avg": "946",
      "compute_ratio_max": 0.1564929693961952,
      "compute_ms_max": "946",
      "write_ratio_avg": 0.013564929693961952,
      "write_ms_avg": "82",
      "write_ratio_max": 0.013564929693961952,
      "write_ms_max": "82",
      "shuffle_output_bytes": "43297272",
      "shuffle_output_bytes_spilled": "0",
      "records_read": "290440",
      "records_written": "290440",
      "parallel_inputs": "1",
      "completed_parallel_inputs": "1",
      "status": "COMPLETE",
      "steps": [
        {
          "kind": "READ",
          "substeps": [
            "$51, $56, $54, $50, $52, $55, $53, $10",
            "FROM __stage02_output"
          ]
        },
        {
          "kind": "WRITE",
          "substeps": [
            "$51, $56, $54, $50, $52, $55, $53, $10",
            "TO __stage03_output"
          ]
        }
      ],
      "slot_ms": "1194",
      "compute_mode": "BIGQUERY"
    }
  ],
  "total_bytes_billed": "60817408",
  "query_info": {
    "query_hashes": {
      "normalized_literals": "6dd3b5ad96e4379836e222103f83abee5213d17a0335fd80cf4291dcae48b4e1"
    }
  },
  "transferred_bytes": "0"
}
Leave a Comment