Skip to content

Instantly share code, notes, and snippets.

/Fast query Secret
Created May 15, 2017

Embed
What would you like to do?
This file has been truncated, but you can view the full file.
Query (id=514ee9ab39cdc507:7b38551b00000000):
Summary:
Session ID: c44bdbae62c1e2cb:799ff15c4a08fb98
Session Type: HIVESERVER2
HiveServer2 Protocol Version: V6
Start Time: 2017-05-15 11:32:21.898800000
End Time: 2017-05-15 11:44:40.288157000
Query Type: QUERY
Query State: FINISHED
Query Status: OK
Impala Version: impalad version 2.7.0-cdh5.10.1 RELEASE (build 876895d2a90346e69f2aea02d5528c2125ae7a32)
User: hdfs
Connected User: hdfs
Delegated User:
Network Address: ::ffff:172.16.0.220:57996
Default Db: 24x7_prod
Sql Statement: SELECT `@associative_tag.Propensity`,
`@dataset_a.Device`,
`y`,
x_rank,
seg_rank
FROM
(SELECT `@associative_tag.Propensity`,
`@dataset_a.Device`,
`y`,
x_rank,
dense_rank() over(
ORDER BY `y__SUM` DESC, `@dataset_a.Device` ASC) seg_rank
FROM
(SELECT `@associative_tag.Propensity`,
`@dataset_a.Device`,
`y`,
x_rank,
sum(`y`) over(partition BY `@dataset_a.Device`) `y__SUM`
FROM
(SELECT `@associative_tag.Propensity`,
`@dataset_a.Device`,
`y`,
dense_rank() over(
ORDER BY `y__SUM` DESC, `@associative_tag.Propensity`) x_rank
FROM
(SELECT `@associative_tag.Propensity`,
`@dataset_a.Device`,
`y`,
sum(`y`) over(partition BY `@associative_tag.Propensity`) `y__SUM`
FROM
(SELECT `@dataset_a.Device`,
`@associative_tag.Propensity`,
count(DISTINCT if(1 = 1, `@dataset_a.header_associativetag__LEVEL`, NULL)) `y`
FROM
(SELECT `@dataset_a.header_associativetag`,
min(if(1 = 1, `@dataset_a.header_associativetag`, NULL)) `@dataset_a.header_associativetag__LEVEL`
FROM
(SELECT `header_associativetag` `@dataset_a.header_associativetag`
FROM dataset_a_batch
WHERE `cuberon_event_date` BETWEEN "2017-04-23" AND "2017-05-07") Q1
GROUP BY `@dataset_a.header_associativetag`) Q2
JOIN
(SELECT `@dataset_a.header_associativetag` __JOIN_KEY0__,
`@dataset_a.Device`,
`__LEVEL_EXISTS__`
FROM
(SELECT `@dataset_a.header_associativetag`,
`@dataset_a.Device`,
`__LEVEL_EXISTS__`
FROM
(SELECT `@dataset_a.header_associativetag`,
`@dataset_a.Device`,
sum(if(1 = 1, 1, 0)) > 0 `__LEVEL_EXISTS__`
FROM
(SELECT `header_associativetag` `@dataset_a.header_associativetag`,
`body_customproperties_devicedetails_value` `@dataset_a.Device`
FROM dataset_a_batch
WHERE `cuberon_event_date` BETWEEN "2017-04-23" AND "2017-05-07") Q1
GROUP BY `@dataset_a.header_associativetag`,
`@dataset_a.Device`) Q2) __JOIN_QUERY__) __subquery0__ ON Q2.`@dataset_a.header_associativetag` = __subquery0__.__JOIN_KEY0__
LEFT OUTER JOIN
(SELECT `@dataset_a.header_associativetag` __JOIN_KEY0__,
`@associative_tag.Propensity`
FROM
(SELECT `@dataset_a.header_associativetag`,
`@associative_tag.Propensity`
FROM
(SELECT `@dataset_a.header_associativetag`,
min(if(1 = 1, `@dataset_a.Propensity`, NULL)) `@associative_tag.Propensity`
FROM
(SELECT `header_associativetag` `@dataset_a.header_associativetag`,
`body_customproperties_eventdata_value_f_c_ops` `@dataset_a.Propensity`,
`cuberon_event_epoch_target` `@Event.Event Time`
FROM dataset_a_batch
WHERE `cuberon_event_date` BETWEEN "2017-04-23" AND "2017-05-07") Q1
JOIN
(SELECT `@dataset_a.header_associativetag` __JOIN_KEY0__,
`@associative_tag.Propensity__JOINER`
FROM
(SELECT `@dataset_a.header_associativetag`,
`@associative_tag.Propensity__JOINER`
FROM
(SELECT `@dataset_a.header_associativetag`,
max(if(1 = 1, `@Event.Event Time`, NULL)) `@associative_tag.Propensity__JOINER`
FROM
(SELECT `header_associativetag` `@dataset_a.header_associativetag`,
`body_customproperties_eventdata_value_f_c_ops` `@dataset_a.Propensity`,
`cuberon_event_epoch_target` `@Event.Event Time`
FROM dataset_a_batch
WHERE `cuberon_event_date` BETWEEN "2017-04-23" AND "2017-05-07") Q1
WHERE `@dataset_a.Propensity` IS NOT NULL
GROUP BY `@dataset_a.header_associativetag`) Q2) __JOIN_QUERY__) __subquery0__ ON Q1.`@dataset_a.header_associativetag` = __subquery0__.__JOIN_KEY0__
AND Q1.`@Event.Event Time` = __subquery0__.`@associative_tag.Propensity__JOINER`
GROUP BY `@dataset_a.header_associativetag`) Q2) __JOIN_QUERY__) __subquery1__ ON Q2.`@dataset_a.header_associativetag` = __subquery1__.__JOIN_KEY0__
WHERE (`@associative_tag.Propensity` = 'Business-Medium'
AND `@associative_tag.Propensity` IS NOT NULL)
GROUP BY `@dataset_a.Device`,
`@associative_tag.Propensity`) XR1) XR2 ) SR1
WHERE x_rank <= 10) SR2 ) SR3
WHERE seg_rank <= 20
ORDER BY seg_rank,
x_rank
Coordinator: cdh1.net.cuberonlabs.com:22000
Query Options (non default): QUERY_TIMEOUT_S=600,MT_DOP=0
Plan:
----------------
Estimated Per-Host Requirements: Memory=21.30GB VCores=3
PLAN-ROOT SINK
|
23:SORT
| order by: seg_rank ASC, x_rank ASC
| hosts=17 per-host-mem=unavailable
| tuple-ids=35 row-size=76B cardinality=23
|
22:SELECT
| predicates: dense_rank() <= 20
| hosts=17 per-host-mem=unavailable
| tuple-ids=48,47 row-size=92B cardinality=23
|
21:ANALYTIC
| functions: dense_rank()
| order by: sum(y) DESC, `@dataset_a.Device` ASC
| window: RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW
| hosts=17 per-host-mem=unavailable
| tuple-ids=48,47 row-size=92B cardinality=227
|
40:MERGING-EXCHANGE [UNPARTITIONED]
| order by: sum(y) DESC, `@dataset_a.Device` ASC
| hosts=17 per-host-mem=unavailable
| tuple-ids=48 row-size=84B cardinality=227
|
20:SORT
| order by: sum(y) DESC, `@dataset_a.Device` ASC
| hosts=17 per-host-mem=16.00MB
| tuple-ids=48 row-size=84B cardinality=227
|
19:ANALYTIC
| functions: sum(count(if(TRUE, `@dataset_a.header_associativetag__LEVEL`, NULL)))
| partition by: `@dataset_a.Device`
| hosts=17 per-host-mem=0B
| tuple-ids=44,43 row-size=84B cardinality=227
|
18:SORT
| order by: `@dataset_a.Device` ASC NULLS FIRST
| hosts=17 per-host-mem=16.00MB
| tuple-ids=44 row-size=76B cardinality=227
|
39:EXCHANGE [HASH(`@dataset_a.Device`)]
| hosts=17 per-host-mem=0B
| tuple-ids=41,40 row-size=76B cardinality=227
|
17:SELECT
| predicates: dense_rank() <= 10
| hosts=17 per-host-mem=unavailable
| tuple-ids=41,40 row-size=76B cardinality=227
|
16:ANALYTIC
| functions: dense_rank()
| order by: sum(y) DESC, `@associative_tag.Propensity` ASC
| window: RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW
| hosts=17 per-host-mem=unavailable
| tuple-ids=41,40 row-size=76B cardinality=2266
|
38:MERGING-EXCHANGE [UNPARTITIONED]
| order by: sum(y) DESC, `@associative_tag.Propensity` ASC
| hosts=17 per-host-mem=unavailable
| tuple-ids=41 row-size=68B cardinality=2266
|
15:SORT
| order by: sum(y) DESC, `@associative_tag.Propensity` ASC
| hosts=17 per-host-mem=16.00MB
| tuple-ids=41 row-size=68B cardinality=2266
|
14:ANALYTIC
| functions: sum(count(if(TRUE, `@dataset_a.header_associativetag__LEVEL`, NULL)))
| partition by: `@associative_tag.Propensity`
| hosts=17 per-host-mem=0B
| tuple-ids=37,36 row-size=68B cardinality=2266
|
13:SORT
| order by: `@associative_tag.Propensity` ASC NULLS FIRST
| hosts=17 per-host-mem=16.00MB
| tuple-ids=37 row-size=60B cardinality=2266
|
37:EXCHANGE [HASH(`@associative_tag.Propensity`)]
| hosts=17 per-host-mem=0B
| tuple-ids=23 row-size=60B cardinality=2266
|
12:AGGREGATE [FINALIZE]
| output: count(if(TRUE, `@dataset_a.header_associativetag__LEVEL`, NULL))
| group by: `@dataset_a.Device`, `@associative_tag.Propensity`
| hosts=17 per-host-mem=10.00MB
| tuple-ids=23 row-size=60B cardinality=2266
|
36:AGGREGATE
| group by: `@dataset_a.Device`, `@associative_tag.Propensity`, if(TRUE, `@dataset_a.header_associativetag__LEVEL`, NULL)
| hosts=17 per-host-mem=2.89GB
| tuple-ids=22 row-size=68B cardinality=41522992
|
35:EXCHANGE [HASH(`@dataset_a.Device`,`@associative_tag.Propensity`)]
| hosts=17 per-host-mem=0B
| tuple-ids=22 row-size=68B cardinality=41522992
|
11:AGGREGATE [STREAMING]
| group by: `@dataset_a.Device`, min(if(TRUE, `@dataset_a.Propensity`, NULL)), if(TRUE, min(if(TRUE, `@dataset_a.header_associativetag`, NULL)), NULL)
| hosts=17 per-host-mem=2.89GB
| tuple-ids=22 row-size=68B cardinality=41522992
|
10:HASH JOIN [LEFT OUTER JOIN, PARTITIONED]
| hash predicates: `@dataset_a.header_associativetag` = `@dataset_a.header_associativetag`
| other predicates: min(if(TRUE, `@dataset_a.Propensity`, NULL)) IS NOT NULL, min(if(TRUE, `@dataset_a.Propensity`, NULL)) = 'Business-Medium'
| hosts=17 per-host-mem=3.12MB
| tuple-ids=6,2,18N row-size=251B cardinality=41522992
|
|--34:AGGREGATE [FINALIZE]
| | output: min:merge(if(TRUE, `@dataset_a.Propensity`, NULL))
| | group by: `@dataset_a.header_associativetag`
| | having: min(if(TRUE, `@dataset_a.Propensity`, NULL)) IS NOT NULL, min(if(TRUE, `@dataset_a.Propensity`, NULL)) = 'Business-Medium'
| | hosts=17 per-host-mem=52.96MB
| | tuple-ids=18 row-size=77B cardinality=655319
| |
| 33:EXCHANGE [HASH(`@dataset_a.header_associativetag`)]
| | hosts=17 per-host-mem=0B
| | tuple-ids=18 row-size=77B cardinality=17897362
| |
| 08:AGGREGATE [STREAMING]
| | output: min(if(TRUE, body_customproperties_eventdata_value_f_c_ops, NULL))
| | group by: header_associativetag
| | hosts=17 per-host-mem=216.74MB
| | tuple-ids=18 row-size=77B cardinality=17897362
| |
| 07:HASH JOIN [INNER JOIN, PARTITIONED]
| | hash predicates: cuberon_event_epoch_target = max(if(TRUE, `@Event.Event Time`, NULL)), header_associativetag = `@dataset_a.header_associativetag`
| | runtime filters: RF001 <- max(if(TRUE, `@Event.Event Time`, NULL)), RF002 <- `@dataset_a.header_associativetag`
| | hosts=17 per-host-mem=83.72MB
| | tuple-ids=10,14 row-size=167B cardinality=17897362
| |
| |--32:EXCHANGE [HASH(max(if(TRUE, `@Event.Event Time`, NULL)),`@dataset_a.header_associativetag`)]
| | | hosts=17 per-host-mem=0B
| | | tuple-ids=14 row-size=69B cardinality=19650614
| | |
| | 30:AGGREGATE [FINALIZE]
| | | output: max:merge(if(TRUE, `@Event.Event Time`, NULL))
| | | group by: `@dataset_a.header_associativetag`
| | | hosts=17 per-host-mem=194.24MB
| | | tuple-ids=14 row-size=69B cardinality=19650614
| | |
| | 29:EXCHANGE [HASH(`@dataset_a.header_associativetag`)]
| | | hosts=17 per-host-mem=0B
| | | tuple-ids=14 row-size=69B cardinality=19650614
| | |
| | 06:AGGREGATE [STREAMING]
| | | output: max(if(TRUE, cuberon_event_epoch_target, NULL))
| | | group by: header_associativetag
| | | hosts=17 per-host-mem=1.39GB
| | | tuple-ids=14 row-size=69B cardinality=19650614
| | |
| | 05:SCAN HDFS [24x7_prod.dataset_a_batch, RANDOM]
| | partitions=7/8 files=503 size=46.87GB
| | predicates: 24x7_prod.dataset_a_batch.body_customproperties_eventdata_value_f_c_ops IS NOT NULL
| | table stats: 215756183 rows total
| | column stats: all
| | hosts=17 per-host-mem=264.00MB
| | tuple-ids=12 row-size=98B cardinality=19650614
| |
| 31:EXCHANGE [HASH(cuberon_event_epoch_target,header_associativetag)]
| | hosts=17 per-host-mem=0B
| | tuple-ids=10 row-size=98B cardinality=196506140
| |
| 04:SCAN HDFS [24x7_prod.dataset_a_batch, RANDOM]
| partitions=7/8 files=503 size=46.87GB
| runtime filters: RF001 -> cuberon_event_epoch_target, RF002 -> header_associativetag
| table stats: 215756183 rows total
| column stats: all
| hosts=17 per-host-mem=264.00MB
| tuple-ids=10 row-size=98B cardinality=196506140
|
09:HASH JOIN [INNER JOIN, PARTITIONED]
| hash predicates: `@dataset_a.header_associativetag` = `@dataset_a.header_associativetag`
| runtime filters: RF000 <- `@dataset_a.header_associativetag`
| hosts=17 per-host-mem=216.74MB
| tuple-ids=6,2 row-size=174B cardinality=41522992
|
|--27:AGGREGATE [FINALIZE]
| | output: min:merge(if(TRUE, `@dataset_a.header_associativetag`, NULL))
| | group by: `@dataset_a.header_associativetag`
| | hosts=17 per-host-mem=216.74MB
| | tuple-ids=2 row-size=77B cardinality=45590648
| |
| 26:EXCHANGE [HASH(`@dataset_a.header_associativetag`)]
| | hosts=17 per-host-mem=0B
| | tuple-ids=2 row-size=77B cardinality=45590648
| |
| 01:AGGREGATE [STREAMING]
| | output: min(if(TRUE, header_associativetag, NULL))
| | group by: header_associativetag
| | hosts=17 per-host-mem=3.60GB
| | tuple-ids=2 row-size=77B cardinality=45590648
| |
| 00:SCAN HDFS [24x7_prod.dataset_a_batch, RANDOM]
| partitions=7/8 files=503 size=46.87GB
| table stats: 215756183 rows total
| column stats: all
| hosts=17 per-host-mem=88.00MB
| tuple-ids=0 row-size=61B cardinality=196506140
|
28:EXCHANGE [HASH(`@dataset_a.header_associativetag`)]
| hosts=17 per-host-mem=0B
| tuple-ids=6 row-size=97B cardinality=196506140
|
25:AGGREGATE [FINALIZE]
| group by: `@dataset_a.header_associativetag`, `@dataset_a.Device`
| hosts=17 per-host-mem=1.60GB
| tuple-ids=6 row-size=97B cardinality=196506140
|
24:EXCHANGE [HASH(`@dataset_a.header_associativetag`,`@dataset_a.Device`)]
| hosts=17 per-host-mem=0B
| tuple-ids=6 row-size=97B cardinality=196506140
|
03:AGGREGATE [STREAMING]
| group by: header_associativetag, body_customproperties_devicedetails_value
| hosts=17 per-host-mem=19.53GB
| tuple-ids=6 row-size=97B cardinality=196506140
|
02:SCAN HDFS [24x7_prod.dataset_a_batch, RANDOM]
partitions=7/8 files=503 size=46.87GB
runtime filters: RF000 -> 24x7_prod.dataset_a_batch.header_associativetag
table stats: 215756183 rows total
column stats: all
hosts=17 per-host-mem=176.00MB
tuple-ids=4 row-size=97B cardinality=196506140
----------------
Estimated Per-Host Mem: 22872427775
Estimated Per-Host VCores: 3
Request Pool: root.hdfs
Admission result: Admitted immediately
ExecSummary:
Operator #Hosts Avg Time Max Time #Rows Est. #Rows Peak Mem Est. Peak Mem Detail
----------------------------------------------------------------------------------------------------------------------------------
23:SORT 1 273.728us 273.728us 20 23 24.03 MB -1.00 B
22:SELECT 1 77.148us 77.148us 20 23 24.00 KB -1.00 B
21:ANALYTIC 1 344.908us 344.908us 52 227 8.03 MB -1.00 B
40:MERGING-EXCHANGE 1 443.832us 443.832us 52 227 0 -1.00 B UNPARTITIONED
20:SORT 1 396.724us 396.724us 52 227 24.03 MB 16.00 MB
19:ANALYTIC 1 179.456us 179.456us 52 227 8.03 MB 0
18:SORT 1 678.452us 678.452us 52 227 24.03 MB 16.00 MB
39:EXCHANGE 1 11.348us 11.348us 52 227 0 0 HASH(`@dataset_a.Device`)
17:SELECT 1 44.280us 44.280us 52 227 24.00 KB -1.00 B
16:ANALYTIC 1 170.736us 170.736us 52 2.27K 8.03 MB -1.00 B
38:MERGING-EXCHANGE 1 41.420us 41.420us 52 2.27K 0 -1.00 B UNPARTITIONED
15:SORT 17 101.031us 287.881us 52 2.27K 24.03 MB 16.00 MB
14:ANALYTIC 17 192.790us 529.572us 52 2.27K 8.03 MB 0
13:SORT 17 221.655us 559.936us 52 2.27K 24.08 MB 16.00 MB
37:EXCHANGE 17 12.627us 135.244us 52 2.27K 0 0 HASH(`@associative_tag.Prop...
12:AGGREGATE 17 1.898ms 4.211ms 52 2.27K 2.56 MB 10.00 MB FINALIZE
36:AGGREGATE 17 3.646ms 14.411ms 35.85K 41.52M 11.19 MB 2.89 GB
35:EXCHANGE 17 210.341us 1.386ms 35.85K 41.52M 0 0 HASH(`@dataset_a.Device`,`@...
11:AGGREGATE 17 71.502ms 80.600ms 35.85K 41.52M 9.44 MB 2.89 GB STREAMING
10:HASH JOIN 17 342.957ms 377.603ms 35.85K 41.52M 1.28 MB 3.12 MB LEFT OUTER JOIN, PARTITIONED
|--34:AGGREGATE 17 23.275ms 27.444ms 17.92K 655.32K 20.08 MB 52.96 MB FINALIZE
| 33:EXCHANGE 17 2.052ms 5.782ms 518.12K 17.90M 0 0 HASH(`@dataset_a.header_ass...
| 08:AGGREGATE 17 94.774ms 120.072ms 518.12K 17.90M 13.04 MB 216.74 MB STREAMING
| 07:HASH JOIN 17 215.970ms 258.952ms 1.36M 17.90M 10.18 MB 83.72 MB INNER JOIN, PARTITIONED
| |--32:EXCHANGE 17 1.122ms 1.351ms 518.12K 19.65M 0 0 HASH(max(if(TRUE, `@Event.E...
| | 30:AGGREGATE 17 24.420ms 29.346ms 518.12K 19.65M 11.13 MB 194.24 MB FINALIZE
| | 29:EXCHANGE 17 3.543ms 4.587ms 1.99M 19.65M 0 0 HASH(`@dataset_a.header_ass...
| | 06:AGGREGATE 17 223.177ms 314.593ms 1.99M 19.65M 21.14 MB 1.39 GB STREAMING
| | 05:SCAN HDFS 17 159.508ms 237.531ms 3.63M 19.65M 77.55 MB 264.00 MB 24x7_prod.dataset_a_batch
| 31:EXCHANGE 17 130.445ms 188.042ms 37.77M 196.51M 0 0 HASH(cuberon_event_epoch_ta...
| 04:SCAN HDFS 17 980.913ms 1s024ms 37.77M 196.51M 98.90 MB 264.00 MB 24x7_prod.dataset_a_batch
09:HASH JOIN 17 1s671ms 2s004ms 43.32M 41.52M 457.17 MB 216.74 MB INNER JOIN, PARTITIONED
|--27:AGGREGATE 17 2s587ms 2s868ms 41.76M 45.59M 530.16 MB 216.74 MB FINALIZE
| 26:EXCHANGE 17 198.242ms 222.558ms 73.99M 45.59M 0 0 HASH(`@dataset_a.header_ass...
| 01:AGGREGATE 17 5s439ms 7s140ms 73.99M 45.59M 1.07 GB 3.60 GB STREAMING
| 00:SCAN HDFS 17 80.893ms 146.873ms 196.51M 196.51M 27.62 MB 88.00 MB 24x7_prod.dataset_a_batch
28:EXCHANGE 17 152.883ms 206.050ms 43.32M 196.51M 0 0 HASH(`@dataset_a.header_ass...
25:AGGREGATE 17 1s544ms 1s796ms 43.32M 196.51M 330.17 MB 1.60 GB FINALIZE
24:EXCHANGE 17 202.057ms 234.085ms 76.67M 196.51M 0 0 HASH(`@dataset_a.header_ass...
03:AGGREGATE 17 2s677ms 3s556ms 76.67M 196.51M 652.25 MB 19.53 GB STREAMING
02:SCAN HDFS 17 905.576ms 943.004ms 196.51M 196.51M 40.59 MB 176.00 MB 24x7_prod.dataset_a_batch
Planner Timeline: 55.086ms
- Analysis finished: 7.378ms (7.378ms)
- Equivalence classes computed: 8.023ms (644.847us)
- Single node plan created: 24.813ms (16.790ms)
- Runtime filters computed: 25.174ms (360.534us)
- Distributed plan created: 26.995ms (1.821ms)
- Lineage info computed: 28.087ms (1.091ms)
- Planning finished: 55.086ms (26.999ms)
Query Timeline: 12m18s
- Query submitted: 57.136us (57.136us)
- Planning finished: 114.390ms (114.332ms)
- Submit for admission: 124.498ms (10.108ms)
- Completed admission: 124.554ms (56.176us)
- Ready to start 173 fragment instances: 126.245ms (1.690ms)
- All 173 fragment instances started: 185.952ms (59.707ms)
- First dynamic filter received: 933.984ms (748.032ms)
- Rows available: 14s019ms (13s085ms)
- First row fetched: 14s899ms (879.593ms)
- Unregister query: 12m18s (12m3s)
- ComputeScanRangeAssignmentTimer: 5.390ms
ImpalaServer:
- ClientFetchWaitTimer: 12m4s
- RowMaterializationTimer: 20.465ms
Execution Profile 514ee9ab39cdc507:7b38551b00000000:(Total: 13s912ms, non-child: 0.000ns, % non-child: 0.00%)
Number of filters: 3
Filter routing table:
ID Src. Node Tgt. Node(s) Targets Target type Partition filter Pending (Expected) First arrived Completed Enabled
----------------------------------------------------------------------------------------------------------------------------
2 7 4 17 REMOTE false 17 (17) N/A N/A true
1 7 4 17 REMOTE false 17 (17) N/A N/A true
0 9 2 17 REMOTE false 17 (17) N/A N/A true
Fragment instance start latencies: Count: 173, 25th %-ile: 1ms, 50th %-ile: 1ms, 75th %-ile: 4ms, 90th %-ile: 5ms, 95th %-ile: 6ms, 99.9th %-ile: 10ms
Per Node Peak Memory Usage: cdh8.net.cuberonlabs.com:22000(1.63 GB) cdh7.net.cuberonlabs.com:22000(1.58 GB) cdh5.net.cuberonlabs.com:22000(2.15 GB) cdh12.net.cuberonlabs.com:22000(1.12 GB) cdh2.net.cuberonlabs.com:22000(1.74 GB) cdh10.net.cuberonlabs.com:22000(1.66 GB) cdh17.net.cuberonlabs.com:22000(1.75 GB) cdh3.net.cuberonlabs.com:22000(2.16 GB) cdh15.net.cuberonlabs.com:22000(1.57 GB) cdh14.net.cuberonlabs.com:22000(1.44 GB) cdh9.net.cuberonlabs.com:22000(1.69 GB) cdh6.net.cuberonlabs.com:22000(1.67 GB) cdh11.net.cuberonlabs.com:22000(1.48 GB) cdh13.net.cuberonlabs.com:22000(1.66 GB) cdh16.net.cuberonlabs.com:22000(1.64 GB) cdh4.net.cuberonlabs.com:22000(2.13 GB) cdh1.net.cuberonlabs.com:22000(1.81 GB)
Final filter table:
ID Src. Node Tgt. Node(s) Targets Target type Partition filter Pending (Expected) First arrived Completed Enabled
----------------------------------------------------------------------------------------------------------------------------
2 7 4 17 REMOTE false 0 (17) 948.745ms 1s286ms false
1 7 4 17 REMOTE false 0 (17) 933.986ms 1s291ms false
0 9 2 17 REMOTE false 0 (17) 11s613ms 12s251ms false
- FiltersReceived: 51 (51)
- FinalizationTimer: 0.000ns
Coordinator Fragment F13:
Instance 514ee9ab39cdc507:7b38551b00000000 (host=cdh1.net.cuberonlabs.com:22000):(Total: 14s771ms, non-child: 883.087ms, % non-child: 5.98%)
MemoryUsage(500.000ms): 24.56 MB, 24.02 MB, 24.02 MB, 24.02 MB, 24.02 MB, 24.02 MB, 24.02 MB, 24.02 MB, 24.02 MB, 24.02 MB, 24.02 MB, 24.02 MB, 24.02 MB, 24.02 MB, 24.02 MB, 24.02 MB, 24.02 MB, 24.02 MB, 24.02 MB, 24.02 MB, 24.02 MB, 24.02 MB, 24.02 MB, 24.02 MB, 24.02 MB, 24.02 MB, 24.02 MB, 24.02 MB, 24.02 MB, 24.02 MB
- AverageThreadTokens: 0.00
- BloomFilterBytes: 0
- PeakMemoryUsage: 32.08 MB (33634378)
- PerHostPeakMemUsage: 1.81 GB (1939587581)
- RowsProduced: 20 (20)
- TotalNetworkReceiveTime: 0.000ns
- TotalNetworkSendTime: 0.000ns
- TotalStorageWaitTime: 0.000ns
- TotalThreadsInvoluntaryContextSwitches: 1 (1)
- TotalThreadsTotalWallClockTime: 14s727ms
- TotalThreadsSysTime: 0.000ns
- TotalThreadsUserTime: 104.000ms
- TotalThreadsVoluntaryContextSwitches: 29 (29)
Fragment Instance Lifecycle Timings:
- ExecTime: 879.799ms
- ExecTreeExecTime: 10.040us
- OpenTime: 13s848ms
- ExecTreeOpenTime: 13s743ms
- PrepareTime: 43.208ms
- ExecTreePrepareTime: 341.064us
BlockMgr:
- BlockWritesOutstanding: 0 (0)
- BlocksCreated: 408 (408)
- BlocksRecycled: 301 (301)
- BufferedPins: 0 (0)
- BytesWritten: 0
- MaxBlockSize: 8.00 MB (8388608)
- MemoryLimit: 48.00 GB (51539607552)
- PeakMemoryUsage: 1.34 GB (1443135488)
- ScratchFileUsedBytes: 0
- TotalBufferWaitTime: 0.000ns
- TotalEncryptionTime: 0.000ns
- TotalReadBlockTime: 0.000ns
PLAN_ROOT_SINK:
- PeakMemoryUsage: 0
CodeGen:(Total: 143.939ms, non-child: 143.939ms, % non-child: 100.00%)
- CodegenTime: 1.365ms
- CompileTime: 16.076ms
- LoadTime: 0.000ns
- ModuleBitcodeSize: 1.90 MB (1992760)
- NumFunctions: 62 (62)
- NumInstructions: 1.13K (1129)
- OptimizationTime: 86.696ms
- PeakMemoryUsage: 564.50 KB (578048)
- PrepareTime: 40.096ms
SORT_NODE (id=23):(Total: 13s744ms, non-child: 273.728us, % non-child: 0.00%)
ExecOption: Codegen Enabled
- InMemorySortTime: 12.720us
- InitialRunsCreated: 1 (1)
- PeakMemoryUsage: 24.03 MB (25194496)
- RowsReturned: 20 (20)
- RowsReturnedRate: 1.00 /sec
- SortDataSize: 1.78 KB (1824)
- SpilledRuns: 0 (0)
- TotalMergesPerformed: 0 (0)
SELECT_NODE (id=22):(Total: 13s743ms, non-child: 77.148us, % non-child: 0.00%)
- PeakMemoryUsage: 24.00 KB (24576)
- RowsReturned: 20 (20)
- RowsReturnedRate: 1.00 /sec
ANALYTIC_EVAL_NODE (id=21):(Total: 13s743ms, non-child: 344.908us, % non-child: 0.00%)
- EvaluationTime: 83.272us
- GetNewBlockTime: 1.612us
- PeakMemoryUsage: 8.03 MB (8422421)
- PinTime: 0.000ns
- RowsReturned: 52 (52)
- RowsReturnedRate: 3.00 /sec
- UnpinTime: 0.000ns
EXCHANGE_NODE (id=40):(Total: 13s743ms, non-child: 443.832us, % non-child: 0.00%)
ExecOption: Codegen Enabled
BytesReceived(500.000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0
- BytesReceived: 1.88 KB (1920)
- ConvertRowBatchTime: 0.000ns
- DeserializeRowBatchTimer: 23.304us
- FirstBatchArrivalWaitTime: 13s743ms
- MergeGetNext: 428.888us
- MergeGetNextBatch: 421.580us
- PeakMemoryUsage: 0
- RowsReturned: 52 (52)
- RowsReturnedRate: 3.00 /sec
- SendersBlockedTimer: 0.000ns
- SendersBlockedTotalTimer(*): 0.000ns
Averaged Fragment F12:(Total: 13s890ms, non-child: 4.292ms, % non-child: 0.03%)
split sizes: min: 0, max: 0, avg: 0, stddev: 0
completion times: min:13s891ms max:13s891ms mean: 13s891ms stddev:0.000ns
execution rates: min:0.00 /sec max:0.00 /sec mean:0.00 /sec stddev:0.00 /sec
num instances: 1
- AverageThreadTokens: 1.00
- BloomFilterBytes: 0
- PeakMemoryUsage: 56.06 MB (58784661)
- PerHostPeakMemUsage: 1.81 GB (1939587581)
- RowsProduced: 52 (52)
- TotalNetworkReceiveTime: 13s760ms
- TotalNetworkSendTime: 193.768us
- TotalStorageWaitTime: 0.000ns
- TotalThreadsInvoluntaryContextSwitches: 1 (1)
- TotalThreadsTotalWallClockTime: 13s854ms
- TotalThreadsSysTime: 0.000ns
- TotalThreadsUserTime: 92.000ms
- TotalThreadsVoluntaryContextSwitches: 35 (35)
Fragment Instance Lifecycle Timings:
- ExecTime: 393.468us
- ExecTreeExecTime: 5.612us
- OpenTime: 13s854ms
- ExecTreeOpenTime: 13s761ms
- PrepareTime: 35.893ms
- ExecTreePrepareTime: 501.208us
DataStreamSender (dst_id=40):(Total: 117.204us, non-child: 117.204us, % non-child: 100.00%)
- BytesSent: 1.88 KB (1920)
- NetworkThroughput(*): 44.29 MB/sec
- OverallThroughput: 15.62 MB/sec
- PeakMemoryUsage: 1.97 KB (2016)
- RowsReturned: 52 (52)
- SerializeBatchTime: 42.220us
- TransmitDataRPCTime: 41.340us
- UncompressedRowBatchSize: 5.23 KB (5353)
CodeGen:(Total: 124.678ms, non-child: 124.678ms, % non-child: 100.00%)
- CodegenTime: 858.552us
- CompileTime: 14.428ms
- LoadTime: 0.000ns
- ModuleBitcodeSize: 1.90 MB (1992760)
- NumFunctions: 46 (46)
- NumInstructions: 892 (892)
- OptimizationTime: 75.882ms
- PeakMemoryUsage: 446.00 KB (456704)
- PrepareTime: 33.847ms
SORT_NODE (id=20):(Total: 13s761ms, non-child: 396.724us, % non-child: 0.00%)
- InMemorySortTime: 30.228us
- InitialRunsCreated: 1 (1)
- PeakMemoryUsage: 24.03 MB (25194496)
- RowsReturned: 52 (52)
- RowsReturnedRate: 3.00 /sec
- SortDataSize: 5.02 KB (5141)
- SpilledRuns: 0 (0)
- TotalMergesPerformed: 0 (0)
ANALYTIC_EVAL_NODE (id=19):(Total: 13s761ms, non-child: 179.456us, % non-child: 0.00%)
- EvaluationTime: 43.688us
- GetNewBlockTime: 2.436us
- PeakMemoryUsage: 8.03 MB (8417280)
- PinTime: 0.000ns
- RowsReturned: 52 (52)
- RowsReturnedRate: 3.00 /sec
- UnpinTime: 0.000ns
SORT_NODE (id=18):(Total: 13s760ms, non-child: 678.452us, % non-child: 0.00%)
- InMemorySortTime: 30.656us
- InitialRunsCreated: 1 (1)
- PeakMemoryUsage: 24.03 MB (25194718)
- RowsReturned: 52 (52)
- RowsReturnedRate: 3.00 /sec
- SortDataSize: 4.61 KB (4725)
- SpilledRuns: 0 (0)
- TotalMergesPerformed: 0 (0)
EXCHANGE_NODE (id=39):(Total: 13s760ms, non-child: 13s760ms, % non-child: 100.00%)
- BytesReceived: 2.00 KB (2046)
- ConvertRowBatchTime: 2.744us
- DeserializeRowBatchTimer: 21.812us
- FirstBatchArrivalWaitTime: 13s760ms
- PeakMemoryUsage: 0
- RowsReturned: 52 (52)
- RowsReturnedRate: 3.00 /sec
- SendersBlockedTimer: 0.000ns
- SendersBlockedTotalTimer(*): 0.000ns
Fragment F12:
Instance 514ee9ab39cdc507:ac (host=cdh1.net.cuberonlabs.com:22000):(Total: 13s890ms, non-child: 4.292ms, % non-child: 0.03%)
MemoryUsage(500.000ms): 48.45 MB, 48.01 MB, 48.01 MB, 48.01 MB, 48.01 MB, 48.01 MB, 48.01 MB, 48.01 MB, 48.01 MB, 48.01 MB, 48.01 MB, 48.01 MB, 48.01 MB, 48.01 MB, 48.01 MB, 48.01 MB, 48.01 MB, 48.01 MB, 48.01 MB, 48.01 MB, 48.01 MB, 48.01 MB, 48.01 MB, 48.01 MB, 48.01 MB, 48.01 MB, 48.01 MB, 48.01 MB
ThreadUsage(500.000ms): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1
- AverageThreadTokens: 1.00
- BloomFilterBytes: 0
- PeakMemoryUsage: 56.06 MB (58784661)
- PerHostPeakMemUsage: 1.81 GB (1939587581)
- RowsProduced: 52 (52)
- TotalNetworkReceiveTime: 13s760ms
- TotalNetworkSendTime: 193.768us
- TotalStorageWaitTime: 0.000ns
- TotalThreadsInvoluntaryContextSwitches: 1 (1)
- TotalThreadsTotalWallClockTime: 13s854ms
- TotalThreadsSysTime: 0.000ns
- TotalThreadsUserTime: 92.000ms
- TotalThreadsVoluntaryContextSwitches: 35 (35)
Fragment Instance Lifecycle Timings:
- ExecTime: 393.468us
- ExecTreeExecTime: 5.612us
- OpenTime: 13s854ms
- ExecTreeOpenTime: 13s761ms
- PrepareTime: 35.893ms
- ExecTreePrepareTime: 501.208us
DataStreamSender (dst_id=40):(Total: 117.204us, non-child: 117.204us, % non-child: 100.00%)
- BytesSent: 1.88 KB (1920)
- NetworkThroughput(*): 44.29 MB/sec
- OverallThroughput: 15.62 MB/sec
- PeakMemoryUsage: 1.97 KB (2016)
- RowsReturned: 52 (52)
- SerializeBatchTime: 42.220us
- TransmitDataRPCTime: 41.340us
- UncompressedRowBatchSize: 5.23 KB (5353)
CodeGen:(Total: 124.678ms, non-child: 124.678ms, % non-child: 100.00%)
- CodegenTime: 858.552us
- CompileTime: 14.428ms
- LoadTime: 0.000ns
- ModuleBitcodeSize: 1.90 MB (1992760)
- NumFunctions: 46 (46)
- NumInstructions: 892 (892)
- OptimizationTime: 75.882ms
- PeakMemoryUsage: 446.00 KB (456704)
- PrepareTime: 33.847ms
SORT_NODE (id=20):(Total: 13s761ms, non-child: 396.724us, % non-child: 0.00%)
ExecOption: Codegen Enabled
- InMemorySortTime: 30.228us
- InitialRunsCreated: 1 (1)
- PeakMemoryUsage: 24.03 MB (25194496)
- RowsReturned: 52 (52)
- RowsReturnedRate: 3.00 /sec
- SortDataSize: 5.02 KB (5141)
- SpilledRuns: 0 (0)
- TotalMergesPerformed: 0 (0)
ANALYTIC_EVAL_NODE (id=19):(Total: 13s761ms, non-child: 179.456us, % non-child: 0.00%)
- EvaluationTime: 43.688us
- GetNewBlockTime: 2.436us
- PeakMemoryUsage: 8.03 MB (8417280)
- PinTime: 0.000ns
- RowsReturned: 52 (52)
- RowsReturnedRate: 3.00 /sec
- UnpinTime: 0.000ns
SORT_NODE (id=18):(Total: 13s760ms, non-child: 678.452us, % non-child: 0.00%)
ExecOption: Codegen Enabled
- InMemorySortTime: 30.656us
- InitialRunsCreated: 1 (1)
- PeakMemoryUsage: 24.03 MB (25194718)
- RowsReturned: 52 (52)
- RowsReturnedRate: 3.00 /sec
- SortDataSize: 4.61 KB (4725)
- SpilledRuns: 0 (0)
- TotalMergesPerformed: 0 (0)
EXCHANGE_NODE (id=39):(Total: 13s760ms, non-child: 11.348us, % non-child: 0.00%)
BytesReceived(500.000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0
- BytesReceived: 2.00 KB (2046)
- ConvertRowBatchTime: 2.744us
- DeserializeRowBatchTimer: 21.812us
- FirstBatchArrivalWaitTime: 13s760ms
- PeakMemoryUsage: 0
- RowsReturned: 52 (52)
- RowsReturnedRate: 3.00 /sec
- SendersBlockedTimer: 0.000ns
- SendersBlockedTotalTimer(*): 0.000ns
Averaged Fragment F11:(Total: 13s889ms, non-child: 2.336ms, % non-child: 0.02%)
split sizes: min: 0, max: 0, avg: 0, stddev: 0
completion times: min:13s890ms max:13s890ms mean: 13s890ms stddev:0.000ns
execution rates: min:0.00 /sec max:0.00 /sec mean:0.00 /sec stddev:0.00 /sec
num instances: 1
- AverageThreadTokens: 1.00
- BloomFilterBytes: 0
- PeakMemoryUsage: 8.07 MB (8463866)
- PerHostPeakMemUsage: 1.81 GB (1939587581)
- RowsProduced: 52 (52)
- TotalNetworkReceiveTime: 0.000ns
- TotalNetworkSendTime: 173.280us
- TotalStorageWaitTime: 0.000ns
- TotalThreadsInvoluntaryContextSwitches: 4 (4)
- TotalThreadsTotalWallClockTime: 13s864ms
- TotalThreadsSysTime: 0.000ns
- TotalThreadsUserTime: 92.000ms
- TotalThreadsVoluntaryContextSwitches: 33 (33)
Fragment Instance Lifecycle Timings:
- ExecTime: 377.648us
- ExecTreeExecTime: 51.992us
- OpenTime: 13s863ms
- ExecTreeOpenTime: 13s773ms
- PrepareTime: 25.368ms
- ExecTreePrepareTime: 101.656us
DataStreamSender (dst_id=39):(Total: 115.820us, non-child: 115.820us, % non-child: 100.00%)
- BytesSent: 2.00 KB (2046)
- NetworkThroughput(*): 54.93 MB/sec
- OverallThroughput: 16.85 MB/sec
- PeakMemoryUsage: 4.41 KB (4512)
- RowsReturned: 52 (52)
- SerializeBatchTime: 47.444us
- TransmitDataRPCTime: 35.520us
- UncompressedRowBatchSize: 4.63 KB (4742)
CodeGen:(Total: 113.753ms, non-child: 113.753ms, % non-child: 100.00%)
- CodegenTime: 718.952us
- CompileTime: 15.517ms
- LoadTime: 0.000ns
- ModuleBitcodeSize: 1.90 MB (1992760)
- NumFunctions: 59 (59)
- NumInstructions: 1.03K (1032)
- OptimizationTime: 74.029ms
- PeakMemoryUsage: 516.00 KB (528384)
- PrepareTime: 23.655ms
SELECT_NODE (id=17):(Total: 13s773ms, non-child: 44.280us, % non-child: 0.00%)
- PeakMemoryUsage: 24.00 KB (24576)
- RowsReturned: 52 (52)
- RowsReturnedRate: 3.00 /sec
ANALYTIC_EVAL_NODE (id=16):(Total: 13s773ms, non-child: 170.736us, % non-child: 0.00%)
- EvaluationTime: 29.696us
- GetNewBlockTime: 3.000us
- PeakMemoryUsage: 8.03 MB (8421589)
- PinTime: 0.000ns
- RowsReturned: 52 (52)
- RowsReturnedRate: 3.00 /sec
- UnpinTime: 0.000ns
EXCHANGE_NODE (id=38):(Total: 13s773ms, non-child: 13s773ms, % non-child: 100.00%)
- BytesReceived: 1.80 KB (1839)
- ConvertRowBatchTime: 0.000ns
- DeserializeRowBatchTimer: 22.136us
- FirstBatchArrivalWaitTime: 13s773ms
- MergeGetNext: 6.024us
- MergeGetNextBatch: 1.304us
- PeakMemoryUsage: 0
- RowsReturned: 52 (52)
- RowsReturnedRate: 3.00 /sec
- SendersBlockedTimer: 0.000ns
- SendersBlockedTotalTimer(*): 0.000ns
Fragment F11:
Instance 514ee9ab39cdc507:ab (host=cdh1.net.cuberonlabs.com:22000):(Total: 13s889ms, non-child: 2.336ms, % non-child: 0.02%)
MemoryUsage(500.000ms): 24.41 KB, 29.29 KB, 29.29 KB, 29.29 KB, 29.29 KB, 29.29 KB, 29.29 KB, 29.29 KB, 29.29 KB, 29.29 KB, 29.29 KB, 29.29 KB, 29.29 KB, 29.29 KB, 29.29 KB, 29.29 KB, 29.29 KB, 29.29 KB, 29.29 KB, 29.29 KB, 29.29 KB, 29.29 KB, 29.29 KB, 29.29 KB, 29.29 KB, 29.29 KB, 29.29 KB, 29.29 KB
ThreadUsage(500.000ms): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1
- AverageThreadTokens: 1.00
- BloomFilterBytes: 0
- PeakMemoryUsage: 8.07 MB (8463866)
- PerHostPeakMemUsage: 1.81 GB (1939587581)
- RowsProduced: 52 (52)
- TotalNetworkReceiveTime: 0.000ns
- TotalNetworkSendTime: 173.280us
- TotalStorageWaitTime: 0.000ns
- TotalThreadsInvoluntaryContextSwitches: 4 (4)
- TotalThreadsTotalWallClockTime: 13s864ms
- TotalThreadsSysTime: 0.000ns
- TotalThreadsUserTime: 92.000ms
- TotalThreadsVoluntaryContextSwitches: 33 (33)
Fragment Instance Lifecycle Timings:
- ExecTime: 377.648us
- ExecTreeExecTime: 51.992us
- OpenTime: 13s863ms
- ExecTreeOpenTime: 13s773ms
- PrepareTime: 25.368ms
- ExecTreePrepareTime: 101.656us
DataStreamSender (dst_id=39):(Total: 115.820us, non-child: 115.820us, % non-child: 100.00%)
- BytesSent: 2.00 KB (2046)
- NetworkThroughput(*): 54.93 MB/sec
- OverallThroughput: 16.85 MB/sec
- PeakMemoryUsage: 4.41 KB (4512)
- RowsReturned: 52 (52)
- SerializeBatchTime: 47.444us
- TransmitDataRPCTime: 35.520us
- UncompressedRowBatchSize: 4.63 KB (4742)
CodeGen:(Total: 113.753ms, non-child: 113.753ms, % non-child: 100.00%)
- CodegenTime: 718.952us
- CompileTime: 15.517ms
- LoadTime: 0.000ns
- ModuleBitcodeSize: 1.90 MB (1992760)
- NumFunctions: 59 (59)
- NumInstructions: 1.03K (1032)
- OptimizationTime: 74.029ms
- PeakMemoryUsage: 516.00 KB (528384)
- PrepareTime: 23.655ms
SELECT_NODE (id=17):(Total: 13s773ms, non-child: 44.280us, % non-child: 0.00%)
- PeakMemoryUsage: 24.00 KB (24576)
- RowsReturned: 52 (52)
- RowsReturnedRate: 3.00 /sec
ANALYTIC_EVAL_NODE (id=16):(Total: 13s773ms, non-child: 170.736us, % non-child: 0.00%)
- EvaluationTime: 29.696us
- GetNewBlockTime: 3.000us
- PeakMemoryUsage: 8.03 MB (8421589)
- PinTime: 0.000ns
- RowsReturned: 52 (52)
- RowsReturnedRate: 3.00 /sec
- UnpinTime: 0.000ns
EXCHANGE_NODE (id=38):(Total: 13s773ms, non-child: 41.420us, % non-child: 0.00%)
ExecOption: Codegen Enabled
BytesReceived(500.000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0
- BytesReceived: 1.80 KB (1839)
- ConvertRowBatchTime: 0.000ns
- DeserializeRowBatchTimer: 22.136us
- FirstBatchArrivalWaitTime: 13s773ms
- MergeGetNext: 6.024us
- MergeGetNextBatch: 1.304us
- PeakMemoryUsage: 0
- RowsReturned: 52 (52)
- RowsReturnedRate: 3.00 /sec
- SendersBlockedTimer: 0.000ns
- SendersBlockedTotalTimer(*): 0.000ns
Averaged Fragment F10:(Total: 13s887ms, non-child: 2.167ms, % non-child: 0.02%)
split sizes: min: 0, max: 0, avg: 0, stddev: 0
completion times: min:13s887ms max:13s888ms mean: 13s888ms stddev:393.332us
execution rates: min:0.00 /sec max:0.00 /sec mean:0.00 /sec stddev:0.00 /sec
num instances: 17
- AverageThreadTokens: 1.00
- BloomFilterBytes: 0
- PeakMemoryUsage: 48.90 MB (51272600)
- PerHostPeakMemUsage: 1.70 GB (1824024877)
- RowsProduced: 3 (3)
- TotalNetworkReceiveTime: 13s754ms
- TotalNetworkSendTime: 19.125us
- TotalStorageWaitTime: 0.000ns
- TotalThreadsInvoluntaryContextSwitches: 0 (0)
- TotalThreadsTotalWallClockTime: 13s852ms
- TotalThreadsSysTime: 705.882us
- TotalThreadsUserTime: 98.823ms
- TotalThreadsVoluntaryContextSwitches: 14 (14)
Fragment Instance Lifecycle Timings:
- ExecTime: 221.229us
- ExecTreeExecTime: 3.224us
- OpenTime: 13s852ms
- ExecTreeOpenTime: 13s755ms
- PrepareTime: 34.406ms
- ExecTreePrepareTime: 162.475us
BlockMgr:
- BlockWritesOutstanding: 0 (0)
- BlocksCreated: 404 (404)
- BlocksRecycled: 297 (297)
- BufferedPins: 0 (0)
- BytesWritten: 0
- MaxBlockSize: 8.00 MB (8388608)
- MemoryLimit: 48.00 GB (51539607552)
- PeakMemoryUsage: 1.25 GB (1346116160)
- ScratchFileUsedBytes: 0
- TotalBufferWaitTime: 0.000ns
- TotalEncryptionTime: 0.000ns
- TotalReadBlockTime: 0.000ns
DataStreamSender (dst_id=38):(Total: 21.176us, non-child: 21.176us, % non-child: 100.00%)
- BytesSent: 108.00 B (108)
- NetworkThroughput(*): 2.25 MB/sec
- OverallThroughput: 1.07 MB/sec
- PeakMemoryUsage: 2.61 KB (2672)
- RowsReturned: 3 (3)
- SerializeBatchTime: 2.069us
- TransmitDataRPCTime: 2.698us
- UncompressedRowBatchSize: 265.00 B (265)
CodeGen:(Total: 129.471ms, non-child: 129.471ms, % non-child: 100.00%)
- CodegenTime: 1.222ms
- CompileTime: 15.791ms
- LoadTime: 0.000ns
- ModuleBitcodeSize: 1.90 MB (1992760)
- NumFunctions: 46 (46)
- NumInstructions: 892 (892)
- OptimizationTime: 80.046ms
- PeakMemoryUsage: 446.00 KB (456704)
- PrepareTime: 32.833ms
SORT_NODE (id=15):(Total: 13s755ms, non-child: 101.031us, % non-child: 0.00%)
- InMemorySortTime: 1.352us
- InitialRunsCreated: 1 (1)
- PeakMemoryUsage: 24.02 MB (25182930)
- RowsReturned: 3 (3)
- RowsReturnedRate: 0
- SortDataSize: 253.00 B (253)
- SpilledRuns: 0 (0)
- TotalMergesPerformed: 0 (0)
ANALYTIC_EVAL_NODE (id=14):(Total: 13s755ms, non-child: 192.790us, % non-child: 0.00%)
- EvaluationTime: 3.068us
- GetNewBlockTime: 3.910us
- PeakMemoryUsage: 8.02 MB (8413424)
- PinTime: 0.000ns
- RowsReturned: 3 (3)
- RowsReturnedRate: 0
- UnpinTime: 0.000ns
SORT_NODE (id=13):(Total: 13s755ms, non-child: 221.656us, % non-child: 0.00%)
- InMemorySortTime: 1.817us
- InitialRunsCreated: 1 (1)
- PeakMemoryUsage: 24.01 MB (25178593)
- RowsReturned: 3 (3)
- RowsReturnedRate: 0
- SortDataSize: 229.00 B (229)
- SpilledRuns: 0 (0)
- TotalMergesPerformed: 0 (0)
EXCHANGE_NODE (id=37):(Total: 13s754ms, non-child: 13s754ms, % non-child: 100.00%)
- BytesReceived: 154.00 B (154)
- ConvertRowBatchTime: 1.851us
- DeserializeRowBatchTimer: 6.043us
- FirstBatchArrivalWaitTime: 13s754ms
- PeakMemoryUsage: 0
- RowsReturned: 3 (3)
- RowsReturnedRate: 0
- SendersBlockedTimer: 0.000ns
- SendersBlockedTotalTimer(*): 0.000ns
Fragment F10:
Instance 514ee9ab39cdc507:a1 (host=cdh2.net.cuberonlabs.com:22000):(Total: 13s887ms, non-child: 2.266ms, % non-child: 0.02%)
MemoryUsage(500.000ms): 48.01 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB
ThreadUsage(500.000ms): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1
- AverageThreadTokens: 1.00
- BloomFilterBytes: 0
- PeakMemoryUsage: 48.45 MB (50803312)
- PerHostPeakMemUsage: 1.74 GB (1866918022)
- RowsProduced: 0 (0)
- TotalNetworkReceiveTime: 13s754ms
- TotalNetworkSendTime: 244.000ns
- TotalStorageWaitTime: 0.000ns
- TotalThreadsInvoluntaryContextSwitches: 0 (0)
- TotalThreadsTotalWallClockTime: 13s852ms
- TotalThreadsSysTime: 0.000ns
- TotalThreadsUserTime: 100.000ms
- TotalThreadsVoluntaryContextSwitches: 14 (14)
Fragment Instance Lifecycle Timings:
- ExecTime: 179.644us
- ExecTreeExecTime: 4.944us
- OpenTime: 13s852ms
- ExecTreeOpenTime: 13s755ms
- PrepareTime: 35.365ms
- ExecTreePrepareTime: 163.580us
BlockMgr:
- BlockWritesOutstanding: 0 (0)
- BlocksCreated: 399 (399)
- BlocksRecycled: 314 (314)
- BufferedPins: 0 (0)
- BytesWritten: 0
- MaxBlockSize: 8.00 MB (8388608)
- MemoryLimit: 48.00 GB (51539607552)
- PeakMemoryUsage: 1.27 GB (1368162304)
- ScratchFileUsedBytes: 0
- TotalBufferWaitTime: 0.000ns
- TotalEncryptionTime: 0.000ns
- TotalReadBlockTime: 0.000ns
DataStreamSender (dst_id=38):(Total: 15.112us, non-child: 15.112us, % non-child: 100.00%)
- BytesSent: 0
- NetworkThroughput(*): 0.00 /sec
- OverallThroughput: 0.00 /sec
- PeakMemoryUsage: 2.61 KB (2672)
- RowsReturned: 0 (0)
- SerializeBatchTime: 0.000ns
- TransmitDataRPCTime: 0.000ns
- UncompressedRowBatchSize: 0
CodeGen:(Total: 129.976ms, non-child: 129.976ms, % non-child: 100.00%)
- CodegenTime: 1.300ms
- CompileTime: 15.147ms
- LoadTime: 0.000ns
- ModuleBitcodeSize: 1.90 MB (1992760)
- NumFunctions: 46 (46)
- NumInstructions: 892 (892)
- OptimizationTime: 80.326ms
- PeakMemoryUsage: 446.00 KB (456704)
- PrepareTime: 33.630ms
SORT_NODE (id=15):(Total: 13s755ms, non-child: 71.204us, % non-child: 0.00%)
ExecOption: Codegen Enabled
- InMemorySortTime: 336.000ns
- InitialRunsCreated: 1 (1)
- PeakMemoryUsage: 24.02 MB (25182208)
- RowsReturned: 0 (0)
- RowsReturnedRate: 0
- SortDataSize: 0
- SpilledRuns: 0 (0)
- TotalMergesPerformed: 0 (0)
ANALYTIC_EVAL_NODE (id=14):(Total: 13s755ms, non-child: 529.572us, % non-child: 0.00%)
- EvaluationTime: 820.000ns
- GetNewBlockTime: 2.728us
- PeakMemoryUsage: 8.02 MB (8413184)
- PinTime: 0.000ns
- RowsReturned: 0 (0)
- RowsReturnedRate: 0
- UnpinTime: 0.000ns
SORT_NODE (id=13):(Total: 13s754ms, non-child: 108.228us, % non-child: 0.00%)
ExecOption: Codegen Enabled
- InMemorySortTime: 732.000ns
- InitialRunsCreated: 1 (1)
- PeakMemoryUsage: 24.01 MB (25174016)
- RowsReturned: 0 (0)
- RowsReturnedRate: 0
- SortDataSize: 0
- SpilledRuns: 0 (0)
- TotalMergesPerformed: 0 (0)
EXCHANGE_NODE (id=37):(Total: 13s754ms, non-child: 4.240us, % non-child: 0.00%)
BytesReceived(500.000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0
- BytesReceived: 0
- ConvertRowBatchTime: 752.000ns
- DeserializeRowBatchTimer: 0.000ns
- FirstBatchArrivalWaitTime: 13s754ms
- PeakMemoryUsage: 0
- RowsReturned: 0 (0)
- RowsReturnedRate: 0
- SendersBlockedTimer: 0.000ns
- SendersBlockedTotalTimer(*): 0.000ns
Instance 514ee9ab39cdc507:a2 (host=cdh12.net.cuberonlabs.com:22000):(Total: 13s887ms, non-child: 2.200ms, % non-child: 0.02%)
MemoryUsage(500.000ms): 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB
ThreadUsage(500.000ms): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1
- AverageThreadTokens: 1.00
- BloomFilterBytes: 0
- PeakMemoryUsage: 48.45 MB (50803312)
- PerHostPeakMemUsage: 1.12 GB (1201773720)
- RowsProduced: 0 (0)
- TotalNetworkReceiveTime: 13s761ms
- TotalNetworkSendTime: 255.000ns
- TotalStorageWaitTime: 0.000ns
- TotalThreadsInvoluntaryContextSwitches: 0 (0)
- TotalThreadsTotalWallClockTime: 13s855ms
- TotalThreadsSysTime: 4.000ms
- TotalThreadsUserTime: 92.000ms
- TotalThreadsVoluntaryContextSwitches: 16 (16)
Fragment Instance Lifecycle Timings:
- ExecTime: 208.105us
- ExecTreeExecTime: 5.252us
- OpenTime: 13s855ms
- ExecTreeOpenTime: 13s761ms
- PrepareTime: 32.264ms
- ExecTreePrepareTime: 161.288us
BlockMgr:
- BlockWritesOutstanding: 0 (0)
- BlocksCreated: 383 (383)
- BlocksRecycled: 282 (282)
- BufferedPins: 0 (0)
- BytesWritten: 0
- MaxBlockSize: 8.00 MB (8388608)
- MemoryLimit: 48.00 GB (51539607552)
- PeakMemoryUsage: 836.78 MB (877430784)
- ScratchFileUsedBytes: 0
- TotalBufferWaitTime: 0.000ns
- TotalEncryptionTime: 0.000ns
- TotalReadBlockTime: 0.000ns
DataStreamSender (dst_id=38):(Total: 15.763us, non-child: 15.763us, % non-child: 100.00%)
- BytesSent: 0
- NetworkThroughput(*): 0.00 /sec
- OverallThroughput: 0.00 /sec
- PeakMemoryUsage: 2.61 KB (2672)
- RowsReturned: 0 (0)
- SerializeBatchTime: 0.000ns
- TransmitDataRPCTime: 0.000ns
- UncompressedRowBatchSize: 0
CodeGen:(Total: 123.540ms, non-child: 123.540ms, % non-child: 100.00%)
- CodegenTime: 1.298ms
- CompileTime: 14.842ms
- LoadTime: 0.000ns
- ModuleBitcodeSize: 1.90 MB (1992760)
- NumFunctions: 46 (46)
- NumInstructions: 892 (892)
- OptimizationTime: 76.833ms
- PeakMemoryUsage: 446.00 KB (456704)
- PrepareTime: 31.052ms
SORT_NODE (id=15):(Total: 13s761ms, non-child: 275.998us, % non-child: 0.00%)
ExecOption: Codegen Enabled
- InMemorySortTime: 298.000ns
- InitialRunsCreated: 1 (1)
- PeakMemoryUsage: 24.02 MB (25182208)
- RowsReturned: 0 (0)
- RowsReturnedRate: 0
- SortDataSize: 0
- SpilledRuns: 0 (0)
- TotalMergesPerformed: 0 (0)
ANALYTIC_EVAL_NODE (id=14):(Total: 13s761ms, non-child: 100.546us, % non-child: 0.00%)
- EvaluationTime: 643.000ns
- GetNewBlockTime: 5.634us
- PeakMemoryUsage: 8.02 MB (8413184)
- PinTime: 0.000ns
- RowsReturned: 0 (0)
- RowsReturnedRate: 0
- UnpinTime: 0.000ns
SORT_NODE (id=13):(Total: 13s761ms, non-child: 100.313us, % non-child: 0.00%)
ExecOption: Codegen Enabled
- InMemorySortTime: 941.000ns
- InitialRunsCreated: 1 (1)
- PeakMemoryUsage: 24.01 MB (25174016)
- RowsReturned: 0 (0)
- RowsReturnedRate: 0
- SortDataSize: 0
- SpilledRuns: 0 (0)
- TotalMergesPerformed: 0 (0)
EXCHANGE_NODE (id=37):(Total: 13s761ms, non-child: 4.675us, % non-child: 0.00%)
BytesReceived(500.000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0
- BytesReceived: 0
- ConvertRowBatchTime: 871.000ns
- DeserializeRowBatchTimer: 0.000ns
- FirstBatchArrivalWaitTime: 13s761ms
- PeakMemoryUsage: 0
- RowsReturned: 0 (0)
- RowsReturnedRate: 0
- SendersBlockedTimer: 0.000ns
- SendersBlockedTotalTimer(*): 0.000ns
Instance 514ee9ab39cdc507:a0 (host=cdh17.net.cuberonlabs.com:22000):(Total: 13s887ms, non-child: 2.229ms, % non-child: 0.02%)
MemoryUsage(500.000ms): 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB
ThreadUsage(500.000ms): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1
- AverageThreadTokens: 1.00
- BloomFilterBytes: 0
- PeakMemoryUsage: 48.45 MB (50803312)
- PerHostPeakMemUsage: 1.75 GB (1879028559)
- RowsProduced: 0 (0)
- TotalNetworkReceiveTime: 13s758ms
- TotalNetworkSendTime: 223.000ns
- TotalStorageWaitTime: 0.000ns
- TotalThreadsInvoluntaryContextSwitches: 0 (0)
- TotalThreadsTotalWallClockTime: 13s852ms
- TotalThreadsSysTime: 4.000ms
- TotalThreadsUserTime: 96.000ms
- TotalThreadsVoluntaryContextSwitches: 16 (16)
Fragment Instance Lifecycle Timings:
- ExecTime: 314.273us
- ExecTreeExecTime: 2.460us
- OpenTime: 13s852ms
- ExecTreeOpenTime: 13s758ms
- PrepareTime: 34.559ms
- ExecTreePrepareTime: 178.652us
BlockMgr:
- BlockWritesOutstanding: 0 (0)
- BlocksCreated: 386 (386)
- BlocksRecycled: 311 (311)
- BufferedPins: 0 (0)
- BytesWritten: 0
- MaxBlockSize: 8.00 MB (8388608)
- MemoryLimit: 48.00 GB (51539607552)
- PeakMemoryUsage: 1.31 GB (1410891776)
- ScratchFileUsedBytes: 0
- TotalBufferWaitTime: 0.000ns
- TotalEncryptionTime: 0.000ns
- TotalReadBlockTime: 0.000ns
DataStreamSender (dst_id=38):(Total: 15.884us, non-child: 15.884us, % non-child: 100.00%)
- BytesSent: 0
- NetworkThroughput(*): 0.00 /sec
- OverallThroughput: 0.00 /sec
- PeakMemoryUsage: 2.61 KB (2672)
- RowsReturned: 0 (0)
- SerializeBatchTime: 0.000ns
- TransmitDataRPCTime: 0.000ns
- UncompressedRowBatchSize: 0
CodeGen:(Total: 126.143ms, non-child: 126.143ms, % non-child: 100.00%)
- CodegenTime: 1.183ms
- CompileTime: 15.014ms
- LoadTime: 0.000ns
- ModuleBitcodeSize: 1.90 MB (1992760)
- NumFunctions: 46 (46)
- NumInstructions: 892 (892)
- OptimizationTime: 77.520ms
- PeakMemoryUsage: 446.00 KB (456704)
- PrepareTime: 32.831ms
SORT_NODE (id=15):(Total: 13s759ms, non-child: 72.300us, % non-child: 0.00%)
ExecOption: Codegen Enabled
- InMemorySortTime: 177.000ns
- InitialRunsCreated: 1 (1)
- PeakMemoryUsage: 24.02 MB (25182208)
- RowsReturned: 0 (0)
- RowsReturnedRate: 0
- SortDataSize: 0
- SpilledRuns: 0 (0)
- TotalMergesPerformed: 0 (0)
ANALYTIC_EVAL_NODE (id=14):(Total: 13s759ms, non-child: 101.035us, % non-child: 0.00%)
- EvaluationTime: 1.051us
- GetNewBlockTime: 3.093us
- PeakMemoryUsage: 8.02 MB (8413184)
- PinTime: 0.000ns
- RowsReturned: 0 (0)
- RowsReturnedRate: 0
- UnpinTime: 0.000ns
SORT_NODE (id=13):(Total: 13s758ms, non-child: 208.052us, % non-child: 0.00%)
ExecOption: Codegen Enabled
- InMemorySortTime: 790.000ns
- InitialRunsCreated: 1 (1)
- PeakMemoryUsage: 24.01 MB (25174016)
- RowsReturned: 0 (0)
- RowsReturnedRate: 0
- SortDataSize: 0
- SpilledRuns: 0 (0)
- TotalMergesPerformed: 0 (0)
EXCHANGE_NODE (id=37):(Total: 13s758ms, non-child: 4.369us, % non-child: 0.00%)
BytesReceived(500.000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0
- BytesReceived: 0
- ConvertRowBatchTime: 606.000ns
- DeserializeRowBatchTimer: 0.000ns
- FirstBatchArrivalWaitTime: 13s758ms
- PeakMemoryUsage: 0
- RowsReturned: 0 (0)
- RowsReturnedRate: 0
- SendersBlockedTimer: 0.000ns
- SendersBlockedTotalTimer(*): 0.000ns
Instance 514ee9ab39cdc507:aa (host=cdh10.net.cuberonlabs.com:22000):(Total: 13s887ms, non-child: 2.186ms, % non-child: 0.02%)
MemoryUsage(500.000ms): 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB
ThreadUsage(500.000ms): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1
- AverageThreadTokens: 1.00
- BloomFilterBytes: 0
- PeakMemoryUsage: 48.45 MB (50803312)
- PerHostPeakMemUsage: 1.66 GB (1784016472)
- RowsProduced: 0 (0)
- TotalNetworkReceiveTime: 13s762ms
- TotalNetworkSendTime: 194.000ns
- TotalStorageWaitTime: 0.000ns
- TotalThreadsInvoluntaryContextSwitches: 0 (0)
- TotalThreadsTotalWallClockTime: 13s854ms
- TotalThreadsSysTime: 0.000ns
- TotalThreadsUserTime: 92.000ms
- TotalThreadsVoluntaryContextSwitches: 8 (8)
Fragment Instance Lifecycle Timings:
- ExecTime: 152.558us
- ExecTreeExecTime: 1.819us
- OpenTime: 13s853ms
- ExecTreeOpenTime: 13s763ms
- PrepareTime: 33.271ms
- ExecTreePrepareTime: 165.076us
BlockMgr:
- BlockWritesOutstanding: 0 (0)
- BlocksCreated: 415 (415)
- BlocksRecycled: 282 (282)
- BufferedPins: 0 (0)
- BytesWritten: 0
- MaxBlockSize: 8.00 MB (8388608)
- MemoryLimit: 48.00 GB (51539607552)
- PeakMemoryUsage: 1.22 GB (1310228480)
- ScratchFileUsedBytes: 0
- TotalBufferWaitTime: 0.000ns
- TotalEncryptionTime: 0.000ns
- TotalReadBlockTime: 0.000ns
DataStreamSender (dst_id=38):(Total: 15.973us, non-child: 15.973us, % non-child: 100.00%)
- BytesSent: 0
- NetworkThroughput(*): 0.00 /sec
- OverallThroughput: 0.00 /sec
- PeakMemoryUsage: 2.61 KB (2672)
- RowsReturned: 0 (0)
- SerializeBatchTime: 0.000ns
- TransmitDataRPCTime: 0.000ns
- UncompressedRowBatchSize: 0
CodeGen:(Total: 121.919ms, non-child: 121.919ms, % non-child: 100.00%)
- CodegenTime: 1.295ms
- CompileTime: 14.713ms
- LoadTime: 0.000ns
- ModuleBitcodeSize: 1.90 MB (1992760)
- NumFunctions: 46 (46)
- NumInstructions: 892 (892)
- OptimizationTime: 74.836ms
- PeakMemoryUsage: 446.00 KB (456704)
- PrepareTime: 31.531ms
SORT_NODE (id=15):(Total: 13s763ms, non-child: 73.640us, % non-child: 0.00%)
ExecOption: Codegen Enabled
- InMemorySortTime: 317.000ns
- InitialRunsCreated: 1 (1)
- PeakMemoryUsage: 24.02 MB (25182208)
- RowsReturned: 0 (0)
- RowsReturnedRate: 0
- SortDataSize: 0
- SpilledRuns: 0 (0)
- TotalMergesPerformed: 0 (0)
ANALYTIC_EVAL_NODE (id=14):(Total: 13s763ms, non-child: 95.851us, % non-child: 0.00%)
- EvaluationTime: 921.000ns
- GetNewBlockTime: 3.329us
- PeakMemoryUsage: 8.02 MB (8413184)
- PinTime: 0.000ns
- RowsReturned: 0 (0)
- RowsReturnedRate: 0
- UnpinTime: 0.000ns
SORT_NODE (id=13):(Total: 13s763ms, non-child: 194.088us, % non-child: 0.00%)
ExecOption: Codegen Enabled
- InMemorySortTime: 966.000ns
- InitialRunsCreated: 1 (1)
- PeakMemoryUsage: 24.01 MB (25174016)
- RowsReturned: 0 (0)
- RowsReturnedRate: 0
- SortDataSize: 0
- SpilledRuns: 0 (0)
- TotalMergesPerformed: 0 (0)
EXCHANGE_NODE (id=37):(Total: 13s762ms, non-child: 4.634us, % non-child: 0.00%)
BytesReceived(500.000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0
- BytesReceived: 0
- ConvertRowBatchTime: 942.000ns
- DeserializeRowBatchTimer: 0.000ns
- FirstBatchArrivalWaitTime: 13s762ms
- PeakMemoryUsage: 0
- RowsReturned: 0 (0)
- RowsReturnedRate: 0
- SendersBlockedTimer: 0.000ns
- SendersBlockedTotalTimer(*): 0.000ns
Instance 514ee9ab39cdc507:a4 (host=cdh1.net.cuberonlabs.com:22000):(Total: 13s887ms, non-child: 2.259ms, % non-child: 0.02%)
MemoryUsage(500.000ms): 48.45 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB
ThreadUsage(500.000ms): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1
- AverageThreadTokens: 1.00
- BloomFilterBytes: 0
- PeakMemoryUsage: 48.45 MB (50803312)
- PerHostPeakMemUsage: 1.81 GB (1939587581)
- RowsProduced: 0 (0)
- TotalNetworkReceiveTime: 13s743ms
- TotalNetworkSendTime: 284.000ns
- TotalStorageWaitTime: 0.000ns
- TotalThreadsInvoluntaryContextSwitches: 1 (1)
- TotalThreadsTotalWallClockTime: 13s843ms
- TotalThreadsSysTime: 4.000ms
- TotalThreadsUserTime: 96.000ms
- TotalThreadsVoluntaryContextSwitches: 29 (29)
Fragment Instance Lifecycle Timings:
- ExecTime: 132.636us
- ExecTreeExecTime: 3.000us
- OpenTime: 13s843ms
- ExecTreeOpenTime: 13s743ms
- PrepareTime: 43.870ms
- ExecTreePrepareTime: 95.856us
DataStreamSender (dst_id=38):(Total: 9.224us, non-child: 9.224us, % non-child: 100.00%)
- BytesSent: 0
- NetworkThroughput(*): 0.00 /sec
- OverallThroughput: 0.00 /sec
- PeakMemoryUsage: 2.61 KB (2672)
- RowsReturned: 0 (0)
- SerializeBatchTime: 0.000ns
- TransmitDataRPCTime: 0.000ns
- UncompressedRowBatchSize: 0
CodeGen:(Total: 141.340ms, non-child: 141.340ms, % non-child: 100.00%)
- CodegenTime: 1.584ms
- CompileTime: 14.899ms
- LoadTime: 0.000ns
- ModuleBitcodeSize: 1.90 MB (1992760)
- NumFunctions: 46 (46)
- NumInstructions: 892 (892)
- OptimizationTime: 82.845ms
- PeakMemoryUsage: 446.00 KB (456704)
- PrepareTime: 42.681ms
SORT_NODE (id=15):(Total: 13s743ms, non-child: 107.248us, % non-child: 0.00%)
ExecOption: Codegen Enabled
- InMemorySortTime: 196.000ns
- InitialRunsCreated: 1 (1)
- PeakMemoryUsage: 24.02 MB (25182208)
- RowsReturned: 0 (0)
- RowsReturnedRate: 0
- SortDataSize: 0
- SpilledRuns: 0 (0)
- TotalMergesPerformed: 0 (0)
ANALYTIC_EVAL_NODE (id=14):(Total: 13s743ms, non-child: 78.972us, % non-child: 0.00%)
- EvaluationTime: 876.000ns
- GetNewBlockTime: 3.268us
- PeakMemoryUsage: 8.02 MB (8413184)
- PinTime: 0.000ns
- RowsReturned: 0 (0)
- RowsReturnedRate: 0
- UnpinTime: 0.000ns
SORT_NODE (id=13):(Total: 13s743ms, non-child: 434.984us, % non-child: 0.00%)
ExecOption: Codegen Enabled
- InMemorySortTime: 844.000ns
- InitialRunsCreated: 1 (1)
- PeakMemoryUsage: 24.01 MB (25174016)
- RowsReturned: 0 (0)
- RowsReturnedRate: 0
- SortDataSize: 0
- SpilledRuns: 0 (0)
- TotalMergesPerformed: 0 (0)
EXCHANGE_NODE (id=37):(Total: 13s743ms, non-child: 5.576us, % non-child: 0.00%)
BytesReceived(500.000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0
- BytesReceived: 0
- ConvertRowBatchTime: 832.000ns
- DeserializeRowBatchTimer: 0.000ns
- FirstBatchArrivalWaitTime: 13s743ms
- PeakMemoryUsage: 0
- RowsReturned: 0 (0)
- RowsReturnedRate: 0
- SendersBlockedTimer: 0.000ns
- SendersBlockedTotalTimer(*): 0.000ns
Instance 514ee9ab39cdc507:9f (host=cdh3.net.cuberonlabs.com:22000):(Total: 13s887ms, non-child: 2.015ms, % non-child: 0.01%)
MemoryUsage(500.000ms): 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB
ThreadUsage(500.000ms): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1
- AverageThreadTokens: 1.00
- BloomFilterBytes: 0
- PeakMemoryUsage: 48.45 MB (50803312)
- PerHostPeakMemUsage: 2.16 GB (2318232477)
- RowsProduced: 0 (0)
- TotalNetworkReceiveTime: 13s731ms
- TotalNetworkSendTime: 192.000ns
- TotalStorageWaitTime: 0.000ns
- TotalThreadsInvoluntaryContextSwitches: 2 (2)
- TotalThreadsTotalWallClockTime: 13s853ms
- TotalThreadsSysTime: 0.000ns
- TotalThreadsUserTime: 124.000ms
- TotalThreadsVoluntaryContextSwitches: 15 (15)
Fragment Instance Lifecycle Timings:
- ExecTime: 172.296us
- ExecTreeExecTime: 2.400us
- OpenTime: 13s853ms
- ExecTreeOpenTime: 13s731ms
- PrepareTime: 33.753ms
- ExecTreePrepareTime: 202.768us
BlockMgr:
- BlockWritesOutstanding: 0 (0)
- BlocksCreated: 413 (413)
- BlocksRecycled: 316 (316)
- BufferedPins: 0 (0)
- BytesWritten: 0
- MaxBlockSize: 8.00 MB (8388608)
- MemoryLimit: 48.00 GB (51539607552)
- PeakMemoryUsage: 1.60 GB (1720483840)
- ScratchFileUsedBytes: 0
- TotalBufferWaitTime: 0.000ns
- TotalEncryptionTime: 0.000ns
- TotalReadBlockTime: 0.000ns
DataStreamSender (dst_id=38):(Total: 21.828us, non-child: 21.828us, % non-child: 100.00%)
- BytesSent: 0
- NetworkThroughput(*): 0.00 /sec
- OverallThroughput: 0.00 /sec
- PeakMemoryUsage: 2.61 KB (2672)
- RowsReturned: 0 (0)
- SerializeBatchTime: 0.000ns
- TransmitDataRPCTime: 0.000ns
- UncompressedRowBatchSize: 0
CodeGen:(Total: 153.101ms, non-child: 153.101ms, % non-child: 100.00%)
- CodegenTime: 1.044ms
- CompileTime: 20.172ms
- LoadTime: 0.000ns
- ModuleBitcodeSize: 1.90 MB (1992760)
- NumFunctions: 46 (46)
- NumInstructions: 892 (892)
- OptimizationTime: 99.970ms
- PeakMemoryUsage: 446.00 KB (456704)
- PrepareTime: 32.286ms
SORT_NODE (id=15):(Total: 13s732ms, non-child: 77.284us, % non-child: 0.00%)
ExecOption: Codegen Enabled
- InMemorySortTime: 176.000ns
- InitialRunsCreated: 1 (1)
- PeakMemoryUsage: 24.02 MB (25182208)
- RowsReturned: 0 (0)
- RowsReturnedRate: 0
- SortDataSize: 0
- SpilledRuns: 0 (0)
- TotalMergesPerformed: 0 (0)
ANALYTIC_EVAL_NODE (id=14):(Total: 13s732ms, non-child: 112.116us, % non-child: 0.00%)
- EvaluationTime: 656.000ns
- GetNewBlockTime: 2.832us
- PeakMemoryUsage: 8.02 MB (8413184)
- PinTime: 0.000ns
- RowsReturned: 0 (0)
- RowsReturnedRate: 0
- UnpinTime: 0.000ns
SORT_NODE (id=13):(Total: 13s731ms, non-child: 541.508us, % non-child: 0.00%)
ExecOption: Codegen Enabled
- InMemorySortTime: 704.000ns
- InitialRunsCreated: 1 (1)
- PeakMemoryUsage: 24.01 MB (25174016)
- RowsReturned: 0 (0)
- RowsReturnedRate: 0
- SortDataSize: 0
- SpilledRuns: 0 (0)
- TotalMergesPerformed: 0 (0)
EXCHANGE_NODE (id=37):(Total: 13s731ms, non-child: 4.988us, % non-child: 0.00%)
BytesReceived(500.000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0
- BytesReceived: 0
- ConvertRowBatchTime: 1.032us
- DeserializeRowBatchTimer: 0.000ns
- FirstBatchArrivalWaitTime: 13s731ms
- PeakMemoryUsage: 0
- RowsReturned: 0 (0)
- RowsReturnedRate: 0
- SendersBlockedTimer: 0.000ns
- SendersBlockedTotalTimer(*): 0.000ns
Instance 514ee9ab39cdc507:a8 (host=cdh11.net.cuberonlabs.com:22000):(Total: 13s887ms, non-child: 2.038ms, % non-child: 0.01%)
MemoryUsage(500.000ms): 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB
ThreadUsage(500.000ms): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1
- AverageThreadTokens: 1.00
- BloomFilterBytes: 0
- PeakMemoryUsage: 48.45 MB (50803312)
- PerHostPeakMemUsage: 1.48 GB (1591793359)
- RowsProduced: 0 (0)
- TotalNetworkReceiveTime: 13s762ms
- TotalNetworkSendTime: 237.000ns
- TotalStorageWaitTime: 0.000ns
- TotalThreadsInvoluntaryContextSwitches: 0 (0)
- TotalThreadsTotalWallClockTime: 13s854ms
- TotalThreadsSysTime: 0.000ns
- TotalThreadsUserTime: 92.000ms
- TotalThreadsVoluntaryContextSwitches: 13 (13)
Fragment Instance Lifecycle Timings:
- ExecTime: 184.537us
- ExecTreeExecTime: 2.060us
- OpenTime: 13s854ms
- ExecTreeOpenTime: 13s762ms
- PrepareTime: 32.424ms
- ExecTreePrepareTime: 167.987us
BlockMgr:
- BlockWritesOutstanding: 0 (0)
- BlocksCreated: 399 (399)
- BlocksRecycled: 298 (298)
- BufferedPins: 0 (0)
- BytesWritten: 0
- MaxBlockSize: 8.00 MB (8388608)
- MemoryLimit: 48.00 GB (51539607552)
- PeakMemoryUsage: 1.12 GB (1197277184)
- ScratchFileUsedBytes: 0
- TotalBufferWaitTime: 0.000ns
- TotalEncryptionTime: 0.000ns
- TotalReadBlockTime: 0.000ns
DataStreamSender (dst_id=38):(Total: 15.001us, non-child: 15.001us, % non-child: 100.00%)
- BytesSent: 0
- NetworkThroughput(*): 0.00 /sec
- OverallThroughput: 0.00 /sec
- PeakMemoryUsage: 2.61 KB (2672)
- RowsReturned: 0 (0)
- SerializeBatchTime: 0.000ns
- TransmitDataRPCTime: 0.000ns
- UncompressedRowBatchSize: 0
CodeGen:(Total: 122.295ms, non-child: 122.295ms, % non-child: 100.00%)
- CodegenTime: 1.281ms
- CompileTime: 15.189ms
- LoadTime: 0.000ns
- ModuleBitcodeSize: 1.90 MB (1992760)
- NumFunctions: 46 (46)
- NumInstructions: 892 (892)
- OptimizationTime: 75.483ms
- PeakMemoryUsage: 446.00 KB (456704)
- PrepareTime: 30.817ms
SORT_NODE (id=15):(Total: 13s762ms, non-child: 67.132us, % non-child: 0.00%)
ExecOption: Codegen Enabled
- InMemorySortTime: 291.000ns
- InitialRunsCreated: 1 (1)
- PeakMemoryUsage: 24.02 MB (25182208)
- RowsReturned: 0 (0)
- RowsReturnedRate: 0
- SortDataSize: 0
- SpilledRuns: 0 (0)
- TotalMergesPerformed: 0 (0)
ANALYTIC_EVAL_NODE (id=14):(Total: 13s762ms, non-child: 98.045us, % non-child: 0.00%)
- EvaluationTime: 583.000ns
- GetNewBlockTime: 3.225us
- PeakMemoryUsage: 8.02 MB (8413184)
- PinTime: 0.000ns
- RowsReturned: 0 (0)
- RowsReturnedRate: 0
- UnpinTime: 0.000ns
SORT_NODE (id=13):(Total: 13s762ms, non-child: 413.389us, % non-child: 0.00%)
ExecOption: Codegen Enabled
- InMemorySortTime: 554.000ns
- InitialRunsCreated: 1 (1)
- PeakMemoryUsage: 24.01 MB (25174016)
- RowsReturned: 0 (0)
- RowsReturnedRate: 0
- SortDataSize: 0
- SpilledRuns: 0 (0)
- TotalMergesPerformed: 0 (0)
EXCHANGE_NODE (id=37):(Total: 13s762ms, non-child: 4.013us, % non-child: 0.00%)
BytesReceived(500.000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0
- BytesReceived: 0
- ConvertRowBatchTime: 754.000ns
- DeserializeRowBatchTimer: 0.000ns
- FirstBatchArrivalWaitTime: 13s762ms
- PeakMemoryUsage: 0
- RowsReturned: 0 (0)
- RowsReturnedRate: 0
- SendersBlockedTimer: 0.000ns
- SendersBlockedTotalTimer(*): 0.000ns
Instance 514ee9ab39cdc507:9d (host=cdh6.net.cuberonlabs.com:22000):(Total: 13s887ms, non-child: 2.369ms, % non-child: 0.02%)
MemoryUsage(500.000ms): 48.01 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB
ThreadUsage(500.000ms): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1
- AverageThreadTokens: 1.00
- BloomFilterBytes: 0
- PeakMemoryUsage: 56.06 MB (58781221)
- PerHostPeakMemUsage: 1.67 GB (1794839264)
- RowsProduced: 52 (52)
- TotalNetworkReceiveTime: 13s757ms
- TotalNetworkSendTime: 321.380us
- TotalStorageWaitTime: 0.000ns
- TotalThreadsInvoluntaryContextSwitches: 0 (0)
- TotalThreadsTotalWallClockTime: 13s852ms
- TotalThreadsSysTime: 0.000ns
- TotalThreadsUserTime: 96.000ms
- TotalThreadsVoluntaryContextSwitches: 30 (30)
Fragment Instance Lifecycle Timings:
- ExecTime: 552.740us
- ExecTreeExecTime: 4.600us
- OpenTime: 13s852ms
- ExecTreeOpenTime: 13s758ms
- PrepareTime: 34.608ms
- ExecTreePrepareTime: 159.868us
BlockMgr:
- BlockWritesOutstanding: 0 (0)
- BlocksCreated: 399 (399)
- BlocksRecycled: 298 (298)
- BufferedPins: 0 (0)
- BytesWritten: 0
- MaxBlockSize: 8.00 MB (8388608)
- MemoryLimit: 48.00 GB (51539607552)
- PeakMemoryUsage: 1.23 GB (1316126720)
- ScratchFileUsedBytes: 0
- TotalBufferWaitTime: 0.000ns
- TotalEncryptionTime: 0.000ns
- TotalReadBlockTime: 0.000ns
DataStreamSender (dst_id=38):(Total: 96.696us, non-child: 96.696us, % non-child: 100.00%)
- BytesSent: 1.80 KB (1839)
- NetworkThroughput(*): 38.24 MB/sec
- OverallThroughput: 18.14 MB/sec
- PeakMemoryUsage: 2.61 KB (2672)
- RowsReturned: 52 (52)
- SerializeBatchTime: 35.176us
- TransmitDataRPCTime: 45.868us
- UncompressedRowBatchSize: 4.42 KB (4521)
CodeGen:(Total: 126.456ms, non-child: 126.456ms, % non-child: 100.00%)
- CodegenTime: 1.219ms
- CompileTime: 14.917ms
- LoadTime: 0.000ns
- ModuleBitcodeSize: 1.90 MB (1992760)
- NumFunctions: 46 (46)
- NumInstructions: 892 (892)
- OptimizationTime: 77.885ms
- PeakMemoryUsage: 446.00 KB (456704)
- PrepareTime: 32.866ms
SORT_NODE (id=15):(Total: 13s758ms, non-child: 107.948us, % non-child: 0.00%)
ExecOption: Codegen Enabled
- InMemorySortTime: 18.168us
- InitialRunsCreated: 1 (1)
- PeakMemoryUsage: 24.03 MB (25194496)
- RowsReturned: 52 (52)
- RowsReturnedRate: 3.00 /sec
- SortDataSize: 4.21 KB (4309)
- SpilledRuns: 0 (0)
- TotalMergesPerformed: 0 (0)
ANALYTIC_EVAL_NODE (id=14):(Total: 13s758ms, non-child: 130.644us, % non-child: 0.00%)
- EvaluationTime: 39.204us
- GetNewBlockTime: 2.752us
- PeakMemoryUsage: 8.03 MB (8417280)
- PinTime: 0.000ns
- RowsReturned: 52 (52)
- RowsReturnedRate: 3.00 /sec
- UnpinTime: 0.000ns
SORT_NODE (id=13):(Total: 13s758ms, non-child: 559.936us, % non-child: 0.00%)
ExecOption: Codegen Enabled
- InMemorySortTime: 18.764us
- InitialRunsCreated: 1 (1)
- PeakMemoryUsage: 24.08 MB (25251840)
- RowsReturned: 52 (52)
- RowsReturnedRate: 3.00 /sec
- SortDataSize: 3.80 KB (3893)
- SpilledRuns: 0 (0)
- TotalMergesPerformed: 0 (0)
EXCHANGE_NODE (id=37):(Total: 13s757ms, non-child: 135.244us, % non-child: 0.00%)
BytesReceived(500.000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0
- BytesReceived: 2.57 KB (2630)
- ConvertRowBatchTime: 17.864us
- DeserializeRowBatchTimer: 102.740us
- FirstBatchArrivalWaitTime: 13s747ms
- PeakMemoryUsage: 0
- RowsReturned: 52 (52)
- RowsReturnedRate: 3.00 /sec
- SendersBlockedTimer: 0.000ns
- SendersBlockedTotalTimer(*): 0.000ns
Instance 514ee9ab39cdc507:a7 (host=cdh8.net.cuberonlabs.com:22000):(Total: 13s887ms, non-child: 2.148ms, % non-child: 0.02%)
MemoryUsage(500.000ms): 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB
ThreadUsage(500.000ms): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1
- AverageThreadTokens: 1.00
- BloomFilterBytes: 0
- PeakMemoryUsage: 48.45 MB (50803312)
- PerHostPeakMemUsage: 1.63 GB (1748411303)
- RowsProduced: 0 (0)
- TotalNetworkReceiveTime: 13s761ms
- TotalNetworkSendTime: 250.000ns
- TotalStorageWaitTime: 0.000ns
- TotalThreadsInvoluntaryContextSwitches: 0 (0)
- TotalThreadsTotalWallClockTime: 13s853ms
- TotalThreadsSysTime: 0.000ns
- TotalThreadsUserTime: 92.000ms
- TotalThreadsVoluntaryContextSwitches: 7 (7)
Fragment Instance Lifecycle Timings:
- ExecTime: 220.069us
- ExecTreeExecTime: 3.457us
- OpenTime: 13s853ms
- ExecTreeOpenTime: 13s761ms
- PrepareTime: 33.111ms
- ExecTreePrepareTime: 167.440us
BlockMgr:
- BlockWritesOutstanding: 0 (0)
- BlocksCreated: 399 (399)
- BlocksRecycled: 298 (298)
- BufferedPins: 0 (0)
- BytesWritten: 0
- MaxBlockSize: 8.00 MB (8388608)
- MemoryLimit: 48.00 GB (51539607552)
- PeakMemoryUsage: 1.22 GB (1309378560)
- ScratchFileUsedBytes: 0
- TotalBufferWaitTime: 0.000ns
- TotalEncryptionTime: 0.000ns
- TotalReadBlockTime: 0.000ns
DataStreamSender (dst_id=38):(Total: 16.170us, non-child: 16.170us, % non-child: 100.00%)
- BytesSent: 0
- NetworkThroughput(*): 0.00 /sec
- OverallThroughput: 0.00 /sec
- PeakMemoryUsage: 2.61 KB (2672)
- RowsReturned: 0 (0)
- SerializeBatchTime: 0.000ns
- TransmitDataRPCTime: 0.000ns
- UncompressedRowBatchSize: 0
CodeGen:(Total: 123.349ms, non-child: 123.349ms, % non-child: 100.00%)
- CodegenTime: 1.340ms
- CompileTime: 14.830ms
- LoadTime: 0.000ns
- ModuleBitcodeSize: 1.90 MB (1992760)
- NumFunctions: 46 (46)
- NumInstructions: 892 (892)
- OptimizationTime: 76.406ms
- PeakMemoryUsage: 446.00 KB (456704)
- PrepareTime: 31.310ms
SORT_NODE (id=15):(Total: 13s761ms, non-child: 84.438us, % non-child: 0.00%)
ExecOption: Codegen Enabled
- InMemorySortTime: 524.000ns
- InitialRunsCreated: 1 (1)
- PeakMemoryUsage: 24.02 MB (25182208)
- RowsReturned: 0 (0)
- RowsReturnedRate: 0
- SortDataSize: 0
- SpilledRuns: 0 (0)
- TotalMergesPerformed: 0 (0)
ANALYTIC_EVAL_NODE (id=14):(Total: 13s761ms, non-child: 113.256us, % non-child: 0.00%)
- EvaluationTime: 978.000ns
- GetNewBlockTime: 4.260us
- PeakMemoryUsage: 8.02 MB (8413184)
- PinTime: 0.000ns
- RowsReturned: 0 (0)
- RowsReturnedRate: 0
- UnpinTime: 0.000ns
SORT_NODE (id=13):(Total: 13s761ms, non-child: 118.594us, % non-child: 0.00%)
ExecOption: Codegen Enabled
- InMemorySortTime: 890.000ns
- InitialRunsCreated: 1 (1)
- PeakMemoryUsage: 24.01 MB (25174016)
- RowsReturned: 0 (0)
- RowsReturnedRate: 0
- SortDataSize: 0
- SpilledRuns: 0 (0)
- TotalMergesPerformed: 0 (0)
EXCHANGE_NODE (id=37):(Total: 13s761ms, non-child: 4.757us, % non-child: 0.00%)
BytesReceived(500.000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0
- BytesReceived: 0
- ConvertRowBatchTime: 873.000ns
- DeserializeRowBatchTimer: 0.000ns
- FirstBatchArrivalWaitTime: 13s761ms
- PeakMemoryUsage: 0
- RowsReturned: 0 (0)
- RowsReturnedRate: 0
- SendersBlockedTimer: 0.000ns
- SendersBlockedTotalTimer(*): 0.000ns
Instance 514ee9ab39cdc507:a9 (host=cdh9.net.cuberonlabs.com:22000):(Total: 13s887ms, non-child: 2.060ms, % non-child: 0.01%)
MemoryUsage(500.000ms): 48.01 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB
ThreadUsage(500.000ms): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1
- AverageThreadTokens: 1.00
- BloomFilterBytes: 0
- PeakMemoryUsage: 48.45 MB (50803312)
- PerHostPeakMemUsage: 1.69 GB (1813107104)
- RowsProduced: 0 (0)
- TotalNetworkReceiveTime: 13s760ms
- TotalNetworkSendTime: 228.000ns
- TotalStorageWaitTime: 0.000ns
- TotalThreadsInvoluntaryContextSwitches: 0 (0)
- TotalThreadsTotalWallClockTime: 13s853ms
- TotalThreadsSysTime: 0.000ns
- TotalThreadsUserTime: 96.000ms
- TotalThreadsVoluntaryContextSwitches: 6 (6)
Fragment Instance Lifecycle Timings:
- ExecTime: 177.665us
- ExecTreeExecTime: 2.862us
- OpenTime: 13s853ms
- ExecTreeOpenTime: 13s760ms
- PrepareTime: 33.537ms
- ExecTreePrepareTime: 182.250us
BlockMgr:
- BlockWritesOutstanding: 0 (0)
- BlocksCreated: 415 (415)
- BlocksRecycled: 282 (282)
- BufferedPins: 0 (0)
- BytesWritten: 0
- MaxBlockSize: 8.00 MB (8388608)
- MemoryLimit: 48.00 GB (51539607552)
- PeakMemoryUsage: 1.23 GB (1316128768)
- ScratchFileUsedBytes: 0
- TotalBufferWaitTime: 0.000ns
- TotalEncryptionTime: 0.000ns
- TotalReadBlockTime: 0.000ns
DataStreamSender (dst_id=38):(Total: 15.120us, non-child: 15.120us, % non-child: 100.00%)
- BytesSent: 0
- NetworkThroughput(*): 0.00 /sec
- OverallThroughput: 0.00 /sec
- PeakMemoryUsage: 2.61 KB (2672)
- RowsReturned: 0 (0)
- SerializeBatchTime: 0.000ns
- TransmitDataRPCTime: 0.000ns
- UncompressedRowBatchSize: 0
CodeGen:(Total: 123.926ms, non-child: 123.926ms, % non-child: 100.00%)
- CodegenTime: 1.204ms
- CompileTime: 14.804ms
- LoadTime: 0.000ns
- ModuleBitcodeSize: 1.90 MB (1992760)
- NumFunctions: 46 (46)
- NumInstructions: 892 (892)
- OptimizationTime: 76.515ms
- PeakMemoryUsage: 446.00 KB (456704)
- PrepareTime: 31.813ms
SORT_NODE (id=15):(Total: 13s761ms, non-child: 68.091us, % non-child: 0.00%)
ExecOption: Codegen Enabled
- InMemorySortTime: 492.000ns
- InitialRunsCreated: 1 (1)
- PeakMemoryUsage: 24.02 MB (25182208)
- RowsReturned: 0 (0)
- RowsReturnedRate: 0
- SortDataSize: 0
- SpilledRuns: 0 (0)
- TotalMergesPerformed: 0 (0)
ANALYTIC_EVAL_NODE (id=14):(Total: 13s760ms, non-child: 113.028us, % non-child: 0.00%)
- EvaluationTime: 597.000ns
- GetNewBlockTime: 2.732us
- PeakMemoryUsage: 8.02 MB (8413184)
- PinTime: 0.000ns
- RowsReturned: 0 (0)
- RowsReturnedRate: 0
- UnpinTime: 0.000ns
SORT_NODE (id=13):(Total: 13s760ms, non-child: 116.665us, % non-child: 0.00%)
ExecOption: Codegen Enabled
- InMemorySortTime: 785.000ns
- InitialRunsCreated: 1 (1)
- PeakMemoryUsage: 24.01 MB (25174016)
- RowsReturned: 0 (0)
- RowsReturnedRate: 0
- SortDataSize: 0
- SpilledRuns: 0 (0)
- TotalMergesPerformed: 0 (0)
EXCHANGE_NODE (id=37):(Total: 13s760ms, non-child: 5.428us, % non-child: 0.00%)
BytesReceived(500.000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0
- BytesReceived: 0
- ConvertRowBatchTime: 633.000ns
- DeserializeRowBatchTimer: 0.000ns
- FirstBatchArrivalWaitTime: 13s760ms
- PeakMemoryUsage: 0
- RowsReturned: 0 (0)
- RowsReturnedRate: 0
- SendersBlockedTimer: 0.000ns
- SendersBlockedTotalTimer(*): 0.000ns
Instance 514ee9ab39cdc507:a5 (host=cdh5.net.cuberonlabs.com:22000):(Total: 13s886ms, non-child: 2.233ms, % non-child: 0.02%)
MemoryUsage(500.000ms): 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB
ThreadUsage(500.000ms): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1
- AverageThreadTokens: 1.00
- BloomFilterBytes: 0
- PeakMemoryUsage: 48.45 MB (50803312)
- PerHostPeakMemUsage: 2.15 GB (2303708143)
- RowsProduced: 0 (0)
- TotalNetworkReceiveTime: 13s752ms
- TotalNetworkSendTime: 240.000ns
- TotalStorageWaitTime: 0.000ns
- TotalThreadsInvoluntaryContextSwitches: 0 (0)
- TotalThreadsTotalWallClockTime: 13s852ms
- TotalThreadsSysTime: 0.000ns
- TotalThreadsUserTime: 104.000ms
- TotalThreadsVoluntaryContextSwitches: 8 (8)
Fragment Instance Lifecycle Timings:
- ExecTime: 214.404us
- ExecTreeExecTime: 2.344us
- OpenTime: 13s852ms
- ExecTreeOpenTime: 13s752ms
- PrepareTime: 34.475ms
- ExecTreePrepareTime: 167.700us
BlockMgr:
- BlockWritesOutstanding: 0 (0)
- BlocksCreated: 415 (415)
- BlocksRecycled: 314 (314)
- BufferedPins: 0 (0)
- BytesWritten: 0
- MaxBlockSize: 8.00 MB (8388608)
- MemoryLimit: 48.00 GB (51539607552)
- PeakMemoryUsage: 1.60 GB (1713143808)
- ScratchFileUsedBytes: 0
- TotalBufferWaitTime: 0.000ns
- TotalEncryptionTime: 0.000ns
- TotalReadBlockTime: 0.000ns
DataStreamSender (dst_id=38):(Total: 14.668us, non-child: 14.668us, % non-child: 100.00%)
- BytesSent: 0
- NetworkThroughput(*): 0.00 /sec
- OverallThroughput: 0.00 /sec
- PeakMemoryUsage: 2.61 KB (2672)
- RowsReturned: 0 (0)
- SerializeBatchTime: 0.000ns
- TransmitDataRPCTime: 0.000ns
- UncompressedRowBatchSize: 0
CodeGen:(Total: 131.972ms, non-child: 131.972ms, % non-child: 100.00%)
- CodegenTime: 1.361ms
- CompileTime: 15.902ms
- LoadTime: 0.000ns
- ModuleBitcodeSize: 1.90 MB (1992760)
- NumFunctions: 46 (46)
- NumInstructions: 892 (892)
- OptimizationTime: 82.465ms
- PeakMemoryUsage: 446.00 KB (456704)
- PrepareTime: 32.746ms
SORT_NODE (id=15):(Total: 13s752ms, non-child: 71.460us, % non-child: 0.00%)
ExecOption: Codegen Enabled
- InMemorySortTime: 280.000ns
- InitialRunsCreated: 1 (1)
- PeakMemoryUsage: 24.02 MB (25182208)
- RowsReturned: 0 (0)
- RowsReturnedRate: 0
- SortDataSize: 0
- SpilledRuns: 0 (0)
- TotalMergesPerformed: 0 (0)
ANALYTIC_EVAL_NODE (id=14):(Total: 13s752ms, non-child: 344.756us, % non-child: 0.00%)
- EvaluationTime: 784.000ns
- GetNewBlockTime: 5.432us
- PeakMemoryUsage: 8.02 MB (8413184)
- PinTime: 0.000ns
- RowsReturned: 0 (0)
- RowsReturnedRate: 0
- UnpinTime: 0.000ns
SORT_NODE (id=13):(Total: 13s752ms, non-child: 101.388us, % non-child: 0.00%)
ExecOption: Codegen Enabled
- InMemorySortTime: 568.000ns
- InitialRunsCreated: 1 (1)
- PeakMemoryUsage: 24.01 MB (25174016)
- RowsReturned: 0 (0)
- RowsReturnedRate: 0
- SortDataSize: 0
- SpilledRuns: 0 (0)
- TotalMergesPerformed: 0 (0)
EXCHANGE_NODE (id=37):(Total: 13s752ms, non-child: 4.088us, % non-child: 0.00%)
BytesReceived(500.000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0
- BytesReceived: 0
- ConvertRowBatchTime: 664.000ns
- DeserializeRowBatchTimer: 0.000ns
- FirstBatchArrivalWaitTime: 13s752ms
- PeakMemoryUsage: 0
- RowsReturned: 0 (0)
- RowsReturnedRate: 0
- SendersBlockedTimer: 0.000ns
- SendersBlockedTotalTimer(*): 0.000ns
Instance 514ee9ab39cdc507:a3 (host=cdh14.net.cuberonlabs.com:22000):(Total: 13s886ms, non-child: 2.484ms, % non-child: 0.02%)
MemoryUsage(500.000ms): 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB
ThreadUsage(500.000ms): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1
- AverageThreadTokens: 1.00
- BloomFilterBytes: 0
- PeakMemoryUsage: 48.45 MB (50803312)
- PerHostPeakMemUsage: 1.44 GB (1548652528)
- RowsProduced: 0 (0)
- TotalNetworkReceiveTime: 13s760ms
- TotalNetworkSendTime: 246.000ns
- TotalStorageWaitTime: 0.000ns
- TotalThreadsInvoluntaryContextSwitches: 0 (0)
- TotalThreadsTotalWallClockTime: 13s851ms
- TotalThreadsSysTime: 0.000ns
- TotalThreadsUserTime: 92.000ms
- TotalThreadsVoluntaryContextSwitches: 19 (19)
Fragment Instance Lifecycle Timings:
- ExecTime: 181.521us
- ExecTreeExecTime: 2.643us
- OpenTime: 13s851ms
- ExecTreeOpenTime: 13s760ms
- PrepareTime: 35.477ms
- ExecTreePrepareTime: 160.178us
BlockMgr:
- BlockWritesOutstanding: 0 (0)
- BlocksCreated: 415 (415)
- BlocksRecycled: 282 (282)
- BufferedPins: 0 (0)
- BytesWritten: 0
- MaxBlockSize: 8.00 MB (8388608)
- MemoryLimit: 48.00 GB (51539607552)
- PeakMemoryUsage: 1.07 GB (1154154496)
- ScratchFileUsedBytes: 0
- TotalBufferWaitTime: 0.000ns
- TotalEncryptionTime: 0.000ns
- TotalReadBlockTime: 0.000ns
DataStreamSender (dst_id=38):(Total: 22.010us, non-child: 22.010us, % non-child: 100.00%)
- BytesSent: 0
- NetworkThroughput(*): 0.00 /sec
- OverallThroughput: 0.00 /sec
- PeakMemoryUsage: 2.61 KB (2672)
- RowsReturned: 0 (0)
- SerializeBatchTime: 0.000ns
- TransmitDataRPCTime: 0.000ns
- UncompressedRowBatchSize: 0
CodeGen:(Total: 123.324ms, non-child: 123.324ms, % non-child: 100.00%)
- CodegenTime: 1.250ms
- CompileTime: 14.369ms
- LoadTime: 0.000ns
- ModuleBitcodeSize: 1.90 MB (1992760)
- NumFunctions: 46 (46)
- NumInstructions: 892 (892)
- OptimizationTime: 74.413ms
- PeakMemoryUsage: 446.00 KB (456704)
- PrepareTime: 33.813ms
SORT_NODE (id=15):(Total: 13s761ms, non-child: 67.178us, % non-child: 0.00%)
ExecOption: Codegen Enabled
- InMemorySortTime: 378.000ns
- InitialRunsCreated: 1 (1)
- PeakMemoryUsage: 24.02 MB (25182208)
- RowsReturned: 0 (0)
- RowsReturnedRate: 0
- SortDataSize: 0
- SpilledRuns: 0 (0)
- TotalMergesPerformed: 0 (0)
ANALYTIC_EVAL_NODE (id=14):(Total: 13s760ms, non-child: 421.495us, % non-child: 0.00%)
- EvaluationTime: 839.000ns
- GetNewBlockTime: 6.321us
- PeakMemoryUsage: 8.02 MB (8413184)
- PinTime: 0.000ns
- RowsReturned: 0 (0)
- RowsReturnedRate: 0
- UnpinTime: 0.000ns
SORT_NODE (id=13):(Total: 13s760ms, non-child: 101.616us, % non-child: 0.00%)
ExecOption: Codegen Enabled
- InMemorySortTime: 533.000ns
- InitialRunsCreated: 1 (1)
- PeakMemoryUsage: 24.01 MB (25174016)
- RowsReturned: 0 (0)
- RowsReturnedRate: 0
- SortDataSize: 0
- SpilledRuns: 0 (0)
- TotalMergesPerformed: 0 (0)
EXCHANGE_NODE (id=37):(Total: 13s760ms, non-child: 4.541us, % non-child: 0.00%)
BytesReceived(500.000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0
- BytesReceived: 0
- ConvertRowBatchTime: 892.000ns
- DeserializeRowBatchTimer: 0.000ns
- FirstBatchArrivalWaitTime: 13s760ms
- PeakMemoryUsage: 0
- RowsReturned: 0 (0)
- RowsReturnedRate: 0
- SendersBlockedTimer: 0.000ns
- SendersBlockedTotalTimer(*): 0.000ns
Instance 514ee9ab39cdc507:9e (host=cdh15.net.cuberonlabs.com:22000):(Total: 13s886ms, non-child: 2.041ms, % non-child: 0.01%)
MemoryUsage(500.000ms): 48.45 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB
ThreadUsage(500.000ms): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1
- AverageThreadTokens: 1.00
- BloomFilterBytes: 0
- PeakMemoryUsage: 48.45 MB (50803312)
- PerHostPeakMemUsage: 1.57 GB (1688553772)
- RowsProduced: 0 (0)
- TotalNetworkReceiveTime: 13s759ms
- TotalNetworkSendTime: 253.000ns
- TotalStorageWaitTime: 0.000ns
- TotalThreadsInvoluntaryContextSwitches: 0 (0)
- TotalThreadsTotalWallClockTime: 13s853ms
- TotalThreadsSysTime: 0.000ns
- TotalThreadsUserTime: 92.000ms
- TotalThreadsVoluntaryContextSwitches: 13 (13)
Fragment Instance Lifecycle Timings:
- ExecTime: 194.577us
- ExecTreeExecTime: 2.257us
- OpenTime: 13s853ms
- ExecTreeOpenTime: 13s760ms
- PrepareTime: 33.126ms
- ExecTreePrepareTime: 160.916us
BlockMgr:
- BlockWritesOutstanding: 0 (0)
- BlocksCreated: 415 (415)
- BlocksRecycled: 282 (282)
- BufferedPins: 0 (0)
- BytesWritten: 0
- MaxBlockSize: 8.00 MB (8388608)
- MemoryLimit: 48.00 GB (51539607552)
- PeakMemoryUsage: 1.16 GB (1245904896)
- ScratchFileUsedBytes: 0
- TotalBufferWaitTime: 0.000ns
- TotalEncryptionTime: 0.000ns
- TotalReadBlockTime: 0.000ns
DataStreamSender (dst_id=38):(Total: 15.837us, non-child: 15.837us, % non-child: 100.00%)
- BytesSent: 0
- NetworkThroughput(*): 0.00 /sec
- OverallThroughput: 0.00 /sec
- PeakMemoryUsage: 2.61 KB (2672)
- RowsReturned: 0 (0)
- SerializeBatchTime: 0.000ns
- TransmitDataRPCTime: 0.000ns
- UncompressedRowBatchSize: 0
CodeGen:(Total: 124.408ms, non-child: 124.408ms, % non-child: 100.00%)
- CodegenTime: 1.124ms
- CompileTime: 15.157ms
- LoadTime: 0.000ns
- ModuleBitcodeSize: 1.90 MB (1992760)
- NumFunctions: 46 (46)
- NumInstructions: 892 (892)
- OptimizationTime: 76.979ms
- PeakMemoryUsage: 446.00 KB (456704)
- PrepareTime: 31.422ms
SORT_NODE (id=15):(Total: 13s760ms, non-child: 68.256us, % non-child: 0.00%)
ExecOption: Codegen Enabled
- InMemorySortTime: 313.000ns
- InitialRunsCreated: 1 (1)
- PeakMemoryUsage: 24.02 MB (25182208)
- RowsReturned: 0 (0)
- RowsReturnedRate: 0
- SortDataSize: 0
- SpilledRuns: 0 (0)
- TotalMergesPerformed: 0 (0)
ANALYTIC_EVAL_NODE (id=14):(Total: 13s760ms, non-child: 293.524us, % non-child: 0.00%)
- EvaluationTime: 1.020us
- GetNewBlockTime: 3.136us
- PeakMemoryUsage: 8.02 MB (8413184)
- PinTime: 0.000ns
- RowsReturned: 0 (0)
- RowsReturnedRate: 0
- UnpinTime: 0.000ns
SORT_NODE (id=13):(Total: 13s760ms, non-child: 100.639us, % non-child: 0.00%)
ExecOption: Codegen Enabled
- InMemorySortTime: 780.000ns
- InitialRunsCreated: 1 (1)
- PeakMemoryUsage: 24.01 MB (25174016)
- RowsReturned: 0 (0)
- RowsReturnedRate: 0
- SortDataSize: 0
- SpilledRuns: 0 (0)
- TotalMergesPerformed: 0 (0)
EXCHANGE_NODE (id=37):(Total: 13s759ms, non-child: 5.234us, % non-child: 0.00%)
BytesReceived(500.000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0
- BytesReceived: 0
- ConvertRowBatchTime: 1.107us
- DeserializeRowBatchTimer: 0.000ns
- FirstBatchArrivalWaitTime: 13s759ms
- PeakMemoryUsage: 0
- RowsReturned: 0 (0)
- RowsReturnedRate: 0
- SendersBlockedTimer: 0.000ns
- SendersBlockedTotalTimer(*): 0.000ns
Instance 514ee9ab39cdc507:9c (host=cdh13.net.cuberonlabs.com:22000):(Total: 13s886ms, non-child: 2.054ms, % non-child: 0.01%)
MemoryUsage(500.000ms): 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB
ThreadUsage(500.000ms): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1
- AverageThreadTokens: 1.00
- BloomFilterBytes: 0
- PeakMemoryUsage: 48.45 MB (50803312)
- PerHostPeakMemUsage: 1.66 GB (1782381748)
- RowsProduced: 0 (0)
- TotalNetworkReceiveTime: 13s757ms
- TotalNetworkSendTime: 206.000ns
- TotalStorageWaitTime: 0.000ns
- TotalThreadsInvoluntaryContextSwitches: 0 (0)
- TotalThreadsTotalWallClockTime: 13s852ms
- TotalThreadsSysTime: 0.000ns
- TotalThreadsUserTime: 100.000ms
- TotalThreadsVoluntaryContextSwitches: 12 (12)
Fragment Instance Lifecycle Timings:
- ExecTime: 205.436us
- ExecTreeExecTime: 6.160us
- OpenTime: 13s852ms
- ExecTreeOpenTime: 13s757ms
- PrepareTime: 34.197ms
- ExecTreePrepareTime: 158.355us
BlockMgr:
- BlockWritesOutstanding: 0 (0)
- BlocksCreated: 415 (415)
- BlocksRecycled: 282 (282)
- BufferedPins: 0 (0)
- BytesWritten: 0
- MaxBlockSize: 8.00 MB (8388608)
- MemoryLimit: 48.00 GB (51539607552)
- PeakMemoryUsage: 1.22 GB (1308917760)
- ScratchFileUsedBytes: 0
- TotalBufferWaitTime: 0.000ns
- TotalEncryptionTime: 0.000ns
- TotalReadBlockTime: 0.000ns
DataStreamSender (dst_id=38):(Total: 26.086us, non-child: 26.086us, % non-child: 100.00%)
- BytesSent: 0
- NetworkThroughput(*): 0.00 /sec
- OverallThroughput: 0.00 /sec
- PeakMemoryUsage: 2.61 KB (2672)
- RowsReturned: 0 (0)
- SerializeBatchTime: 0.000ns
- TransmitDataRPCTime: 0.000ns
- UncompressedRowBatchSize: 0
CodeGen:(Total: 126.891ms, non-child: 126.891ms, % non-child: 100.00%)
- CodegenTime: 1.199ms
- CompileTime: 15.256ms
- LoadTime: 0.000ns
- ModuleBitcodeSize: 1.90 MB (1992760)
- NumFunctions: 46 (46)
- NumInstructions: 892 (892)
- OptimizationTime: 78.210ms
- PeakMemoryUsage: 446.00 KB (456704)
- PrepareTime: 32.655ms
SORT_NODE (id=15):(Total: 13s757ms, non-child: 287.881us, % non-child: 0.00%)
ExecOption: Codegen Enabled
- InMemorySortTime: 219.000ns
- InitialRunsCreated: 1 (1)
- PeakMemoryUsage: 24.02 MB (25182208)
- RowsReturned: 0 (0)
- RowsReturnedRate: 0
- SortDataSize: 0
- SpilledRuns: 0 (0)
- TotalMergesPerformed: 0 (0)
ANALYTIC_EVAL_NODE (id=14):(Total: 13s757ms, non-child: 100.004us, % non-child: 0.00%)
- EvaluationTime: 834.000ns
- GetNewBlockTime: 3.136us
- PeakMemoryUsage: 8.02 MB (8413184)
- PinTime: 0.000ns
- RowsReturned: 0 (0)
- RowsReturnedRate: 0
- UnpinTime: 0.000ns
SORT_NODE (id=13):(Total: 13s757ms, non-child: 103.106us, % non-child: 0.00%)
ExecOption: Codegen Enabled
- InMemorySortTime: 729.000ns
- InitialRunsCreated: 1 (1)
- PeakMemoryUsage: 24.01 MB (25174016)
- RowsReturned: 0 (0)
- RowsReturnedRate: 0
- SortDataSize: 0
- SpilledRuns: 0 (0)
- TotalMergesPerformed: 0 (0)
EXCHANGE_NODE (id=37):(Total: 13s757ms, non-child: 4.783us, % non-child: 0.00%)
BytesReceived(500.000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0
- BytesReceived: 0
- ConvertRowBatchTime: 1.058us
- DeserializeRowBatchTimer: 0.000ns
- FirstBatchArrivalWaitTime: 13s757ms
- PeakMemoryUsage: 0
- RowsReturned: 0 (0)
- RowsReturnedRate: 0
- SendersBlockedTimer: 0.000ns
- SendersBlockedTotalTimer(*): 0.000ns
Instance 514ee9ab39cdc507:a6 (host=cdh7.net.cuberonlabs.com:22000):(Total: 13s886ms, non-child: 2.144ms, % non-child: 0.02%)
MemoryUsage(500.000ms): 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB
ThreadUsage(500.000ms): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1
- AverageThreadTokens: 1.00
- BloomFilterBytes: 0
- PeakMemoryUsage: 48.45 MB (50803312)
- PerHostPeakMemUsage: 1.58 GB (1699637471)
- RowsProduced: 0 (0)
- TotalNetworkReceiveTime: 13s755ms
- TotalNetworkSendTime: 226.000ns
- TotalStorageWaitTime: 0.000ns
- TotalThreadsInvoluntaryContextSwitches: 1 (1)
- TotalThreadsTotalWallClockTime: 13s850ms
- TotalThreadsSysTime: 0.000ns
- TotalThreadsUserTime: 96.000ms
- TotalThreadsVoluntaryContextSwitches: 10 (10)
Fragment Instance Lifecycle Timings:
- ExecTime: 245.757us
- ExecTreeExecTime: 2.753us
- OpenTime: 13s850ms
- ExecTreeOpenTime: 13s755ms
- PrepareTime: 35.589ms
- ExecTreePrepareTime: 166.049us
BlockMgr:
- BlockWritesOutstanding: 0 (0)
- BlocksCreated: 383 (383)
- BlocksRecycled: 314 (314)
- BufferedPins: 0 (0)
- BytesWritten: 0
- MaxBlockSize: 8.00 MB (8388608)
- MemoryLimit: 48.00 GB (51539607552)
- PeakMemoryUsage: 1.19 GB (1280214016)
- ScratchFileUsedBytes: 0
- TotalBufferWaitTime: 0.000ns
- TotalEncryptionTime: 0.000ns
- TotalReadBlockTime: 0.000ns
DataStreamSender (dst_id=38):(Total: 15.738us, non-child: 15.738us, % non-child: 100.00%)
- BytesSent: 0
- NetworkThroughput(*): 0.00 /sec
- OverallThroughput: 0.00 /sec
- PeakMemoryUsage: 2.61 KB (2672)
- RowsReturned: 0 (0)
- SerializeBatchTime: 0.000ns
- TransmitDataRPCTime: 0.000ns
- UncompressedRowBatchSize: 0
CodeGen:(Total: 128.702ms, non-child: 128.702ms, % non-child: 100.00%)
- CodegenTime: 1.164ms
- CompileTime: 15.188ms
- LoadTime: 0.000ns
- ModuleBitcodeSize: 1.90 MB (1992760)
- NumFunctions: 46 (46)
- NumInstructions: 892 (892)
- OptimizationTime: 78.455ms
- PeakMemoryUsage: 446.00 KB (456704)
- PrepareTime: 34.260ms
SORT_NODE (id=15):(Total: 13s755ms, non-child: 76.025us, % non-child: 0.00%)
ExecOption: Codegen Enabled
- InMemorySortTime: 270.000ns
- InitialRunsCreated: 1 (1)
- PeakMemoryUsage: 24.02 MB (25182208)
- RowsReturned: 0 (0)
- RowsReturnedRate: 0
- SortDataSize: 0
- SpilledRuns: 0 (0)
- TotalMergesPerformed: 0 (0)
ANALYTIC_EVAL_NODE (id=14):(Total: 13s755ms, non-child: 97.360us, % non-child: 0.00%)
- EvaluationTime: 687.000ns
- GetNewBlockTime: 3.070us
- PeakMemoryUsage: 8.02 MB (8413184)
- PinTime: 0.000ns
- RowsReturned: 0 (0)
- RowsReturnedRate: 0
- UnpinTime: 0.000ns
SORT_NODE (id=13):(Total: 13s755ms, non-child: 109.671us, % non-child: 0.00%)
ExecOption: Codegen Enabled
- InMemorySortTime: 1.040us
- InitialRunsCreated: 1 (1)
- PeakMemoryUsage: 24.01 MB (25174016)
- RowsReturned: 0 (0)
- RowsReturnedRate: 0
- SortDataSize: 0
- SpilledRuns: 0 (0)
- TotalMergesPerformed: 0 (0)
EXCHANGE_NODE (id=37):(Total: 13s755ms, non-child: 9.185us, % non-child: 0.00%)
BytesReceived(500.000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0
- BytesReceived: 0
- ConvertRowBatchTime: 1.053us
- DeserializeRowBatchTimer: 0.000ns
- FirstBatchArrivalWaitTime: 13s755ms
- PeakMemoryUsage: 0
- RowsReturned: 0 (0)
- RowsReturnedRate: 0
- SendersBlockedTimer: 0.000ns
- SendersBlockedTotalTimer(*): 0.000ns
Instance 514ee9ab39cdc507:9a (host=cdh4.net.cuberonlabs.com:22000):(Total: 13s886ms, non-child: 2.048ms, % non-child: 0.01%)
MemoryUsage(500.000ms): 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB
ThreadUsage(500.000ms): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1
- AverageThreadTokens: 1.00
- BloomFilterBytes: 0
- PeakMemoryUsage: 48.45 MB (50803312)
- PerHostPeakMemUsage: 2.13 GB (2284202661)
- RowsProduced: 0 (0)
- TotalNetworkReceiveTime: 13s744ms
- TotalNetworkSendTime: 224.000ns
- TotalStorageWaitTime: 0.000ns
- TotalThreadsInvoluntaryContextSwitches: 7 (7)
- TotalThreadsTotalWallClockTime: 13s853ms
- TotalThreadsSysTime: 0.000ns
- TotalThreadsUserTime: 112.000ms
- TotalThreadsVoluntaryContextSwitches: 20 (20)
Fragment Instance Lifecycle Timings:
- ExecTime: 230.344us
- ExecTreeExecTime: 3.068us
- OpenTime: 13s853ms
- ExecTreeOpenTime: 13s745ms
- PrepareTime: 32.891ms
- ExecTreePrepareTime: 142.416us
BlockMgr:
- BlockWritesOutstanding: 0 (0)
- BlocksCreated: 417 (417)
- BlocksRecycled: 312 (312)
- BufferedPins: 0 (0)
- BytesWritten: 0
- MaxBlockSize: 8.00 MB (8388608)
- MemoryLimit: 48.00 GB (51539607552)
- PeakMemoryUsage: 1.58 GB (1692174336)
- ScratchFileUsedBytes: 0
- TotalBufferWaitTime: 0.000ns
- TotalEncryptionTime: 0.000ns
- TotalReadBlockTime: 0.000ns
DataStreamSender (dst_id=38):(Total: 13.820us, non-child: 13.820us, % non-child: 100.00%)
- BytesSent: 0
- NetworkThroughput(*): 0.00 /sec
- OverallThroughput: 0.00 /sec
- PeakMemoryUsage: 2.61 KB (2672)
- RowsReturned: 0 (0)
- SerializeBatchTime: 0.000ns
- TransmitDataRPCTime: 0.000ns
- UncompressedRowBatchSize: 0
CodeGen:(Total: 138.774ms, non-child: 138.774ms, % non-child: 100.00%)
- CodegenTime: 1.143ms
- CompileTime: 21.751ms
- LoadTime: 0.000ns
- ModuleBitcodeSize: 1.90 MB (1992760)
- NumFunctions: 46 (46)
- NumInstructions: 892 (892)
- OptimizationTime: 84.782ms
- PeakMemoryUsage: 446.00 KB (456704)
- PrepareTime: 31.256ms
SORT_NODE (id=15):(Total: 13s745ms, non-child: 77.932us, % non-child: 0.00%)
ExecOption: Codegen Enabled
- InMemorySortTime: 260.000ns
- InitialRunsCreated: 1 (1)
- PeakMemoryUsage: 24.02 MB (25182208)
- RowsReturned: 0 (0)
- RowsReturnedRate: 0
- SortDataSize: 0
- SpilledRuns: 0 (0)
- TotalMergesPerformed: 0 (0)
ANALYTIC_EVAL_NODE (id=14):(Total: 13s745ms, non-child: 425.152us, % non-child: 0.00%)
- EvaluationTime: 888.000ns
- GetNewBlockTime: 5.936us
- PeakMemoryUsage: 8.02 MB (8413184)
- PinTime: 0.000ns
- RowsReturned: 0 (0)
- RowsReturnedRate: 0
- UnpinTime: 0.000ns
SORT_NODE (id=13):(Total: 13s745ms, non-child: 97.580us, % non-child: 0.00%)
ExecOption: Codegen Enabled
- InMemorySortTime: 632.000ns
- InitialRunsCreated: 1 (1)
- PeakMemoryUsage: 24.01 MB (25174016)
- RowsReturned: 0 (0)
- RowsReturnedRate: 0
- SortDataSize: 0
- SpilledRuns: 0 (0)
- TotalMergesPerformed: 0 (0)
EXCHANGE_NODE (id=37):(Total: 13s744ms, non-child: 4.672us, % non-child: 0.00%)
BytesReceived(500.000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0
- BytesReceived: 0
- ConvertRowBatchTime: 812.000ns
- DeserializeRowBatchTimer: 0.000ns
- FirstBatchArrivalWaitTime: 13s744ms
- PeakMemoryUsage: 0
- RowsReturned: 0 (0)
- RowsReturnedRate: 0
- SendersBlockedTimer: 0.000ns
- SendersBlockedTotalTimer(*): 0.000ns
Instance 514ee9ab39cdc507:9b (host=cdh16.net.cuberonlabs.com:22000):(Total: 13s886ms, non-child: 2.066ms, % non-child: 0.01%)
MemoryUsage(500.000ms): 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB, 48.02 MB
ThreadUsage(500.000ms): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1
- AverageThreadTokens: 1.00
- BloomFilterBytes: 0
- PeakMemoryUsage: 48.45 MB (50803312)
- PerHostPeakMemUsage: 1.64 GB (1763578733)
- RowsProduced: 0 (0)
- TotalNetworkReceiveTime: 13s748ms
- TotalNetworkSendTime: 259.000ns
- TotalStorageWaitTime: 0.000ns
- TotalThreadsInvoluntaryContextSwitches: 1 (1)
- TotalThreadsTotalWallClockTime: 13s853ms
- TotalThreadsSysTime: 0.000ns
- TotalThreadsUserTime: 108.000ms
- TotalThreadsVoluntaryContextSwitches: 12 (12)
Fragment Instance Lifecycle Timings:
- ExecTime: 194.334us
- ExecTreeExecTime: 2.733us
- OpenTime: 13s853ms
- ExecTreeOpenTime: 13s749ms
- PrepareTime: 32.380ms
- ExecTreePrepareTime: 161.699us
BlockMgr:
- BlockWritesOutstanding: 0 (0)
- BlocksCreated: 399 (399)
- BlocksRecycled: 298 (298)
- BufferedPins: 0 (0)
- BytesWritten: 0
- MaxBlockSize: 8.00 MB (8388608)
- MemoryLimit: 48.00 GB (51539607552)
- PeakMemoryUsage: 1.23 GB (1317240832)
- ScratchFileUsedBytes: 0
- TotalBufferWaitTime: 0.000ns
- TotalEncryptionTime: 0.000ns
- TotalReadBlockTime: 0.000ns
DataStreamSender (dst_id=38):(Total: 15.074us, non-child: 15.074us, % non-child: 100.00%)
- BytesSent: 0
- NetworkThroughput(*): 0.00 /sec
- OverallThroughput: 0.00 /sec
- PeakMemoryUsage: 2.61 KB (2672)
- RowsReturned: 0 (0)
- SerializeBatchTime: 0.000ns
- TransmitDataRPCTime: 0.000ns
- UncompressedRowBatchSize: 0
CodeGen:(Total: 134.896ms, non-child: 134.896ms, % non-child: 100.00%)
- CodegenTime: 779.704us
- CompileTime: 16.301ms
- LoadTime: 0.000ns
- ModuleBitcodeSize: 1.90 MB (1992760)
- NumFunctions: 46 (46)
- NumInstructions: 892 (892)
- OptimizationTime: 86.857ms
- PeakMemoryUsage: 446.00 KB (456704)
- PrepareTime: 31.199ms
SORT_NODE (id=15):(Total: 13s749ms, non-child: 63.516us, % non-child: 0.00%)
ExecOption: Codegen Enabled
- InMemorySortTime: 301.000ns
- InitialRunsCreated: 1 (1)
- PeakMemoryUsage: 24.02 MB (25182208)
- RowsReturned: 0 (0)
- RowsReturnedRate: 0
- SortDataSize: 0
- SpilledRuns: 0 (0)
- TotalMergesPerformed: 0 (0)
ANALYTIC_EVAL_NODE (id=14):(Total: 13s749ms, non-child: 122.081us, % non-child: 0.00%)
- EvaluationTime: 779.000ns
- GetNewBlockTime: 5.600us
- PeakMemoryUsage: 8.02 MB (8413184)
- PinTime: 0.000ns
- RowsReturned: 0 (0)
- RowsReturnedRate: 0
- UnpinTime: 0.000ns
SORT_NODE (id=13):(Total: 13s749ms, non-child: 358.391us, % non-child: 0.00%)
ExecOption: Codegen Enabled
- InMemorySortTime: 637.000ns
- InitialRunsCreated: 1 (1)
- PeakMemoryUsage: 24.01 MB (25174016)
- RowsReturned: 0 (0)
- RowsReturnedRate: 0
- SortDataSize: 0
- SpilledRuns: 0 (0)
- TotalMergesPerformed: 0 (0)
EXCHANGE_NODE (id=37):(Total: 13s748ms, non-child: 4.234us, % non-child: 0.00%)
BytesReceived(500.000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0
- BytesReceived: 0
- ConvertRowBatchTime: 737.000ns
- DeserializeRowBatchTimer: 0.000ns
- FirstBatchArrivalWaitTime: 13s748ms
- PeakMemoryUsage: 0
- RowsReturned: 0 (0)
- RowsReturnedRate: 0
- SendersBlockedTimer: 0.000ns
- SendersBlockedTotalTimer(*): 0.000ns
Averaged Fragment F09:(Total: 13s880ms, non-child: 8.807ms, % non-child: 0.06%)
split sizes: min: 0, max: 0, avg: 0, stddev: 0
completion times: min:13s878ms max:13s886ms mean: 13s882ms stddev:2.535ms
execution rates: min:0.00 /sec max:0.00 /sec mean:0.00 /sec stddev:0.00 /sec
num instances: 17
- AverageThreadTokens: 1.00
- BloomFilterBytes: 0
- PeakMemoryUsage: 5.89 MB (6175198)
- PerHostPeakMemUsage: 1.70 GB (1824024877)
- RowsProduced: 3 (3)
- TotalNetworkReceiveTime: 13s589ms
- TotalNetworkSendTime: 248.386us
- TotalStorageWaitTime: 0.000ns
- TotalThreadsInvoluntaryContextSwitches: 0 (0)
- TotalThreadsTotalWallClockTime: 13s842ms
- TotalThreadsSysTime: 5.411ms
- TotalThreadsUserTime: 244.705ms
- TotalThreadsVoluntaryContextSwitches: 100 (100)
Fragment Instance Lifecycle Timings:
- ExecTime: 3.367ms
- ExecTreeExecTime: 160.482us
- OpenTime: 13s839ms
- ExecTreeOpenTime: 13s593ms
- PrepareTime: 37.924ms
- ExecTreePrepareTime: 1.258ms
DataStreamSender (dst_id=37):(Total: 97.659us, non-child: 97.659us, % non-child: 100.00%)
- BytesSent: 154.00 B (154)
- NetworkThroughput(*): 4.90 MB/sec
- OverallThroughput: 1.59 MB/sec
- PeakMemoryUsage: 56.99 KB (58360)
- RowsReturned: 3 (3)
- SerializeBatchTime: 20.743us
- TransmitDataRPCTime: 36.087us
- UncompressedRowBatchSize: 245.00 B (245)
CodeGen:(Total: 276.452ms, non-child: 276.452ms, % non-child: 100.00%)
- CodegenTime: 4.311ms
- CompileTime: 83.330ms
- LoadTime: 0.000ns
- ModuleBitcodeSize: 1.90 MB (1992760)
- NumFunctions: 56 (56)
- NumInstructions: 1.52K (1523)
- OptimizationTime: 160.782ms
- PeakMemoryUsage: 761.50 KB (779776)
- PrepareTime: 31.557ms
AGGREGATION_NODE (id=12):(Total: 13s595ms, non-child: 1.898ms, % non-child: 0.01%)
- BuildTime: 339.488us
- GetNewBlockTime: 164.748us
- GetResultsTime: 6.136us
- HTResizeTime: 26.735us
- HashBuckets: 2.95K (2951)
- LargestPartitionPercent: 7 (7)
- MaxPartitionLevel: 0 (0)
- NumRepartitions: 0 (0)
- PartitionsCreated: 16 (16)
- PeakMemoryUsage: 2.31 MB (2427008)
- PinTime: 0.000ns
- RowsRepartitioned: 0 (0)
- RowsReturned: 3 (3)
- RowsReturnedRate: 0
- SpilledPartitions: 0 (0)
- UnpinTime: 911.000ns
AGGREGATION_NODE (id=36):(Total: 13s593ms, non-child: 3.646ms, % non-child: 0.03%)
- BuildTime: 1.277ms
- GetNewBlockTime: 180.067us
- GetResultsTime: 176.689us
- HTResizeTime: 474.485us
- HashBuckets: 23.43K (23431)
- LargestPartitionPercent: 14 (14)
- MaxPartitionLevel: 0 (0)
- NumRepartitions: 0 (0)
- PartitionsCreated: 16 (16)
- PeakMemoryUsage: 3.00 MB (3146340)
- PinTime: 0.000ns
- RowsRepartitioned: 0 (0)
- RowsReturned: 2.11K (2108)
- RowsReturnedRate: 154.00 /sec
- SpilledPartitions: 0 (0)
- UnpinTime: 998.000ns
EXCHANGE_NODE (id=35):(Total: 13s589ms, non-child: 13s589ms, % non-child: 100.00%)
- BytesReceived: 122.07 KB (124997)
- ConvertRowBatchTime: 64.458us
- DeserializeRowBatchTimer: 693.596us
- FirstBatchArrivalWaitTime: 13s575ms
- PeakMemoryUsage: 0
- RowsReturned: 2.11K (2108)
- RowsReturnedRate: 154.00 /sec
- SendersBlockedTimer: 0.000ns
- SendersBlockedTotalTimer(*): 0.000ns
Fragment F09:
Instance 514ee9ab39cdc507:98 (host=cdh9.net.cuberonlabs.com:22000):(Total: 13s885ms, non-child: 8.614ms, % non-child: 0.06%)
MemoryUsage(500.000ms): 5.40 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB
ThreadUsage(500.000ms): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1
- AverageThreadTokens: 1.00
- BloomFilterBytes: 0
- PeakMemoryUsage: 5.40 MB (5660408)
- PerHostPeakMemUsage: 1.69 GB (1813107104)
- RowsProduced: 4 (4)
- TotalNetworkReceiveTime: 13s609ms
- TotalNetworkSendTime: 232.353us
- TotalStorageWaitTime: 0.000ns
- TotalThreadsInvoluntaryContextSwitches: 0 (0)
- TotalThreadsTotalWallClockTime: 13s848ms
- TotalThreadsSysTime: 0.000ns
- TotalThreadsUserTime: 236.000ms
- TotalThreadsVoluntaryContextSwitches: 71 (71)
Fragment Instance Lifecycle Timings:
- ExecTime: 3.826ms
- ExecTreeExecTime: 312.368us
- OpenTime: 13s844ms
- ExecTreeOpenTime: 13s614ms
- PrepareTime: 37.348ms
- ExecTreePrepareTime: 1.243ms
DataStreamSender (dst_id=37):(Total: 90.018us, non-child: 90.018us, % non-child: 100.00%)
- BytesSent: 190.00 B (190)
- NetworkThroughput(*): 6.56 MB/sec
- OverallThroughput: 2.01 MB/sec
- PeakMemoryUsage: 56.99 KB (58360)
- RowsReturned: 4 (4)
- SerializeBatchTime: 16.477us
- TransmitDataRPCTime: 27.613us
- UncompressedRowBatchSize: 310.00 B (310)
CodeGen:(Total: 261.175ms, non-child: 261.175ms, % non-child: 100.00%)
- CodegenTime: 4.163ms
- CompileTime: 72.410ms
- LoadTime: 0.000ns
- ModuleBitcodeSize: 1.90 MB (1992760)
- NumFunctions: 56 (56)
- NumInstructions: 1.52K (1523)
- OptimizationTime: 156.852ms
- PeakMemoryUsage: 761.50 KB (779776)
- PrepareTime: 31.200ms
AGGREGATION_NODE (id=12):(Total: 13s615ms, non-child: 3.467ms, % non-child: 0.03%)
ExecOption: Codegen Enabled
- BuildTime: 257.464us
- GetNewBlockTime: 161.464us
- GetResultsTime: 11.696us
- HTResizeTime: 18.093us
- HashBuckets: 4.10K (4096)
- LargestPartitionPercent: 0 (0)
- MaxPartitionLevel: 0 (0)
- NumRepartitions: 0 (0)
- PartitionsCreated: 16 (16)
- PeakMemoryUsage: 2.30 MB (2410624)
- PinTime: 0.000ns
- RowsRepartitioned: 0 (0)
- RowsReturned: 4 (4)
- RowsReturnedRate: 0
- SpilledPartitions: 0 (0)
- UnpinTime: 916.000ns
AGGREGATION_NODE (id=36):(Total: 13s612ms, non-child: 2.864ms, % non-child: 0.02%)
ExecOption: Codegen Enabled
- BuildTime: 1.151ms
- GetNewBlockTime: 196.156us
- GetResultsTime: 147.690us
- HTResizeTime: 740.979us
- HashBuckets: 32.77K (32768)
- LargestPartitionPercent: 7 (7)
- MaxPartitionLevel: 0 (0)
- NumRepartitions: 0 (0)
- PartitionsCreated: 16 (16)
- PeakMemoryUsage: 2.69 MB (2823492)
- PinTime: 0.000ns
- RowsRepartitioned: 0 (0)
- RowsReturned: 1.10K (1097)
- RowsReturnedRate: 80.00 /sec
- SpilledPartitions: 0 (0)
- UnpinTime: 996.000ns
EXCHANGE_NODE (id=35):(Total: 13s609ms, non-child: 190.273us, % non-child: 0.00%)
BytesReceived(500.000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0
- BytesReceived: 69.51 KB (71181)
- ConvertRowBatchTime: 45.897us
- DeserializeRowBatchTimer: 392.699us
- FirstBatchArrivalWaitTime: 13s593ms
- PeakMemoryUsage: 0
- RowsReturned: 1.10K (1097)
- RowsReturnedRate: 80.00 /sec
- SendersBlockedTimer: 0.000ns
- SendersBlockedTotalTimer(*): 0.000ns
Instance 514ee9ab39cdc507:90 (host=cdh2.net.cuberonlabs.com:22000):(Total: 13s883ms, non-child: 8.754ms, % non-child: 0.06%)
MemoryUsage(500.000ms): 5.40 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB
ThreadUsage(500.000ms): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1
- AverageThreadTokens: 1.00
- BloomFilterBytes: 0
- PeakMemoryUsage: 13.74 MB (14411849)
- PerHostPeakMemUsage: 1.74 GB (1866918022)
- RowsProduced: 5 (5)
- TotalNetworkReceiveTime: 13s581ms
- TotalNetworkSendTime: 256.612us
- TotalStorageWaitTime: 0.000ns
- TotalThreadsInvoluntaryContextSwitches: 1 (1)
- TotalThreadsTotalWallClockTime: 13s845ms
- TotalThreadsSysTime: 4.000ms
- TotalThreadsUserTime: 252.000ms
- TotalThreadsVoluntaryContextSwitches: 161 (161)
Fragment Instance Lifecycle Timings:
- ExecTime: 3.524ms
- ExecTreeExecTime: 244.544us
- OpenTime: 13s841ms
- ExecTreeOpenTime: 13s599ms
- PrepareTime: 37.722ms
- ExecTreePrepareTime: 1.112ms
DataStreamSender (dst_id=37):(Total: 107.180us, non-child: 107.180us, % non-child: 100.00%)
- BytesSent: 228.00 B (228)
- NetworkThroughput(*): 4.01 MB/sec
- OverallThroughput: 2.03 MB/sec
- PeakMemoryUsage: 56.99 KB (58360)
- RowsReturned: 5 (5)
- SerializeBatchTime: 16.596us
- TransmitDataRPCTime: 54.288us
- UncompressedRowBatchSize: 380.00 B (380)
CodeGen:(Total: 273.326ms, non-child: 273.326ms, % non-child: 100.00%)
- CodegenTime: 4.245ms
- CompileTime: 81.004ms
- LoadTime: 0.000ns
- ModuleBitcodeSize: 1.90 MB (1992760)
- NumFunctions: 56 (56)
- NumInstructions: 1.52K (1523)
- OptimizationTime: 160.043ms
- PeakMemoryUsage: 761.50 KB (779776)
- PrepareTime: 31.470ms
AGGREGATION_NODE (id=12):(Total: 13s600ms, non-child: 4.211ms, % non-child: 0.03%)
ExecOption: Codegen Enabled
- BuildTime: 2.570ms
- GetNewBlockTime: 149.896us
- GetResultsTime: 8.644us
- HTResizeTime: 166.784us
- HashBuckets: 6.14K (6144)
- LargestPartitionPercent: 0 (0)
- MaxPartitionLevel: 0 (0)
- NumRepartitions: 0 (0)
- PartitionsCreated: 16 (16)
- PeakMemoryUsage: 2.56 MB (2689152)
- PinTime: 0.000ns
- RowsRepartitioned: 0 (0)
- RowsReturned: 5 (5)
- RowsReturnedRate: 0
- SpilledPartitions: 0 (0)
- UnpinTime: 892.000ns
AGGREGATION_NODE (id=36):(Total: 13s596ms, non-child: 14.411ms, % non-child: 0.11%)
ExecOption: Codegen Enabled
- BuildTime: 11.368ms
- GetNewBlockTime: 189.796us
- GetResultsTime: 1.263ms
- HTResizeTime: 3.971ms
- HashBuckets: 65.54K (65536)
- LargestPartitionPercent: 6 (6)
- MaxPartitionLevel: 0 (0)
- NumRepartitions: 0 (0)
- PartitionsCreated: 16 (16)
- PeakMemoryUsage: 11.19 MB (11735748)
- PinTime: 0.000ns
- RowsRepartitioned: 0 (0)
- RowsReturned: 21.13K (21130)
- RowsReturnedRate: 1.55 K/sec
- SpilledPartitions: 0 (0)
- UnpinTime: 952.000ns
EXCHANGE_NODE (id=35):(Total: 13s582ms, non-child: 1.386ms, % non-child: 0.01%)
BytesReceived(500.000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0
- BytesReceived: 1.15 MB (1204724)
- ConvertRowBatchTime: 473.332us
- DeserializeRowBatchTimer: 5.090ms
- FirstBatchArrivalWaitTime: 13s572ms
- PeakMemoryUsage: 0
- RowsReturned: 21.13K (21130)
- RowsReturnedRate: 1.55 K/sec
- SendersBlockedTimer: 0.000ns
- SendersBlockedTotalTimer(*): 0.000ns
Instance 514ee9ab39cdc507:97 (host=cdh11.net.cuberonlabs.com:22000):(Total: 13s882ms, non-child: 8.696ms, % non-child: 0.06%)
MemoryUsage(500.000ms): 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB
ThreadUsage(500.000ms): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1
- AverageThreadTokens: 1.00
- BloomFilterBytes: 0
- PeakMemoryUsage: 5.40 MB (5660408)
- PerHostPeakMemUsage: 1.48 GB (1591793359)
- RowsProduced: 1 (1)
- TotalNetworkReceiveTime: 13s639ms
- TotalNetworkSendTime: 237.962us
- TotalStorageWaitTime: 0.000ns
- TotalThreadsInvoluntaryContextSwitches: 0 (0)
- TotalThreadsTotalWallClockTime: 13s846ms
- TotalThreadsSysTime: 0.000ns
- TotalThreadsUserTime: 204.000ms
- TotalThreadsVoluntaryContextSwitches: 49 (49)
Fragment Instance Lifecycle Timings:
- ExecTime: 3.533ms
- ExecTreeExecTime: 122.911us
- OpenTime: 13s843ms
- ExecTreeOpenTime: 13s641ms
- PrepareTime: 35.769ms
- ExecTreePrepareTime: 1.210ms
DataStreamSender (dst_id=37):(Total: 96.748us, non-child: 96.748us, % non-child: 100.00%)
- BytesSent: 67.00 B (67)
- NetworkThroughput(*): 2.32 MB/sec
- OverallThroughput: 676.29 KB/sec
- PeakMemoryUsage: 56.99 KB (58360)
- RowsReturned: 1 (1)
- SerializeBatchTime: 29.650us
- TransmitDataRPCTime: 27.487us
- UncompressedRowBatchSize: 85.00 B (85)
CodeGen:(Total: 230.816ms, non-child: 230.816ms, % non-child: 100.00%)
- CodegenTime: 2.510ms
- CompileTime: 71.216ms
- LoadTime: 0.000ns
- ModuleBitcodeSize: 1.90 MB (1992760)
- NumFunctions: 56 (56)
- NumInstructions: 1.52K (1523)
- OptimizationTime: 129.548ms
- PeakMemoryUsage: 761.50 KB (779776)
- PrepareTime: 29.599ms
AGGREGATION_NODE (id=12):(Total: 13s643ms, non-child: 1.498ms, % non-child: 0.01%)
ExecOption: Codegen Enabled
- BuildTime: 17.327us
- GetNewBlockTime: 151.591us
- GetResultsTime: 3.034us
- HTResizeTime: 6.464us
- HashBuckets: 1.02K (1024)
- LargestPartitionPercent: 100 (100)
- MaxPartitionLevel: 0 (0)
- NumRepartitions: 0 (0)
- PartitionsCreated: 16 (16)
- PeakMemoryUsage: 2.30 MB (2410624)
- PinTime: 0.000ns
- RowsRepartitioned: 0 (0)
- RowsReturned: 1 (1)
- RowsReturnedRate: 0
- SpilledPartitions: 0 (0)
- UnpinTime: 852.000ns
AGGREGATION_NODE (id=36):(Total: 13s641ms, non-child: 1.940ms, % non-child: 0.01%)
ExecOption: Codegen Enabled
- BuildTime: 11.892us
- GetNewBlockTime: 156.314us
- GetResultsTime: 929.000ns
- HTResizeTime: 4.189us
- HashBuckets: 1.02K (1024)
- LargestPartitionPercent: 100 (100)
- MaxPartitionLevel: 0 (0)
- NumRepartitions: 0 (0)
- PartitionsCreated: 16 (16)
- PeakMemoryUsage: 2.32 MB (2428032)
- PinTime: 0.000ns
- RowsRepartitioned: 0 (0)
- RowsReturned: 1 (1)
- RowsReturnedRate: 0
- SpilledPartitions: 0 (0)
- UnpinTime: 1.012us
EXCHANGE_NODE (id=35):(Total: 13s639ms, non-child: 9.593us, % non-child: 0.00%)
BytesReceived(500.000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0
- BytesReceived: 107.00 B (107)
- ConvertRowBatchTime: 651.000ns
- DeserializeRowBatchTimer: 11.520us
- FirstBatchArrivalWaitTime: 13s639ms
- PeakMemoryUsage: 0
- RowsReturned: 1 (1)
- RowsReturnedRate: 0
- SendersBlockedTimer: 0.000ns
- SendersBlockedTotalTimer(*): 0.000ns
Instance 514ee9ab39cdc507:96 (host=cdh8.net.cuberonlabs.com:22000):(Total: 13s882ms, non-child: 8.217ms, % non-child: 0.06%)
MemoryUsage(500.000ms): 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB
ThreadUsage(500.000ms): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1
- AverageThreadTokens: 1.00
- BloomFilterBytes: 0
- PeakMemoryUsage: 5.40 MB (5660408)
- PerHostPeakMemUsage: 1.63 GB (1748411303)
- RowsProduced: 2 (2)
- TotalNetworkReceiveTime: 13s594ms
- TotalNetworkSendTime: 275.496us
- TotalStorageWaitTime: 0.000ns
- TotalThreadsInvoluntaryContextSwitches: 1 (1)
- TotalThreadsTotalWallClockTime: 13s841ms
- TotalThreadsSysTime: 8.000ms
- TotalThreadsUserTime: 236.000ms
- TotalThreadsVoluntaryContextSwitches: 118 (118)
Fragment Instance Lifecycle Timings:
- ExecTime: 3.549ms
- ExecTreeExecTime: 81.407us
- OpenTime: 13s838ms
- ExecTreeOpenTime: 13s597ms
- PrepareTime: 40.819ms
- ExecTreePrepareTime: 1.187ms
DataStreamSender (dst_id=37):(Total: 95.612us, non-child: 95.612us, % non-child: 100.00%)
- BytesSent: 110.00 B (110)
- NetworkThroughput(*): 3.79 MB/sec
- OverallThroughput: 1.10 MB/sec
- PeakMemoryUsage: 56.99 KB (58360)
- RowsReturned: 2 (2)
- SerializeBatchTime: 19.118us
- TransmitDataRPCTime: 27.675us
- UncompressedRowBatchSize: 157.00 B (157)
CodeGen:(Total: 275.628ms, non-child: 275.628ms, % non-child: 100.00%)
- CodegenTime: 4.009ms
- CompileTime: 78.155ms
- LoadTime: 0.000ns
- ModuleBitcodeSize: 1.90 MB (1992760)
- NumFunctions: 56 (56)
- NumInstructions: 1.52K (1523)
- OptimizationTime: 161.456ms
- PeakMemoryUsage: 761.50 KB (779776)
- PrepareTime: 35.313ms
AGGREGATION_NODE (id=12):(Total: 13s598ms, non-child: 1.445ms, % non-child: 0.01%)
ExecOption: Codegen Enabled
- BuildTime: 181.688us
- GetNewBlockTime: 151.726us
- GetResultsTime: 2.816us
- HTResizeTime: 18.660us
- HashBuckets: 2.05K (2048)
- LargestPartitionPercent: 0 (0)
- MaxPartitionLevel: 0 (0)
- NumRepartitions: 0 (0)
- PartitionsCreated: 16 (16)
- PeakMemoryUsage: 2.30 MB (2410624)
- PinTime: 0.000ns
- RowsRepartitioned: 0 (0)
- RowsReturned: 2 (2)
- RowsReturnedRate: 0
- SpilledPartitions: 0 (0)
- UnpinTime: 917.000ns
AGGREGATION_NODE (id=36):(Total: 13s597ms, non-child: 2.253ms, % non-child: 0.02%)
ExecOption: Codegen Enabled
- BuildTime: 467.935us
- GetNewBlockTime: 163.420us
- GetResultsTime: 91.996us
- HTResizeTime: 2.725us
- HashBuckets: 16.38K (16384)
- LargestPartitionPercent: 7 (7)
- MaxPartitionLevel: 0 (0)
- NumRepartitions: 0 (0)
- PartitionsCreated: 16 (16)
- PeakMemoryUsage: 2.40 MB (2516241)
- PinTime: 0.000ns
- RowsRepartitioned: 0 (0)
- RowsReturned: 763 (763)
- RowsReturnedRate: 56.00 /sec
- SpilledPartitions: 0 (0)
- UnpinTime: 992.000ns
EXCHANGE_NODE (id=35):(Total: 13s595ms, non-child: 164.028us, % non-child: 0.00%)
BytesReceived(500.000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0
- BytesReceived: 47.11 KB (48245)
- ConvertRowBatchTime: 39.573us
- DeserializeRowBatchTimer: 312.286us
- FirstBatchArrivalWaitTime: 13s579ms
- PeakMemoryUsage: 0
- RowsReturned: 763 (763)
- RowsReturnedRate: 56.00 /sec
- SendersBlockedTimer: 0.000ns
- SendersBlockedTotalTimer(*): 0.000ns
Instance 514ee9ab39cdc507:99 (host=cdh10.net.cuberonlabs.com:22000):(Total: 13s882ms, non-child: 7.702ms, % non-child: 0.06%)
MemoryUsage(500.000ms): 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB
ThreadUsage(500.000ms): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1
- AverageThreadTokens: 1.00
- BloomFilterBytes: 0
- PeakMemoryUsage: 5.40 MB (5660408)
- PerHostPeakMemUsage: 1.66 GB (1784016472)
- RowsProduced: 3 (3)
- TotalNetworkReceiveTime: 13s506ms
- TotalNetworkSendTime: 190.386us
- TotalStorageWaitTime: 0.000ns
- TotalThreadsInvoluntaryContextSwitches: 1 (1)
- TotalThreadsTotalWallClockTime: 13s846ms
- TotalThreadsSysTime: 0.000ns
- TotalThreadsUserTime: 332.000ms
- TotalThreadsVoluntaryContextSwitches: 163 (163)
Fragment Instance Lifecycle Timings:
- ExecTime: 3.185ms
- ExecTreeExecTime: 185.458us
- OpenTime: 13s843ms
- ExecTreeOpenTime: 13s507ms
- PrepareTime: 35.549ms
- ExecTreePrepareTime: 1.143ms
DataStreamSender (dst_id=37):(Total: 77.089us, non-child: 77.089us, % non-child: 100.00%)
- BytesSent: 147.00 B (147)
- NetworkThroughput(*): 6.22 MB/sec
- OverallThroughput: 1.82 MB/sec
- PeakMemoryUsage: 56.99 KB (58360)
- RowsReturned: 3 (3)
- SerializeBatchTime: 20.542us
- TransmitDataRPCTime: 22.544us
- UncompressedRowBatchSize: 242.00 B (242)
CodeGen:(Total: 365.398ms, non-child: 365.398ms, % non-child: 100.00%)
- CodegenTime: 4.171ms
- CompileTime: 138.960ms
- LoadTime: 0.000ns
- ModuleBitcodeSize: 1.90 MB (1992760)
- NumFunctions: 56 (56)
- NumInstructions: 1.52K (1523)
- OptimizationTime: 195.694ms
- PeakMemoryUsage: 761.50 KB (779776)
- PrepareTime: 30.004ms
AGGREGATION_NODE (id=12):(Total: 13s509ms, non-child: 1.265ms, % non-child: 0.01%)
ExecOption: Codegen Enabled
- BuildTime: 34.961us
- GetNewBlockTime: 147.273us
- GetResultsTime: 7.885us
- HTResizeTime: 9.716us
- HashBuckets: 3.07K (3072)
- LargestPartitionPercent: 2 (2)
- MaxPartitionLevel: 0 (0)
- NumRepartitions: 0 (0)
- PartitionsCreated: 16 (16)
- PeakMemoryUsage: 2.30 MB (2410624)
- PinTime: 0.000ns
- RowsRepartitioned: 0 (0)
- RowsReturned: 3 (3)
- RowsReturnedRate: 0
- SpilledPartitions: 0 (0)
- UnpinTime: 860.000ns
AGGREGATION_NODE (id=36):(Total: 13s507ms, non-child: 1.398ms, % non-child: 0.01%)
ExecOption: Codegen Enabled
- BuildTime: 30.200us
- GetNewBlockTime: 160.463us
- GetResultsTime: 23.751us
- HTResizeTime: 2.989us
- HashBuckets: 15.36K (15360)
- LargestPartitionPercent: 16 (16)
- MaxPartitionLevel: 0 (0)
- NumRepartitions: 0 (0)
- PartitionsCreated: 16 (16)
- PeakMemoryUsage: 2.37 MB (2485376)
- PinTime: 0.000ns
- RowsRepartitioned: 0 (0)
- RowsReturned: 36 (36)
- RowsReturnedRate: 2.00 /sec
- SpilledPartitions: 0 (0)
- UnpinTime: 907.000ns
EXCHANGE_NODE (id=35):(Total: 13s506ms, non-child: 102.741us, % non-child: 0.00%)
BytesReceived(500.000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0
- BytesReceived: 2.89 KB (2960)
- ConvertRowBatchTime: 15.733us
- DeserializeRowBatchTimer: 108.245us
- FirstBatchArrivalWaitTime: 13s490ms
- PeakMemoryUsage: 0
- RowsReturned: 36 (36)
- RowsReturnedRate: 2.00 /sec
- SendersBlockedTimer: 0.000ns
- SendersBlockedTotalTimer(*): 0.000ns
Instance 514ee9ab39cdc507:91 (host=cdh12.net.cuberonlabs.com:22000):(Total: 13s881ms, non-child: 8.793ms, % non-child: 0.06%)
MemoryUsage(500.000ms): 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB
ThreadUsage(500.000ms): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1
- AverageThreadTokens: 1.00
- BloomFilterBytes: 0
- PeakMemoryUsage: 5.40 MB (5660408)
- PerHostPeakMemUsage: 1.12 GB (1201773720)
- RowsProduced: 4 (4)
- TotalNetworkReceiveTime: 13s572ms
- TotalNetworkSendTime: 216.962us
- TotalStorageWaitTime: 0.000ns
- TotalThreadsInvoluntaryContextSwitches: 1 (1)
- TotalThreadsTotalWallClockTime: 13s841ms
- TotalThreadsSysTime: 4.000ms
- TotalThreadsUserTime: 264.000ms
- TotalThreadsVoluntaryContextSwitches: 124 (124)
Fragment Instance Lifecycle Timings:
- ExecTime: 2.944ms
- ExecTreeExecTime: 168.248us
- OpenTime: 13s838ms
- ExecTreeOpenTime: 13s576ms
- PrepareTime: 40.011ms
- ExecTreePrepareTime: 1.182ms
DataStreamSender (dst_id=37):(Total: 80.692us, non-child: 80.692us, % non-child: 100.00%)
- BytesSent: 188.00 B (188)
- NetworkThroughput(*): 8.64 MB/sec
- OverallThroughput: 2.22 MB/sec
- PeakMemoryUsage: 56.99 KB (58360)
- RowsReturned: 4 (4)
- SerializeBatchTime: 19.497us
- TransmitDataRPCTime: 20.748us
- UncompressedRowBatchSize: 323.00 B (323)
CodeGen:(Total: 294.492ms, non-child: 294.492ms, % non-child: 100.00%)
- CodegenTime: 5.458ms
- CompileTime: 88.551ms
- LoadTime: 0.000ns
- ModuleBitcodeSize: 1.90 MB (1992760)
- NumFunctions: 56 (56)
- NumInstructions: 1.52K (1523)
- OptimizationTime: 171.669ms
- PeakMemoryUsage: 761.50 KB (779776)
- PrepareTime: 33.334ms
AGGREGATION_NODE (id=12):(Total: 13s578ms, non-child: 1.539ms, % non-child: 0.01%)
ExecOption: Codegen Enabled
- BuildTime: 112.393us
- GetNewBlockTime: 160.937us
- GetResultsTime: 8.116us
- HTResizeTime: 17.632us
- HashBuckets: 4.10K (4096)
- LargestPartitionPercent: 0 (0)
- MaxPartitionLevel: 0 (0)
- NumRepartitions: 0 (0)
- PartitionsCreated: 16 (16)
- PeakMemoryUsage: 2.30 MB (2410624)
- PinTime: 0.000ns
- RowsRepartitioned: 0 (0)
- RowsReturned: 4 (4)
- RowsReturnedRate: 0
- SpilledPartitions: 0 (0)
- UnpinTime: 914.000ns
AGGREGATION_NODE (id=36):(Total: 13s576ms, non-child: 4.215ms, % non-child: 0.03%)
ExecOption: Codegen Enabled
- BuildTime: 146.806us
- GetNewBlockTime: 159.658us
- GetResultsTime: 79.354us
- HTResizeTime: 3.427us
- HashBuckets: 16.38K (16384)
- LargestPartitionPercent: 9 (9)
- MaxPartitionLevel: 0 (0)
- NumRepartitions: 0 (0)
- PartitionsCreated: 16 (16)
- PeakMemoryUsage: 2.38 MB (2493568)
- PinTime: 0.000ns
- RowsRepartitioned: 0 (0)
- RowsReturned: 331 (331)
- RowsReturnedRate: 24.00 /sec
- SpilledPartitions: 0 (0)
- UnpinTime: 983.000ns
EXCHANGE_NODE (id=35):(Total: 13s572ms, non-child: 118.259us, % non-child: 0.00%)
BytesReceived(500.000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0
- BytesReceived: 21.32 KB (21832)
- ConvertRowBatchTime: 26.232us
- DeserializeRowBatchTimer: 164.881us
- FirstBatchArrivalWaitTime: 13s556ms
- PeakMemoryUsage: 0
- RowsReturned: 331 (331)
- RowsReturnedRate: 24.00 /sec
- SendersBlockedTimer: 0.000ns
- SendersBlockedTotalTimer(*): 0.000ns
Instance 514ee9ab39cdc507:92 (host=cdh14.net.cuberonlabs.com:22000):(Total: 13s881ms, non-child: 9.063ms, % non-child: 0.07%)
MemoryUsage(500.000ms): 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.97 MB
ThreadUsage(500.000ms): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1
- AverageThreadTokens: 1.00
- BloomFilterBytes: 0
- PeakMemoryUsage: 5.40 MB (5660408)
- PerHostPeakMemUsage: 1.44 GB (1548652528)
- RowsProduced: 1 (1)
- TotalNetworkReceiveTime: 13s550ms
- TotalNetworkSendTime: 286.486us
- TotalStorageWaitTime: 0.000ns
- TotalThreadsInvoluntaryContextSwitches: 3 (3)
- TotalThreadsTotalWallClockTime: 13s840ms
- TotalThreadsSysTime: 0.000ns
- TotalThreadsUserTime: 288.000ms
- TotalThreadsVoluntaryContextSwitches: 80 (80)
Fragment Instance Lifecycle Timings:
- ExecTime: 3.424ms
- ExecTreeExecTime: 123.922us
- OpenTime: 13s837ms
- ExecTreeOpenTime: 13s555ms
- PrepareTime: 40.369ms
- ExecTreePrepareTime: 1.193ms
DataStreamSender (dst_id=37):(Total: 177.401us, non-child: 177.401us, % non-child: 100.00%)
- BytesSent: 64.00 B (64)
- NetworkThroughput(*): 537.57 KB/sec
- OverallThroughput: 352.31 KB/sec
- PeakMemoryUsage: 56.99 KB (58360)
- RowsReturned: 1 (1)
- SerializeBatchTime: 15.842us
- TransmitDataRPCTime: 116.264us
- UncompressedRowBatchSize: 83.00 B (83)
CodeGen:(Total: 315.092ms, non-child: 315.092ms, % non-child: 100.00%)
- CodegenTime: 5.020ms
- CompileTime: 110.489ms
- LoadTime: 0.000ns
- ModuleBitcodeSize: 1.90 MB (1992760)
- NumFunctions: 56 (56)
- NumInstructions: 1.52K (1523)
- OptimizationTime: 169.851ms
- PeakMemoryUsage: 761.50 KB (779776)
- PrepareTime: 33.917ms
AGGREGATION_NODE (id=12):(Total: 13s556ms, non-child: 2.310ms, % non-child: 0.02%)
ExecOption: Codegen Enabled
- BuildTime: 680.135us
- GetNewBlockTime: 160.458us
- GetResultsTime: 2.003us
- HTResizeTime: 23.624us
- HashBuckets: 1.02K (1024)
- LargestPartitionPercent: 0 (0)
- MaxPartitionLevel: 0 (0)
- NumRepartitions: 0 (0)
- PartitionsCreated: 16 (16)
- PeakMemoryUsage: 2.30 MB (2410624)
- PinTime: 0.000ns
- RowsRepartitioned: 0 (0)
- RowsReturned: 1 (1)
- RowsReturnedRate: 0
- SpilledPartitions: 0 (0)
- UnpinTime: 912.000ns
AGGREGATION_NODE (id=36):(Total: 13s554ms, non-child: 4.292ms, % non-child: 0.03%)
ExecOption: Codegen Enabled
- BuildTime: 2.291ms
- GetNewBlockTime: 169.494us
- GetResultsTime: 283.952us
- HTResizeTime: 858.850us
- HashBuckets: 32.77K (32768)
- LargestPartitionPercent: 6 (6)
- MaxPartitionLevel: 0 (0)
- NumRepartitions: 0 (0)
- PartitionsCreated: 16 (16)
- PeakMemoryUsage: 2.68 MB (2814600)
- PinTime: 0.000ns
- RowsRepartitioned: 0 (0)
- RowsReturned: 3.68K (3678)
- RowsReturnedRate: 271.00 /sec
- SpilledPartitions: 0 (0)
- UnpinTime: 948.000ns
EXCHANGE_NODE (id=35):(Total: 13s550ms, non-child: 260.783us, % non-child: 0.00%)
BytesReceived(500.000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 141.58 KB
- BytesReceived: 220.51 KB (225807)
- ConvertRowBatchTime: 101.429us
- DeserializeRowBatchTimer: 892.049us
- FirstBatchArrivalWaitTime: 13s536ms
- PeakMemoryUsage: 0
- RowsReturned: 3.68K (3678)
- RowsReturnedRate: 271.00 /sec
- SendersBlockedTimer: 0.000ns
- SendersBlockedTotalTimer(*): 0.000ns
Instance 514ee9ab39cdc507:93 (host=cdh1.net.cuberonlabs.com:22000):(Total: 13s881ms, non-child: 16.344ms, % non-child: 0.12%)
MemoryUsage(500.000ms): 5.40 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB
ThreadUsage(500.000ms): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1
- AverageThreadTokens: 1.00
- BloomFilterBytes: 0
- PeakMemoryUsage: 5.40 MB (5660408)
- PerHostPeakMemUsage: 1.81 GB (1939587581)
- RowsProduced: 6 (6)
- TotalNetworkReceiveTime: 13s574ms
- TotalNetworkSendTime: 243.892us
- TotalStorageWaitTime: 0.000ns
- TotalThreadsInvoluntaryContextSwitches: 2 (2)
- TotalThreadsTotalWallClockTime: 13s830ms
- TotalThreadsSysTime: 0.000ns
- TotalThreadsUserTime: 252.000ms
- TotalThreadsVoluntaryContextSwitches: 143 (143)
Fragment Instance Lifecycle Timings:
- ExecTime: 3.211ms
- ExecTreeExecTime: 222.648us
- OpenTime: 13s827ms
- ExecTreeOpenTime: 13s579ms
- PrepareTime: 50.194ms
- ExecTreePrepareTime: 2.042ms
DataStreamSender (dst_id=37):(Total: 100.024us, non-child: 100.024us, % non-child: 100.00%)
- BytesSent: 255.00 B (255)
- NetworkThroughput(*): 7.74 MB/sec
- OverallThroughput: 2.43 MB/sec
- PeakMemoryUsage: 56.99 KB (58360)
- RowsReturned: 6 (6)
- SerializeBatchTime: 14.572us
- TransmitDataRPCTime: 31.416us
- UncompressedRowBatchSize: 466.00 B (466)
CodeGen:(Total: 283.316ms, non-child: 283.316ms, % non-child: 100.00%)
- CodegenTime: 6.212ms
- CompileTime: 78.461ms
- LoadTime: 0.000ns
- ModuleBitcodeSize: 1.90 MB (1992760)
- NumFunctions: 56 (56)
- NumInstructions: 1.52K (1523)
- OptimizationTime: 166.174ms
- PeakMemoryUsage: 761.50 KB (779776)
- PrepareTime: 37.370ms
AGGREGATION_NODE (id=12):(Total: 13s581ms, non-child: 2.573ms, % non-child: 0.02%)
ExecOption: Codegen Enabled
- BuildTime: 666.564us
- GetNewBlockTime: 266.324us
- GetResultsTime: 11.796us
- HTResizeTime: 19.668us
- HashBuckets: 5.12K (5120)
- LargestPartitionPercent: 0 (0)
- MaxPartitionLevel: 0 (0)
- NumRepartitions: 0 (0)
- PartitionsCreated: 16 (16)
- PeakMemoryUsage: 2.30 MB (2410624)
- PinTime: 0.000ns
- RowsRepartitioned: 0 (0)
- RowsReturned: 6 (6)
- RowsReturnedRate: 0
- SpilledPartitions: 0 (0)
- UnpinTime: 948.000ns
AGGREGATION_NODE (id=36):(Total: 13s578ms, non-child: 4.202ms, % non-child: 0.03%)
ExecOption: Codegen Enabled
- BuildTime: 2.095ms
- GetNewBlockTime: 392.116us
- GetResultsTime: 323.536us
- HTResizeTime: 497.768us
- HashBuckets: 32.77K (32768)
- LargestPartitionPercent: 6 (6)
- MaxPartitionLevel: 0 (0)
- NumRepartitions: 0 (0)
- PartitionsCreated: 16 (16)
- PeakMemoryUsage: 2.69 MB (2818297)
- PinTime: 0.000ns
- RowsRepartitioned: 0 (0)
- RowsReturned: 4.25K (4250)
- RowsReturnedRate: 312.00 /sec
- SpilledPartitions: 0 (0)
- UnpinTime: 1.016us
EXCHANGE_NODE (id=35):(Total: 13s574ms, non-child: 193.532us, % non-child: 0.00%)
BytesReceived(500.000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0
- BytesReceived: 245.20 KB (251084)
- ConvertRowBatchTime: 100.500us
- DeserializeRowBatchTimer: 939.728us
- FirstBatchArrivalWaitTime: 13s560ms
- PeakMemoryUsage: 0
- RowsReturned: 4.25K (4250)
- RowsReturnedRate: 313.00 /sec
- SendersBlockedTimer: 0.000ns
- SendersBlockedTotalTimer(*): 0.000ns
Instance 514ee9ab39cdc507:95 (host=cdh7.net.cuberonlabs.com:22000):(Total: 13s881ms, non-child: 7.566ms, % non-child: 0.05%)
MemoryUsage(500.000ms): 5.40 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB
ThreadUsage(500.000ms): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1
- AverageThreadTokens: 1.00
- BloomFilterBytes: 0
- PeakMemoryUsage: 5.40 MB (5660408)
- PerHostPeakMemUsage: 1.58 GB (1699637471)
- RowsProduced: 3 (3)
- TotalNetworkReceiveTime: 13s622ms
- TotalNetworkSendTime: 248.472us
- TotalStorageWaitTime: 0.000ns
- TotalThreadsInvoluntaryContextSwitches: 0 (0)
- TotalThreadsTotalWallClockTime: 13s846ms
- TotalThreadsSysTime: 8.000ms
- TotalThreadsUserTime: 216.000ms
- TotalThreadsVoluntaryContextSwitches: 77 (77)
Fragment Instance Lifecycle Timings:
- ExecTime: 3.137ms
- ExecTreeExecTime: 136.549us
- OpenTime: 13s843ms
- ExecTreeOpenTime: 13s624ms
- PrepareTime: 34.345ms
- ExecTreePrepareTime: 1.126ms
DataStreamSender (dst_id=37):(Total: 90.547us, non-child: 90.547us, % non-child: 100.00%)
- BytesSent: 170.00 B (170)
- NetworkThroughput(*): 5.93 MB/sec
- OverallThroughput: 1.79 MB/sec
- PeakMemoryUsage: 56.99 KB (58360)
- RowsReturned: 3 (3)
- SerializeBatchTime: 18.963us
- TransmitDataRPCTime: 27.324us
- UncompressedRowBatchSize: 246.00 B (246)
CodeGen:(Total: 247.421ms, non-child: 247.421ms, % non-child: 100.00%)
- CodegenTime: 3.932ms
- CompileTime: 74.371ms
- LoadTime: 0.000ns
- ModuleBitcodeSize: 1.90 MB (1992760)
- NumFunctions: 56 (56)
- NumInstructions: 1.52K (1523)
- OptimizationTime: 143.416ms
- PeakMemoryUsage: 761.50 KB (779776)
- PrepareTime: 28.784ms
AGGREGATION_NODE (id=12):(Total: 13s625ms, non-child: 1.316ms, % non-child: 0.01%)
ExecOption: Codegen Enabled
- BuildTime: 77.969us
- GetNewBlockTime: 144.905us
- GetResultsTime: 5.336us
- HTResizeTime: 19.932us
- HashBuckets: 3.07K (3072)
- LargestPartitionPercent: 1 (1)
- MaxPartitionLevel: 0 (0)
- NumRepartitions: 0 (0)
- PartitionsCreated: 16 (16)
- PeakMemoryUsage: 2.30 MB (2410624)
- PinTime: 0.000ns
- RowsRepartitioned: 0 (0)
- RowsReturned: 3 (3)
- RowsReturnedRate: 0
- SpilledPartitions: 0 (0)
- UnpinTime: 855.000ns
AGGREGATION_NODE (id=36):(Total: 13s624ms, non-child: 1.816ms, % non-child: 0.01%)
ExecOption: Codegen Enabled
- BuildTime: 44.147us
- GetNewBlockTime: 152.022us
- GetResultsTime: 62.466us
- HTResizeTime: 3.589us
- HashBuckets: 16.38K (16384)
- LargestPartitionPercent: 9 (9)
- MaxPartitionLevel: 0 (0)
- NumRepartitions: 0 (0)
- PartitionsCreated: 16 (16)
- PeakMemoryUsage: 2.38 MB (2493568)
- PinTime: 0.000ns
- RowsRepartitioned: 0 (0)
- RowsReturned: 62 (62)
- RowsReturnedRate: 4.00 /sec
- SpilledPartitions: 0 (0)
- UnpinTime: 906.000ns
EXCHANGE_NODE (id=35):(Total: 13s622ms, non-child: 102.849us, % non-child: 0.00%)
BytesReceived(500.000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0
- BytesReceived: 5.15 KB (5272)
- ConvertRowBatchTime: 18.121us
- DeserializeRowBatchTimer: 128.354us
- FirstBatchArrivalWaitTime: 13s607ms
- PeakMemoryUsage: 0
- RowsReturned: 62 (62)
- RowsReturnedRate: 4.00 /sec
- SendersBlockedTimer: 0.000ns
- SendersBlockedTotalTimer(*): 0.000ns
Instance 514ee9ab39cdc507:94 (host=cdh5.net.cuberonlabs.com:22000):(Total: 13s880ms, non-child: 6.809ms, % non-child: 0.05%)
MemoryUsage(500.000ms): 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.71 MB
ThreadUsage(500.000ms): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1
- AverageThreadTokens: 1.00
- BloomFilterBytes: 0
- PeakMemoryUsage: 5.40 MB (5660408)
- PerHostPeakMemUsage: 2.15 GB (2303708143)
- RowsProduced: 2 (2)
- TotalNetworkReceiveTime: 13s673ms
- TotalNetworkSendTime: 178.928us
- TotalStorageWaitTime: 0.000ns
- TotalThreadsInvoluntaryContextSwitches: 0 (0)
- TotalThreadsTotalWallClockTime: 13s861ms
- TotalThreadsSysTime: 12.000ms
- TotalThreadsUserTime: 176.000ms
- TotalThreadsVoluntaryContextSwitches: 68 (68)
Fragment Instance Lifecycle Timings:
- ExecTime: 3.226ms
- ExecTreeExecTime: 69.304us
- OpenTime: 13s858ms
- ExecTreeOpenTime: 13s675ms
- PrepareTime: 19.093ms
- ExecTreePrepareTime: 1.183ms
DataStreamSender (dst_id=37):(Total: 74.508us, non-child: 74.508us, % non-child: 100.00%)
- BytesSent: 127.00 B (127)
- NetworkThroughput(*): 4.30 MB/sec
- OverallThroughput: 1.63 MB/sec
- PeakMemoryUsage: 56.99 KB (58360)
- RowsReturned: 2 (2)
- SerializeBatchTime: 22.064us
- TransmitDataRPCTime: 28.184us
- UncompressedRowBatchSize: 173.00 B (173)
CodeGen:(Total: 197.430ms, non-child: 197.430ms, % non-child: 100.00%)
- CodegenTime: 2.370ms
- CompileTime: 62.005ms
- LoadTime: 0.000ns
- ModuleBitcodeSize: 1.90 MB (1992760)
- NumFunctions: 56 (56)
- NumInstructions: 1.52K (1523)
- OptimizationTime: 120.517ms
- PeakMemoryUsage: 761.50 KB (779776)
- PrepareTime: 14.422ms
AGGREGATION_NODE (id=12):(Total: 13s676ms, non-child: 1.251ms, % non-child: 0.01%)
ExecOption: Codegen Enabled
- BuildTime: 62.580us
- GetNewBlockTime: 160.500us
- GetResultsTime: 2.232us
- HTResizeTime: 16.648us
- HashBuckets: 1.02K (1024)
- LargestPartitionPercent: 1 (1)
- MaxPartitionLevel: 0 (0)
- NumRepartitions: 0 (0)
- PartitionsCreated: 16 (16)
- PeakMemoryUsage: 2.30 MB (2410624)
- PinTime: 0.000ns
- RowsRepartitioned: 0 (0)
- RowsReturned: 2 (2)
- RowsReturnedRate: 0
- SpilledPartitions: 0 (0)
- UnpinTime: 988.000ns
AGGREGATION_NODE (id=36):(Total: 13s675ms, non-child: 1.975ms, % non-child: 0.01%)
ExecOption: Codegen Enabled
- BuildTime: 59.964us
- GetNewBlockTime: 163.332us
- GetResultsTime: 46.120us
- HTResizeTime: 3.524us
- HashBuckets: 16.38K (16384)
- LargestPartitionPercent: 11 (11)
- MaxPartitionLevel: 0 (0)
- NumRepartitions: 0 (0)
- PartitionsCreated: 16 (16)
- PeakMemoryUsage: 2.38 MB (2493568)
- PinTime: 0.000ns
- RowsRepartitioned: 0 (0)
- RowsReturned: 126 (126)
- RowsReturnedRate: 9.00 /sec
- SpilledPartitions: 0 (0)
- UnpinTime: 1.024us
EXCHANGE_NODE (id=35):(Total: 13s673ms, non-child: 111.828us, % non-child: 0.00%)
BytesReceived(500.000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5.96 KB
- BytesReceived: 9.08 KB (9300)
- ConvertRowBatchTime: 20.876us
- DeserializeRowBatchTimer: 131.044us
- FirstBatchArrivalWaitTime: 13s657ms
- PeakMemoryUsage: 0
- RowsReturned: 126 (126)
- RowsReturnedRate: 9.00 /sec
- SendersBlockedTimer: 0.000ns
- SendersBlockedTotalTimer(*): 0.000ns
Instance 514ee9ab39cdc507:89 (host=cdh4.net.cuberonlabs.com:22000):(Total: 13s880ms, non-child: 8.192ms, % non-child: 0.06%)
MemoryUsage(500.000ms): 4.65 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB
ThreadUsage(500.000ms): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1
- AverageThreadTokens: 1.00
- BloomFilterBytes: 0
- PeakMemoryUsage: 5.40 MB (5660408)
- PerHostPeakMemUsage: 2.13 GB (2284202661)
- RowsProduced: 2 (2)
- TotalNetworkReceiveTime: 13s563ms
- TotalNetworkSendTime: 201.208us
- TotalStorageWaitTime: 0.000ns
- TotalThreadsInvoluntaryContextSwitches: 0 (0)
- TotalThreadsTotalWallClockTime: 13s845ms
- TotalThreadsSysTime: 20.000ms
- TotalThreadsUserTime: 260.000ms
- TotalThreadsVoluntaryContextSwitches: 120 (120)
Fragment Instance Lifecycle Timings:
- ExecTime: 3.667ms
- ExecTreeExecTime: 108.668us
- OpenTime: 13s841ms
- ExecTreeOpenTime: 13s571ms
- PrepareTime: 35.043ms
- ExecTreePrepareTime: 1.133ms
DataStreamSender (dst_id=37):(Total: 89.264us, non-child: 89.264us, % non-child: 100.00%)
- BytesSent: 113.00 B (113)
- NetworkThroughput(*): 3.91 MB/sec
- OverallThroughput: 1.21 MB/sec
- PeakMemoryUsage: 56.99 KB (58360)
- RowsReturned: 2 (2)
- SerializeBatchTime: 24.512us
- TransmitDataRPCTime: 27.560us
- UncompressedRowBatchSize: 159.00 B (159)
CodeGen:(Total: 299.754ms, non-child: 299.754ms, % non-child: 100.00%)
- CodegenTime: 3.957ms
- CompileTime: 86.357ms
- LoadTime: 0.000ns
- ModuleBitcodeSize: 1.90 MB (1992760)
- NumFunctions: 56 (56)
- NumInstructions: 1.52K (1523)
- OptimizationTime: 182.807ms
- PeakMemoryUsage: 761.50 KB (779776)
- PrepareTime: 29.826ms
AGGREGATION_NODE (id=12):(Total: 13s572ms, non-child: 1.771ms, % non-child: 0.01%)
ExecOption: Codegen Enabled
- BuildTime: 353.928us
- GetNewBlockTime: 155.068us
- GetResultsTime: 2.836us
- HTResizeTime: 40.332us
- HashBuckets: 2.05K (2048)
- LargestPartitionPercent: 0 (0)
- MaxPartitionLevel: 0 (0)
- NumRepartitions: 0 (0)
- PartitionsCreated: 16 (16)
- PeakMemoryUsage: 2.30 MB (2410624)
- PinTime: 0.000ns
- RowsRepartitioned: 0 (0)
- RowsReturned: 2 (2)
- RowsReturnedRate: 0
- SpilledPartitions: 0 (0)
- UnpinTime: 884.000ns
AGGREGATION_NODE (id=36):(Total: 13s570ms, non-child: 6.859ms, % non-child: 0.05%)
ExecOption: Codegen Enabled
- BuildTime: 1.255ms
- GetNewBlockTime: 158.952us
- GetResultsTime: 194.656us
- HTResizeTime: 564.256us
- HashBuckets: 32.77K (32768)
- LargestPartitionPercent: 7 (7)
- MaxPartitionLevel: 0 (0)
- NumRepartitions: 0 (0)
- PartitionsCreated: 16 (16)
- PeakMemoryUsage: 2.69 MB (2825783)
- PinTime: 0.000ns
- RowsRepartitioned: 0 (0)
- RowsReturned: 1.46K (1455)
- RowsReturnedRate: 107.00 /sec
- SpilledPartitions: 0 (0)
- UnpinTime: 980.000ns
EXCHANGE_NODE (id=35):(Total: 13s563ms, non-child: 167.612us, % non-child: 0.00%)
BytesReceived(500.000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0
- BytesReceived: 89.46 KB (91604)
- ConvertRowBatchTime: 62.008us
- DeserializeRowBatchTimer: 427.780us
- FirstBatchArrivalWaitTime: 13s548ms
- PeakMemoryUsage: 0
- RowsReturned: 1.46K (1455)
- RowsReturnedRate: 107.00 /sec
- SendersBlockedTimer: 0.000ns
- SendersBlockedTotalTimer(*): 0.000ns
Instance 514ee9ab39cdc507:8d (host=cdh15.net.cuberonlabs.com:22000):(Total: 13s878ms, non-child: 8.438ms, % non-child: 0.06%)
MemoryUsage(500.000ms): 5.40 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB
ThreadUsage(500.000ms): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1
- AverageThreadTokens: 1.00
- BloomFilterBytes: 0
- PeakMemoryUsage: 5.40 MB (5660408)
- PerHostPeakMemUsage: 1.57 GB (1688553772)
- RowsProduced: 4 (4)
- TotalNetworkReceiveTime: 13s613ms
- TotalNetworkSendTime: 284.353us
- TotalStorageWaitTime: 0.000ns
- TotalThreadsInvoluntaryContextSwitches: 0 (0)
- TotalThreadsTotalWallClockTime: 13s843ms
- TotalThreadsSysTime: 12.000ms
- TotalThreadsUserTime: 216.000ms
- TotalThreadsVoluntaryContextSwitches: 89 (89)
Fragment Instance Lifecycle Timings:
- ExecTime: 3.579ms
- ExecTreeExecTime: 127.782us
- OpenTime: 13s839ms
- ExecTreeOpenTime: 13s616ms
- PrepareTime: 35.455ms
- ExecTreePrepareTime: 1.220ms
DataStreamSender (dst_id=37):(Total: 104.800us, non-child: 104.800us, % non-child: 100.00%)
- BytesSent: 206.00 B (206)
- NetworkThroughput(*): 3.98 MB/sec
- OverallThroughput: 1.87 MB/sec
- PeakMemoryUsage: 56.99 KB (58360)
- RowsReturned: 4 (4)
- SerializeBatchTime: 16.090us
- TransmitDataRPCTime: 49.313us
- UncompressedRowBatchSize: 334.00 B (334)
CodeGen:(Total: 252.746ms, non-child: 252.746ms, % non-child: 100.00%)
- CodegenTime: 4.026ms
- CompileTime: 72.621ms
- LoadTime: 0.000ns
- ModuleBitcodeSize: 1.90 MB (1992760)
- NumFunctions: 56 (56)
- NumInstructions: 1.52K (1523)
- OptimizationTime: 149.796ms
- PeakMemoryUsage: 761.50 KB (779776)
- PrepareTime: 29.653ms
AGGREGATION_NODE (id=12):(Total: 13s617ms, non-child: 1.338ms, % non-child: 0.01%)
ExecOption: Codegen Enabled
- BuildTime: 119.455us
- GetNewBlockTime: 143.159us
- GetResultsTime: 9.015us
- HTResizeTime: 18.597us
- HashBuckets: 3.07K (3072)
- LargestPartitionPercent: 0 (0)
- MaxPartitionLevel: 0 (0)
- NumRepartitions: 0 (0)
- PartitionsCreated: 16 (16)
- PeakMemoryUsage: 2.30 MB (2410624)
- PinTime: 0.000ns
- RowsRepartitioned: 0 (0)
- RowsReturned: 4 (4)
- RowsReturnedRate: 0
- SpilledPartitions: 0 (0)
- UnpinTime: 838.000ns
AGGREGATION_NODE (id=36):(Total: 13s616ms, non-child: 2.595ms, % non-child: 0.02%)
ExecOption: Codegen Enabled
- BuildTime: 136.495us
- GetNewBlockTime: 158.426us
- GetResultsTime: 84.000us
- HTResizeTime: 2.738us
- HashBuckets: 16.38K (16384)
- LargestPartitionPercent: 8 (8)
- MaxPartitionLevel: 0 (0)
- NumRepartitions: 0 (0)
- PartitionsCreated: 16 (16)
- PeakMemoryUsage: 2.38 MB (2493568)
- PinTime: 0.000ns
- RowsRepartitioned: 0 (0)
- RowsReturned: 362 (362)
- RowsReturnedRate: 26.00 /sec
- SpilledPartitions: 0 (0)
- UnpinTime: 1.322us
EXCHANGE_NODE (id=35):(Total: 13s613ms, non-child: 122.236us, % non-child: 0.00%)
BytesReceived(500.000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0
- BytesReceived: 24.04 KB (24613)
- ConvertRowBatchTime: 31.311us
- DeserializeRowBatchTimer: 199.540us
- FirstBatchArrivalWaitTime: 13s597ms
- PeakMemoryUsage: 0
- RowsReturned: 362 (362)
- RowsReturnedRate: 26.00 /sec
- SendersBlockedTimer: 0.000ns
- SendersBlockedTotalTimer(*): 0.000ns
Instance 514ee9ab39cdc507:8f (host=cdh17.net.cuberonlabs.com:22000):(Total: 13s878ms, non-child: 8.312ms, % non-child: 0.06%)
MemoryUsage(500.000ms): 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB
ThreadUsage(500.000ms): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1
- AverageThreadTokens: 1.00
- BloomFilterBytes: 0
- PeakMemoryUsage: 5.40 MB (5660408)
- PerHostPeakMemUsage: 1.75 GB (1879028559)
- RowsProduced: 3 (3)
- TotalNetworkReceiveTime: 13s604ms
- TotalNetworkSendTime: 256.079us
- TotalStorageWaitTime: 0.000ns
- TotalThreadsInvoluntaryContextSwitches: 0 (0)
- TotalThreadsTotalWallClockTime: 13s840ms
- TotalThreadsSysTime: 0.000ns
- TotalThreadsUserTime: 232.000ms
- TotalThreadsVoluntaryContextSwitches: 66 (66)
Fragment Instance Lifecycle Timings:
- ExecTime: 3.402ms
- ExecTreeExecTime: 131.973us
- OpenTime: 13s837ms
- ExecTreeOpenTime: 13s606ms
- PrepareTime: 38.317ms
- ExecTreePrepareTime: 1.470ms
DataStreamSender (dst_id=37):(Total: 121.523us, non-child: 121.523us, % non-child: 100.00%)
- BytesSent: 149.00 B (149)
- NetworkThroughput(*): 2.80 MB/sec
- OverallThroughput: 1.17 MB/sec
- PeakMemoryUsage: 56.99 KB (58360)
- RowsReturned: 3 (3)
- SerializeBatchTime: 25.783us
- TransmitDataRPCTime: 50.734us
- UncompressedRowBatchSize: 247.00 B (247)
CodeGen:(Total: 261.866ms, non-child: 261.866ms, % non-child: 100.00%)
- CodegenTime: 4.491ms
- CompileTime: 69.562ms
- LoadTime: 0.000ns
- ModuleBitcodeSize: 1.90 MB (1992760)
- NumFunctions: 56 (56)
- NumInstructions: 1.52K (1523)
- OptimizationTime: 159.521ms
- PeakMemoryUsage: 761.50 KB (779776)
- PrepareTime: 32.042ms
AGGREGATION_NODE (id=12):(Total: 13s608ms, non-child: 1.663ms, % non-child: 0.01%)
ExecOption: Codegen Enabled
- BuildTime: 162.576us
- GetNewBlockTime: 193.587us
- GetResultsTime: 8.575us
- HTResizeTime: 15.851us
- HashBuckets: 3.07K (3072)
- LargestPartitionPercent: 0 (0)
- MaxPartitionLevel: 0 (0)
- NumRepartitions: 0 (0)
- PartitionsCreated: 16 (16)
- PeakMemoryUsage: 2.30 MB (2410624)
- PinTime: 0.000ns
- RowsRepartitioned: 0 (0)
- RowsReturned: 3 (3)
- RowsReturnedRate: 0
- SpilledPartitions: 0 (0)
- UnpinTime: 909.000ns
AGGREGATION_NODE (id=36):(Total: 13s606ms, non-child: 2.609ms, % non-child: 0.02%)
ExecOption: Codegen Enabled
- BuildTime: 973.775us
- GetNewBlockTime: 172.046us
- GetResultsTime: 105.891us
- HTResizeTime: 445.566us
- HashBuckets: 32.77K (32768)
- LargestPartitionPercent: 7 (7)
- MaxPartitionLevel: 0 (0)
- NumRepartitions: 0 (0)
- PartitionsCreated: 16 (16)
- PeakMemoryUsage: 2.68 MB (2809307)
- PinTime: 0.000ns
- RowsRepartitioned: 0 (0)
- RowsReturned: 883 (883)
- RowsReturnedRate: 64.00 /sec
- SpilledPartitions: 0 (0)
- UnpinTime: 998.000ns
EXCHANGE_NODE (id=35):(Total: 13s604ms, non-child: 213.183us, % non-child: 0.00%)
BytesReceived(500.000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0
- BytesReceived: 56.00 KB (57342)
- ConvertRowBatchTime: 55.169us
- DeserializeRowBatchTimer: 2.297ms
- FirstBatchArrivalWaitTime: 13s588ms
- PeakMemoryUsage: 0
- RowsReturned: 883 (883)
- RowsReturnedRate: 64.00 /sec
- SendersBlockedTimer: 0.000ns
- SendersBlockedTotalTimer(*): 0.000ns
Instance 514ee9ab39cdc507:8c (host=cdh6.net.cuberonlabs.com:22000):(Total: 13s878ms, non-child: 7.805ms, % non-child: 0.06%)
MemoryUsage(500.000ms): 5.40 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB
ThreadUsage(500.000ms): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1
- AverageThreadTokens: 1.00
- BloomFilterBytes: 0
- PeakMemoryUsage: 5.40 MB (5660408)
- PerHostPeakMemUsage: 1.67 GB (1794839264)
- RowsProduced: 2 (2)
- TotalNetworkReceiveTime: 13s573ms
- TotalNetworkSendTime: 162.608us
- TotalStorageWaitTime: 0.000ns
- TotalThreadsInvoluntaryContextSwitches: 0 (0)
- TotalThreadsTotalWallClockTime: 13s840ms
- TotalThreadsSysTime: 4.000ms
- TotalThreadsUserTime: 264.000ms
- TotalThreadsVoluntaryContextSwitches: 75 (75)
Fragment Instance Lifecycle Timings:
- ExecTime: 2.785ms
- ExecTreeExecTime: 93.556us
- OpenTime: 13s838ms
- ExecTreeOpenTime: 13s576ms
- PrepareTime: 37.561ms
- ExecTreePrepareTime: 1.236ms
DataStreamSender (dst_id=37):(Total: 104.728us, non-child: 104.728us, % non-child: 100.00%)
- BytesSent: 123.00 B (123)
- NetworkThroughput(*): 3.53 MB/sec
- OverallThroughput: 1.12 MB/sec
- PeakMemoryUsage: 56.99 KB (58360)
- RowsReturned: 2 (2)
- SerializeBatchTime: 28.968us
- TransmitDataRPCTime: 33.184us
- UncompressedRowBatchSize: 169.00 B (169)
CodeGen:(Total: 292.623ms, non-child: 292.623ms, % non-child: 100.00%)
- CodegenTime: 4.257ms
- CompileTime: 91.739ms
- LoadTime: 0.000ns
- ModuleBitcodeSize: 1.90 MB (1992760)
- NumFunctions: 56 (56)
- NumInstructions: 1.52K (1523)
- OptimizationTime: 168.706ms
- PeakMemoryUsage: 761.50 KB (779776)
- PrepareTime: 31.378ms
AGGREGATION_NODE (id=12):(Total: 13s578ms, non-child: 1.463ms, % non-child: 0.01%)
ExecOption: Codegen Enabled
- BuildTime: 66.856us
- GetNewBlockTime: 164.044us
- GetResultsTime: 2.896us
- HTResizeTime: 17.568us
- HashBuckets: 2.05K (2048)
- LargestPartitionPercent: 1 (1)
- MaxPartitionLevel: 0 (0)
- NumRepartitions: 0 (0)
- PartitionsCreated: 16 (16)
- PeakMemoryUsage: 2.30 MB (2410624)
- PinTime: 0.000ns
- RowsRepartitioned: 0 (0)
- RowsReturned: 2 (2)
- RowsReturnedRate: 0
- SpilledPartitions: 0 (0)
- UnpinTime: 984.000ns
AGGREGATION_NODE (id=36):(Total: 13s576ms, non-child: 3.369ms, % non-child: 0.02%)
ExecOption: Codegen Enabled
- BuildTime: 58.984us
- GetNewBlockTime: 169.364us
- GetResultsTime: 60.196us
- HTResizeTime: 3.728us
- HashBuckets: 16.38K (16384)
- LargestPartitionPercent: 11 (11)
- MaxPartitionLevel: 0 (0)
- NumRepartitions: 0 (0)
- PartitionsCreated: 16 (16)
- PeakMemoryUsage: 2.38 MB (2493568)
- PinTime: 0.000ns
- RowsRepartitioned: 0 (0)
- RowsReturned: 98 (98)
- RowsReturnedRate: 7.00 /sec
- SpilledPartitions: 0 (0)
- UnpinTime: 1.008us
EXCHANGE_NODE (id=35):(Total: 13s573ms, non-child: 141.024us, % non-child: 0.00%)
BytesReceived(500.000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0
- BytesReceived: 6.80 KB (6962)
- ConvertRowBatchTime: 20.588us
- DeserializeRowBatchTimer: 134.564us
- FirstBatchArrivalWaitTime: 13s557ms
- PeakMemoryUsage: 0
- RowsReturned: 98 (98)
- RowsReturnedRate: 7.00 /sec
- SendersBlockedTimer: 0.000ns
- SendersBlockedTotalTimer(*): 0.000ns
Instance 514ee9ab39cdc507:8e (host=cdh3.net.cuberonlabs.com:22000):(Total: 13s878ms, non-child: 8.430ms, % non-child: 0.06%)
MemoryUsage(500.000ms): 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.66 MB, 4.67 MB
ThreadUsage(500.000ms): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1
- AverageThreadTokens: 1.00
- BloomFilterBytes: 0
- PeakMemoryUsage: 5.40 MB (5660408)
- PerHostPeakMemUsage: 2.16 GB (2318232477)
- RowsProduced: 1 (1)
- TotalNetworkReceiveTime: 13s570ms
- TotalNetworkSendTime: 311.624us
- TotalStorageWaitTime: 0.000ns
- TotalThreadsInvoluntaryContextSwitches: 2 (2)
- TotalThreadsTotalWallClockTime: 13s844ms
- TotalThreadsSysTime: 4.000ms
- TotalThreadsUserTime: 264.000ms
- TotalThreadsVoluntaryContextSwitches: 74 (74)
Fragment Instance Lifecycle Timings:
- ExecTime: 3.517ms
- ExecTreeExecTime: 112.248us
- OpenTime: 13s840ms
- ExecTreeOpenTime: 13s573ms
- PrepareTime: 34.242ms
- ExecTreePrepareTime: 1.250ms
DataStreamSender (dst_id=37):(Total: 79.460us, non-child: 7