[presto] 监控相关指标

1,916 阅读1分钟

集群相关: http://ip:port/v1/cluster

{
	"runningQueries": 0,
	"blockedQueries": 0,
	"queuedQueries": 0,
	"activeCoordinators": 1,
	"activeWorkers": 5,
	"runningDrivers": 0,
	"totalAvailableProcessors": 40,
	"reservedMemory": 0.0,
	"totalInputRows": 16040,
	"totalInputBytes": 953262,
	"totalCpuTimeSecs": 0
}

查询相关:

http://ip:port/v1/query

{
	"queryId": "20200520_063208_00004_83qkz",
	"session": {
		"queryId": "20200520_063208_00004_83qkz",
		"transactionId": "0d0b6209-2616-42da-a79a-4d1aad303e84",
		"clientTransactionSupport": true,
		"user": "root",
		"source": "presto-cli",
		"catalog": "jmx",
		"schema": "history",
		"path": {},
		"timeZoneKey": 1980,
		"locale": "zh_CN",
		"remoteUserAddress": "",
		"userAgent": "StatementClientV1/324",
		"clientTags": [],
		"clientCapabilities": ["PATH"],
		"resourceEstimates": {},
		"startTime": 1589956328727,
		"systemProperties": {},
		"catalogProperties": {},
		"unprocessedCatalogProperties": {},
		"roles": {},
		"preparedStatements": {}
	},
	"resourceGroupId": ["global"],
	"state": "FINISHED",
	"memoryPool": "general",
	"scheduled": true,
	"self": "http://0/v1/query/20200520_063208_00004_83qkz",
	"query": "SHOW FUNCTIONS",
	"queryStats": {
		"createTime": "2020-05-20T06:32:08.728Z",
		"endTime": "2020-05-20T06:32:10.910Z",
		"queuedTime": "134.25us",
		"elapsedTime": "2.18s",
		"executionTime": "2.17s",
		"totalDrivers": 103,
		"queuedDrivers": 0,
		"runningDrivers": 0,
		"completedDrivers": 103,
		"rawInputDataSize": "0B",
		"rawInputPositions": 0,
		"cumulativeUserMemory": 0.0,
		"userMemoryReservation": "0B",
		"totalMemoryReservation": "0B",
		"peakUserMemoryReservation": "0B",
		"peakTotalMemoryReservation": "0B",
		"totalCpuTime": "57.00ms",
		"totalScheduledTime": "219.00ms",
		"fullyBlocked": true,
		"blockedReasons": [],
		"progressPercentage": 100.0
	}
}

集群内存相关:


{
	"reserved": {
		"maxBytes": 5368709120,
		"reservedBytes": 0,
		"reservedRevocableBytes": 0,
		"queryMemoryReservations": {},
		"queryMemoryAllocations": {},
		"queryMemoryRevocableReservations": {},
		"freeBytes": 5368709120
	},
	"general": {
		"maxBytes": 2147483650,
		"reservedBytes": 0,
		"reservedRevocableBytes": 0,
		"queryMemoryReservations": {},
		"queryMemoryAllocations": {},
		"queryMemoryRevocableReservations": {},
		"freeBytes": 2147483650
	}
}