CitiBike-External-S3 - Details for Query 0

Submitted Time: 2026/10/18 15:53:02
Duration: 3 s
Succeeded Jobs: 0 1

Show the Stage ID and Task ID that corresponds to the max metric

digraph G { 0 [labelType="html" label=" AdaptiveSparkPlan "]; subgraph cluster1 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: 7 ms"; 2 [labelType="html" label="HashAggregate time in aggregation build: 6 ms number of output rows: 1"]; } 3 [labelType="html" label="Exchange shuffle records written: 2 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 26 ms (0 ms, 13 ms, 13 ms (stage 0.0: task 0)) remote merged bytes read: 0.0 B local merged blocks fetched: 0 corrupt merged block chunks: 0 remote merged reqs duration: 0 ms remote merged blocks fetched: 0 records read: 2 local bytes read: 115.0 B fetch wait time: 0 ms remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 2 remote merged chunks fetched: 0 remote blocks read: 0 data size total (min, med, max (stageId: taskId)) 32.0 B (0.0 B, 16.0 B, 16.0 B (stage 0.0: task 0)) local merged bytes read: 0.0 B number of partitions: 1 remote reqs duration: 0 ms remote bytes read to disk: 0.0 B shuffle bytes written total (min, med, max (stageId: taskId)) 115.0 B (0.0 B, 56.0 B, 59.0 B (stage 0.0: task 1))"]; subgraph cluster4 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n52 ms (26 ms, 26 ms, 26 ms (stage 0.0: task 0))"; 5 [labelType="html" label="HashAggregate time in aggregation build total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 0.0: task 0)) number of output rows: 2"]; 6 [labelType="html" label=" Project "]; 7 [labelType="html" label="Range number of output rows: 1"]; } 2->0; 3->2; 5->3; 6->5; 7->6; }

AdaptiveSparkPlan isFinalPlan=true

HashAggregate(keys=[], functions=[count(1)])

WholeStageCodegen (2)

Exchange SinglePartition, ENSURE_REQUIREMENTS, [plan_id=23]

HashAggregate(keys=[], functions=[partial_count(1)])

Project

Range (0, 1, step=1, splits=2)

WholeStageCodegen (1)

Details

== Physical Plan ==
AdaptiveSparkPlan (9)
+- == Final Plan ==
   * HashAggregate (6)
   +- ShuffleQueryStage (5), Statistics(sizeInBytes=32.0 B, rowCount=2)
      +- Exchange (4)
         +- * HashAggregate (3)
            +- * Project (2)
               +- * Range (1)
+- == Initial Plan ==
   HashAggregate (8)
   +- Exchange (7)
      +- HashAggregate (3)
         +- Project (2)
            +- Range (1)


(1) Range [codegen id : 1]
Output [1]: [id#0L]
Arguments: Range (0, 1, step=1, splits=Some(2))

(2) Project [codegen id : 1]
Output: []
Input [1]: [id#0L]

(3) HashAggregate [codegen id : 1]
Input: []
Keys: []
Functions [1]: [partial_count(1)]
Aggregate Attributes [1]: [count#6L]
Results [1]: [count#7L]

(4) Exchange
Input [1]: [count#7L]
Arguments: SinglePartition, ENSURE_REQUIREMENTS, [plan_id=23]

(5) ShuffleQueryStage
Output [1]: [count#7L]
Arguments: 0

(6) HashAggregate [codegen id : 2]
Input [1]: [count#7L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#3L]
Results [1]: [count(1)#3L AS count#4L]

(7) Exchange
Input [1]: [count#7L]
Arguments: SinglePartition, ENSURE_REQUIREMENTS, [plan_id=15]

(8) HashAggregate
Input [1]: [count#7L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#3L]
Results [1]: [count(1)#3L AS count#4L]

(9) AdaptiveSparkPlan
Output [1]: [count#4L]
Arguments: isFinalPlan=true