Untitled
unknown
plain_text
2 years ago
9.2 kB
8
Indexable
{
"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"
}Editor is loading...
Leave a Comment