Skip to content

Instantly share code, notes, and snippets.

@sriharshaj

sriharshaj/query_info.json

Created September 11, 2024 15:18
Show Gist options
  • Save sriharshaj/f26e655f233b84754da8216be2ae0172 to your computer and use it in GitHub Desktop.
Save sriharshaj/f26e655f233b84754da8216be2ae0172 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
query_info.json
{
"queryId": "20240911_144851_00236_b6249",
"session": {
"queryId": "20240911_144851_00236_b6249",
"querySpan": {
},
"transactionId": "21bb588c-3469-4053-b923-7ad5d187488c",
"clientTransactionSupport": true,
"user": "user_name",
"originalUser": "user_name",
"groups": [],
"originalUserGroups": [],
"principal": "user_name",
"enabledRoles": [],
"source": "trino-cli",
"catalog": "hive",
"path": {
"path": [
{
"catalogName": "system",
"schemaName": "$query"
},
{
"catalogName": "system",
"schemaName": "builtin"
}
],
"rawPath": ""
},
"timeZoneKey": 1847,
"locale": "en_US",
"remoteUserAddress": "some_host",
"userAgent": "StatementClientV1/444",
"clientTags": [],
"clientCapabilities": [
"PATH",
"PARAMETRIC_DATETIME",
"SESSION_AUTHORIZATION"
],
"resourceEstimates": {
},
"start": "2024-09-11T14:48:51.351798727Z",
"systemProperties": {
},
"catalogProperties": {
},
"catalogRoles": {
},
"preparedStatements": {
},
"protocolName": "Trino",
"timeZone": "America/New_York"
},
"state": "FINISHED",
"self": "some_host:8889/v1/query/20240911_144851_00236_b6249",
"fieldNames": [
"dt"
],
"query": "SELECT dt FROM table_name WHERE dt \u003E '2024-08-01' AND dt \u003C '2024-08-03' LIMIT 10",
"queryStats": {
"createTime": "2024-09-11T14:48:51.352Z",
"executionStartTime": "2024-09-11T14:48:51.517Z",
"lastHeartbeat": "2024-09-11T14:55:32.039Z",
"endTime": "2024-09-11T14:55:32.079Z",
"elapsedTime": "6.68m",
"queuedTime": "563.19us",
"resourceWaitingTime": "165.27ms",
"dispatchingTime": "36.21us",
"executionTime": "6.68m",
"analysisTime": "165.35ms",
"planningTime": "6.67m",
"planningCpuTime": "6.65m",
"finishingTime": "8.73ms",
"totalTasks": 2,
"runningTasks": 0,
"completedTasks": 2,
"failedTasks": 0,
"totalDrivers": 66,
"queuedDrivers": 0,
"runningDrivers": 0,
"blockedDrivers": 0,
"completedDrivers": 66,
"cumulativeUserMemory": 76604.683024,
"failedCumulativeUserMemory": 0,
"userMemoryReservation": "0B",
"revocableMemoryReservation": "0B",
"totalMemoryReservation": "0B",
"peakUserMemoryReservation": "5296B",
"peakRevocableMemoryReservation": "0B",
"peakTotalMemoryReservation": "5296B",
"peakTaskUserMemory": "5208B",
"peakTaskRevocableMemory": "0B",
"peakTaskTotalMemory": "5208B",
"scheduled": true,
"progressPercentage": 100,
"runningPercentage": 0,
"totalScheduledTime": "3.00ms",
"failedScheduledTime": "0.00ns",
"totalCpuTime": "3.00ms",
"failedCpuTime": "0.00ns",
"totalBlockedTime": "1.70s",
"fullyBlocked": true,
"blockedReasons": [],
"physicalInputDataSize": "0B",
"failedPhysicalInputDataSize": "0B",
"physicalInputPositions": 0,
"failedPhysicalInputPositions": 0,
"physicalInputReadTime": "0.00ns",
"failedPhysicalInputReadTime": "0.00ns",
"internalNetworkInputDataSize": "0B",
"failedInternalNetworkInputDataSize": "0B",
"internalNetworkInputPositions": 0,
"failedInternalNetworkInputPositions": 0,
"rawInputDataSize": "0B",
"failedRawInputDataSize": "0B",
"rawInputPositions": 0,
"failedRawInputPositions": 0,
"processedInputDataSize": "0B",
"failedProcessedInputDataSize": "0B",
"processedInputPositions": 0,
"failedProcessedInputPositions": 0,
"inputBlockedTime": "1.68s",
"failedInputBlockedTime": "0.00ns",
"outputDataSize": "0B",
"failedOutputDataSize": "0B",
"outputPositions": 0,
"failedOutputPositions": 0,
"outputBlockedTime": "0.00ns",
"failedOutputBlockedTime": "0.00ns",
"physicalWrittenDataSize": "0B",
"failedPhysicalWrittenDataSize": "0B",
"stageGcStatistics": [
{
"stageId": 0,
"tasks": 1,
"fullGcTasks": 0,
"minFullGcSec": 0,
"maxFullGcSec": 0,
"totalFullGcSec": 0,
"averageFullGcSec": 0
},
{
"stageId": 1,
"tasks": 1,
"fullGcTasks": 0,
"minFullGcSec": 0,
"maxFullGcSec": 0,
"totalFullGcSec": 0,
"averageFullGcSec": 0
}
],
"dynamicFiltersStats": {
"dynamicFilterDomainStats": [],
"lazyDynamicFilters": 0,
"replicatedDynamicFilters": 0,
"totalDynamicFilters": 0,
"dynamicFiltersCompleted": 0
},
"operatorSummaries": [
{
"stageId": 0,
"pipelineId": 0,
"operatorId": 0,
"planNodeId": "168",
"operatorType": "ExchangeOperator",
"totalDrivers": 64,
"addInputCalls": 0,
"addInputWall": "0.00ns",
"addInputCpu": "0.00ns",
"physicalInputDataSize": "0B",
"physicalInputPositions": 0,
"physicalInputReadTime": "0.00ns",
"internalNetworkInputDataSize": "0B",
"internalNetworkInputPositions": 0,
"rawInputDataSize": "0B",
"inputDataSize": "0B",
"inputPositions": 0,
"sumSquaredInputPositions": 0,
"getOutputCalls": 0,
"getOutputWall": "0.00ns",
"getOutputCpu": "0.00ns",
"outputDataSize": "0B",
"outputPositions": 0,
"dynamicFilterSplitsProcessed": 0,
"metrics": {
"Input rows distribution": {
"@class": "io.trino.execution.DistributionSnapshot",
"total": 64,
"min": 0,
"max": 0,
"p01": 0,
"p05": 0,
"p10": 0,
"p25": 0,
"p50": 0,
"p75": 0,
"p90": 0,
"p95": 0,
"p99": 0
},
"CPU time distribution (s)": {
"@class": "io.trino.execution.DistributionSnapshot",
"total": 64,
"min": 0,
"max": 0,
"p01": 0,
"p05": 0,
"p10": 0,
"p25": 0,
"p50": 0,
"p75": 0,
"p90": 0,
"p95": 0,
"p99": 0
},
"Scheduled time distribution (s)": {
"@class": "io.trino.execution.DistributionSnapshot",
"total": 64,
"min": 0,
"max": 0,
"p01": 0,
"p05": 0,
"p10": 0,
"p25": 0,
"p50": 0,
"p75": 0,
"p90": 0,
"p95": 0,
"p99": 0
},
"Blocked time distribution (s)": {
"@class": "io.trino.execution.DistributionSnapshot",
"total": 64,
"min": 0.025377247,
"max": 0.026712377,
"p01": 0.025377247,
"p05": 0.025377247,
"p10": 0.025377247,
"p25": 0.025377247,
"p50": 0.025377247,
"p75": 0.025377247,
"p90": 0.025377247,
"p95": 0.025377247,
"p99": 0.025377247
}
},
"connectorMetrics": {
},
"pipelineMetrics": {
},
"physicalWrittenDataSize": "0B",
"blockedWall": "1.68s",
"finishCalls": 0,
"finishWall": "0.00ns",
"finishCpu": "0.00ns",
"userMemoryReservation": "0B",
"revocableMemoryReservation": "0B",
"peakUserMemoryReservation": "80B",
"peakRevocableMemoryReservation": "0B",
"peakTotalMemoryReservation": "80B",
"spilledDataSize": "0B",
"info": {
"@type": "directExchangeClientStatus",
"bufferedBytes": 0,
"maxBufferedBytes": 0,
"averageBytesPerRequest": 0,
"successfulRequestsCount": 64,
"bufferedPages": 0,
"spilledPages": 0,
"spilledBytes": 0,
"noMoreLocations": true,
"pageBufferClientStatuses": [],
"requestDuration": {
"digest": "AAAAAAAAADlAAAAAAAAAOUAAAAAAAABZQAAAAAAAAPA/AQAAAAAAAAAAADlAAAAAAAAA8D8=",
"min": 25,
"max": 25,
"p25": 25,
"p50": 25,
"p75": 25,
"p90": 25,
"p95": 25,
"p99": 25,
"total": 1,
"p01": 25,
"p05": 25,
"p10": 25
}
}
},
{
"stageId": 0,
"pipelineId": 1,
"operatorId": 0,
"planNodeId": "201",
"operatorType": "LocalExchangeSourceOperator",
"totalDrivers": 1,
"addInputCalls": 0,
"addInputWall": "0.00ns",
"addInputCpu": "0.00ns",
"physicalInputDataSize": "0B",
"physicalInputPositions": 0,
"physicalInputReadTime": "0.00ns",
"internalNetworkInputDataSize": "0B",
"internalNetworkInputPositions": 0,
"rawInputDataSize": "0B",
"inputDataSize": "0B",
"inputPositions": 0,
"sumSquaredInputPositions": 0,
"getOutputCalls": 0,
"getOutputWall": "0.00ns",
"getOutputCpu": "0.00ns",
"outputDataSize": "0B",
"outputPositions": 0,
"dynamicFilterSplitsProcessed": 0,
"metrics": {
"Input rows distribution": {
"@class": "io.trino.execution.DistributionSnapshot",
"total": 1,
"min": 0,
"max": 0,
"p01": 0,
"p05": 0,
"p10": 0,
"p25": 0,
"p50": 0,
"p75": 0,
"p90": 0,
"p95": 0,
"p99": 0
},
"CPU time distribution (s)": {
"@class": "io.trino.execution.DistributionSnapshot",
"total": 1,
"min": 0,
"max": 0,
"p01": 0,
"p05": 0,
"p10": 0,
"p25": 0,
"p50": 0,
"p75": 0,
"p90": 0,
"p95": 0,
"p99": 0
},
"Scheduled time distribution (s)": {
"@class": "io.trino.execution.DistributionSnapshot",
"total": 1,
"min": 0,
"max": 0,
"p01": 0,
"p05": 0,
"p10": 0,
"p25": 0,
"p50": 0,
"p75": 0,
"p90": 0,
"p95": 0,
"p99": 0
},
"Blocked time distribution (s)": {
"@class": "io.trino.execution.DistributionSnapshot",
"total": 1,
"min": 0.026565039,
"max": 0.026565039,
"p01": 0.026565039,
"p05": 0.026565039,
"p10": 0.026565039,
"p25": 0.026565039,
"p50": 0.026565039,
"p75": 0.026565039,
"p90": 0.026565039,
"p95": 0.026565039,
"p99": 0.026565039
}
},
"connectorMetrics": {
},
"pipelineMetrics": {
},
"physicalWrittenDataSize": "0B",
"blockedWall": "26.57ms",
"finishCalls": 0,
"finishWall": "0.00ns",
"finishCpu": "0.00ns",
"userMemoryReservation": "0B",
"revocableMemoryReservation": "0B",
"peakUserMemoryReservation": "0B",
"peakRevocableMemoryReservation": "0B",
"peakTotalMemoryReservation": "0B",
"spilledDataSize": "0B"
},
{
"stageId": 0,
"pipelineId": 1,
"operatorId": 2,
"planNodeId": "7",
"operatorType": "TaskOutputOperator",
"totalDrivers": 1,
"addInputCalls": 0,
"addInputWall": "0.00ns",
"addInputCpu": "0.00ns",
"physicalInputDataSize": "0B",
"physicalInputPositions": 0,
"physicalInputReadTime": "0.00ns",
"internalNetworkInputDataSize": "0B",
"internalNetworkInputPositions": 0,
"rawInputDataSize": "0B",
"inputDataSize": "0B",
"inputPositions": 0,
"sumSquaredInputPositions": 0,
"getOutputCalls": 0,
"getOutputWall": "0.00ns",
"getOutputCpu": "0.00ns",
"outputDataSize": "0B",
"outputPositions": 0,
"dynamicFilterSplitsProcessed": 0,
"metrics": {
"Input rows distribution": {
"@class": "io.trino.execution.DistributionSnapshot",
"total": 1,
"min": 0,
"max": 0,
"p01": 0,
"p05": 0,
"p10": 0,
"p25": 0,
"p50": 0,
"p75": 0,
"p90": 0,
"p95": 0,
"p99": 0
},
"CPU time distribution (s)": {
"@class": "io.trino.execution.DistributionSnapshot",
"total": 1,
"min": 0.000002814999999999,
"max": 0.000002814999999999,
"p01": 0.000002814999999999,
"p05": 0.000002814999999999,
"p10": 0.000002814999999999,
"p25": 0.000002814999999999,
"p50": 0.000002814999999999,
"p75": 0.000002814999999999,
"p90": 0.000002814999999999,
"p95": 0.000002814999999999,
"p99": 0.000002814999999999
},
"Scheduled time distribution (s)": {
"@class": "io.trino.execution.DistributionSnapshot",
"total": 1,
"min": 0.000003494999999999,
"max": 0.000003494999999999,
"p01": 0.000003494999999999,
"p05": 0.000003494999999999,
"p10": 0.000003494999999999,
"p25": 0.000003494999999999,
"p50": 0.000003494999999999,
"p75": 0.000003494999999999,
"p90": 0.000003494999999999,
"p95": 0.000003494999999999,
"p99": 0.000003494999999999
},
"Blocked time distribution (s)": {
"@class": "io.trino.execution.DistributionSnapshot",
"total": 1,
"min": 0,
"max": 0,
"p01": 0,
"p05": 0,
"p10": 0,
"p25": 0,
"p50": 0,
"p75": 0,
"p90": 0,
"p95": 0,
"p99": 0
}
},
"connectorMetrics": {
},
"pipelineMetrics": {
},
"physicalWrittenDataSize": "0B",
"blockedWall": "0.00ns",
"finishCalls": 1,
"finishWall": "3.50us",
"finishCpu": "2.82us",
"userMemoryReservation": "0B",
"revocableMemoryReservation": "0B",
"peakUserMemoryReservation": "88B",
"peakRevocableMemoryReservation": "0B",
"peakTotalMemoryReservation": "88B",
"spilledDataSize": "0B"
},
{
"stageId": 0,
"pipelineId": 0,
"operatorId": 1,
"planNodeId": "201",
"operatorType": "LocalExchangeSinkOperator",
"totalDrivers": 64,
"addInputCalls": 0,
"addInputWall": "0.00ns",
"addInputCpu": "0.00ns",
"physicalInputDataSize": "0B",
"physicalInputPositions": 0,
"physicalInputReadTime": "0.00ns",
"internalNetworkInputDataSize": "0B",
"internalNetworkInputPositions": 0,
"rawInputDataSize": "0B",
"inputDataSize": "0B",
"inputPositions": 0,
"sumSquaredInputPositions": 0,
"getOutputCalls": 0,
"getOutputWall": "0.00ns",
"getOutputCpu": "0.00ns",
"outputDataSize": "0B",
"outputPositions": 0,
"dynamicFilterSplitsProcessed": 0,
"metrics": {
"Input rows distribution": {
"@class": "io.trino.execution.DistributionSnapshot",
"total": 64,
"min": 0,
"max": 0,
"p01": 0,
"p05": 0,
"p10": 0,
"p25": 0,
"p50": 0,
"p75": 0,
"p90": 0,
"p95": 0,
"p99": 0
},
"CPU time distribution (s)": {
"@class": "io.trino.execution.DistributionSnapshot",
"total": 64,
"min": 0.000003539999999999,
"max": 0.000017103999999999,
"p01": 0.000003539999999999,
"p05": 0.000003539999999999,
"p10": 0.000003539999999999,
"p25": 0.000003539999999999,
"p50": 0.000003539999999999,
"p75": 0.000003539999999999,
"p90": 0.000003539999999999,
"p95": 0.000003539999999999,
"p99": 0.000003539999999999
},
"Scheduled time distribution (s)": {
"@class": "io.trino.execution.DistributionSnapshot",
"total": 64,
"min": 0.000004411999999999,
"max": 0.000018065999999999,
"p01": 0.000004411999999999,
"p05": 0.000004411999999999,
"p10": 0.000004411999999999,
"p25": 0.000004411999999999,
"p50": 0.000004411999999999,
"p75": 0.000004411999999999,
"p90": 0.000004411999999999,
"p95": 0.000004411999999999,
"p99": 0.000004411999999999
},
"Blocked time distribution (s)": {
"@class": "io.trino.execution.DistributionSnapshot",
"total": 64,
"min": 0,
"max": 0,
"p01": 0,
"p05": 0,
"p10": 0,
"p25": 0,
"p50": 0,
"p75": 0,
"p90": 0,
"p95": 0,
"p99": 0
}
},
"connectorMetrics": {
},
"pipelineMetrics": {
},
"physicalWrittenDataSize": "0B",
"blockedWall": "0.00ns",
"finishCalls": 64,
"finishWall": "394.11us",
"finishCpu": "338.82us",
"userMemoryReservation": "0B",
"revocableMemoryReservation": "0B",
"peakUserMemoryReservation": "0B",
"peakRevocableMemoryReservation": "0B",
"peakTotalMemoryReservation": "0B",
"spilledDataSize": "0B"
},
{
"stageId": 0,
"pipelineId": 1,
"operatorId": 1,
"planNodeId": "128",
"operatorType": "LimitOperator",
"totalDrivers": 1,
"addInputCalls": 0,
"addInputWall": "0.00ns",
"addInputCpu": "0.00ns",
"physicalInputDataSize": "0B",
"physicalInputPositions": 0,
"physicalInputReadTime": "0.00ns",
"internalNetworkInputDataSize": "0B",
"internalNetworkInputPositions": 0,
"rawInputDataSize": "0B",
"inputDataSize": "0B",
"inputPositions": 0,
"sumSquaredInputPositions": 0,
"getOutputCalls": 1,
"getOutputWall": "7.08us",
"getOutputCpu": "5.94us",
"outputDataSize": "0B",
"outputPositions": 0,
"dynamicFilterSplitsProcessed": 0,
"metrics": {
"Input rows distribution": {
"@class": "io.trino.execution.DistributionSnapshot",
"total": 1,
"min": 0,
"max": 0,
"p01": 0,
"p05": 0,
"p10": 0,
"p25": 0,
"p50": 0,
"p75": 0,
"p90": 0,
"p95": 0,
"p99": 0
},
"CPU time distribution (s)": {
"@class": "io.trino.execution.DistributionSnapshot",
"total": 1,
"min": 0.000012436999999999,
"max": 0.000012436999999999,
"p01": 0.000012436999999999,
"p05": 0.000012436999999999,
"p10": 0.000012436999999999,
"p25": 0.000012436999999999,
"p50": 0.000012436999999999,
"p75": 0.000012436999999999,
"p90": 0.000012436999999999,
"p95": 0.000012436999999999,
"p99": 0.000012436999999999
},
"Scheduled time distribution (s)": {
"@class": "io.trino.execution.DistributionSnapshot",
"total": 1,
"min": 0.000014489999999999,
"max": 0.000014489999999999,
"p01": 0.000014489999999999,
"p05": 0.000014489999999999,
"p10": 0.000014489999999999,
"p25": 0.000014489999999999,
"p50": 0.000014489999999999,
"p75": 0.000014489999999999,
"p90": 0.000014489999999999,
"p95": 0.000014489999999999,
"p99": 0.000014489999999999
},
"Blocked time distribution (s)": {
"@class": "io.trino.execution.DistributionSnapshot",
"total": 1,
"min": 0,
"max": 0,
"p01": 0,
"p05": 0,
"p10": 0,
"p25": 0,
"p50": 0,
"p75": 0,
"p90": 0,
"p95": 0,
"p99": 0
}
},
"connectorMetrics": {
},
"pipelineMetrics": {
},
"physicalWrittenDataSize": "0B",
"blockedWall": "0.00ns",
"finishCalls": 1,
"finishWall": "7.41us",
"finishCpu": "6.50us",
"userMemoryReservation": "0B",
"revocableMemoryReservation": "0B",
"peakUserMemoryReservation": "0B",
"peakRevocableMemoryReservation": "0B",
"peakTotalMemoryReservation": "0B",
"spilledDataSize": "0B"
},
{
"stageId": 1,
"pipelineId": 0,
"operatorId": 0,
"planNodeId": "0",
"operatorType": "TableScanOperator",
"totalDrivers": 1,
"addInputCalls": 0,
"addInputWall": "0.00ns",
"addInputCpu": "0.00ns",
"physicalInputDataSize": "0B",
"physicalInputPositions": 0,
"physicalInputReadTime": "0.00ns",
"internalNetworkInputDataSize": "0B",
"internalNetworkInputPositions": 0,
"rawInputDataSize": "0B",
"inputDataSize": "0B",
"inputPositions": 0,
"sumSquaredInputPositions": 0,
"getOutputCalls": 0,
"getOutputWall": "0.00ns",
"getOutputCpu": "0.00ns",
"outputDataSize": "0B",
"outputPositions": 0,
"dynamicFilterSplitsProcessed": 0,
"metrics": {
"Input rows distribution": {
"@class": "io.trino.execution.DistributionSnapshot",
"total": 1,
"min": 0,
"max": 0,
"p01": 0,
"p05": 0,
"p10": 0,
"p25": 0,
"p50": 0,
"p75": 0,
"p90": 0,
"p95": 0,
"p99": 0
},
"CPU time distribution (s)": {
"@class": "io.trino.execution.DistributionSnapshot",
"total": 1,
"min": 0,
"max": 0,
"p01": 0,
"p05": 0,
"p10": 0,
"p25": 0,
"p50": 0,
"p75": 0,
"p90": 0,
"p95": 0,
"p99": 0
},
"Scheduled time distribution (s)": {
"@class": "io.trino.execution.DistributionSnapshot",
"total": 1,
"min": 0,
"max": 0,
"p01": 0,
"p05": 0,
"p10": 0,
"p25": 0,
"p50": 0,
"p75": 0,
"p90": 0,
"p95": 0,
"p99": 0
},
"Blocked time distribution (s)": {
"@class": "io.trino.execution.DistributionSnapshot",
"total": 1,
"min": 0,
"max": 0,
"p01": 0,
"p05": 0,
"p10": 0,
"p25": 0,
"p50": 0,
"p75": 0,
"p90": 0,
"p95": 0,
"p99": 0
}
},
"connectorMetrics": {
},
"pipelineMetrics": {
},
"physicalWrittenDataSize": "0B",
"blockedWall": "0.00ns",
"finishCalls": 0,
"finishWall": "0.00ns",
"finishCpu": "0.00ns",
"userMemoryReservation": "0B",
"revocableMemoryReservation": "0B",
"peakUserMemoryReservation": "0B",
"peakRevocableMemoryReservation": "0B",
"peakTotalMemoryReservation": "0B",
"spilledDataSize": "0B"
},
{
"stageId": 1,
"pipelineId": 0,
"operatorId": 2,
"planNodeId": "167",
"operatorType": "TaskOutputOperator",
"totalDrivers": 1,
"addInputCalls": 0,
"addInputWall": "0.00ns",
"addInputCpu": "0.00ns",
"physicalInputDataSize": "0B",
"physicalInputPositions": 0,
"physicalInputReadTime": "0.00ns",
"internalNetworkInputDataSize": "0B",
"internalNetworkInputPositions": 0,
"rawInputDataSize": "0B",
"inputDataSize": "0B",
"inputPositions": 0,
"sumSquaredInputPositions": 0,
"getOutputCalls": 0,
"getOutputWall": "0.00ns",
"getOutputCpu": "0.00ns",
"outputDataSize": "0B",
"outputPositions": 0,
"dynamicFilterSplitsProcessed": 0,
"metrics": {
"Input rows distribution": {
"@class": "io.trino.execution.DistributionSnapshot",
"total": 1,
"min": 0,
"max": 0,
"p01": 0,
"p05": 0,
"p10": 0,
"p25": 0,
"p50": 0,
"p75": 0,
"p90": 0,
"p95": 0,
"p99": 0
},
"CPU time distribution (s)": {
"@class": "io.trino.execution.DistributionSnapshot",
"total": 1,
"min": 0.000002040999999999,
"max": 0.000002040999999999,
"p01": 0.000002040999999999,
"p05": 0.000002040999999999,
"p10": 0.000002040999999999,
"p25": 0.000002040999999999,
"p50": 0.000002040999999999,
"p75": 0.000002040999999999,
"p90": 0.000002040999999999,
"p95": 0.000002040999999999,
"p99": 0.000002040999999999
},
"Scheduled time distribution (s)": {
"@class": "io.trino.execution.DistributionSnapshot",
"total": 1,
"min": 0.000001954,
"max": 0.000001954,
"p01": 0.000001954,
"p05": 0.000001954,
"p10": 0.000001954,
"p25": 0.000001954,
"p50": 0.000001954,
"p75": 0.000001954,
"p90": 0.000001954,
"p95": 0.000001954,
"p99": 0.000001954
},
"Blocked time distribution (s)": {
"@class": "io.trino.execution.DistributionSnapshot",
"total": 1,
"min": 0,
"max": 0,
"p01": 0,
"p05": 0,
"p10": 0,
"p25": 0,
"p50": 0,
"p75": 0,
"p90": 0,
"p95": 0,
"p99": 0
}
},
"connectorMetrics": {
},
"pipelineMetrics": {
},
"physicalWrittenDataSize": "0B",
"blockedWall": "0.00ns",
"finishCalls": 1,
"finishWall": "1.95us",
"finishCpu": "2.04us",
"userMemoryReservation": "0B",
"revocableMemoryReservation": "0B",
"peakUserMemoryReservation": "88B",
"peakRevocableMemoryReservation": "0B",
"peakTotalMemoryReservation": "88B",
"spilledDataSize": "0B"
},
{
"stageId": 1,
"pipelineId": 0,
"operatorId": 1,
"planNodeId": "167",
"operatorType": "LimitOperator",
"totalDrivers": 1,
"addInputCalls": 0,
"addInputWall": "0.00ns",
"addInputCpu": "0.00ns",
"physicalInputDataSize": "0B",
"physicalInputPositions": 0,
"physicalInputReadTime": "0.00ns",
"internalNetworkInputDataSize": "0B",
"internalNetworkInputPositions": 0,
"rawInputDataSize": "0B",
"inputDataSize": "0B",
"inputPositions": 0,
"sumSquaredInputPositions": 0,
"getOutputCalls": 0,
"getOutputWall": "0.00ns",
"getOutputCpu": "0.00ns",
"outputDataSize": "0B",
"outputPositions": 0,
"dynamicFilterSplitsProcessed": 0,
"metrics": {
"Input rows distribution": {
"@class": "io.trino.execution.DistributionSnapshot",
"total": 1,
"min": 0,
"max": 0,
"p01": 0,
"p05": 0,
"p10": 0,
"p25": 0,
"p50": 0,
"p75": 0,
"p90": 0,
"p95": 0,
"p99": 0
},
"CPU time distribution (s)": {
"@class": "io.trino.execution.DistributionSnapshot",
"total": 1,
"min": 0.000014151999999999,
"max": 0.000014151999999999,
"p01": 0.000014151999999999,
"p05": 0.000014151999999999,
"p10": 0.000014151999999999,
"p25": 0.000014151999999999,
"p50": 0.000014151999999999,
"p75": 0.000014151999999999,
"p90": 0.000014151999999999,
"p95": 0.000014151999999999,
"p99": 0.000014151999999999
},
"Scheduled time distribution (s)": {
"@class": "io.trino.execution.DistributionSnapshot",
"total": 1,
"min": 0.000016936,
"max": 0.000016936,
"p01": 0.000016936,
"p05": 0.000016936,
"p10": 0.000016936,
"p25": 0.000016936,
"p50": 0.000016936,
"p75": 0.000016936,
"p90": 0.000016936,
"p95": 0.000016936,
"p99": 0.000016936
},
"Blocked time distribution (s)": {
"@class": "io.trino.execution.DistributionSnapshot",
"total": 1,
"min": 0,
"max": 0,
"p01": 0,
"p05": 0,
"p10": 0,
"p25": 0,
"p50": 0,
"p75": 0,
"p90": 0,
"p95": 0,
"p99": 0
}
},
"connectorMetrics": {
},
"pipelineMetrics": {
},
"physicalWrittenDataSize": "0B",
"blockedWall": "0.00ns",
"finishCalls": 1,
"finishWall": "16.94us",
"finishCpu": "14.15us",
"userMemoryReservation": "0B",
"revocableMemoryReservation": "0B",
"peakUserMemoryReservation": "0B",
"peakRevocableMemoryReservation": "0B",
"peakTotalMemoryReservation": "0B",
"spilledDataSize": "0B"
}
],
"optimizerRulesSummaries": [
{
"rule": "io.trino.sql.planner.iterative.rule.DetermineTableScanNodePartitioning",
"invocations": 3,
"applied": 1,
"totalTime": 9344070897,
"failures": 0
},
{
"rule": "io.trino.sql.planner.iterative.rule.PushPredicateIntoTableScan",
"invocations": 1,
"applied": 1,
"totalTime": 6335094451,
"failures": 0
},
{
"rule": "io.trino.sql.planner.iterative.rule.PruneTableScanColumns",
"invocations": 7,
"applied": 1,
"totalTime": 6234313283,
"failures": 0
},
{
"rule": "io.trino.sql.planner.optimizations.AddExchanges",
"invocations": 1,
"applied": 1,
"totalTime": 3119226530,
"failures": 0
},
{
"rule": "io.trino.sql.planner.iterative.rule.PushLimitIntoTableScan",
"invocations": 4,
"applied": 1,
"totalTime": 3114619549,
"failures": 0
},
{
"rule": "io.trino.sql.planner.iterative.rule.PruneProjectColumns",
"invocations": 7,
"applied": 4,
"totalTime": 4453423,
"failures": 0
},
{
"rule": "io.trino.sql.planner.iterative.rule.InlineProjections",
"invocations": 7,
"applied": 4,
"totalTime": 2282496,
"failures": 0
},
{
"rule": "io.trino.sql.planner.iterative.rule.PruneOutputSourceColumns",
"invocations": 16,
"applied": 1,
"totalTime": 1340997,
"failures": 0
},
{
"rule": "io.trino.sql.planner.iterative.rule.PruneLimitColumns",
"invocations": 7,
"applied": 1,
"totalTime": 1225769,
"failures": 0
},
{
"rule": "io.trino.sql.planner.iterative.rule.PruneFilterColumns",
"invocations": 7,
"applied": 1,
"totalTime": 1161357,
"failures": 0
}
],
"spilledDataSize": "0B",
"logicalWrittenDataSize": "0B",
"writtenPositions": 0
},
"resetAuthorizationUser": false,
"setSessionProperties": {
},
"resetSessionProperties": [],
"setRoles": {
},
"addedPreparedStatements": {
},
"deallocatedPreparedStatements": [],
"clearTransactionId": false,
"outputStage": {
"stageId": "20240911_144851_00236_b6249.0",
"state": "FINISHED",
"plan": {
"id": "0",
"root": {
"@type": "output",
"id": "7",
"source": {
"@type": "limit",
"id": "128",
"source": {
"@type": "exchange",
"id": "201",
"type": "GATHER",
"scope": "LOCAL",
"partitioningScheme": {
"partitioning": {
"handle": {
"connectorHandle": {
"@type": "system:io.trino.sql.planner.SystemPartitioningHandle",
"partitioning": "SINGLE",
"function": "SINGLE"
},
"scaleWriters": false
},
"arguments": []
},
"outputLayout": [
{
"type": "varchar",
"name": "dt"
}
],
"replicateNullsAndAny": false
},
"sources": [
{
"@type": "remoteSource",
"id": "168",
"sourceFragmentIds": [
"1"
],
"outputs": [
{
"type": "varchar",
"name": "dt"
}
],
"exchangeType": "GATHER",
"retryPolicy": "NONE"
}
],
"inputs": [
[
{
"type": "varchar",
"name": "dt"
}
]
]
},
"count": 10,
"partial": false,
"requiresPreSortedInputs": []
},
"columns": [
"dt"
],
"outputs": [
{
"type": "varchar",
"name": "dt"
}
]
},
"symbols": [
{
"type": "varchar",
"name": "dt"
}
],
"partitioning": {
"connectorHandle": {
"@type": "system:io.trino.sql.planner.SystemPartitioningHandle",
"partitioning": "SINGLE",
"function": "SINGLE"
},
"scaleWriters": false
},
"partitionedSources": [],
"outputPartitioningScheme": {
"partitioning": {
"handle": {
"connectorHandle": {
"@type": "system:io.trino.sql.planner.SystemPartitioningHandle",
"partitioning": "SINGLE",
"function": "SINGLE"
},
"scaleWriters": false
},
"arguments": []
},
"outputLayout": [
{
"type": "varchar",
"name": "dt"
}
],
"replicateNullsAndAny": false
},
"statsAndCosts": {
"stats": {
"7": {
"outputRowCount": 10,
"symbolStatistics": {
}
},
"128": {
"outputRowCount": 10,
"symbolStatistics": {
}
},
"201": {
"outputRowCount": 10,
"symbolStatistics": {
}
},
"168": {
"outputRowCount": 10,
"symbolStatistics": {
}
}
},
"costs": {
"7": {
"cpuCost": "NaN",
"maxMemory": 0,
"maxMemoryWhenOutputting": 0,
"networkCost": 550,
"rootNodeLocalCostEstimate": {
"cpuCost": 0,
"maxMemory": 0,
"networkCost": 0
}
},
"128": {
"cpuCost": "NaN",
"maxMemory": 0,
"maxMemoryWhenOutputting": 0,
"networkCost": 550,
"rootNodeLocalCostEstimate": {
"cpuCost": 550,
"maxMemory": 0,
"networkCost": 0
}
},
"201": {
"cpuCost": "NaN",
"maxMemory": 0,
"maxMemoryWhenOutputting": 0,
"networkCost": 550,
"rootNodeLocalCostEstimate": {
"cpuCost": 0,
"maxMemory": 0,
"networkCost": 0
}
},
"168": {
"cpuCost": "NaN",
"maxMemory": 0,
"maxMemoryWhenOutputting": 0,
"networkCost": 550,
"rootNodeLocalCostEstimate": {
"cpuCost": 0,
"maxMemory": 0,
"networkCost": 550
}
}
}
},
"activeCatalogs": [],
"languageFunctions": {
},
"jsonRepresentation": "{\n \"id\" : \"7\",\n \"name\" : \"Output\",\n \"descriptor\" : {\n \"columnNames\" : \"[dt]\"\n },\n \"outputs\" : [ {\n \"type\" : \"varchar\",\n \"name\" : \"dt\"\n } ],\n \"details\" : [ ],\n \"estimates\" : [ ],\n \"children\" : [ {\n \"id\" : \"128\",\n \"name\" : \"Limit\",\n \"descriptor\" : {\n \"count\" : \"10\",\n \"withTies\" : \"\",\n \"inputPreSortedBy\" : \"[]\"\n },\n \"outputs\" : [ {\n \"type\" : \"varchar\",\n \"name\" : \"dt\"\n } ],\n \"details\" : [ ],\n \"estimates\" : [ ],\n \"children\" : [ {\n \"id\" : \"201\",\n \"name\" : \"LocalExchange\",\n \"descriptor\" : {\n \"partitioning\" : \"SINGLE\",\n \"isReplicateNullsAndAny\" : \"\",\n \"hashColumn\" : \"[]\",\n \"arguments\" : \"[]\"\n },\n \"outputs\" : [ {\n \"type\" : \"varchar\",\n \"name\" : \"dt\"\n } ],\n \"details\" : [ ],\n \"estimates\" : [ ],\n \"children\" : [ {\n \"id\" : \"168\",\n \"name\" : \"RemoteSource\",\n \"descriptor\" : {\n \"sourceFragmentIds\" : \"[1]\"\n },\n \"outputs\" : [ {\n \"type\" : \"varchar\",\n \"name\" : \"dt\"\n } ],\n \"details\" : [ ],\n \"estimates\" : [ ],\n \"children\" : [ ]\n } ]\n } ]\n } ]\n}"
},
"coordinatorOnly": false,
"types": [
"varchar"
],
"stageStats": {
"schedulingComplete": "2024-09-11T14:55:32.039Z",
"getSplitDistribution": {
"count": 0,
"total": 0,
"p01": "NaN",
"p05": "NaN",
"p10": "NaN",
"p25": "NaN",
"p50": "NaN",
"p75": "NaN",
"p90": "NaN",
"p95": "NaN",
"p99": "NaN",
"min": "NaN",
"max": "NaN",
"avg": "NaN"
},
"totalTasks": 1,
"runningTasks": 0,
"completedTasks": 1,
"failedTasks": 0,
"totalDrivers": 65,
"queuedDrivers": 0,
"runningDrivers": 0,
"blockedDrivers": 0,
"completedDrivers": 65,
"cumulativeUserMemory": 76531.114716,
"failedCumulativeUserMemory": 0,
"userMemoryReservation": "0B",
"revocableMemoryReservation": "0B",
"totalMemoryReservation": "0B",
"peakUserMemoryReservation": "5208B",
"peakRevocableMemoryReservation": "0B",
"totalScheduledTime": "2.90ms",
"failedScheduledTime": "0.00s",
"totalCpuTime": "2.62ms",
"failedCpuTime": "0.00s",
"totalBlockedTime": "1.70s",
"fullyBlocked": false,
"blockedReasons": [],
"physicalInputDataSize": "0B",
"failedPhysicalInputDataSize": "0B",
"physicalInputPositions": 0,
"failedPhysicalInputPositions": 0,
"physicalInputReadTime": "0.00s",
"failedPhysicalInputReadTime": "0.00s",
"internalNetworkInputDataSize": "0B",
"failedInternalNetworkInputDataSize": "0B",
"internalNetworkInputPositions": 0,
"failedInternalNetworkInputPositions": 0,
"rawInputDataSize": "0B",
"failedRawInputDataSize": "0B",
"rawInputPositions": 0,
"failedRawInputPositions": 0,
"processedInputDataSize": "0B",
"failedProcessedInputDataSize": "0B",
"processedInputPositions": 0,
"failedProcessedInputPositions": 0,
"inputBlockedTime": "1.68s",
"failedInputBlockedTime": "0.00s",
"bufferedDataSize": "0B",
"outputBufferUtilization": {
"digest": "AAAAAAAAAPB/AAAAAAAA8P8AAAAAAABZQAAAAAAAAAAAAAAAAA==",
"min": "NaN",
"max": "NaN",
"p25": "NaN",
"p50": "NaN",
"p75": "NaN",
"p90": "NaN",
"p95": "NaN",
"p99": "NaN",
"total": 0,
"p01": "NaN",
"p05": "NaN",
"p10": "NaN"
},
"outputDataSize": "0B",
"failedOutputDataSize": "0B",
"outputPositions": 0,
"failedOutputPositions": 0,
"outputBlockedTime": "0.00s",
"failedOutputBlockedTime": "0.00s",
"physicalWrittenDataSize": "0B",
"failedPhysicalWrittenDataSize": "0B",
"gcInfo": {
"stageId": 0,
"tasks": 1,
"fullGcTasks": 0,
"minFullGcSec": 0,
"maxFullGcSec": 0,
"totalFullGcSec": 0,
"averageFullGcSec": 0
},
"operatorSummaries": [
{
"stageId": 0,
"pipelineId": 0,
"operatorId": 0,
"planNodeId": "168",
"operatorType": "ExchangeOperator",
"totalDrivers": 64,
"addInputCalls": 0,
"addInputWall": "0.00ns",
"addInputCpu": "0.00ns",
"physicalInputDataSize": "0B",
"physicalInputPositions": 0,
"physicalInputReadTime": "0.00ns",
"internalNetworkInputDataSize": "0B",
"internalNetworkInputPositions": 0,
"rawInputDataSize": "0B",
"inputDataSize": "0B",
"inputPositions": 0,
"sumSquaredInputPositions": 0,
"getOutputCalls": 0,
"getOutputWall": "0.00ns",
"getOutputCpu": "0.00ns",
"outputDataSize": "0B",
"outputPositions": 0,
"dynamicFilterSplitsProcessed": 0,
"metrics": {
"CPU time distribution (s)": {
"@class": "io.trino.execution.DistributionSnapshot",
"total": 64,
"min": 0,
"max": 0,
"p01": 0,
"p05": 0,
"p10": 0,
"p25": 0,
"p50": 0,
"p75": 0,
"p90": 0,
"p95": 0,
"p99": 0
},
"Input rows distribution": {
"@class": "io.trino.execution.DistributionSnapshot",
"total": 64,
"min": 0,
"max": 0,
"p01": 0,
"p05": 0,
"p10": 0,
"p25": 0,
"p50": 0,
"p75": 0,
"p90": 0,
"p95": 0,
"p99": 0
},
"Scheduled time distribution (s)": {
"@class": "io.trino.execution.DistributionSnapshot",
"total": 64,
"min": 0,
"max": 0,
"p01": 0,
"p05": 0,
"p10": 0,
"p25": 0,
"p50": 0,
"p75": 0,
"p90": 0,
"p95": 0,
"p99": 0
},
"Blocked time distribution (s)": {
"@class": "io.trino.execution.DistributionSnapshot",
"total": 64,
"min": 0.025377247,
"max": 0.026712377,
"p01": 0.025377247,
"p05": 0.025377247,
"p10": 0.025377247,
"p25": 0.025377247,
"p50": 0.025377247,
"p75": 0.025377247,
"p90": 0.025377247,
"p95": 0.025377247,
"p99": 0.025377247
}
},
"connectorMetrics": {
},
"pipelineMetrics": {
},
"physicalWrittenDataSize": "0B",
"blockedWall": "1.68s",
"finishCalls": 0,
"finishWall": "0.00ns",
"finishCpu": "0.00ns",
"userMemoryReservation": "0B",
"revocableMemoryReservation": "0B",
"peakUserMemoryReservation": "80B",
"peakRevocableMemoryReservation": "0B",
"peakTotalMemoryReservation": "80B",
"spilledDataSize": "0B",
"info": {
"@type": "directExchangeClientStatus",
"bufferedBytes": 0,
"maxBufferedBytes": 0,
"averageBytesPerRequest": 0,
"successfulRequestsCount": 64,
"bufferedPages": 0,
"spilledPages": 0,
"spilledBytes": 0,
"noMoreLocations": true,
"pageBufferClientStatuses": [],
"requestDuration": {
"digest": "AAAAAAAAADlAAAAAAAAAOUAAAAAAAABZQAAAAAAAAPA/AQAAAAAAAAAAADlAAAAAAAAA8D8=",
"min": 25,
"max": 25,
"p25": 25,
"p50": 25,
"p75": 25,
"p90": 25,
"p95": 25,
"p99": 25,
"total": 1,
"p01": 25,
"p05": 25,
"p10": 25
}
}
},
{
"stageId": 0,
"pipelineId": 1,
"operatorId": 0,
"planNodeId": "201",
"operatorType": "LocalExchangeSourceOperator",
"totalDrivers": 1,
"addInputCalls": 0,
"addInputWall": "0.00ns",
"addInputCpu": "0.00ns",
"physicalInputDataSize": "0B",
"physicalInputPositions": 0,
"physicalInputReadTime": "0.00ns",
"internalNetworkInputDataSize": "0B",
"internalNetworkInputPositions": 0,
"rawInputDataSize": "0B",
"inputDataSize": "0B",
"inputPositions": 0,
"sumSquaredInputPositions": 0,
"getOutputCalls": 0,
"getOutputWall": "0.00ns",
"getOutputCpu": "0.00ns",
"outputDataSize": "0B",
"outputPositions": 0,
"dynamicFilterSplitsProcessed": 0,
"metrics": {
"CPU time distribution (s)": {
"@class": "io.trino.execution.DistributionSnapshot",
"total": 1,
"min": 0,
"max": 0,
"p01": 0,
"p05": 0,
"p10": 0,
"p25": 0,
"p50": 0,
"p75": 0,
"p90": 0,
"p95": 0,
"p99": 0
},
"Input rows distribution": {
"@class": "io.trino.execution.DistributionSnapshot",
"total": 1,
"min": 0,
"max": 0,
"p01": 0,
"p05": 0,
"p10": 0,
"p25": 0,
"p50": 0,
"p75": 0,
"p90": 0,
"p95": 0,
"p99": 0
},
"Scheduled time distribution (s)": {
"@class": "io.trino.execution.DistributionSnapshot",
"total": 1,
"min": 0,
"max": 0,
"p01": 0,
"p05": 0,
"p10": 0,
"p25": 0,
"p50": 0,
"p75": 0,
"p90": 0,
"p95": 0,
"p99": 0
},
"Blocked time distribution (s)": {
"@class": "io.trino.execution.DistributionSnapshot",
"total": 1,
"min": 0.026565039,
"max": 0.026565039,
"p01": 0.026565039,
"p05": 0.026565039,
"p10": 0.026565039,
"p25": 0.026565039,
"p50": 0.026565039,
"p75": 0.026565039,
"p90": 0.026565039,
"p95": 0.026565039,
"p99": 0.026565039
}
},
"connectorMetrics": {
},
"pipelineMetrics": {
},
"physicalWrittenDataSize": "0B",
"blockedWall": "26.57ms",
"finishCalls": 0,
"finishWall": "0.00ns",
"finishCpu": "0.00ns",
"userMemoryReservation": "0B",
"revocableMemoryReservation": "0B",
"peakUserMemoryReservation": "0B",
"peakRevocableMemoryReservation": "0B",
"peakTotalMemoryReservation": "0B",
"spilledDataSize": "0B"
},
{
"stageId": 0,
"pipelineId": 1,
"operatorId": 2,
"planNodeId": "7",
"operatorType": "TaskOutputOperator",
"totalDrivers": 1,
"addInputCalls": 0,
"addInputWall": "0.00ns",
"addInputCpu": "0.00ns",
"physicalInputDataSize": "0B",
"physicalInputPositions": 0,
"physicalInputReadTime": "0.00ns",
"internalNetworkInputDataSize": "0B",
"internalNetworkInputPositions": 0,
"rawInputDataSize": "0B",
"inputDataSize": "0B",
"inputPositions": 0,
"sumSquaredInputPositions": 0,
"getOutputCalls": 0,
"getOutputWall": "0.00ns",
"getOutputCpu": "0.00ns",
"outputDataSize": "0B",
"outputPositions": 0,
"dynamicFilterSplitsProcessed": 0,
"metrics": {
"CPU time distribution (s)": {
"@class": "io.trino.execution.DistributionSnapshot",
"total": 1,
"min": 0.000002814999999999,
"max": 0.000002814999999999,
"p01": 0.000002814999999999,
"p05": 0.000002814999999999,
"p10": 0.000002814999999999,
"p25": 0.000002814999999999,
"p50": 0.000002814999999999,
"p75": 0.000002814999999999,
"p90": 0.000002814999999999,
"p95": 0.000002814999999999,
"p99": 0.000002814999999999
},
"Input rows distribution": {
"@class": "io.trino.execution.DistributionSnapshot",
"total": 1,
"min": 0,
"max": 0,
"p01": 0,
"p05": 0,
"p10": 0,
"p25": 0,
"p50": 0,
"p75": 0,
"p90": 0,
"p95": 0,
"p99": 0
},
"Scheduled time distribution (s)": {
"@class": "io.trino.execution.DistributionSnapshot",
"total": 1,
"min": 0.000003494999999999,
"max": 0.000003494999999999,
"p01": 0.000003494999999999,
"p05": 0.000003494999999999,
"p10": 0.000003494999999999,
"p25": 0.000003494999999999,
"p50": 0.000003494999999999,
"p75": 0.000003494999999999,
"p90": 0.000003494999999999,
"p95": 0.000003494999999999,
"p99": 0.000003494999999999
},
"Blocked time distribution (s)": {
"@class": "io.trino.execution.DistributionSnapshot",
"total": 1,
"min": 0,
"max": 0,
"p01": 0,
"p05": 0,
"p10": 0,
"p25": 0,
"p50": 0,
"p75": 0,
"p90": 0,
"p95": 0,
"p99": 0
}
},
"connectorMetrics": {
},
"pipelineMetrics": {
},
"physicalWrittenDataSize": "0B",
"blockedWall": "0.00ns",
"finishCalls": 1,
"finishWall": "3.50us",
"finishCpu": "2.82us",
"userMemoryReservation": "0B",
"revocableMemoryReservation": "0B",
"peakUserMemoryReservation": "88B",
"peakRevocableMemoryReservation": "0B",
"peakTotalMemoryReservation": "88B",
"spilledDataSize": "0B"
},
{
"stageId": 0,
"pipelineId": 0,
"operatorId": 1,
"planNodeId": "201",
"operatorType": "LocalExchangeSinkOperator",
"totalDrivers": 64,
"addInputCalls": 0,
"addInputWall": "0.00ns",
"addInputCpu": "0.00ns",
"physicalInputDataSize": "0B",
"physicalInputPositions": 0,
"physicalInputReadTime": "0.00ns",
"internalNetworkInputDataSize": "0B",
"internalNetworkInputPositions": 0,
"rawInputDataSize": "0B",
"inputDataSize": "0B",
"inputPositions": 0,
"sumSquaredInputPositions": 0,
"getOutputCalls": 0,
"getOutputWall": "0.00ns",
"getOutputCpu": "0.00ns",
"outputDataSize": "0B",
"outputPositions": 0,
"dynamicFilterSplitsProcessed": 0,
"metrics": {
"CPU time distribution (s)": {
"@class": "io.trino.execution.DistributionSnapshot",
"total": 64,
"min": 0.000003539999999999,
"max": 0.000017103999999999,
"p01": 0.000003539999999999,
"p05": 0.000003539999999999,
"p10": 0.000003539999999999,
"p25": 0.000003539999999999,
"p50": 0.000003539999999999,
"p75": 0.000003539999999999,
"p90": 0.000003539999999999,
"p95": 0.000003539999999999,
"p99": 0.000003539999999999
},
"Input rows distribution": {
"@class": "io.trino.execution.DistributionSnapshot",
"total": 64,
"min": 0,
"max": 0,
"p01": 0,
"p05": 0,
"p10": 0,
"p25": 0,
"p50": 0,
"p75": 0,
"p90": 0,
"p95": 0,
"p99": 0
},
"Scheduled time distribution (s)": {
"@class": "io.trino.execution.DistributionSnapshot",
"total": 64,
"min": 0.000004411999999999,
"max": 0.000018065999999999,
"p01": 0.000004411999999999,
"p05": 0.000004411999999999,
"p10": 0.000004411999999999,
"p25": 0.000004411999999999,
"p50": 0.000004411999999999,
"p75": 0.000004411999999999,
"p90": 0.000004411999999999,
"p95": 0.000004411999999999,
"p99": 0.000004411999999999
},
"Blocked time distribution (s)": {
"@class": "io.trino.execution.DistributionSnapshot",
"total": 64,
"min": 0,
"max": 0,
"p01": 0,
"p05": 0,
"p10": 0,
"p25": 0,
"p50": 0,
"p75": 0,
"p90": 0,
"p95": 0,
"p99": 0
}
},
"connectorMetrics": {
},
"pipelineMetrics": {
},
"physicalWrittenDataSize": "0B",
"blockedWall": "0.00ns",
"finishCalls": 64,
"finishWall": "394.11us",
"finishCpu": "338.82us",
"userMemoryReservation": "0B",
"revocableMemoryReservation": "0B",
"peakUserMemoryReservation": "0B",
"peakRevocableMemoryReservation": "0B",
"peakTotalMemoryReservation": "0B",
"spilledDataSize": "0B"
},
{
"stageId": 0,
"pipelineId": 1,
"operatorId": 1,
"planNodeId": "128",
"operatorType": "LimitOperator",
"totalDrivers": 1,
"addInputCalls": 0,
"addInputWall": "0.00ns",
"addInputCpu": "0.00ns",
"physicalInputDataSize": "0B",
"physicalInputPositions": 0,
"physicalInputReadTime": "0.00ns",
"internalNetworkInputDataSize": "0B",
"internalNetworkInputPositions": 0,
"rawInputDataSize": "0B",
"inputDataSize": "0B",
"inputPositions": 0,
"sumSquaredInputPositions": 0,
"getOutputCalls": 1,
"getOutputWall": "7.08us",
"getOutputCpu": "5.94us",
"outputDataSize": "0B",
"outputPositions": 0,
"dynamicFilterSplitsProcessed": 0,
"metrics": {
"CPU time distribution (s)": {
"@class": "io.trino.execution.DistributionSnapshot",
"total": 1,
"min": 0.000012436999999999,
"max": 0.000012436999999999,
"p01": 0.000012436999999999,
"p05": 0.000012436999999999,
"p10": 0.000012436999999999,
"p25": 0.000012436999999999,
"p50": 0.000012436999999999,
"p75": 0.000012436999999999,
"p90": 0.000012436999999999,
"p95": 0.000012436999999999,
"p99": 0.000012436999999999
},
"Input rows distribution": {
"@class": "io.trino.execution.DistributionSnapshot",
"total": 1,
"min": 0,
"max": 0,
"p01": 0,
"p05": 0,
"p10": 0,
"p25": 0,
"p50": 0,
"p75": 0,
"p90": 0,
"p95": 0,
"p99": 0
},
"Scheduled time distribution (s)": {
"@class": "io.trino.execution.DistributionSnapshot",
"total": 1,
"min": 0.000014489999999999,
"max": 0.000014489999999999,
"p01": 0.000014489999999999,
"p05": 0.000014489999999999,
"p10": 0.000014489999999999,
"p25": 0.000014489999999999,
"p50": 0.000014489999999999,
"p75": 0.000014489999999999,
"p90": 0.000014489999999999,
"p95": 0.000014489999999999,
"p99": 0.000014489999999999
},
"Blocked time distribution (s)": {
"@class": "io.trino.execution.DistributionSnapshot",
"total": 1,
"min": 0,
"max": 0,
"p01": 0,
"p05": 0,
"p10": 0,
"p25": 0,
"p50": 0,
"p75": 0,
"p90": 0,
"p95": 0,
"p99": 0
}
},
"connectorMetrics": {
},
"pipelineMetrics": {
},
"physicalWrittenDataSize": "0B",
"blockedWall": "0.00ns",
"finishCalls": 1,
"finishWall": "7.41us",
"finishCpu": "6.50us",
"userMemoryReservation": "0B",
"revocableMemoryReservation": "0B",
"peakUserMemoryReservation": "0B",
"peakRevocableMemoryReservation": "0B",
"peakTotalMemoryReservation": "0B",
"spilledDataSize": "0B"
}
]
},
"tasks": [
{
"taskStatus": {
"taskId": "20240911_144851_00236_b6249.0.0.0",
"taskInstanceId": "2035a912-a329-4dbc-a216-f2749f70e084",
"version": 2,
"state": "FINISHED",
"self": "http://some_host:8889/v1/task/20240911_144851_00236_b6249.0.0.0",
"nodeId": "trino-adhoc-test-worker038",
"speculative": false,
"failures": [],
"queuedPartitionedDrivers": 0,
"runningPartitionedDrivers": 0,
"outputBufferStatus": {
"outputBuffersVersion": 2,
"overutilized": false,
"exchangeSinkInstanceHandleUpdateRequired": false
},
"outputDataSize": "0B",
"writerInputDataSize": "0B",
"physicalWrittenDataSize": "0B",
"memoryReservation": "0B",
"peakMemoryReservation": "5208B",
"revocableMemoryReservation": "0B",
"fullGcCount": 0,
"fullGcTime": "0.00ns",
"dynamicFiltersVersion": 0,
"queuedPartitionedSplitsWeight": 0,
"runningPartitionedSplitsWeight": 0
},
"lastHeartbeat": "2024-09-11T14:55:32.068Z",
"outputBuffers": {
"type": "PARTITIONED",
"state": "FINISHED",
"canAddBuffers": false,
"canAddPages": false,
"totalBufferedBytes": 0,
"totalBufferedPages": 0,
"totalRowsSent": 0,
"totalPagesSent": 0,
"utilization": {
"digest": "AAAAAAAAAPB/AAAAAAAA8P8AAAAAAABZQAAAAAAAAAAAAAAAAA==",
"min": "NaN",
"max": "NaN",
"p25": "NaN",
"p50": "NaN",
"p75": "NaN",
"p90": "NaN",
"p95": "NaN",
"p99": "NaN",
"total": 0,
"p01": "NaN",
"p05": "NaN",
"p10": "NaN"
}
},
"noMoreSplits": [
"168"
],
"stats": {
"createTime": "2024-09-11T14:55:32.036Z",
"firstStartTime": "2024-09-11T14:55:32.038Z",
"lastStartTime": "2024-09-11T14:55:32.039Z",
"lastEndTime": "2024-09-11T14:55:32.066Z",
"endTime": "2024-09-11T14:55:32.068Z",
"elapsedTime": "29.81ms",
"queuedTime": "371.17us",
"totalDrivers": 65,
"queuedDrivers": 0,
"queuedPartitionedDrivers": 0,
"queuedPartitionedSplitsWeight": 0,
"runningDrivers": 0,
"runningPartitionedDrivers": 0,
"runningPartitionedSplitsWeight": 0,
"blockedDrivers": 0,
"completedDrivers": 65,
"cumulativeUserMemory": 76531.114716,
"userMemoryReservation": "0B",
"peakUserMemoryReservation": "5208B",
"revocableMemoryReservation": "0B",
"totalScheduledTime": "2.90ms",
"totalCpuTime": "2.62ms",
"totalBlockedTime": "1.70s",
"fullyBlocked": false,
"blockedReasons": [],
"physicalInputDataSize": "0B",
"physicalInputPositions": 0,
"physicalInputReadTime": "0.00ns",
"internalNetworkInputDataSize": "0B",
"internalNetworkInputPositions": 0,
"rawInputDataSize": "0B",
"rawInputPositions": 0,
"processedInputDataSize": "0B",
"processedInputPositions": 0,
"inputBlockedTime": "1.68s",
"outputDataSize": "0B",
"outputPositions": 0,
"outputBlockedTime": "0.00ns",
"writerInputDataSize": "0B",
"physicalWrittenDataSize": "0B",
"fullGcCount": 0,
"fullGcTime": "0.00ns",
"pipelines": [
{
"pipelineId": 0,
"firstStartTime": "2024-09-11T14:55:32.038Z",
"lastStartTime": "2024-09-11T14:55:32.039Z",
"lastEndTime": "2024-09-11T14:55:32.066Z",
"inputPipeline": true,
"outputPipeline": false,
"totalDrivers": 64,
"queuedDrivers": 0,
"queuedPartitionedDrivers": 0,
"queuedPartitionedSplitsWeight": 0,
"runningDrivers": 0,
"runningPartitionedDrivers": 0,
"runningPartitionedSplitsWeight": 0,
"blockedDrivers": 0,
"completedDrivers": 64,
"userMemoryReservation": "0B",
"revocableMemoryReservation": "0B",
"queuedTime": {
"count": 64,
"total": 43674983,
"p01": 133429,
"p05": 208289,
"p10": 263398,
"p25": 439879,
"p50": 649620,
"p75": 967007,
"p90": 1102833,
"p95": 1141327,
"p99": 1230112,
"min": 133429,
"max": 1230112,
"avg": 682421.609375
},
"elapsedTime": {
"count": 64,
"total": 1744939593,
"p01": 26968003,
"p05": 27014489,
"p10": 27055519,
"p25": 27139129,
"p50": 27267358,
"p75": 27401980,
"p90": 27456209,
"p95": 27476672,
"p99": 27692884,
"min": 26968003,
"max": 27692884,
"avg": 27264681.140625
},
"totalScheduledTime": "2.86ms",
"totalCpuTime": "2.58ms",
"totalBlockedTime": "1.68s",
"fullyBlocked": false,
"blockedReasons": [],
"physicalInputDataSize": "0B",
"physicalInputPositions": 0,
"physicalInputReadTime": "0.00ns",
"internalNetworkInputDataSize": "0B",
"internalNetworkInputPositions": 0,
"rawInputDataSize": "0B",
"rawInputPositions": 0,
"processedInputDataSize": "0B",
"processedInputPositions": 0,
"inputBlockedTime": "1.68s",
"outputDataSize": "0B",
"outputPositions": 0,
"outputBlockedTime": "0.00ns",
"physicalWrittenDataSize": "0B",
"operatorSummaries": [
{
"stageId": 0,
"pipelineId": 0,
"operatorId": 0,
"planNodeId": "168",
"operatorType": "ExchangeOperator",
"totalDrivers": 64,
"addInputCalls": 0,
"addInputWall": "0.00ns",
"addInputCpu": "0.00ns",
"physicalInputDataSize": "0B",
"physicalInputPositions": 0,
"physicalInputReadTime": "0.00ns",
"internalNetworkInputDataSize": "0B",
"internalNetworkInputPositions": 0,
"rawInputDataSize": "0B",
"inputDataSize": "0B",
"inputPositions": 0,
"sumSquaredInputPositions": 0,
"getOutputCalls": 0,
"getOutputWall": "0.00ns",
"getOutputCpu": "0.00ns",
"outputDataSize": "0B",
"outputPositions": 0,
"dynamicFilterSplitsProcessed": 0,
"metrics": {
"Input rows distribution": {
"@class": "io.trino.plugin.base.metrics.TDigestHistogram",
"digest": "AAAAAAAAAAAAAAAAAAAAAAAAAAAAAABZQAAAAAAAAFBAKAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA8D8AAAAAAADwPwAAAAAAAPA/AAAAAAAA8D8AAAAAAADwPwAAAAAAAPA/AAAAAAAA8D8AAAAAAADwPwAAAAAAAPA/AAAAAAAA8D8AAAAAAADwPwAAAAAAAPA/AAAAAAAAAEAAAAAAAAAAQAAAAAAAAABAAAAAAAAAAEAAAAAAAAAAQAAAAAAAAAhAAAAAAAAACEAAAAAAAAAIQAAAAAAAAAhAAAAAAAAACEAAAAAAAAAIQAAAAAAAAAhAAAAAAAAAAEAAAAAAAAAAQAAAAAAAAABAAAAAAAAAAEAAAAAAAAAAQAAAAAAAAPA/AAAAAAAA8D8AAAAAAADwPwAAAAAAAPA/AAAAAAAA8D8AAAAAAADwPwAAAAAAAPA/AAAAAAAA8D8AAAAAAADwPwAAAAAAAPA/AAAAAAAA8D8=",
"min": 0,
"max": 0,
"p25": 0,
"p50": 0,
"p75": 0,
"p90": 0,
"p95": 0,
"p99": 0,
"total": 64,
"p01": 0,
"p05": 0,
"p10": 0
},
"CPU time distribution (s)": {
"@class": "io.trino.plugin.base.metrics.TDigestHistogram",
"digest": "AAAAAAAAAAAAAAAAAAAAAAAAAAAAAABZQAAAAAAAAFBAKAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA8D8AAAAAAADwPwAAAAAAAPA/AAAAAAAA8D8AAAAAAADwPwAAAAAAAPA/AAAAAAAA8D8AAAAAAADwPwAAAAAAAPA/AAAAAAAA8D8AAAAAAADwPwAAAAAAAPA/AAAAAAAAAEAAAAAAAAAAQAAAAAAAAABAAAAAAAAAAEAAAAAAAAAAQAAAAAAAAAhAAAAAAAAACEAAAAAAAAAIQAAAAAAAAAhAAAAAAAAACEAAAAAAAAAIQAAAAAAAAAhAAAAAAAAAAEAAAAAAAAAAQAAAAAAAAABAAAAAAAAAAEAAAAAAAAAAQAAAAAAAAPA/AAAAAAAA8D8AAAAAAADwPwAAAAAAAPA/AAAAAAAA8D8AAAAAAADwPwAAAAAAAPA/AAAAAAAA8D8AAAAAAADwPwAAAAAAAPA/AAAAAAAA8D8=",
"min": 0,
"max": 0,
"p25": 0,
"p50": 0,
"p75": 0,
"p90": 0,
"p95": 0,
"p99": 0,
"total": 64,
"p01": 0,
"p05": 0,
"p10": 0
},
"Scheduled time distribution (s)": {
"@class": "io.trino.plugin.base.metrics.TDigestHistogram",
"digest": "AAAAAAAAAAAAAAAAAAAAAAAAAAAAAABZQAAAAAAAAFBAKAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA8D8AAAAAAADwPwAAAAAAAPA/AAAAAAAA8D8AAAAAAADwPwAAAAAAAPA/AAAAAAAA8D8AAAAAAADwPwAAAAAAAPA/AAAAAAAA8D8AAAAAAADwPwAAAAAAAPA/AAAAAAAAAEAAAAAAAAAAQAAAAAAAAABAAAAAAAAAAEAAAAAAAAAAQAAAAAAAAAhAAAAAAAAACEAAAAAAAAAIQAAAAAAAAAhAAAAAAAAACEAAAAAAAAAIQAAAAAAAAAhAAAAAAAAAAEAAAAAAAAAAQAAAAAAAAABAAAAAAAAAAEAAAAAAAAAAQAAAAAAAAPA/AAAAAAAA8D8AAAAAAADwPwAAAAAAAPA/AAAAAAAA8D8AAAAAAADwPwAAAAAAAPA/AAAAAAAA8D8AAAAAAADwPwAAAAAAAPA/AAAAAAAA8D8=",
"min": 0,
"max": 0,
"p25": 0,
"p50": 0,
"p75": 0,
"p90": 0,
"p95": 0,
"p99": 0,
"total": 64,
"p01": 0,
"p05": 0,
"p10": 0
},
"Blocked time distribution (s)": {
"@class": "io.trino.plugin.base.metrics.TDigestHistogram",
"digest": "AEHGtTd+/Jk/DCV0Rn1amz8AAAAAAABZQAAAAAAAAFBAKAAAAEHGtTd+/Jk/C6e46VD/mT/ijBXAig+aP1BuLD+oP5o/o58VvfhHmj/0YRvDLEyaP828m/XJVJo/UQDMgndcmj8zUaIqSGGaPx3eC33EcJo/T7U5dbV6mj8Up/9RQH+aPywC7G5hh5o/C4PycX+Lmj+lB6rr9ZOaP1SKj+IroJo/6Brp6Xyomj99nw2e37SaP5x2Czfzvpo/d7rh4bfNmj++Omc/4daaP1dQsZh58po/ZA9ArC/5mj8Ru/QC+f6aP8AdQHCpC5s/7j5IyKAQmz+s7piHOhabP5obRWl+G5s/YF09cJMmmz/+E6WCXyqbPwR4lhaxLJs/brYhFbIymz9HkqtOijObP9Ee/LIeOJs/1T66ZF4/mz/bFijTr0ebPySo6cygTps/ryTjko9Pmz+oFvVvtVObPwwldEZ9Wps/AAAAAAAA8D8AAAAAAADwPwAAAAAAAPA/AAAAAAAA8D8AAAAAAADwPwAAAAAAAPA/AAAAAAAA8D8AAAAAAADwPwAAAAAAAPA/AAAAAAAA8D8AAAAAAADwPwAAAAAAAPA/AAAAAAAAAEAAAAAAAAAAQAAAAAAAAABAAAAAAAAAAEAAAAAAAAAAQAAAAAAAAAhAAAAAAAAACEAAAAAAAAAIQAAAAAAAAAhAAAAAAAAACEAAAAAAAAAIQAAAAAAAAAhAAAAAAAAAAEAAAAAAAAAAQAAAAAAAAABAAAAAAAAAAEAAAAAAAAAAQAAAAAAAAPA/AAAAAAAA8D8AAAAAAADwPwAAAAAAAPA/AAAAAAAA8D8AAAAAAADwPwAAAAAAAPA/AAAAAAAA8D8AAAAAAADwPwAAAAAAAPA/AAAAAAAA8D8=",
"min": 0.025377247,
"max": 0.026712377,
"p25": 0.0259389085,
"p50": 0.0262045018888889,
"p75": 0.026451983,
"p90": 0.026581268,
"p95": 0.02666713,
"p99": 0.026712377,
"total": 64,
"p01": 0.025377247,
"p05": 0.025633458,
"p10": 0.025714069
}
},
"connectorMetrics": {
},
"pipelineMetrics": {
},
"physicalWrittenDataSize": "0B",
"blockedWall": "1.68s",
"finishCalls": 0,
"finishWall": "0.00ns",
"finishCpu": "0.00ns",
"userMemoryReservation": "0B",
"revocableMemoryReservation": "0B",
"peakUserMemoryReservation": "80B",
"peakRevocableMemoryReservation": "0B",
"peakTotalMemoryReservation": "80B",
"spilledDataSize": "0B",
"info": {
"@type": "directExchangeClientStatus",
"bufferedBytes": 0,
"maxBufferedBytes": 0,
"averageBytesPerRequest": 0,
"successfulRequestsCount": 64,
"bufferedPages": 0,
"spilledPages": 0,
"spilledBytes": 0,
"noMoreLocations": true,
"pageBufferClientStatuses": [],
"requestDuration": {
"digest": "AAAAAAAAADlAAAAAAAAAOUAAAAAAAABZQAAAAAAAAPA/AQAAAAAAAAAAADlAAAAAAAAA8D8=",
"min": 25,
"max": 25,
"p25": 25,
"p50": 25,
"p75": 25,
"p90": 25,
"p95": 25,
"p99": 25,
"total": 1,
"p01": 25,
"p05": 25,
"p10": 25
}
}
},
{
"stageId": 0,
"pipelineId": 0,
"operatorId": 1,
"planNodeId": "201",
"operatorType": "LocalExchangeSinkOperator",
"totalDrivers": 64,
"addInputCalls": 0,
"addInputWall": "0.00ns",
"addInputCpu": "0.00ns",
"physicalInputDataSize": "0B",
"physicalInputPositions": 0,
"physicalInputReadTime": "0.00ns",
"internalNetworkInputDataSize": "0B",
"internalNetworkInputPositions": 0,
"rawInputDataSize": "0B",
"inputDataSize": "0B",
"inputPositions": 0,
"sumSquaredInputPositions": 0,
"getOutputCalls": 0,
"getOutputWall": "0.00ns",
"getOutputCpu": "0.00ns",
"outputDataSize": "0B",
"outputPositions": 0,
"dynamicFilterSplitsProcessed": 0,
"metrics": {
"Input rows distribution": {
"@class": "io.trino.plugin.base.metrics.TDigestHistogram",
"digest": "AAAAAAAAAAAAAAAAAAAAAAAAAAAAAABZQAAAAAAAAFBAKAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA8D8AAAAAAADwPwAAAAAAAPA/AAAAAAAA8D8AAAAAAADwPwAAAAAAAPA/AAAAAAAA8D8AAAAAAADwPwAAAAAAAPA/AAAAAAAA8D8AAAAAAADwPwAAAAAAAPA/AAAAAAAAAEAAAAAAAAAAQAAAAAAAAABAAAAAAAAAAEAAAAAAAAAAQAAAAAAAAAhAAAAAAAAACEAAAAAAAAAIQAAAAAAAAAhAAAAAAAAACEAAAAAAAAAIQAAAAAAAAAhAAAAAAAAAAEAAAAAAAAAAQAAAAAAAAABAAAAAAAAAAEAAAAAAAAAAQAAAAAAAAPA/AAAAAAAA8D8AAAAAAADwPwAAAAAAAPA/AAAAAAAA8D8AAAAAAADwPwAAAAAAAPA/AAAAAAAA8D8AAAAAAADwPwAAAAAAAPA/AAAAAAAA8D8=",
"min": 0,
"max": 0,
"p25": 0,
"p50": 0,
"p75": 0,
"p90": 0,
"p95": 0,
"p99": 0,
"total": 64,
"p01": 0,
"p05": 0,
"p10": 0
},
"CPU time distribution (s)": {
"@class": "io.trino.plugin.base.metrics.TDigestHistogram",
"digest": "AOchx5QXss0+gosa7lHv8T4AAAAAAABZQAAAAAAAAFBAKAAAAOchx5QXss0+CaQfaGA/zz7YtnRBhz3QPuR9ej6TldA+uDWYb0Wu0D40ijjfgH3RPnB3tWDSrdE+VNRtRIgP0j7YSCZoEkPSPozjVRDiTtI+HPLMVFNV0j7sy1XQDX3SPvoznUzFjtI+Gx8UMXja0j6SK4XYSvzSPjBwzPRDU9M+Sw7kSIO10z5Rngu1OPXTPlNQnmv2Q9Q+CEQX7yR31D79GCOpuZzUPgEk/zrWEtU+l+/kxyHe1T5Oq3EBKzHWPidBJOjUOtY+qrXcC19u1j6E56CpqfXWPmIpcaEbL9c+BEcdqwE72D69JExTL7jZPoVCq2P6/dk+V1RXTfYg2z50k7Ag4TzbPlaBnikbpts+wzCk5lIs3D6Mvc3RmWrcPrjOCDStVN0+JuN4O0tb3z70TTfciYrfPoKLGu5R7/E+AAAAAAAA8D8AAAAAAADwPwAAAAAAAPA/AAAAAAAA8D8AAAAAAADwPwAAAAAAAPA/AAAAAAAA8D8AAAAAAADwPwAAAAAAAPA/AAAAAAAA8D8AAAAAAADwPwAAAAAAAPA/AAAAAAAAAEAAAAAAAAAAQAAAAAAAAABAAAAAAAAAAEAAAAAAAAAAQAAAAAAAAAhAAAAAAAAACEAAAAAAAAAIQAAAAAAAAAhAAAAAAAAACEAAAAAAAAAIQAAAAAAAAAhAAAAAAAAAAEAAAAAAAAAAQAAAAAAAAABAAAAAAAAAAEAAAAAAAAAAQAAAAAAAAPA/AAAAAAAA8D8AAAAAAADwPwAAAAAAAPA/AAAAAAAA8D8AAAAAAADwPwAAAAAAAPA/AAAAAAAA8D8AAAAAAADwPwAAAAAAAPA/AAAAAAAA8D8=",
"min": 0.000003539999999999,
"max": 0.000017103999999999,
"p25": 0.000004510749999999,
"p50": 0.000004908499999999,
"p75": 0.000005473999999999,
"p90": 0.000006591999999999,
"p95": 0.000006992999999999,
"p99": 0.000017103999999999,
"total": 64,
"p01": 0.000003539999999999,
"p05": 0.000003954,
"p10": 0.000004214999999999
},
"Scheduled time distribution (s)": {
"@class": "io.trino.plugin.base.metrics.TDigestHistogram",
"digest": "AKLVT1NZgdI+SxMUEY7x8j4AAAAAAABZQAAAAAAAAFBAKAAAAKLVT1NZgdI+TbRVkDmr0j5QiIq1GyTUPtKNeP4pX9Q+x2KEuL6E1D7HYoS4voTUPjzOs+Dl7NQ+pg7vwqF61T4L1YM4xZnVPiBYs6DA09U+0/LiSJDf1T6hXaHpzg7WPpTD4sjnO9Y+jAe5XfhZ1j5YA60ju5DWPgxsZSdb29Y+TnTKlPAz1z6hacJY1mfXPsQ4Q5h2w9c+DANHFvEc2D77MapkszHYPnXUtx0xstg+W+MCuKRi2T6p5OTGddTZPkySgRj1BNo+pPDOEWES2j4DOI1S4YbaPjZp4GhD1do+0GZ0vtp83D54A/f8YzPdPqs0ShPGgd0+moVP0KzA3j6ekCtiyTbfPpdDzNFVTd8+JRDAF3Dg3z6Y62IKPhzgPqvNUPONnOA+dsQU8UWX4T67O0Q5V+jhPksTFBGO8fI+AAAAAAAA8D8AAAAAAADwPwAAAAAAAPA/AAAAAAAA8D8AAAAAAADwPwAAAAAAAPA/AAAAAAAA8D8AAAAAAADwPwAAAAAAAPA/AAAAAAAA8D8AAAAAAADwPwAAAAAAAPA/AAAAAAAAAEAAAAAAAAAAQAAAAAAAAABAAAAAAAAAAEAAAAAAAAAAQAAAAAAAAAhAAAAAAAAACEAAAAAAAAAIQAAAAAAAAAhAAAAAAAAACEAAAAAAAAAIQAAAAAAAAAhAAAAAAAAAAEAAAAAAAAAAQAAAAAAAAABAAAAAAAAAAEAAAAAAAAAAQAAAAAAAAPA/AAAAAAAA8D8AAAAAAADwPwAAAAAAAPA/AAAAAAAA8D8AAAAAAADwPwAAAAAAAPA/AAAAAAAA8D8AAAAAAADwPwAAAAAAAPA/AAAAAAAA8D8=",
"min": 0.000004411999999999,
"max": 0.000018065999999999,
"p25": 0.000005354499999999,
"p50": 0.000005765111111111,
"p75": 0.000006324499999999,
"p90": 0.000007462999999999,
"p95": 0.000007921,
"p99": 0.000018065999999999,
"total": 64,
"p01": 0.000004411999999999,
"p05": 0.000004856999999999,
"p10": 0.000004988999999999
},
"Blocked time distribution (s)": {
"@class": "io.trino.plugin.base.metrics.TDigestHistogram",
"digest": "AAAAAAAAAAAAAAAAAAAAAAAAAAAAAABZQAAAAAAAAFBAKAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA8D8AAAAAAADwPwAAAAAAAPA/AAAAAAAA8D8AAAAAAADwPwAAAAAAAPA/AAAAAAAA8D8AAAAAAADwPwAAAAAAAPA/AAAAAAAA8D8AAAAAAADwPwAAAAAAAPA/AAAAAAAAAEAAAAAAAAAAQAAAAAAAAABAAAAAAAAAAEAAAAAAAAAAQAAAAAAAAAhAAAAAAAAACEAAAAAAAAAIQAAAAAAAAAhAAAAAAAAACEAAAAAAAAAIQAAAAAAAAAhAAAAAAAAAAEAAAAAAAAAAQAAAAAAAAABAAAAAAAAAAEAAAAAAAAAAQAAAAAAAAPA/AAAAAAAA8D8AAAAAAADwPwAAAAAAAPA/AAAAAAAA8D8AAAAAAADwPwAAAAAAAPA/AAAAAAAA8D8AAAAAAADwPwAAAAAAAPA/AAAAAAAA8D8=",
"min": 0,
"max": 0,
"p25": 0,
"p50": 0,
"p75": 0,
"p90": 0,
"p95": 0,
"p99": 0,
"total": 64,
"p01": 0,
"p05": 0,
"p10": 0
}
},
"connectorMetrics": {
},
"pipelineMetrics": {
},
"physicalWrittenDataSize": "0B",
"blockedWall": "0.00ns",
"finishCalls": 64,
"finishWall": "394.11us",
"finishCpu": "338.82us",
"userMemoryReservation": "0B",
"revocableMemoryReservation": "0B",
"peakUserMemoryReservation": "0B",
"peakRevocableMemoryReservation": "0B",
"peakTotalMemoryReservation": "0B",
"spilledDataSize": "0B"
}
],
"drivers": []
},
{
"pipelineId": 1,
"firstStartTime": "2024-09-11T14:55:32.039Z",
"lastStartTime": "2024-09-11T14:55:32.039Z",
"lastEndTime": "2024-09-11T14:55:32.066Z",
"inputPipeline": false,
"outputPipeline": true,
"totalDrivers": 1,
"queuedDrivers": 0,
"queuedPartitionedDrivers": 0,
"queuedPartitionedSplitsWeight": 0,
"runningDrivers": 0,
"runningPartitionedDrivers": 0,
"runningPartitionedSplitsWeight": 0,
"blockedDrivers": 0,
"completedDrivers": 1,
"userMemoryReservation": "0B",
"revocableMemoryReservation": "0B",
"queuedTime": {
"count": 1,
"total": 1153836,
"p01": 1153836,
"p05": 1153836,
"p10": 1153836,
"p25": 1153836,
"p50": 1153836,
"p75": 1153836,
"p90": 1153836,
"p95": 1153836,
"p99": 1153836,
"min": 1153836,
"max": 1153836,
"avg": 1153836
},
"elapsedTime": {
"count": 1,
"total": 27722784,
"p01": 27722784,
"p05": 27722784,
"p10": 27722784,
"p25": 27722784,
"p50": 27722784,
"p75": 27722784,
"p90": 27722784,
"p95": 27722784,
"p99": 27722784,
"min": 27722784,
"max": 27722784,
"avg": 27722784
},
"totalScheduledTime": "37.24us",
"totalCpuTime": "35.10us",
"totalBlockedTime": "26.56ms",
"fullyBlocked": false,
"blockedReasons": [],
"physicalInputDataSize": "0B",
"physicalInputPositions": 0,
"physicalInputReadTime": "0.00ns",
"internalNetworkInputDataSize": "0B",
"internalNetworkInputPositions": 0,
"rawInputDataSize": "0B",
"rawInputPositions": 0,
"processedInputDataSize": "0B",
"processedInputPositions": 0,
"inputBlockedTime": "26.57ms",
"outputDataSize": "0B",
"outputPositions": 0,
"outputBlockedTime": "0.00ns",
"physicalWrittenDataSize": "0B",
"operatorSummaries": [
{
"stageId": 0,
"pipelineId": 1,
"operatorId": 0,
"planNodeId": "201",
"operatorType": "LocalExchangeSourceOperator",
"totalDrivers": 1,
"addInputCalls": 0,
"addInputWall": "0.00ns",
"addInputCpu": "0.00ns",
"physicalInputDataSize": "0B",
"physicalInputPositions": 0,
"physicalInputReadTime": "0.00ns",
"internalNetworkInputDataSize": "0B",
"internalNetworkInputPositions": 0,
"rawInputDataSize": "0B",
"inputDataSize": "0B",
"inputPositions": 0,
"sumSquaredInputPositions": 0,
"getOutputCalls": 0,
"getOutputWall": "0.00ns",
"getOutputCpu": "0.00ns",
"outputDataSize": "0B",
"outputPositions": 0,
"dynamicFilterSplitsProcessed": 0,
"metrics": {
"Input rows distribution": {
"@class": "io.trino.plugin.base.metrics.TDigestHistogram",
"digest": "AAAAAAAAAAAAAAAAAAAAAAAAAAAAAABZQAAAAAAAAPA/AQAAAAAAAAAAAAAAAAAAAAAA8D8=",
"min": 0,
"max": 0,
"p25": 0,
"p50": 0,
"p75": 0,
"p90": 0,
"p95": 0,
"p99": 0,
"total": 1,
"p01": 0,
"p05": 0,
"p10": 0
},
"CPU time distribution (s)": {
"@class": "io.trino.plugin.base.metrics.TDigestHistogram",
"digest": "AAAAAAAAAAAAAAAAAAAAAAAAAAAAAABZQAAAAAAAAPA/AQAAAAAAAAAAAAAAAAAAAAAA8D8=",
"min": 0,
"max": 0,
"p25": 0,
"p50": 0,
"p75": 0,
"p90": 0,
"p95": 0,
"p99": 0,
"total": 1,
"p01": 0,
"p05": 0,
"p10": 0
},
"Scheduled time distribution (s)": {
"@class": "io.trino.plugin.base.metrics.TDigestHistogram",
"digest": "AAAAAAAAAAAAAAAAAAAAAAAAAAAAAABZQAAAAAAAAPA/AQAAAAAAAAAAAAAAAAAAAAAA8D8=",
"min": 0,
"max": 0,
"p25": 0,
"p50": 0,
"p75": 0,
"p90": 0,
"p95": 0,
"p99": 0,
"total": 1,
"p01": 0,
"p05": 0,
"p10": 0
},
"Blocked time distribution (s)": {
"@class": "io.trino.plugin.base.metrics.TDigestHistogram",
"digest": "AKtK45bdM5s/q0rjlt0zmz8AAAAAAABZQAAAAAAAAPA/AQAAAKtK45bdM5s/AAAAAAAA8D8=",
"min": 0.026565039,
"max": 0.026565039,
"p25": 0.026565039,
"p50": 0.026565039,
"p75": 0.026565039,
"p90": 0.026565039,
"p95": 0.026565039,
"p99": 0.026565039,
"total": 1,
"p01": 0.026565039,
"p05": 0.026565039,
"p10": 0.026565039
}
},
"connectorMetrics": {
},
"pipelineMetrics": {
},
"physicalWrittenDataSize": "0B",
"blockedWall": "26.57ms",
"finishCalls": 0,
"finishWall": "0.00ns",
"finishCpu": "0.00ns",
"userMemoryReservation": "0B",
"revocableMemoryReservation": "0B",
"peakUserMemoryReservation": "0B",
"peakRevocableMemoryReservation": "0B",
"peakTotalMemoryReservation": "0B",
"spilledDataSize": "0B"
},
{
"stageId": 0,
"pipelineId": 1,
"operatorId": 1,
"planNodeId": "128",
"operatorType": "LimitOperator",
"totalDrivers": 1,
"addInputCalls": 0,
"addInputWall": "0.00ns",
"addInputCpu": "0.00ns",
"physicalInputDataSize": "0B",
"physicalInputPositions": 0,
"physicalInputReadTime": "0.00ns",
"internalNetworkInputDataSize": "0B",
"internalNetworkInputPositions": 0,
"rawInputDataSize": "0B",
"inputDataSize": "0B",
"inputPositions": 0,
"sumSquaredInputPositions": 0,
"getOutputCalls": 1,
"getOutputWall": "7.08us",
"getOutputCpu": "5.94us",
"outputDataSize": "0B",
"outputPositions": 0,
"dynamicFilterSplitsProcessed": 0,
"metrics": {
"Input rows distribution": {
"@class": "io.trino.plugin.base.metrics.TDigestHistogram",
"digest": "AAAAAAAAAAAAAAAAAAAAAAAAAAAAAABZQAAAAAAAAPA/AQAAAAAAAAAAAAAAAAAAAAAA8D8=",
"min": 0,
"max": 0,
"p25": 0,
"p50": 0,
"p75": 0,
"p90": 0,
"p95": 0,
"p99": 0,
"total": 1,
"p01": 0,
"p05": 0,
"p10": 0
},
"CPU time distribution (s)": {
"@class": "io.trino.plugin.base.metrics.TDigestHistogram",
"digest": "ALU2q0MQFeo+tTarQxAV6j4AAAAAAABZQAAAAAAAAPA/AQAAALU2q0MQFeo+AAAAAAAA8D8=",
"min": 0.000012436999999999,
"max": 0.000012436999999999,
"p25": 0.000012436999999999,
"p50": 0.000012436999999999,
"p75": 0.000012436999999999,
"p90": 0.000012436999999999,
"p95": 0.000012436999999999,
"p99": 0.000012436999999999,
"total": 1,
"p01": 0.000012436999999999,
"p05": 0.000012436999999999,
"p10": 0.000012436999999999
},
"Scheduled time distribution (s)": {
"@class": "io.trino.plugin.base.metrics.TDigestHistogram",
"digest": "AGwykW9CY+4+bDKRb0Jj7j4AAAAAAABZQAAAAAAAAPA/AQAAAGwykW9CY+4+AAAAAAAA8D8=",
"min": 0.000014489999999999,
"max": 0.000014489999999999,
"p25": 0.000014489999999999,
"p50": 0.000014489999999999,
"p75": 0.000014489999999999,
"p90": 0.000014489999999999,
"p95": 0.000014489999999999,
"p99": 0.000014489999999999,
"total": 1,
"p01": 0.000014489999999999,
"p05": 0.000014489999999999,
"p10": 0.000014489999999999
},
"Blocked time distribution (s)": {
"@class": "io.trino.plugin.base.metrics.TDigestHistogram",
"digest": "AAAAAAAAAAAAAAAAAAAAAAAAAAAAAABZQAAAAAAAAPA/AQAAAAAAAAAAAAAAAAAAAAAA8D8=",
"min": 0,
"max": 0,
"p25": 0,
"p50": 0,
"p75": 0,
"p90": 0,
"p95": 0,
"p99": 0,
"total": 1,
"p01": 0,
"p05": 0,
"p10": 0
}
},
"connectorMetrics": {
},
"pipelineMetrics": {
},
"physicalWrittenDataSize": "0B",
"blockedWall": "0.00ns",
"finishCalls": 1,
"finishWall": "7.41us",
"finishCpu": "6.50us",
"userMemoryReservation": "0B",
"revocableMemoryReservation": "0B",
"peakUserMemoryReservation": "0B",
"peakRevocableMemoryReservation": "0B",
"peakTotalMemoryReservation": "0B",
"spilledDataSize": "0B"
},
{
"stageId": 0,
"pipelineId": 1,
"operatorId": 2,
"planNodeId": "7",
"operatorType": "TaskOutputOperator",
"totalDrivers": 1,
"addInputCalls": 0,
"addInputWall": "0.00ns",
"addInputCpu": "0.00ns",
"physicalInputDataSize": "0B",
"physicalInputPositions": 0,
"physicalInputReadTime": "0.00ns",
"internalNetworkInputDataSize": "0B",
"internalNetworkInputPositions": 0,
"rawInputDataSize": "0B",
"inputDataSize": "0B",
"inputPositions": 0,
"sumSquaredInputPositions": 0,
"getOutputCalls": 0,
"getOutputWall": "0.00ns",
"getOutputCpu": "0.00ns",
"outputDataSize": "0B",
"outputPositions": 0,
"dynamicFilterSplitsProcessed": 0,
"metrics": {
"Input rows distribution": {
"@class": "io.trino.plugin.base.metrics.TDigestHistogram",
"digest": "AAAAAAAAAAAAAAAAAAAAAAAAAAAAAABZQAAAAAAAAPA/AQAAAAAAAAAAAAAAAAAAAAAA8D8=",
"min": 0,
"max": 0,
"p25": 0,
"p50": 0,
"p75": 0,
"p90": 0,
"p95": 0,
"p99": 0,
"total": 1,
"p01": 0,
"p05": 0,
"p10": 0
},
"CPU time distribution (s)": {
"@class": "io.trino.plugin.base.metrics.TDigestHistogram",
"digest": "ADFiuJ0qncc+MWK4nSqdxz4AAAAAAABZQAAAAAAAAPA/AQAAADFiuJ0qncc+AAAAAAAA8D8=",
"min": 0.000002814999999999,
"max": 0.000002814999999999,
"p25": 0.000002814999999999,
"p50": 0.000002814999999999,
"p75": 0.000002814999999999,
"p90": 0.000002814999999999,
"p95": 0.000002814999999999,
"p99": 0.000002814999999999,
"total": 1,
"p01": 0.000002814999999999,
"p05": 0.000002814999999999,
"p10": 0.000002814999999999
},
"Scheduled time distribution (s)": {
"@class": "io.trino.plugin.base.metrics.TDigestHistogram",
"digest": "AHBHzZF0Uc0+cEfNkXRRzT4AAAAAAABZQAAAAAAAAPA/AQAAAHBHzZF0Uc0+AAAAAAAA8D8=",
"min": 0.000003494999999999,
"max": 0.000003494999999999,
"p25": 0.000003494999999999,
"p50": 0.000003494999999999,
"p75": 0.000003494999999999,
"p90": 0.000003494999999999,
"p95": 0.000003494999999999,
"p99": 0.000003494999999999,
"total": 1,
"p01": 0.000003494999999999,
"p05": 0.000003494999999999,
"p10": 0.000003494999999999
},
"Blocked time distribution (s)": {
"@class": "io.trino.plugin.base.metrics.TDigestHistogram",
"digest": "AAAAAAAAAAAAAAAAAAAAAAAAAAAAAABZQAAAAAAAAPA/AQAAAAAAAAAAAAAAAAAAAAAA8D8=",
"min": 0,
"max": 0,
"p25": 0,
"p50": 0,
"p75": 0,
"p90": 0,
"p95": 0,
"p99": 0,
"total": 1,
"p01": 0,
"p05": 0,
"p10": 0
}
},
"connectorMetrics": {
},
"pipelineMetrics": {
},
"physicalWrittenDataSize": "0B",
"blockedWall": "0.00ns",
"finishCalls": 1,
"finishWall": "3.50us",
"finishCpu": "2.82us",
"userMemoryReservation": "0B",
"revocableMemoryReservation": "0B",
"peakUserMemoryReservation": "88B",
"peakRevocableMemoryReservation": "0B",
"peakTotalMemoryReservation": "88B",
"spilledDataSize": "0B"
}
],
"drivers": []
}
]
},
"needsPlan": false
}
],
"subStages": [
{
"stageId": "20240911_144851_00236_b6249.1",
"state": "FINISHED",
"plan": {
"id": "1",
"root": {
"@type": "limit",
"id": "167",
"source": {
"@type": "tableScan",
"id": "0",
"table": {
"catalogHandle": "catlog:normal:default",
"connectorHandle": {
"@type": "iceberg:io.trino.plugin.iceberg.IcebergTableHandle",
"catalog": "catalog:normal:default",
"schemaName": "schema",
"tableName": "table_name",
"tableType": "DATA",
"snapshotId": 5.540801958347984e+18,
"partitionSpecJson": "{\"spec-id\":0,\"fields\":[{\"name\":\"dt\",\"transform\":\"identity\",\"source-id\":24,\"field-id\":1000}]}",
"tableschemaJSon": "",
"formatVersion": 2,
"unenforcedPredicate": {
"columnDomains": []
},
"enforcedPredicate": {
"columnDomains": [
{
"column": {
"@type": "iceberg:io.trino.plugin.iceberg.IcebergColumnHandle",
"baseColumnIdentity": {
"id": 24,
"name": "dt",
"typeCategory": "PRIMITIVE",
"children": []
},
"baseType": "varchar",
"path": [],
"type": "varchar",
"nullable": true
},
"domain": {
"values": {
"@type": "sortable",
"type": "varchar",
"inclusive": [false, false],
"sortedRanges": "DgAAAFZBUklBQkxFX1dJRFRIAgAAAAIAAAAKAAAACgAAAAAUAAAAMjAyNC0wOC0wMTIwMjQtMDgtMDM=",
"discreteSetMarker": "UNKNOWN"
},
"nullAllowed": false
}
}
]
},
"limit": 10,
"projectedColumns": [
{
"@type": "iceberg:io.trino.plugin.iceberg.IcebergColumnHandle",
"baseColumnIdentity": {
"id": 24,
"name": "dt",
"typeCategory": "PRIMITIVE",
"children": []
},
"baseType": "varchar",
"path": [],
"type": "varchar",
"nullable": true
}
],
"tableLocation": "s3a://some_where",
"storageProperties": {
"write.format.default": "PARQUET",
"write.parquet.compression-codec": "zstd"
}
},
"transaction": {
"@type": "iceberg:io.trino.plugin.hive.HiveTransactionHandle",
"autoCommit": true,
"uuid": "7dcbb685-0efc-40c6-ba17-fce74428429a"
}
},
"outputSymbols": [
{
"type": "varchar",
"name": "dt"
}
],
"assignments": {
"ZHQ=:dmFyY2hhcg==": {
"@type": "iceberg:io.trino.plugin.iceberg.IcebergColumnHandle",
"baseColumnIdentity": {
"id": 24,
"name": "dt",
"typeCategory": "PRIMITIVE",
"children": []
},
"baseType": "varchar",
"path": [],
"type": "varchar",
"nullable": true
}
},
"updateTarget": false,
"useConnectorNodePartitioning": false
},
"count": 10,
"partial": true,
"requiresPreSortedInputs": []
},
"symbols": [
{
"type": "varchar",
"name": "dt"
}
],
"partitioning": {
"connectorHandle": {
"@type": "system:io.trino.sql.planner.SystemPartitioningHandle",
"partitioning": "SOURCE",
"function": "UNKNOWN"
},
"scaleWriters": false
},
"partitionedSources": [
"0"
],
"outputPartitioningScheme": {
"partitioning": {
"handle": {
"connectorHandle": {
"@type": "system:io.trino.sql.planner.SystemPartitioningHandle",
"partitioning": "SINGLE",
"function": "SINGLE"
},
"scaleWriters": false
},
"arguments": []
},
"outputLayout": [
{
"type": "varchar",
"name": "dt"
}
],
"replicateNullsAndAny": false
},
"statsAndCosts": {
"stats": {
"167": {
"outputRowCount": 10,
"symbolStatistics": {
}
},
"0": {
"outputRowCount": "NaN",
"symbolStatistics": {
}
}
},
"costs": {
"167": {
"cpuCost": "NaN",
"maxMemory": 0,
"maxMemoryWhenOutputting": 0,
"networkCost": 0,
"rootNodeLocalCostEstimate": {
"cpuCost": 550,
"maxMemory": 0,
"networkCost": 0
}
},
"0": {
"cpuCost": "NaN",
"maxMemory": 0,
"maxMemoryWhenOutputting": 0,
"networkCost": 0,
"rootNodeLocalCostEstimate": {
"cpuCost": "NaN",
"maxMemory": 0,
"networkCost": 0
}
}
}
},
"activeCatalogs": [],
"languageFunctions": {
},
"jsonRepresentation": "{\n \"id\" : \"167\",\n \"name\" : \"LimitPartial\",\n \"descriptor\" : {\n \"count\" : \"10\",\n \"withTies\" : \"\",\n \"inputPreSortedBy\" : \"[]\"\n },\n \"outputs\" : [ {\n \"type\" : \"varchar\",\n \"name\" : \"dt\"\n } ],\n \"details\" : [ ],\n \"estimates\" : [ ],\n \"children\" : [ {\n \"id\" : \"0\",\n \"name\" : \"TableScan\",\n \"descriptor\" : {\n \"table\" : \"catalog:schema.table_name$data@5540801958347983875 constraint on [dt] LIMIT 10\"\n },\n \"outputs\" : [ {\n \"type\" : \"varchar\",\n \"name\" : \"dt\"\n } ],\n \"details\" : [ \"dt := 24:dt:varchar\", \" :: [(2024-08-01, 2024-08-03)]\" ],\n \"estimates\" : [ ],\n \"children\" : [ ]\n } ]\n}"
},
"coordinatorOnly": false,
"types": [
"varchar"
],
"stageStats": {
"schedulingComplete": "2024-09-11T14:55:32.038Z",
"getSplitDistribution": {
"count": 1,
"total": 5671,
"p01": 5671,
"p05": 5671,
"p10": 5671,
"p25": 5671,
"p50": 5671,
"p75": 5671,
"p90": 5671,
"p95": 5671,
"p99": 5671,
"min": 5671,
"max": 5671,
"avg": 5671
},
"totalTasks": 1,
"runningTasks": 0,
"completedTasks": 1,
"failedTasks": 0,
"totalDrivers": 1,
"queuedDrivers": 0,
"runningDrivers": 0,
"blockedDrivers": 0,
"completedDrivers": 1,
"cumulativeUserMemory": 73.568308,
"failedCumulativeUserMemory": 0,
"userMemoryReservation": "0B",
"revocableMemoryReservation": "0B",
"totalMemoryReservation": "0B",
"peakUserMemoryReservation": "88B",
"peakRevocableMemoryReservation": "0B",
"totalScheduledTime": "41.20us",
"failedScheduledTime": "0.00s",
"totalCpuTime": "38.40us",
"failedCpuTime": "0.00s",
"totalBlockedTime": "0.00s",
"fullyBlocked": false,
"blockedReasons": [],
"physicalInputDataSize": "0B",
"failedPhysicalInputDataSize": "0B",
"physicalInputPositions": 0,
"failedPhysicalInputPositions": 0,
"physicalInputReadTime": "0.00s",
"failedPhysicalInputReadTime": "0.00s",
"internalNetworkInputDataSize": "0B",
"failedInternalNetworkInputDataSize": "0B",
"internalNetworkInputPositions": 0,
"failedInternalNetworkInputPositions": 0,
"rawInputDataSize": "0B",
"failedRawInputDataSize": "0B",
"rawInputPositions": 0,
"failedRawInputPositions": 0,
"processedInputDataSize": "0B",
"failedProcessedInputDataSize": "0B",
"processedInputPositions": 0,
"failedProcessedInputPositions": 0,
"inputBlockedTime": "0.00s",
"failedInputBlockedTime": "0.00s",
"bufferedDataSize": "0B",
"outputBufferUtilization": {
"digest": "AAAAAAAAAPB/AAAAAAAA8P8AAAAAAABZQAAAAAAAAAAAAAAAAA==",
"min": "NaN",
"max": "NaN",
"p25": "NaN",
"p50": "NaN",
"p75": "NaN",
"p90": "NaN",
"p95": "NaN",
"p99": "NaN",
"total": 0,
"p01": "NaN",
"p05": "NaN",
"p10": "NaN"
},
"outputDataSize": "0B",
"failedOutputDataSize": "0B",
"outputPositions": 0,
"failedOutputPositions": 0,
"outputBlockedTime": "0.00s",
"failedOutputBlockedTime": "0.00s",
"physicalWrittenDataSize": "0B",
"failedPhysicalWrittenDataSize": "0B",
"gcInfo": {
"stageId": 1,
"tasks": 1,
"fullGcTasks": 0,
"minFullGcSec": 0,
"maxFullGcSec": 0,
"totalFullGcSec": 0,
"averageFullGcSec": 0
},
"operatorSummaries": [
{
"stageId": 1,
"pipelineId": 0,
"operatorId": 0,
"planNodeId": "0",
"operatorType": "TableScanOperator",
"totalDrivers": 1,
"addInputCalls": 0,
"addInputWall": "0.00ns",
"addInputCpu": "0.00ns",
"physicalInputDataSize": "0B",
"physicalInputPositions": 0,
"physicalInputReadTime": "0.00ns",
"internalNetworkInputDataSize": "0B",
"internalNetworkInputPositions": 0,
"rawInputDataSize": "0B",
"inputDataSize": "0B",
"inputPositions": 0,
"sumSquaredInputPositions": 0,
"getOutputCalls": 0,
"getOutputWall": "0.00ns",
"getOutputCpu": "0.00ns",
"outputDataSize": "0B",
"outputPositions": 0,
"dynamicFilterSplitsProcessed": 0,
"metrics": {
"CPU time distribution (s)": {
"@class": "io.trino.execution.DistributionSnapshot",
"total": 1,
"min": 0,
"max": 0,
"p01": 0,
"p05": 0,
"p10": 0,
"p25": 0,
"p50": 0,
"p75": 0,
"p90": 0,
"p95": 0,
"p99": 0
},
"Input rows distribution": {
"@class": "io.trino.execution.DistributionSnapshot",
"total": 1,
"min": 0,
"max": 0,
"p01": 0,
"p05": 0,
"p10": 0,
"p25": 0,
"p50": 0,
"p75": 0,
"p90": 0,
"p95": 0,
"p99": 0
},
"Scheduled time distribution (s)": {
"@class": "io.trino.execution.DistributionSnapshot",
"total": 1,
"min": 0,
"max": 0,
"p01": 0,
"p05": 0,
"p10": 0,
"p25": 0,
"p50": 0,
"p75": 0,
"p90": 0,
"p95": 0,
"p99": 0
},
"Blocked time distribution (s)": {
"@class": "io.trino.execution.DistributionSnapshot",
"total": 1,
"min": 0,
"max": 0,
"p01": 0,
"p05": 0,
"p10": 0,
"p25": 0,
"p50": 0,
"p75": 0,
"p90": 0,
"p95": 0,
"p99": 0
}
},
"connectorMetrics": {
},
"pipelineMetrics": {
},
"physicalWrittenDataSize": "0B",
"blockedWall": "0.00ns",
"finishCalls": 0,
"finishWall": "0.00ns",
"finishCpu": "0.00ns",
"userMemoryReservation": "0B",
"revocableMemoryReservation": "0B",
"peakUserMemoryReservation": "0B",
"peakRevocableMemoryReservation": "0B",
"peakTotalMemoryReservation": "0B",
"spilledDataSize": "0B"
},
{
"stageId": 1,
"pipelineId": 0,
"operatorId": 2,
"planNodeId": "167",
"operatorType": "TaskOutputOperator",
"totalDrivers": 1,
"addInputCalls": 0,
"addInputWall": "0.00ns",
"addInputCpu": "0.00ns",
"physicalInputDataSize": "0B",
"physicalInputPositions": 0,
"physicalInputReadTime": "0.00ns",
"internalNetworkInputDataSize": "0B",
"internalNetworkInputPositions": 0,
"rawInputDataSize": "0B",
"inputDataSize": "0B",
"inputPositions": 0,
"sumSquaredInputPositions": 0,
"getOutputCalls": 0,
"getOutputWall": "0.00ns",
"getOutputCpu": "0.00ns",
"outputDataSize": "0B",
"outputPositions": 0,
"dynamicFilterSplitsProcessed": 0,
"metrics": {
"CPU time distribution (s)": {
"@class": "io.trino.execution.DistributionSnapshot",
"total": 1,
"min": 0.000002040999999999,
"max": 0.000002040999999999,
"p01": 0.000002040999999999,
"p05": 0.000002040999999999,
"p10": 0.000002040999999999,
"p25": 0.000002040999999999,
"p50": 0.000002040999999999,
"p75": 0.000002040999999999,
"p90": 0.000002040999999999,
"p95": 0.000002040999999999,
"p99": 0.000002040999999999
},
"Input rows distribution": {
"@class": "io.trino.execution.DistributionSnapshot",
"total": 1,
"min": 0,
"max": 0,
"p01": 0,
"p05": 0,
"p10": 0,
"p25": 0,
"p50": 0,
"p75": 0,
"p90": 0,
"p95": 0,
"p99": 0
},
"Scheduled time distribution (s)": {
"@class": "io.trino.execution.DistributionSnapshot",
"total": 1,
"min": 0.000001954,
"max": 0.000001954,
"p01": 0.000001954,
"p05": 0.000001954,
"p10": 0.000001954,
"p25": 0.000001954,
"p50": 0.000001954,
"p75": 0.000001954,
"p90": 0.000001954,
"p95": 0.000001954,
"p99": 0.000001954
},
"Blocked time distribution (s)": {
"@class": "io.trino.execution.DistributionSnapshot",
"total": 1,
"min": 0,
"max": 0,
"p01": 0,
"p05": 0,
"p10": 0,
"p25": 0,
"p50": 0,
"p75": 0,
"p90": 0,
"p95": 0,
"p99": 0
}
},
"connectorMetrics": {
},
"pipelineMetrics": {
},
"physicalWrittenDataSize": "0B",
"blockedWall": "0.00ns",
"finishCalls": 1,
"finishWall": "1.95us",
"finishCpu": "2.04us",
"userMemoryReservation": "0B",
"revocableMemoryReservation": "0B",
"peakUserMemoryReservation": "88B",
"peakRevocableMemoryReservation": "0B",
"peakTotalMemoryReservation": "88B",
"spilledDataSize": "0B"
},
{
"stageId": 1,
"pipelineId": 0,
"operatorId": 1,
"planNodeId": "167",
"operatorType": "LimitOperator",
"totalDrivers": 1,
"addInputCalls": 0,
"addInputWall": "0.00ns",
"addInputCpu": "0.00ns",
"physicalInputDataSize": "0B",
"physicalInputPositions": 0,
"physicalInputReadTime": "0.00ns",
"internalNetworkInputDataSize": "0B",
"internalNetworkInputPositions": 0,
"rawInputDataSize": "0B",
"inputDataSize": "0B",
"inputPositions": 0,
"sumSquaredInputPositions": 0,
"getOutputCalls": 0,
"getOutputWall": "0.00ns",
"getOutputCpu": "0.00ns",
"outputDataSize": "0B",
"outputPositions": 0,
"dynamicFilterSplitsProcessed": 0,
"metrics": {
"CPU time distribution (s)": {
"@class": "io.trino.execution.DistributionSnapshot",
"total": 1,
"min": 0.000014151999999999,
"max": 0.000014151999999999,
"p01": 0.000014151999999999,
"p05": 0.000014151999999999,
"p10": 0.000014151999999999,
"p25": 0.000014151999999999,
"p50": 0.000014151999999999,
"p75": 0.000014151999999999,
"p90": 0.000014151999999999,
"p95": 0.000014151999999999,
"p99": 0.000014151999999999
},
"Input rows distribution": {
"@class": "io.trino.execution.DistributionSnapshot",
"total": 1,
"min": 0,
"max": 0,
"p01": 0,
"p05": 0,
"p10": 0,
"p25": 0,
"p50": 0,
"p75": 0,
"p90": 0,
"p95": 0,
"p99": 0
},
"Scheduled time distribution (s)": {
"@class": "io.trino.execution.DistributionSnapshot",
"total": 1,
"min": 0.000016936,
"max": 0.000016936,
"p01": 0.000016936,
"p05": 0.000016936,
"p10": 0.000016936,
"p25": 0.000016936,
"p50": 0.000016936,
"p75": 0.000016936,
"p90": 0.000016936,
"p95": 0.000016936,
"p99": 0.000016936
},
"Blocked time distribution (s)": {
"@class": "io.trino.execution.DistributionSnapshot",
"total": 1,
"min": 0,
"max": 0,
"p01": 0,
"p05": 0,
"p10": 0,
"p25": 0,
"p50": 0,
"p75": 0,
"p90": 0,
"p95": 0,
"p99": 0
}
},
"connectorMetrics": {
},
"pipelineMetrics": {
},
"physicalWrittenDataSize": "0B",
"blockedWall": "0.00ns",
"finishCalls": 1,
"finishWall": "16.94us",
"finishCpu": "14.15us",
"userMemoryReservation": "0B",
"revocableMemoryReservation": "0B",
"peakUserMemoryReservation": "0B",
"peakRevocableMemoryReservation": "0B",
"peakTotalMemoryReservation": "0B",
"spilledDataSize": "0B"
}
]
},
"tasks": [
{
"taskStatus": {
"taskId": "20240911_144851_00236_b6249.1.0.0",
"taskInstanceId": "9a8b8f40-37fe-4cc2-b249-7a47e254cdfe",
"version": 2,
"state": "FINISHED",
"self": "http://some_host:8889/v1/task/20240911_144851_00236_b6249.1.0.0",
"nodeId": "trino-adhoc-test-worker038",
"speculative": false,
"failures": [],
"queuedPartitionedDrivers": 0,
"runningPartitionedDrivers": 0,
"outputBufferStatus": {
"outputBuffersVersion": 2,
"overutilized": false,
"exchangeSinkInstanceHandleUpdateRequired": false
},
"outputDataSize": "0B",
"writerInputDataSize": "0B",
"physicalWrittenDataSize": "0B",
"memoryReservation": "0B",
"peakMemoryReservation": "88B",
"revocableMemoryReservation": "0B",
"fullGcCount": 0,
"fullGcTime": "0.00ns",
"dynamicFiltersVersion": 0,
"queuedPartitionedSplitsWeight": 0,
"runningPartitionedSplitsWeight": 0
},
"lastHeartbeat": "2024-09-11T14:55:32.065Z",
"outputBuffers": {
"type": "PARTITIONED",
"state": "FINISHED",
"canAddBuffers": false,
"canAddPages": false,
"totalBufferedBytes": 0,
"totalBufferedPages": 0,
"totalRowsSent": 0,
"totalPagesSent": 0,
"utilization": {
"digest": "AAAAAAAAAPB/AAAAAAAA8P8AAAAAAABZQAAAAAAAAAAAAAAAAA==",
"min": "NaN",
"max": "NaN",
"p25": "NaN",
"p50": "NaN",
"p75": "NaN",
"p90": "NaN",
"p95": "NaN",
"p99": "NaN",
"total": 0,
"p01": "NaN",
"p05": "NaN",
"p10": "NaN"
}
},
"noMoreSplits": [
"0"
],
"stats": {
"createTime": "2024-09-11T14:55:32.036Z",
"firstStartTime": "2024-09-11T14:55:32.063Z",
"lastStartTime": "2024-09-11T14:55:32.063Z",
"lastEndTime": "2024-09-11T14:55:32.063Z",
"endTime": "2024-09-11T14:55:32.065Z",
"elapsedTime": "2.89ms",
"queuedTime": "1.01ms",
"totalDrivers": 1,
"queuedDrivers": 0,
"queuedPartitionedDrivers": 0,
"queuedPartitionedSplitsWeight": 0,
"runningDrivers": 0,
"runningPartitionedDrivers": 0,
"runningPartitionedSplitsWeight": 0,
"blockedDrivers": 0,
"completedDrivers": 1,
"cumulativeUserMemory": 73.568308,
"userMemoryReservation": "0B",
"peakUserMemoryReservation": "88B",
"revocableMemoryReservation": "0B",
"totalScheduledTime": "41.20us",
"totalCpuTime": "38.40us",
"totalBlockedTime": "0.00ns",
"fullyBlocked": false,
"blockedReasons": [],
"physicalInputDataSize": "0B",
"physicalInputPositions": 0,
"physicalInputReadTime": "0.00ns",
"internalNetworkInputDataSize": "0B",
"internalNetworkInputPositions": 0,
"rawInputDataSize": "0B",
"rawInputPositions": 0,
"processedInputDataSize": "0B",
"processedInputPositions": 0,
"inputBlockedTime": "0.00ns",
"outputDataSize": "0B",
"outputPositions": 0,
"outputBlockedTime": "0.00ns",
"writerInputDataSize": "0B",
"physicalWrittenDataSize": "0B",
"fullGcCount": 0,
"fullGcTime": "0.00ns",
"pipelines": [
{
"pipelineId": 0,
"firstStartTime": "2024-09-11T14:55:32.063Z",
"lastStartTime": "2024-09-11T14:55:32.063Z",
"lastEndTime": "2024-09-11T14:55:32.063Z",
"inputPipeline": true,
"outputPipeline": true,
"totalDrivers": 1,
"queuedDrivers": 0,
"queuedPartitionedDrivers": 0,
"queuedPartitionedSplitsWeight": 0,
"runningDrivers": 0,
"runningPartitionedDrivers": 0,
"runningPartitionedSplitsWeight": 0,
"blockedDrivers": 0,
"completedDrivers": 1,
"userMemoryReservation": "0B",
"revocableMemoryReservation": "0B",
"queuedTime": {
"count": 1,
"total": 592273,
"p01": 592273,
"p05": 592273,
"p10": 592273,
"p25": 592273,
"p50": 592273,
"p75": 592273,
"p90": 592273,
"p95": 592273,
"p99": 592273,
"min": 592273,
"max": 592273,
"avg": 592273
},
"elapsedTime": {
"count": 1,
"total": 630479,
"p01": 630479,
"p05": 630479,
"p10": 630479,
"p25": 630479,
"p50": 630479,
"p75": 630479,
"p90": 630479,
"p95": 630479,
"p99": 630479,
"min": 630479,
"max": 630479,
"avg": 630479
},
"totalScheduledTime": "41.20us",
"totalCpuTime": "38.40us",
"totalBlockedTime": "0.00ns",
"fullyBlocked": false,
"blockedReasons": [],
"physicalInputDataSize": "0B",
"physicalInputPositions": 0,
"physicalInputReadTime": "0.00ns",
"internalNetworkInputDataSize": "0B",
"internalNetworkInputPositions": 0,
"rawInputDataSize": "0B",
"rawInputPositions": 0,
"processedInputDataSize": "0B",
"processedInputPositions": 0,
"inputBlockedTime": "0.00ns",
"outputDataSize": "0B",
"outputPositions": 0,
"outputBlockedTime": "0.00ns",
"physicalWrittenDataSize": "0B",
"operatorSummaries": [
{
"stageId": 1,
"pipelineId": 0,
"operatorId": 0,
"planNodeId": "0",
"operatorType": "TableScanOperator",
"totalDrivers": 1,
"addInputCalls": 0,
"addInputWall": "0.00ns",
"addInputCpu": "0.00ns",
"physicalInputDataSize": "0B",
"physicalInputPositions": 0,
"physicalInputReadTime": "0.00ns",
"internalNetworkInputDataSize": "0B",
"internalNetworkInputPositions": 0,
"rawInputDataSize": "0B",
"inputDataSize": "0B",
"inputPositions": 0,
"sumSquaredInputPositions": 0,
"getOutputCalls": 0,
"getOutputWall": "0.00ns",
"getOutputCpu": "0.00ns",
"outputDataSize": "0B",
"outputPositions": 0,
"dynamicFilterSplitsProcessed": 0,
"metrics": {
"Input rows distribution": {
"@class": "io.trino.plugin.base.metrics.TDigestHistogram",
"digest": "AAAAAAAAAAAAAAAAAAAAAAAAAAAAAABZQAAAAAAAAPA/AQAAAAAAAAAAAAAAAAAAAAAA8D8=",
"min": 0,
"max": 0,
"p25": 0,
"p50": 0,
"p75": 0,
"p90": 0,
"p95": 0,
"p99": 0,
"total": 1,
"p01": 0,
"p05": 0,
"p10": 0
},
"CPU time distribution (s)": {
"@class": "io.trino.plugin.base.metrics.TDigestHistogram",
"digest": "AAAAAAAAAAAAAAAAAAAAAAAAAAAAAABZQAAAAAAAAPA/AQAAAAAAAAAAAAAAAAAAAAAA8D8=",
"min": 0,
"max": 0,
"p25": 0,
"p50": 0,
"p75": 0,
"p90": 0,
"p95": 0,
"p99": 0,
"total": 1,
"p01": 0,
"p05": 0,
"p10": 0
},
"Scheduled time distribution (s)": {
"@class": "io.trino.plugin.base.metrics.TDigestHistogram",
"digest": "AAAAAAAAAAAAAAAAAAAAAAAAAAAAAABZQAAAAAAAAPA/AQAAAAAAAAAAAAAAAAAAAAAA8D8=",
"min": 0,
"max": 0,
"p25": 0,
"p50": 0,
"p75": 0,
"p90": 0,
"p95": 0,
"p99": 0,
"total": 1,
"p01": 0,
"p05": 0,
"p10": 0
},
"Blocked time distribution (s)": {
"@class": "io.trino.plugin.base.metrics.TDigestHistogram",
"digest": "AAAAAAAAAAAAAAAAAAAAAAAAAAAAAABZQAAAAAAAAPA/AQAAAAAAAAAAAAAAAAAAAAAA8D8=",
"min": 0,
"max": 0,
"p25": 0,
"p50": 0,
"p75": 0,
"p90": 0,
"p95": 0,
"p99": 0,
"total": 1,
"p01": 0,
"p05": 0,
"p10": 0
}
},
"connectorMetrics": {
},
"pipelineMetrics": {
},
"physicalWrittenDataSize": "0B",
"blockedWall": "0.00ns",
"finishCalls": 0,
"finishWall": "0.00ns",
"finishCpu": "0.00ns",
"userMemoryReservation": "0B",
"revocableMemoryReservation": "0B",
"peakUserMemoryReservation": "0B",
"peakRevocableMemoryReservation": "0B",
"peakTotalMemoryReservation": "0B",
"spilledDataSize": "0B"
},
{
"stageId": 1,
"pipelineId": 0,
"operatorId": 1,
"planNodeId": "167",
"operatorType": "LimitOperator",
"totalDrivers": 1,
"addInputCalls": 0,
"addInputWall": "0.00ns",
"addInputCpu": "0.00ns",
"physicalInputDataSize": "0B",
"physicalInputPositions": 0,
"physicalInputReadTime": "0.00ns",
"internalNetworkInputDataSize": "0B",
"internalNetworkInputPositions": 0,
"rawInputDataSize": "0B",
"inputDataSize": "0B",
"inputPositions": 0,
"sumSquaredInputPositions": 0,
"getOutputCalls": 0,
"getOutputWall": "0.00ns",
"getOutputCpu": "0.00ns",
"outputDataSize": "0B",
"outputPositions": 0,
"dynamicFilterSplitsProcessed": 0,
"metrics": {
"Input rows distribution": {
"@class": "io.trino.plugin.base.metrics.TDigestHistogram",
"digest": "AAAAAAAAAAAAAAAAAAAAAAAAAAAAAABZQAAAAAAAAPA/AQAAAAAAAAAAAAAAAAAAAAAA8D8=",
"min": 0,
"max": 0,
"p25": 0,
"p50": 0,
"p75": 0,
"p90": 0,
"p95": 0,
"p99": 0,
"total": 1,
"p01": 0,
"p05": 0,
"p10": 0
},
"CPU time distribution (s)": {
"@class": "io.trino.plugin.base.metrics.TDigestHistogram",
"digest": "ADEYzRHMre0+MRjNEcyt7T4AAAAAAABZQAAAAAAAAPA/AQAAADEYzRHMre0+AAAAAAAA8D8=",
"min": 0.000014151999999999,
"max": 0.000014151999999999,
"p25": 0.000014151999999999,
"p50": 0.000014151999999999,
"p75": 0.000014151999999999,
"p90": 0.000014151999999999,
"p95": 0.000014151999999999,
"p99": 0.000014151999999999,
"total": 1,
"p01": 0.000014151999999999,
"p05": 0.000014151999999999,
"p10": 0.000014151999999999
},
"Scheduled time distribution (s)": {
"@class": "io.trino.plugin.base.metrics.TDigestHistogram",
"digest": "AI8l2Q45wvE+jyXZDjnC8T4AAAAAAABZQAAAAAAAAPA/AQAAAI8l2Q45wvE+AAAAAAAA8D8=",
"min": 0.000016936,
"max": 0.000016936,
"p25": 0.000016936,
"p50": 0.000016936,
"p75": 0.000016936,
"p90": 0.000016936,
"p95": 0.000016936,
"p99": 0.000016936,
"total": 1,
"p01": 0.000016936,
"p05": 0.000016936,
"p10": 0.000016936
},
"Blocked time distribution (s)": {
"@class": "io.trino.plugin.base.metrics.TDigestHistogram",
"digest": "AAAAAAAAAAAAAAAAAAAAAAAAAAAAAABZQAAAAAAAAPA/AQAAAAAAAAAAAAAAAAAAAAAA8D8=",
"min": 0,
"max": 0,
"p25": 0,
"p50": 0,
"p75": 0,
"p90": 0,
"p95": 0,
"p99": 0,
"total": 1,
"p01": 0,
"p05": 0,
"p10": 0
}
},
"connectorMetrics": {
},
"pipelineMetrics": {
},
"physicalWrittenDataSize": "0B",
"blockedWall": "0.00ns",
"finishCalls": 1,
"finishWall": "16.94us",
"finishCpu": "14.15us",
"userMemoryReservation": "0B",
"revocableMemoryReservation": "0B",
"peakUserMemoryReservation": "0B",
"peakRevocableMemoryReservation": "0B",
"peakTotalMemoryReservation": "0B",
"spilledDataSize": "0B"
},
{
"stageId": 1,
"pipelineId": 0,
"operatorId": 2,
"planNodeId": "167",
"operatorType": "TaskOutputOperator",
"totalDrivers": 1,
"addInputCalls": 0,
"addInputWall": "0.00ns",
"addInputCpu": "0.00ns",
"physicalInputDataSize": "0B",
"physicalInputPositions": 0,
"physicalInputReadTime": "0.00ns",
"internalNetworkInputDataSize": "0B",
"internalNetworkInputPositions": 0,
"rawInputDataSize": "0B",
"inputDataSize": "0B",
"inputPositions": 0,
"sumSquaredInputPositions": 0,
"getOutputCalls": 0,
"getOutputWall": "0.00ns",
"getOutputCpu": "0.00ns",
"outputDataSize": "0B",
"outputPositions": 0,
"dynamicFilterSplitsProcessed": 0,
"metrics": {
"Input rows distribution": {
"@class": "io.trino.plugin.base.metrics.TDigestHistogram",
"digest": "AAAAAAAAAAAAAAAAAAAAAAAAAAAAAABZQAAAAAAAAPA/AQAAAAAAAAAAAAAAAAAAAAAA8D8=",
"min": 0,
"max": 0,
"p25": 0,
"p50": 0,
"p75": 0,
"p90": 0,
"p95": 0,
"p99": 0,
"total": 1,
"p01": 0,
"p05": 0,
"p10": 0
},
"CPU time distribution (s)": {
"@class": "io.trino.plugin.base.metrics.TDigestHistogram",
"digest": "AJi0u50DH8E+mLS7nQMfwT4AAAAAAABZQAAAAAAAAPA/AQAAAJi0u50DH8E+AAAAAAAA8D8=",
"min": 0.000002040999999999,
"max": 0.000002040999999999,
"p25": 0.000002040999999999,
"p50": 0.000002040999999999,
"p75": 0.000002040999999999,
"p90": 0.000002040999999999,
"p95": 0.000002040999999999,
"p99": 0.000002040999999999,
"total": 1,
"p01": 0.000002040999999999,
"p05": 0.000002040999999999,
"p10": 0.000002040999999999
},
"Scheduled time distribution (s)": {
"@class": "io.trino.plugin.base.metrics.TDigestHistogram",
"digest": "ADsOP9wuZMA+Ow4/3C5kwD4AAAAAAABZQAAAAAAAAPA/AQAAADsOP9wuZMA+AAAAAAAA8D8=",
"min": 0.000001954,
"max": 0.000001954,
"p25": 0.000001954,
"p50": 0.000001954,
"p75": 0.000001954,
"p90": 0.000001954,
"p95": 0.000001954,
"p99": 0.000001954,
"total": 1,
"p01": 0.000001954,
"p05": 0.000001954,
"p10": 0.000001954
},
"Blocked time distribution (s)": {
"@class": "io.trino.plugin.base.metrics.TDigestHistogram",
"digest": "AAAAAAAAAAAAAAAAAAAAAAAAAAAAAABZQAAAAAAAAPA/AQAAAAAAAAAAAAAAAAAAAAAA8D8=",
"min": 0,
"max": 0,
"p25": 0,
"p50": 0,
"p75": 0,
"p90": 0,
"p95": 0,
"p99": 0,
"total": 1,
"p01": 0,
"p05": 0,
"p10": 0
}
},
"connectorMetrics": {
},
"pipelineMetrics": {
},
"physicalWrittenDataSize": "0B",
"blockedWall": "0.00ns",
"finishCalls": 1,
"finishWall": "1.95us",
"finishCpu": "2.04us",
"userMemoryReservation": "0B",
"revocableMemoryReservation": "0B",
"peakUserMemoryReservation": "88B",
"peakRevocableMemoryReservation": "0B",
"peakTotalMemoryReservation": "88B",
"spilledDataSize": "0B"
}
],
"drivers": []
}
]
},
"needsPlan": false
}
],
"subStages": [],
"tables": {
"0": {
"connectorName": "iceberg",
"tableName": "table_name",
"predicate": {
"columnDomains": [
{
"column": {
"@type": "iceberg:io.trino.plugin.iceberg.IcebergColumnHandle",
"baseColumnIdentity": {
"id": 24,
"name": "dt",
"typeCategory": "PRIMITIVE",
"children": []
},
"baseType": "varchar",
"path": [],
"type": "varchar",
"nullable": true
},
"domain": {
"values": {
"@type": "sortable",
"type": "varchar",
"inclusive": [false, false],
"sortedRanges": "DgAAAFZBUklBQkxFX1dJRFRIAgAAAAIAAAAKAAAACgAAAAAUAAAAMjAyNC0wOC0wMTIwMjQtMDgtMDM=",
"discreteSetMarker": "UNKNOWN"
},
"nullAllowed": false
}
}
]
}
}
}
}
],
"tables": {
}
},
"warnings": [],
"inputs": [
{
"catalogName": "catalog",
"catalogVersion": "default",
"schema": "schema",
"table": "table_name",
"connectorInfo": {
"snapshotId": 5.540801958347984e+18,
"partitioned": true,
"tableDefaultFileFormat": "PARQUET"
},
"columns": [
{
"name": "dt",
"type": "varchar"
}
],
"fragmentId": "1",
"planNodeId": "0"
}
],
"referencedTables": [
{
"catalog": "catalog",
"schema": "schema",
"table": "table_name",
"authorization": "user_name",
"filters": [],
"columns": [
{
"column": "dt"
}
],
"directlyReferenced": true,
"referenceChain": []
}
],
"routines": [],
"finalQueryInfo": true,
"resourceGroupId": [
"DML"
],
"queryType": "SELECT",
"retryPolicy": "NONE",
"pruned": false,
"version": {
"version": "454"
},
"scheduled": true,
"progressPercentage": 100,
"runningPercentage": 0
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment