bigquery.jobs.get.resutls.json

{
	"kind": "bigquery#job",
	"etag": "\"Nffj8WcBg8Vy0jj5i2Ow4j6Mrcs/Z3XdJy-3ci8it9bJqScatGFAerI\"",
	"id": "metal-tile-dev0:bquijob_57d01daf_15e853bceec",
	"selfLink": "https://www.googleapis.com/bigquery/v2/projects/metal-tile-dev0/jobs/bquijob_57d01daf_15e853bceec",
	"jobReference": {
		"projectId": "metal-tile-dev0",
		"jobId": "bquijob_57d01daf_15e853bceec"
	},
	"configuration": {
		"query": {
			"query": "SELECT word FROM [bigquery-public-data:samples.shakespeare] LIMIT 1",
			"destinationTable": {
				"projectId": "metal-tile-dev0",
				"datasetId": "_393a6f102e0128a498a352e4b6622c3201d844e0",
				"tableId": "anon14bbb046e2ae4f3a59b22bc922b643bf282ddec3"
			},
			"createDisposition": "CREATE_IF_NEEDED",
			"writeDisposition": "WRITE_TRUNCATE"
		}
	},
	"status": {
		"state": "DONE"
	},
	"statistics": {
		"creationTime": "1505473841611",
		"startTime": "1505473841945",
		"endTime": "1505473843149",
		"totalBytesProcessed": "1332943",
		"query": {
			"queryPlan": [{
					"name": "Stage 1",
					"id": "1",
					"waitRatioAvg": 0,
					"waitMsAvg": "0",
					"waitRatioMax": 0,
					"waitMsMax": "0",
					"readRatioAvg": 0.9720108787878787,
					"readMsAvg": "32",
					"readRatioMax": 0.9720108787878787,
					"readMsMax": "32",
					"computeRatioAvg": 0.11466038472727272,
					"computeMsAvg": "3",
					"computeRatioMax": 0.11466038472727272,
					"computeMsMax": "3",
					"writeRatioAvg": 0.1101460909090909,
					"writeMsAvg": "3",
					"writeRatioMax": 0.1101460909090909,
					"writeMsMax": "3",
					"shuffleOutputBytes": "9",
					"shuffleOutputBytesSpilled": "0",
					"recordsRead": "164656",
					"recordsWritten": "1",
					"status": "COMPLETE",
					"steps": [{
							"kind": "READ",
							"substeps": [
								"word",
								"FROM bigquery-public-data:samples.shakespeare"
							]
						},
						{
							"kind": "LIMIT",
							"substeps": [
								"1"
							]
						},
						{
							"kind": "WRITE",
							"substeps": [
								"word",
								"TO __stage1_output"
							]
						}
					]
				},
				{
					"name": "Stage 2",
					"id": "2",
					"waitRatioAvg": 1,
					"waitMsAvg": "33",
					"waitRatioMax": 1,
					"waitMsMax": "33",
					"readRatioAvg": 0,
					"readMsAvg": "0",
					"readRatioMax": 0,
					"readMsMax": "0",
					"computeRatioAvg": 0.2652461889090909,
					"computeMsAvg": "8",
					"computeRatioMax": 0.2652461889090909,
					"computeMsMax": "8",
					"writeRatioAvg": 0.8063084242424242,
					"writeMsAvg": "26",
					"writeRatioMax": 0.8063084242424242,
					"writeMsMax": "26",
					"shuffleOutputBytes": "9",
					"shuffleOutputBytesSpilled": "0",
					"recordsRead": "1",
					"recordsWritten": "1",
					"status": "COMPLETE",
					"steps": [{
							"kind": "READ",
							"substeps": [
								"word",
								"FROM __stage1_output AS bigquery-public-data:samples.shakespeare"
							]
						},
						{
							"kind": "LIMIT",
							"substeps": [
								"1"
							]
						},
						{
							"kind": "WRITE",
							"substeps": [
								"word",
								"TO __output"
							]
						}
					]
				}
			],
			"totalBytesProcessed": "1332943",
			"totalBytesBilled": "10485760",
			"billingTier": 1,
			"totalSlotMs": "77",
			"cacheHit": false,
			"referencedTables": [{
				"projectId": "bigquery-public-data",
				"datasetId": "samples",
				"tableId": "shakespeare"
			}],
			"statementType": "SELECT"
		}
	},
	"user_email": "[email protected]"
}