API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Feb 11th, 2020
58
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 95.56 KB | None | 0 0
raw download clone embed print report
  1.  
  2.  
  3. Query (id=434987288e39baec:45101a3900000000):
  4. Summary:
  5. Session ID: 944fff761bf09762:bdfd68a4f8283fbf
  6. Session Type: HIVESERVER2
  7. HiveServer2 Protocol Version: V6
  8. Start Time: 2020-02-11 13:41:51.790478000
  9. End Time: 2020-02-11 13:42:04.630228000
  10. Query Type: QUERY
  11. Query State: FINISHED
  12. Query Status: OK
  13. Impala Version: impalad version 3.2.0-cdh6.3.0 RELEASE (build 495397101e5807c701df71ea288f4815d69c2c8a)
  14. User: nmali
  15. Connected User: nmali
  16. Delegated User:
  17. Network Address: ::ffff:172.17.250.66:36614
  18. Default Db: alerts
  19. Sql Statement: SELECT count(*) FROM (
  20. SELECT
  21. CAST(orig_cust_id as INT) as orig_cust_id,
  22. CAST(dest_npa as INT) as dest_npa,
  23. CAST(dest_nxx as INT) as dest_nxx,
  24. dest_state,
  25. dest_ocn,
  26. orig_trunk_grp_nm as orig_trunk_group_name,
  27. orig_product,
  28. jurisdiction_state as jurisdiction,
  29. sum(cost) as cost,
  30. sum(revenue) as revenue,
  31. sum(conv_seconds) as duration,
  32. call_date_time_hours,
  33. call_date_time_day,
  34. call_date_time_month,
  35. call_date_time_year
  36. FROM call_detail_records.raw
  37. WHERE
  38. call_date_time_day=day(DAYS_SUB(now(), 1)) AND
  39. call_date_time_month=month(DAYS_SUB(now(), 1)) AND
  40. call_date_time_year=year(DAYS_SUB(now(), 1)) AND
  41. orig_cust_id='25'
  42. GROUP BY
  43. orig_cust_id,
  44. dest_npa,
  45. dest_nxx,
  46. dest_state,
  47. dest_ocn,
  48. orig_trunk_grp_nm,
  49. orig_product,
  50. jurisdiction_state,
  51. call_date_time_hours,
  52. call_date_time_day,
  53. call_date_time_month,
  54. call_date_time_year
  55. ) a
  56. Coordinator: itchil804.inteliquent.com:22000
  57. Query Options (set by configuration): QUERY_TIMEOUT_S=300,IDLE_SESSION_TIMEOUT=900
  58. Query Options (set by configuration and planner): QUERY_TIMEOUT_S=300,MT_DOP=0,IDLE_SESSION_TIMEOUT=900
  59. Plan:
  60. ----------------
  61. Max Per-Host Resource Reservation: Memory=100.00MB Threads=4
  62. Per-Host Resource Estimates: Memory=596MB
  63. WARNING: The following tables are missing relevant table and/or column statistics.
  64. call_detail_records.raw
  65. Analyzed query: SELECT count(*) FROM (SELECT CAST(orig_cust_id AS INT)
  66. orig_cust_id, CAST(dest_npa AS INT) dest_npa, CAST(dest_nxx AS INT) dest_nxx,
  67. dest_state, dest_ocn, orig_trunk_grp_nm orig_trunk_group_name, orig_product,
  68. jurisdiction_state jurisdiction, sum(cost) cost, sum(revenue) revenue,
  69. sum(conv_seconds) duration, call_date_time_hours, call_date_time_day,
  70. call_date_time_month, call_date_time_year FROM call_detail_records.raw WHERE
  71. call_date_time_day = CAST(10 AS INT) AND call_date_time_month = CAST(2 AS INT)
  72. AND call_date_time_year = CAST(2020 AS INT) AND orig_cust_id = '25' GROUP BY
  73. CAST(orig_cust_id AS INT), CAST(dest_npa AS INT), CAST(dest_nxx AS INT),
  74. dest_state, dest_ocn, orig_trunk_grp_nm, orig_product, jurisdiction_state,
  75. call_date_time_hours, call_date_time_day, call_date_time_month,
  76. call_date_time_year) a
  77.  
  78. F02:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1
  79. | Per-Host Resources: mem-estimate=10.02MB mem-reservation=0B thread-reservation=1
  80. PLAN-ROOT SINK
  81. | mem-estimate=0B mem-reservation=0B thread-reservation=0
  82. |
  83. 06:AGGREGATE [FINALIZE]
  84. | output: count:merge(*)
  85. | mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0
  86. | tuple-ids=3 row-size=8B cardinality=1
  87. | in pipelines: 06(GETNEXT), 02(OPEN)
  88. |
  89. 05:EXCHANGE [UNPARTITIONED]
  90. | mem-estimate=16.00KB mem-reservation=0B thread-reservation=0
  91. | tuple-ids=3 row-size=8B cardinality=1
  92. | in pipelines: 02(GETNEXT)
  93. |
  94. F01:PLAN FRAGMENT [HASH(CAST(orig_cust_id AS INT),CAST(dest_npa AS INT),CAST(dest_nxx AS INT),dest_state,dest_ocn,orig_trunk_grp_nm,orig_product,jurisdiction_state,call_date_time_hours,call_date_time_day,call_date_time_month,call_date_time_year)] hosts=3 instances=3
  95. Per-Host Resources: mem-estimate=138.00MB mem-reservation=34.00MB thread-reservation=1
  96. 02:AGGREGATE
  97. | output: count(*)
  98. | mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0
  99. | tuple-ids=3 row-size=8B cardinality=1
  100. | in pipelines: 02(GETNEXT), 04(OPEN)
  101. |
  102. 04:AGGREGATE [FINALIZE]
  103. | group by: CAST(orig_cust_id AS INT), CAST(dest_npa AS INT), CAST(dest_nxx AS INT), dest_state, dest_ocn, orig_trunk_grp_nm, orig_product, jurisdiction_state, call_date_time_hours, call_date_time_day, call_date_time_month, call_date_time_year
  104. | mem-estimate=128.00MB mem-reservation=34.00MB spill-buffer=2.00MB thread-reservation=0
  105. | tuple-ids=1 row-size=104B cardinality=unavailable
  106. | in pipelines: 04(GETNEXT), 00(OPEN)
  107. |
  108. 03:EXCHANGE [HASH(CAST(orig_cust_id AS INT),CAST(dest_npa AS INT),CAST(dest_nxx AS INT),dest_state,dest_ocn,orig_trunk_grp_nm,orig_product,jurisdiction_state,call_date_time_hours,call_date_time_day,call_date_time_month,call_date_time_year)]
  109. | mem-estimate=323.97KB mem-reservation=0B thread-reservation=0
  110. | tuple-ids=1 row-size=104B cardinality=unavailable
  111. | in pipelines: 00(GETNEXT)
  112. |
  113. F00:PLAN FRAGMENT [RANDOM] hosts=3 instances=3
  114. Per-Host Resources: mem-estimate=448.00MB mem-reservation=66.00MB thread-reservation=2
  115. 01:AGGREGATE [STREAMING]
  116. | group by: CAST(orig_cust_id AS INT), CAST(dest_npa AS INT), CAST(dest_nxx AS INT), dest_state, dest_ocn, orig_trunk_grp_nm, orig_product, jurisdiction_state, call_date_time_hours, call_date_time_day, call_date_time_month, call_date_time_year
  117. | mem-estimate=128.00MB mem-reservation=34.00MB spill-buffer=2.00MB thread-reservation=0
  118. | tuple-ids=1 row-size=104B cardinality=unavailable
  119. | in pipelines: 00(GETNEXT)
  120. |
  121. 00:SCAN HDFS [call_detail_records.raw, RANDOM]
  122. partition predicates: call_date_time_day = CAST(10 AS INT), call_date_time_month = CAST(2 AS INT), call_date_time_year = CAST(2020 AS INT)
  123. partitions=24/631 files=478 size=14.48GB
  124. predicates: orig_cust_id = '25'
  125. stored statistics:
  126. table: rows=unavailable size=unavailable
  127. partitions: 0/24 rows=unavailable
  128. columns missing stats: orig_cust_id, dest_npa, dest_nxx, dest_state, dest_ocn, orig_trunk_grp_nm, orig_product, jurisdiction_state, cost, revenue, conv_seconds
  129. extrapolated-rows=disabled max-scan-range-rows=unavailable
  130. parquet statistics predicates: orig_cust_id = '25'
  131. parquet dictionary predicates: orig_cust_id = '25'
  132. mem-estimate=320.00MB mem-reservation=32.00MB thread-reservation=1
  133. tuple-ids=0 row-size=104B cardinality=unavailable
  134. in pipelines: 00(GETNEXT)
  135. ----------------
  136. Estimated Per-Host Mem: 624967680
  137. Tables Missing Stats: call_detail_records.raw
  138. Per Host Min Memory Reservation: itchil804.inteliquent.com:22000(100.00 MB) itchil805.inteliquent.com:22000(100.00 MB) itchil806.inteliquent.com:22000(100.00 MB)
  139. Request Pool: root.nmali
  140. Admission result: Admitted immediately
  141. Cluster Memory Admitted: 1.75 GB
  142. ExecSummary:
  143. Operator #Hosts Avg Time Max Time #Rows Est. #Rows Peak Mem Est. Peak Mem Detail
  144. -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  145. F02:ROOT 1 38.528us 38.528us 0 0
  146. 06:AGGREGATE 1 419.131us 419.131us 1 1 16.00 KB 10.00 MB FINALIZE
  147. 05:EXCHANGE 1 53.043us 53.043us 3 1 32.00 KB 16.00 KB UNPARTITIONED
  148. F01:EXCHANGE SENDER 3 140.015us 193.994us 16.00 KB 0
  149. 02:AGGREGATE 3 1.143ms 1.160ms 3 1 16.00 KB 10.00 MB
  150. 04:AGGREGATE 3 898.648ms 954.214ms 3.46M -1 192.11 MB 128.00 MB FINALIZE
  151. 03:EXCHANGE 3 69.093ms 71.785ms 5.11M -1 1.09 MB 323.97 KB HASH(CAST(orig_cust_id AS INT),CAST(dest_npa AS INT),CAST(dest_nxx AS INT),dest_state,dest_ocn,orig_trunk_grp_nm,orig_product,jurisdiction_state,call_date_time_hours,call_date_time_day,call_date_time_month,call_date_time_year)
  152. F00:EXCHANGE SENDER 3 1s226ms 1s333ms 88.27 KB 0
  153. 01:AGGREGATE 3 6s900ms 7s759ms 5.11M -1 321.54 MB 128.00 MB STREAMING
  154. 00:SCAN HDFS 3 221.143ms 297.334ms 54.04M -1 2.02 GB 320.00 MB call_detail_records.raw
  155. Errors:
  156. Query Compilation: 23.051ms
  157. - Metadata of all 1 tables cached: 2.680ms (2.680ms)
  158. - Analysis finished: 10.512ms (7.831ms)
  159. - Value transfer graph computed: 10.668ms (156.378us)
  160. - Single node plan created: 19.915ms (9.247ms)
  161. - Runtime filters computed: 20.189ms (273.752us)
  162. - Distributed plan created: 20.260ms (70.978us)
  163. - Lineage info computed: 20.393ms (132.543us)
  164. - Planning finished: 23.051ms (2.658ms)
  165. Query Timeline: 2m24s
  166. - Query submitted: 118.576us (118.576us)
  167. - Planning finished: 26.581ms (26.462ms)
  168. - Submit for admission: 29.364ms (2.782ms)
  169. - Completed admission: 29.676ms (311.984us)
  170. - Ready to start on 3 backends: 31.032ms (1.355ms)
  171. - All 3 execution backends (7 fragment instances) started: 38.421ms (7.389ms)
  172. - Rows available: 9s787ms (9s749ms)
  173. - First row fetched: 11s498ms (1s710ms)
  174. - Last row fetched: 12s839ms (1s341ms)
  175. - Released admission control resources: 12s839ms (141.351us)
  176. - AdmissionControlTimeSinceLastUpdate: 83.000ms
  177. - ComputeScanRangeAssignmentTimer: 774.145us
  178. Frontend:
  179. ImpalaServer:
  180. - ClientFetchWaitTimer: 3s051ms
  181. - RowMaterializationTimer: 3.938ms
  182. Execution Profile 434987288e39baec:45101a3900000000:(Total: 9s760ms, non-child: 0.000ns, % non-child: 0.00%)
  183. Number of filters: 0
  184. Filter routing table:
  185. ID Src. Node Tgt. Node(s) Target type Partition filter Pending (Expected) First arrived Completed Enabled
  186. -------------------------------------------------------------------------------------------------------------------
  187. Backend startup latencies: Count: 3, min / max: 4ms / 5ms, 25th %-ile: 4ms, 50th %-ile: 5ms, 75th %-ile: 5ms, 90th %-ile: 5ms, 95th %-ile: 5ms, 99.9th %-ile: 5ms
  188. Slowest backend to start up: itchil805.inteliquent.com:22000
  189. Per Node Peak Memory Usage: itchil804.inteliquent.com:22000(2.17 GB) itchil805.inteliquent.com:22000(2.00 GB) itchil806.inteliquent.com:22000(1.92 GB)
  190. Per Node Bytes Read: itchil804.inteliquent.com:22000(1.48 GB) itchil805.inteliquent.com:22000(1.30 GB) itchil806.inteliquent.com:22000(1.30 GB)
  191. Per Node User Time: itchil804.inteliquent.com:22000(28s887ms) itchil805.inteliquent.com:22000(23s195ms) itchil806.inteliquent.com:22000(23s017ms)
  192. Per Node System Time: itchil804.inteliquent.com:22000(1s206ms) itchil805.inteliquent.com:22000(931.985ms) itchil806.inteliquent.com:22000(825.762ms)
  193. - ExchangeScanRatio: 0.07
  194. - FiltersReceived: 0 (0)
  195. - FinalizationTimer: 0.000ns
  196. - InnerNodeSelectivityRatio: 0.00
  197. - NumBackends: 3 (3)
  198. - NumFragmentInstances: 7 (7)
  199. - NumFragments: 3 (3)
  200. - TotalBytesRead: 4.08 GB (4385496404)
  201. - TotalBytesSent: 294.32 MB (308617202)
  202. - TotalCpuTime: 1m18s
  203. - TotalInnerBytesSent: 36.00 B (36)
  204. - TotalScanBytesSent: 294.32 MB (308617166)
  205. Per Node Profiles:
  206. itchil804.inteliquent.com:22000:
  207. - ScratchBytesRead: 0
  208. - ScratchBytesWritten: 0
  209. - ScratchFileUsedBytes: 0
  210. - ScratchReads: 0 (0)
  211. - ScratchWrites: 0 (0)
  212. - TotalEncryptionTime: 0.000ns
  213. - TotalReadBlockTime: 0.000ns
  214. itchil805.inteliquent.com:22000:
  215. - ScratchBytesRead: 0
  216. - ScratchBytesWritten: 0
  217. - ScratchFileUsedBytes: 0
  218. - ScratchReads: 0 (0)
  219. - ScratchWrites: 0 (0)
  220. - TotalEncryptionTime: 0.000ns
  221. - TotalReadBlockTime: 0.000ns
  222. itchil806.inteliquent.com:22000:
  223. - ScratchBytesRead: 0
  224. - ScratchBytesWritten: 0
  225. - ScratchFileUsedBytes: 0
  226. - ScratchReads: 0 (0)
  227. - ScratchWrites: 0 (0)
  228. - TotalEncryptionTime: 0.000ns
  229. - TotalReadBlockTime: 0.000ns
  230. Averaged Fragment F02:(Total: 11s461ms, non-child: 656.174us, % non-child: 0.01%)
  231. split sizes: min: 0, max: 0, avg: 0, stddev: 0
  232. completion times: min:11s463ms max:11s463ms mean: 11s463ms stddev:0.000ns
  233. execution rates: min:0.00 /sec max:0.00 /sec mean:0.00 /sec stddev:0.00 /sec
  234. num instances: 1
  235. - AverageThreadTokens: 0.00
  236. - BloomFilterBytes: 0
  237. - ExchangeScanRatio: 0.00
  238. - PeakMemoryUsage: 56.00 KB (57344)
  239. - PeakReservation: 0
  240. - PeakUsedReservation: 0
  241. - PerHostPeakMemUsage: 2.17 GB (2325567844)
  242. - RowsProduced: 1 (1)
  243. - TotalNetworkReceiveTime: 9s722ms
  244. - TotalNetworkSendTime: 0.000ns
  245. - TotalStorageWaitTime: 0.000ns
  246. - TotalThreadsInvoluntaryContextSwitches: 0 (0)
  247. - TotalThreadsTotalWallClockTime: 11s460ms
  248. - TotalThreadsSysTime: 0.000ns
  249. - TotalThreadsUserTime: 28.181ms
  250. - TotalThreadsVoluntaryContextSwitches: 5 (5)
  251. Buffer pool:
  252. - AllocTime: 0.000ns
  253. - CumulativeAllocationBytes: 0
  254. - CumulativeAllocations: 0 (0)
  255. - PeakReservation: 0
  256. - PeakUnpinnedBytes: 0
  257. - PeakUsedReservation: 0
  258. - ReadIoBytes: 0
  259. - ReadIoOps: 0 (0)
  260. - ReadIoWaitTime: 0.000ns
  261. - ReservationLimit: 0
  262. - SystemAllocTime: 0.000ns
  263. - WriteIoBytes: 0
  264. - WriteIoOps: 0 (0)
  265. - WriteIoWaitTime: 0.000ns
  266. Fragment Instance Lifecycle Timings:
  267. - ExecTime: 1s710ms
  268. - ExecTreeExecTime: 13.981us
  269. - OpenTime: 9s749ms
  270. - ExecTreeOpenTime: 9s722ms
  271. - PrepareTime: 614.622us
  272. - ExecTreePrepareTime: 246.124us
  273. PLAN_ROOT_SINK:(Total: 1s710ms, non-child: 1s710ms, % non-child: 100.00%)
  274. - PeakMemoryUsage: 0
  275. AGGREGATION_NODE (id=6):(Total: 9s722ms, non-child: 419.131us, % non-child: 0.00%)
  276. - PeakMemoryUsage: 16.00 KB (16384)
  277. - RowsReturned: 1 (1)
  278. - RowsReturnedRate: 0
  279. NonGroupingAggregator 0:
  280. - BuildTime: 6.488us
  281. - PeakMemoryUsage: 8.00 KB (8192)
  282. - RowsReturned: 1 (1)
  283. EXCHANGE_NODE (id=5):(Total: 9s722ms, non-child: 9s722ms, % non-child: 100.00%)
  284. - ConvertRowBatchTime: 5.451us
  285. - PeakMemoryUsage: 32.00 KB (32768)
  286. - RowsReturned: 3 (3)
  287. - RowsReturnedRate: 0
  288. Buffer pool:
  289. - AllocTime: 10.847us
  290. - CumulativeAllocationBytes: 48.00 KB (49152)
  291. - CumulativeAllocations: 6 (6)
  292. - PeakReservation: 32.00 KB (32768)
  293. - PeakUnpinnedBytes: 0
  294. - PeakUsedReservation: 32.00 KB (32768)
  295. - ReadIoBytes: 0
  296. - ReadIoOps: 0 (0)
  297. - ReadIoWaitTime: 0.000ns
  298. - SystemAllocTime: 0.000ns
  299. - WriteIoBytes: 0
  300. - WriteIoOps: 0 (0)
  301. - WriteIoWaitTime: 0.000ns
  302. Dequeue:
  303. - FirstBatchWaitTime: 9s719ms
  304. - TotalBytesDequeued: 48.00 B (48)
  305. - TotalGetBatchTime: 9s722ms
  306. - DataWaitTime: 9s722ms
  307. Enqueue:
  308. - DeserializeRowBatchTime: 40.204us
  309. - TotalBatchesEnqueued: 3 (3)
  310. - TotalBatchesReceived: 3 (3)
  311. - TotalBytesReceived: 36.00 B (36)
  312. - TotalEarlySenders: 0 (0)
  313. - TotalEosReceived: 3 (3)
  314. - TotalHasDeferredRPCsTime: 0.000ns
  315. - TotalRPCsDeferred: 0 (0)
  316. CodeGen:(Total: 27.063ms, non-child: 27.063ms, % non-child: 100.00%)
  317. - CodegenInvoluntaryContextSwitches: 0 (0)
  318. - CodegenTotalWallClockTime: 27.040ms
  319. - CodegenSysTime: 0.000ns
  320. - CodegenUserTime: 23.853ms
  321. - CodegenVoluntaryContextSwitches: 0 (0)
  322. - CompileTime: 0.000ns
  323. - IrGenerationTime: 21.336us
  324. - LoadTime: 0.000ns
  325. - ModuleBitcodeSize: 2.28 MB (2393476)
  326. - NumFunctions: 0 (0)
  327. - NumInstructions: 0 (0)
  328. - OptimizationTime: 0.000ns
  329. - PeakMemoryUsage: 0
  330. - PrepareTime: 27.031ms
  331. Coordinator Fragment F02:
  332. Instance 434987288e39baec:45101a3900000000 (host=itchil804.inteliquent.com:22000):(Total: 11s461ms, non-child: 656.174us, % non-child: 0.01%)
  333. Last report received time: 2020-02-11 13:42:03.290
  334. Fragment Instance Lifecycle Event Timeline: 11s461ms
  335. - Prepare Finished: 1.171ms (1.171ms)
  336. - Open Finished: 9s751ms (9s749ms)
  337. - First Batch Produced: 9s751ms (16.303us)
  338. - First Batch Sent: 11s461ms (1s710ms)
  339. - ExecInternal Finished: 11s461ms (145.994us)
  340. - MemoryUsage (500.000ms): 12.00 KB, 12.00 KB, 12.00 KB, 12.00 KB, 12.00 KB, 12.00 KB, 12.00 KB, 12.00 KB, 12.00 KB, 12.00 KB, 12.00 KB, 12.00 KB, 12.00 KB, 12.00 KB, 12.00 KB, 12.00 KB, 12.00 KB, 12.00 KB, 12.00 KB, 16.00 KB, 16.00 KB, 16.00 KB, 16.00 KB
  341. - AverageThreadTokens: 0.00
  342. - BloomFilterBytes: 0
  343. - ExchangeScanRatio: 0.00
  344. - PeakMemoryUsage: 56.00 KB (57344)
  345. - PeakReservation: 0
  346. - PeakUsedReservation: 0
  347. - PerHostPeakMemUsage: 2.17 GB (2325567844)
  348. - RowsProduced: 1 (1)
  349. - TotalNetworkReceiveTime: 9s722ms
  350. - TotalNetworkSendTime: 0.000ns
  351. - TotalStorageWaitTime: 0.000ns
  352. - TotalThreadsInvoluntaryContextSwitches: 0 (0)
  353. - TotalThreadsTotalWallClockTime: 11s460ms
  354. - TotalThreadsSysTime: 0.000ns
  355. - TotalThreadsUserTime: 28.181ms
  356. - TotalThreadsVoluntaryContextSwitches: 5 (5)
  357. Buffer pool:
  358. - AllocTime: 0.000ns
  359. - CumulativeAllocationBytes: 0
  360. - CumulativeAllocations: 0 (0)
  361. - PeakReservation: 0
  362. - PeakUnpinnedBytes: 0
  363. - PeakUsedReservation: 0
  364. - ReadIoBytes: 0
  365. - ReadIoOps: 0 (0)
  366. - ReadIoWaitTime: 0.000ns
  367. - ReservationLimit: 0
  368. - SystemAllocTime: 0.000ns
  369. - WriteIoBytes: 0
  370. - WriteIoOps: 0 (0)
  371. - WriteIoWaitTime: 0.000ns
  372. Fragment Instance Lifecycle Timings:
  373. - ExecTime: 1s710ms
  374. - ExecTreeExecTime: 13.981us
  375. - OpenTime: 9s749ms
  376. - ExecTreeOpenTime: 9s722ms
  377. - PrepareTime: 614.622us
  378. - ExecTreePrepareTime: 246.124us
  379. PLAN_ROOT_SINK:(Total: 1s710ms, non-child: 38.528us, % non-child: 0.00%)
  380. - PeakMemoryUsage: 0
  381. AGGREGATION_NODE (id=6):(Total: 9s722ms, non-child: 419.131us, % non-child: 0.00%)
  382. Node Lifecycle Event Timeline: 11s461ms
  383. - Open Started: 28.405ms (28.405ms)
  384. - Open Finished: 9s750ms (9s722ms)
  385. - First Batch Requested: 9s751ms (48.797us)
  386. - First Batch Returned: 9s751ms (9.059us)
  387. - Last Batch Returned: 9s751ms (882.000ns)
  388. - Closed: 11s461ms (1s710ms)
  389. - PeakMemoryUsage: 16.00 KB (16384)
  390. - RowsReturned: 1 (1)
  391. - RowsReturnedRate: 0
  392. NonGroupingAggregator 0:
  393. - BuildTime: 6.488us
  394. - PeakMemoryUsage: 8.00 KB (8192)
  395. - RowsReturned: 1 (1)
  396. EXCHANGE_NODE (id=5):(Total: 9s722ms, non-child: 53.043us, % non-child: 0.00%)
  397. Node Lifecycle Event Timeline: 9s750ms
  398. - Open Started: 28.406ms (28.406ms)
  399. - Open Finished: 9s747ms (9s719ms)
  400. - First Batch Requested: 9s747ms (23.876us)
  401. - First Batch Returned: 9s750ms (3.156ms)
  402. - Last Batch Returned: 9s750ms (1.147us)
  403. - Closed: 9s750ms (137.191us)
  404. - ConvertRowBatchTime: 5.451us
  405. - PeakMemoryUsage: 32.00 KB (32768)
  406. - RowsReturned: 3 (3)
  407. - RowsReturnedRate: 0
  408. Buffer pool:
  409. - AllocTime: 10.847us
  410. - CumulativeAllocationBytes: 48.00 KB (49152)
  411. - CumulativeAllocations: 6 (6)
  412. - PeakReservation: 32.00 KB (32768)
  413. - PeakUnpinnedBytes: 0
  414. - PeakUsedReservation: 32.00 KB (32768)
  415. - ReadIoBytes: 0
  416. - ReadIoOps: 0 (0)
  417. - ReadIoWaitTime: 0.000ns
  418. - SystemAllocTime: 0.000ns
  419. - WriteIoBytes: 0
  420. - WriteIoOps: 0 (0)
  421. - WriteIoWaitTime: 0.000ns
  422. Dequeue:
  423. - BytesDequeued (500.000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0
  424. - FirstBatchWaitTime: 9s719ms
  425. - TotalBytesDequeued: 48.00 B (48)
  426. - TotalGetBatchTime: 9s722ms
  427. - DataWaitTime: 9s722ms
  428. Enqueue:
  429. - BytesReceived (500.000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0
  430. - DeferredQueueSize (500.000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0
  431. - DispatchTime: (Avg: 105.892us ; Min: 91.295us ; Max: 116.186us ; Number of samples: 3)
  432. - DeserializeRowBatchTime: 40.204us
  433. - TotalBatchesEnqueued: 3 (3)
  434. - TotalBatchesReceived: 3 (3)
  435. - TotalBytesReceived: 36.00 B (36)
  436. - TotalEarlySenders: 0 (0)
  437. - TotalEosReceived: 3 (3)
  438. - TotalHasDeferredRPCsTime: 0.000ns
  439. - TotalRPCsDeferred: 0 (0)
  440. CodeGen:(Total: 27.063ms, non-child: 27.063ms, % non-child: 100.00%)
  441. - CodegenInvoluntaryContextSwitches: 0 (0)
  442. - CodegenTotalWallClockTime: 27.040ms
  443. - CodegenSysTime: 0.000ns
  444. - CodegenUserTime: 23.853ms
  445. - CodegenVoluntaryContextSwitches: 0 (0)
  446. - CompileTime: 0.000ns
  447. - IrGenerationTime: 21.336us
  448. - LoadTime: 0.000ns
  449. - ModuleBitcodeSize: 2.28 MB (2393476)
  450. - NumFunctions: 0 (0)
  451. - NumInstructions: 0 (0)
  452. - OptimizationTime: 0.000ns
  453. - PeakMemoryUsage: 0
  454. - PrepareTime: 27.031ms
  455. Averaged Fragment F01:(Total: 9s747ms, non-child: 840.589us, % non-child: 0.01%)
  456. split sizes: min: 0, max: 0, avg: 0, stddev: 0
  457. completion times: min:9s750ms max:10s012ms mean: 9s838ms stddev:123.148ms
  458. execution rates: min:0.00 /sec max:0.00 /sec mean:0.00 /sec stddev:0.00 /sec
  459. num instances: 3
  460. - AverageThreadTokens: 1.00
  461. - BloomFilterBytes: 0
  462. - ExchangeScanRatio: 0.00
  463. - PeakMemoryUsage: 193.11 MB (202490902)
  464. - PeakReservation: 192.00 MB (201326592)
  465. - PeakUsedReservation: 0
  466. - PerHostPeakMemUsage: 2.03 GB (2176278826)
  467. - RowsProduced: 1 (1)
  468. - TotalNetworkReceiveTime: 8s646ms
  469. - TotalNetworkSendTime: 801.044us
  470. - TotalStorageWaitTime: 0.000ns
  471. - TotalThreadsInvoluntaryContextSwitches: 3 (3)
  472. - TotalThreadsTotalWallClockTime: 9s745ms
  473. - TotalThreadsSysTime: 87.213ms
  474. - TotalThreadsUserTime: 1s103ms
  475. - TotalThreadsVoluntaryContextSwitches: 7.00K (6995)
  476. Buffer pool:
  477. - AllocTime: 0.000ns
  478. - CumulativeAllocationBytes: 0
  479. - CumulativeAllocations: 0 (0)
  480. - PeakReservation: 0
  481. - PeakUnpinnedBytes: 0
  482. - PeakUsedReservation: 0
  483. - ReadIoBytes: 0
  484. - ReadIoOps: 0 (0)
  485. - ReadIoWaitTime: 0.000ns
  486. - ReservationLimit: 0
  487. - SystemAllocTime: 0.000ns
  488. - WriteIoBytes: 0
  489. - WriteIoOps: 0 (0)
  490. - WriteIoWaitTime: 0.000ns
  491. Fragment Instance Lifecycle Timings:
  492. - ExecTime: 868.414us
  493. - ExecTreeExecTime: 3.766us
  494. - OpenTime: 9s744ms
  495. - ExecTreeOpenTime: 9s588ms
  496. - PrepareTime: 1.294ms
  497. - ExecTreePrepareTime: 682.041us
  498. KrpcDataStreamSender (dst_id=5):(Total: 941.745us, non-child: 941.745us, % non-child: 100.00%)
  499. - EosSent: 1 (1)
  500. - PeakMemoryUsage: 16.00 KB (16384)
  501. - RowsSent: 1 (1)
  502. - RpcFailure: 0 (0)
  503. - RpcRetry: 0 (0)
  504. - SerializeBatchTime: 7.304us
  505. - TotalBytesSent: 12.00 B (12)
  506. - UncompressedRowBatchSize: 16.00 B (16)
  507. AGGREGATION_NODE (id=2):(Total: 9s589ms, non-child: 1.143ms, % non-child: 0.01%)
  508. - PeakMemoryUsage: 16.00 KB (16384)
  509. - RowsReturned: 1 (1)
  510. - RowsReturnedRate: 0
  511. NonGroupingAggregator 0:
  512. - BuildTime: 644.082us
  513. - PeakMemoryUsage: 8.00 KB (8192)
  514. - RowsReturned: 1 (1)
  515. AGGREGATION_NODE (id=4):(Total: 9s587ms, non-child: 898.648ms, % non-child: 9.37%)
  516. - PeakMemoryUsage: 192.11 MB (201441408)
  517. - RowsReturned: 1.15M (1153006)
  518. - RowsReturnedRate: 120.25 K/sec
  519. GroupingAggregator 0:
  520. - BuildTime: 857.723ms
  521. - GetResultsTime: 33.524ms
  522. - HTResizeTime: 58.997ms
  523. - HashBuckets: 2.10M (2097152)
  524. - LargestPartitionPercent: 4 (4)
  525. - MaxPartitionLevel: 0 (0)
  526. - NumRepartitions: 0 (0)
  527. - PartitionsCreated: 16 (16)
  528. - PeakMemoryUsage: 192.11 MB (201437312)
  529. - PeakReservation: 192.00 MB (201326592)
  530. - PeakUsedReservation: 0
  531. - RowsRepartitioned: 0 (0)
  532. - RowsReturned: 1.15M (1153006)
  533. - SpilledPartitions: 0 (0)
  534. Buffer pool:
  535. - AllocTime: 21.993ms
  536. - CumulativeAllocationBytes: 208.00 MB (218103808)
  537. - CumulativeAllocations: 104 (104)
  538. - PeakReservation: 192.00 MB (201326592)
  539. - PeakUnpinnedBytes: 0
  540. - PeakUsedReservation: 192.00 MB (201326592)
  541. - ReadIoBytes: 0
  542. - ReadIoOps: 0 (0)
  543. - ReadIoWaitTime: 0.000ns
  544. - SystemAllocTime: 21.840ms
  545. - WriteIoBytes: 0
  546. - WriteIoOps: 0 (0)
  547. - WriteIoWaitTime: 0.000ns
  548. EXCHANGE_NODE (id=3):(Total: 8s689ms, non-child: 8s689ms, % non-child: 100.00%)
  549. - ConvertRowBatchTime: 34.148ms
  550. - PeakMemoryUsage: 992.00 KB (1015808)
  551. - RowsReturned: 1.70M (1702077)
  552. - RowsReturnedRate: 195.89 K/sec
  553. Buffer pool:
  554. - AllocTime: 17.911ms
  555. - CumulativeAllocationBytes: 365.33 MB (383074304)
  556. - CumulativeAllocations: 18.71K (18706)
  557. - PeakReservation: 992.00 KB (1015808)
  558. - PeakUnpinnedBytes: 0
  559. - PeakUsedReservation: 992.00 KB (1015808)
  560. - ReadIoBytes: 0
  561. - ReadIoOps: 0 (0)
  562. - ReadIoWaitTime: 0.000ns
  563. - SystemAllocTime: 2.384ms
  564. - WriteIoBytes: 0
  565. - WriteIoOps: 0 (0)
  566. - WriteIoWaitTime: 0.000ns
  567. Dequeue:
  568. - FirstBatchWaitTime: 6s669ms
  569. - TotalBytesDequeued: 221.77 MB (232547548)
  570. - TotalGetBatchTime: 8s644ms
  571. - DataWaitTime: 8s620ms
  572. Enqueue:
  573. - DeserializeRowBatchTime: 671.310ms
  574. - TotalBatchesEnqueued: 9.35K (9353)
  575. - TotalBatchesReceived: 9.35K (9353)
  576. - TotalBytesReceived: 98.11 MB (102872388)
  577. - TotalEarlySenders: 0 (0)
  578. - TotalEosReceived: 3 (3)
  579. - TotalHasDeferredRPCsTime: 0.000ns
  580. - TotalRPCsDeferred: 0 (0)
  581. CodeGen:(Total: 156.328ms, non-child: 156.328ms, % non-child: 100.00%)
  582. - CodegenInvoluntaryContextSwitches: 0 (0)
  583. - CodegenTotalWallClockTime: 156.316ms
  584. - CodegenSysTime: 3.852ms
  585. - CodegenUserTime: 152.786ms
  586. - CodegenVoluntaryContextSwitches: 0 (0)
  587. - CompileTime: 38.029ms
  588. - IrGenerationTime: 3.661ms
  589. - LoadTime: 0.000ns
  590. - ModuleBitcodeSize: 2.28 MB (2393476)
  591. - NumFunctions: 57 (57)
  592. - NumInstructions: 1.63K (1626)
  593. - OptimizationTime: 88.224ms
  594. - PeakMemoryUsage: 813.00 KB (832512)
  595. - PrepareTime: 25.545ms
  596. Fragment F01:
  597. Instance 434987288e39baec:45101a3900000006 (host=itchil805.inteliquent.com:22000):(Total: 9s748ms, non-child: 966.160us, % non-child: 0.01%)
  598. Last report received time: 2020-02-11 13:42:01.581
  599. Fragment Instance Lifecycle Event Timeline: 9s749ms
  600. - Prepare Finished: 1.955ms (1.955ms)
  601. - Open Finished: 9s747ms (9s746ms)
  602. - First Batch Produced: 9s747ms (5.194us)
  603. - First Batch Sent: 9s748ms (28.907us)
  604. - ExecInternal Finished: 9s749ms (1.042ms)
  605. - MemoryUsage (500.000ms): 137.02 KB, 137.02 KB, 137.02 KB, 137.02 KB, 137.02 KB, 137.02 KB, 137.02 KB, 137.02 KB, 137.02 KB, 137.02 KB, 137.02 KB, 137.02 KB, 137.02 KB, 137.02 KB, 52.53 MB, 108.92 MB, 161.23 MB, 165.23 MB, 181.23 MB, 193.23 MB
  606. - ThreadUsage (500.000ms): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1
  607. - AverageThreadTokens: 1.00
  608. - BloomFilterBytes: 0
  609. - ExchangeScanRatio: 0.00
  610. - PeakMemoryUsage: 193.23 MB (202613782)
  611. - PeakReservation: 192.00 MB (201326592)
  612. - PeakUsedReservation: 0
  613. - PerHostPeakMemUsage: 2.00 GB (2144411750)
  614. - RowsProduced: 1 (1)
  615. - TotalNetworkReceiveTime: 8s650ms
  616. - TotalNetworkSendTime: 854.560us
  617. - TotalStorageWaitTime: 0.000ns
  618. - TotalThreadsInvoluntaryContextSwitches: 7 (7)
  619. - TotalThreadsTotalWallClockTime: 9s746ms
  620. - TotalThreadsSysTime: 76.204ms
  621. - TotalThreadsUserTime: 1s113ms
  622. - TotalThreadsVoluntaryContextSwitches: 7.08K (7076)
  623. Buffer pool:
  624. - AllocTime: 0.000ns
  625. - CumulativeAllocationBytes: 0
  626. - CumulativeAllocations: 0 (0)
  627. - PeakReservation: 0
  628. - PeakUnpinnedBytes: 0
  629. - PeakUsedReservation: 0
  630. - ReadIoBytes: 0
  631. - ReadIoOps: 0 (0)
  632. - ReadIoWaitTime: 0.000ns
  633. - ReservationLimit: 0
  634. - SystemAllocTime: 0.000ns
  635. - WriteIoBytes: 0
  636. - WriteIoOps: 0 (0)
  637. - WriteIoWaitTime: 0.000ns
  638. Fragment Instance Lifecycle Timings:
  639. - ExecTime: 922.107us
  640. - ExecTreeExecTime: 4.160us
  641. - OpenTime: 9s746ms
  642. - ExecTreeOpenTime: 9s590ms
  643. - PrepareTime: 1.302ms
  644. - ExecTreePrepareTime: 643.950us
  645. KrpcDataStreamSender (dst_id=5):(Total: 973.453us, non-child: 118.024us, % non-child: 12.12%)
  646. ExecOption: Unpartitioned Sender Codegen Disabled: not needed
  647. - BytesSent (500.000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0
  648. - NetworkThroughput: (Avg: 25.88 KB/sec ; Min: 25.88 KB/sec ; Max: 25.88 KB/sec ; Number of samples: 1)
  649. - EosSent: 1 (1)
  650. - PeakMemoryUsage: 16.00 KB (16384)
  651. - RowsSent: 1 (1)
  652. - RpcFailure: 0 (0)
  653. - RpcRetry: 0 (0)
  654. - SerializeBatchTime: 6.180us
  655. - TotalBytesSent: 12.00 B (12)
  656. - UncompressedRowBatchSize: 16.00 B (16)
  657. AGGREGATION_NODE (id=2):(Total: 9s590ms, non-child: 1.134ms, % non-child: 0.01%)
  658. Node Lifecycle Event Timeline: 9s748ms
  659. - Open Started: 157.879ms (157.879ms)
  660. - Open Finished: 9s747ms (9s590ms)
  661. - First Batch Requested: 9s747ms (24.105us)
  662. - First Batch Returned: 9s747ms (2.445us)
  663. - Last Batch Returned: 9s747ms (348.000ns)
  664. - Closed: 9s748ms (934.683us)
  665. - PeakMemoryUsage: 16.00 KB (16384)
  666. - RowsReturned: 1 (1)
  667. - RowsReturnedRate: 0
  668. NonGroupingAggregator 0:
  669. ExecOption: Codegen Enabled
  670. - BuildTime: 657.443us
  671. - PeakMemoryUsage: 8.00 KB (8192)
  672. - RowsReturned: 1 (1)
  673. AGGREGATION_NODE (id=4):(Total: 9s589ms, non-child: 895.905ms, % non-child: 9.34%)
  674. Node Lifecycle Event Timeline: 9s747ms
  675. - Open Started: 157.880ms (157.880ms)
  676. - Open Finished: 9s711ms (9s554ms)
  677. - First Batch Requested: 9s711ms (13.807us)
  678. - First Batch Returned: 9s711ms (84.999us)
  679. - Last Batch Returned: 9s747ms (35.932ms)
  680. - Closed: 9s747ms (54.060us)
  681. - PeakMemoryUsage: 192.11 MB (201441408)
  682. - RowsReturned: 1.15M (1154681)
  683. - RowsReturnedRate: 120.41 K/sec
  684. GroupingAggregator 0:
  685. ExecOption: Codegen Enabled
  686. - BuildTime: 854.089ms
  687. - GetResultsTime: 34.583ms
  688. - HTResizeTime: 64.639ms
  689. - HashBuckets: 2.10M (2097152)
  690. - LargestPartitionPercent: 4 (4)
  691. - MaxPartitionLevel: 0 (0)
  692. - NumRepartitions: 0 (0)
  693. - PartitionsCreated: 16 (16)
  694. - PeakMemoryUsage: 192.11 MB (201437312)
  695. - PeakReservation: 192.00 MB (201326592)
  696. - PeakUsedReservation: 0
  697. - RowsRepartitioned: 0 (0)
  698. - RowsReturned: 1.15M (1154681)
  699. - SpilledPartitions: 0 (0)
  700. Buffer pool:
  701. - AllocTime: 19.627ms
  702. - CumulativeAllocationBytes: 208.00 MB (218103808)
  703. - CumulativeAllocations: 104 (104)
  704. - PeakReservation: 192.00 MB (201326592)
  705. - PeakUnpinnedBytes: 0
  706. - PeakUsedReservation: 192.00 MB (201326592)
  707. - ReadIoBytes: 0
  708. - ReadIoOps: 0 (0)
  709. - ReadIoWaitTime: 0.000ns
  710. - SystemAllocTime: 19.486ms
  711. - WriteIoBytes: 0
  712. - WriteIoOps: 0 (0)
  713. - WriteIoWaitTime: 0.000ns
  714. EXCHANGE_NODE (id=3):(Total: 8s693ms, non-child: 69.571ms, % non-child: 0.80%)
  715. Node Lifecycle Event Timeline: 9s711ms
  716. - Open Started: 157.881ms (157.881ms)
  717. - Open Finished: 6s827ms (6s669ms)
  718. - First Batch Requested: 6s827ms (507.809us)
  719. - First Batch Returned: 6s830ms (2.104ms)
  720. - Last Batch Returned: 9s711ms (2s881ms)
  721. - Closed: 9s711ms (334.097us)
  722. - ConvertRowBatchTime: 34.530ms
  723. - PeakMemoryUsage: 1.09 MB (1138688)
  724. - RowsReturned: 1.70M (1703171)
  725. - RowsReturnedRate: 195.91 K/sec
  726. Buffer pool:
  727. - AllocTime: 16.925ms
  728. - CumulativeAllocationBytes: 365.57 MB (383328256)
  729. - CumulativeAllocations: 18.72K (18720)
  730. - PeakReservation: 1.09 MB (1138688)
  731. - PeakUnpinnedBytes: 0
  732. - PeakUsedReservation: 1.09 MB (1138688)
  733. - ReadIoBytes: 0
  734. - ReadIoOps: 0 (0)
  735. - ReadIoWaitTime: 0.000ns
  736. - SystemAllocTime: 1.646ms
  737. - WriteIoBytes: 0
  738. - WriteIoOps: 0 (0)
  739. - WriteIoWaitTime: 0.000ns
  740. Dequeue:
  741. - BytesDequeued (500.000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 29.10 MB, 86.75 MB, 139.44 MB, 162.79 MB, 192.01 MB, 221.27 MB
  742. - FirstBatchWaitTime: 6s669ms
  743. - TotalBytesDequeued: 221.92 MB (232700420)
  744. - TotalGetBatchTime: 8s648ms
  745. - DataWaitTime: 8s624ms
  746. Enqueue:
  747. - BytesReceived (500.000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 12.90 MB, 38.41 MB, 61.74 MB, 72.07 MB, 84.97 MB, 97.90 MB
  748. - DeferredQueueSize (500.000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0
  749. - DispatchTime: (Avg: 26.238us ; Min: 13.959us ; Max: 180.908us ; Number of samples: 9360)
  750. - DeserializeRowBatchTime: 671.705ms
  751. - TotalBatchesEnqueued: 9.36K (9360)
  752. - TotalBatchesReceived: 9.36K (9360)
  753. - TotalBytesReceived: 98.17 MB (102942688)
  754. - TotalEarlySenders: 0 (0)
  755. - TotalEosReceived: 3 (3)
  756. - TotalHasDeferredRPCsTime: 0.000ns
  757. - TotalRPCsDeferred: 0 (0)
  758. CodeGen:(Total: 155.712ms, non-child: 155.712ms, % non-child: 100.00%)
  759. - CodegenInvoluntaryContextSwitches: 0 (0)
  760. - CodegenTotalWallClockTime: 155.700ms
  761. - CodegenSysTime: 3.962ms
  762. - CodegenUserTime: 150.589ms
  763. - CodegenVoluntaryContextSwitches: 0 (0)
  764. - CompileTime: 38.069ms
  765. - IrGenerationTime: 3.796ms
  766. - LoadTime: 0.000ns
  767. - ModuleBitcodeSize: 2.28 MB (2393476)
  768. - NumFunctions: 57 (57)
  769. - NumInstructions: 1.63K (1626)
  770. - OptimizationTime: 88.107ms
  771. - PeakMemoryUsage: 813.00 KB (832512)
  772. - PrepareTime: 24.849ms
  773. Instance 434987288e39baec:45101a3900000005 (host=itchil804.inteliquent.com:22000):(Total: 9s747ms, non-child: 665.820us, % non-child: 0.01%)
  774. Last report received time: 2020-02-11 13:42:01.839
  775. Fragment Instance Lifecycle Event Timeline: 9s748ms
  776. - Prepare Finished: 2.011ms (2.011ms)
  777. - Open Finished: 9s747ms (9s745ms)
  778. - First Batch Produced: 9s747ms (4.810us)
  779. - First Batch Sent: 9s747ms (32.231us)
  780. - ExecInternal Finished: 9s748ms (804.987us)
  781. - MemoryUsage (500.000ms): 137.02 KB, 137.02 KB, 137.02 KB, 137.02 KB, 137.02 KB, 137.02 KB, 137.02 KB, 137.02 KB, 137.02 KB, 137.02 KB, 137.02 KB, 137.02 KB, 137.02 KB, 36.53 MB, 77.15 MB, 135.15 MB, 161.15 MB, 175.15 MB, 187.15 MB
  782. - ThreadUsage (500.000ms): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1
  783. - AverageThreadTokens: 1.00
  784. - BloomFilterBytes: 0
  785. - ExchangeScanRatio: 0.00
  786. - PeakMemoryUsage: 193.15 MB (202531862)
  787. - PeakReservation: 192.00 MB (201326592)
  788. - PeakUsedReservation: 0
  789. - PerHostPeakMemUsage: 2.17 GB (2325567844)
  790. - RowsProduced: 1 (1)
  791. - TotalNetworkReceiveTime: 8s704ms
  792. - TotalNetworkSendTime: 631.237us
  793. - TotalStorageWaitTime: 0.000ns
  794. - TotalThreadsInvoluntaryContextSwitches: 2 (2)
  795. - TotalThreadsTotalWallClockTime: 9s745ms
  796. - TotalThreadsSysTime: 103.776ms
  797. - TotalThreadsUserTime: 1s022ms
  798. - TotalThreadsVoluntaryContextSwitches: 7.24K (7244)
  799. Buffer pool:
  800. - AllocTime: 0.000ns
  801. - CumulativeAllocationBytes: 0
  802. - CumulativeAllocations: 0 (0)
  803. - PeakReservation: 0
  804. - PeakUnpinnedBytes: 0
  805. - PeakUsedReservation: 0
  806. - ReadIoBytes: 0
  807. - ReadIoOps: 0 (0)
  808. - ReadIoWaitTime: 0.000ns
  809. - ReservationLimit: 0
  810. - SystemAllocTime: 0.000ns
  811. - WriteIoBytes: 0
  812. - WriteIoOps: 0 (0)
  813. - WriteIoWaitTime: 0.000ns
  814. Fragment Instance Lifecycle Timings:
  815. - ExecTime: 702.930us
  816. - ExecTreeExecTime: 3.598us
  817. - OpenTime: 9s745ms
  818. - ExecTreeOpenTime: 9s590ms
  819. - PrepareTime: 1.176ms
  820. - ExecTreePrepareTime: 624.957us
  821. KrpcDataStreamSender (dst_id=5):(Total: 825.773us, non-child: 193.994us, % non-child: 23.49%)
  822. ExecOption: Unpartitioned Sender Codegen Disabled: not needed
  823. - BytesSent (500.000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0
  824. - NetworkThroughput: (Avg: 40.17 KB/sec ; Min: 40.17 KB/sec ; Max: 40.17 KB/sec ; Number of samples: 1)
  825. - EosSent: 1 (1)
  826. - PeakMemoryUsage: 16.00 KB (16384)
  827. - RowsSent: 1 (1)
  828. - RpcFailure: 0 (0)
  829. - RpcRetry: 0 (0)
  830. - SerializeBatchTime: 7.636us
  831. - TotalBytesSent: 12.00 B (12)
  832. - UncompressedRowBatchSize: 16.00 B (16)
  833. AGGREGATION_NODE (id=2):(Total: 9s590ms, non-child: 1.160ms, % non-child: 0.01%)
  834. Node Lifecycle Event Timeline: 9s747ms
  835. - Open Started: 157.101ms (157.101ms)
  836. - Open Finished: 9s747ms (9s590ms)
  837. - First Batch Requested: 9s747ms (22.844us)
  838. - First Batch Returned: 9s747ms (1.905us)
  839. - Last Batch Returned: 9s747ms (118.000ns)
  840. - Closed: 9s747ms (734.099us)
  841. - PeakMemoryUsage: 16.00 KB (16384)
  842. - RowsReturned: 1 (1)
  843. - RowsReturnedRate: 0
  844. NonGroupingAggregator 0:
  845. ExecOption: Codegen Enabled
  846. - BuildTime: 623.687us
  847. - PeakMemoryUsage: 8.00 KB (8192)
  848. - RowsReturned: 1 (1)
  849. AGGREGATION_NODE (id=4):(Total: 9s589ms, non-child: 845.825ms, % non-child: 8.82%)
  850. Node Lifecycle Event Timeline: 9s747ms
  851. - Open Started: 157.102ms (157.102ms)
  852. - Open Finished: 9s713ms (9s556ms)
  853. - First Batch Requested: 9s713ms (11.429us)
  854. - First Batch Returned: 9s713ms (56.535us)
  855. - Last Batch Returned: 9s747ms (33.773ms)
  856. - Closed: 9s747ms (120.131us)
  857. - PeakMemoryUsage: 192.11 MB (201441408)
  858. - RowsReturned: 1.15M (1152636)
  859. - RowsReturnedRate: 120.20 K/sec
  860. GroupingAggregator 0:
  861. ExecOption: Codegen Enabled
  862. - BuildTime: 806.089ms
  863. - GetResultsTime: 32.459ms
  864. - HTResizeTime: 50.989ms
  865. - HashBuckets: 2.10M (2097152)
  866. - LargestPartitionPercent: 4 (4)
  867. - MaxPartitionLevel: 0 (0)
  868. - NumRepartitions: 0 (0)
  869. - PartitionsCreated: 16 (16)
  870. - PeakMemoryUsage: 192.11 MB (201437312)
  871. - PeakReservation: 192.00 MB (201326592)
  872. - PeakUsedReservation: 0
  873. - RowsRepartitioned: 0 (0)
  874. - RowsReturned: 1.15M (1152636)
  875. - SpilledPartitions: 0 (0)
  876. Buffer pool:
  877. - AllocTime: 27.779ms
  878. - CumulativeAllocationBytes: 208.00 MB (218103808)
  879. - CumulativeAllocations: 104 (104)
  880. - PeakReservation: 192.00 MB (201326592)
  881. - PeakUnpinnedBytes: 0
  882. - PeakUsedReservation: 192.00 MB (201326592)
  883. - ReadIoBytes: 0
  884. - ReadIoOps: 0 (0)
  885. - ReadIoWaitTime: 0.000ns
  886. - SystemAllocTime: 27.619ms
  887. - WriteIoBytes: 0
  888. - WriteIoOps: 0 (0)
  889. - WriteIoWaitTime: 0.000ns
  890. EXCHANGE_NODE (id=3):(Total: 8s743ms, non-child: 65.924ms, % non-child: 0.75%)
  891. Node Lifecycle Event Timeline: 9s713ms
  892. - Open Started: 157.103ms (157.103ms)
  893. - Open Finished: 6s829ms (6s672ms)
  894. - First Batch Requested: 6s830ms (784.435us)
  895. - First Batch Returned: 6s832ms (1.924ms)
  896. - Last Batch Returned: 9s712ms (2s880ms)
  897. - Closed: 9s713ms (505.500us)
  898. - ConvertRowBatchTime: 31.041ms
  899. - PeakMemoryUsage: 1.01 MB (1056768)
  900. - RowsReturned: 1.70M (1701728)
  901. - RowsReturnedRate: 194.62 K/sec
  902. Buffer pool:
  903. - AllocTime: 19.958ms
  904. - CumulativeAllocationBytes: 365.25 MB (382992384)
  905. - CumulativeAllocations: 18.70K (18702)
  906. - PeakReservation: 1.01 MB (1056768)
  907. - PeakUnpinnedBytes: 0
  908. - PeakUsedReservation: 1.01 MB (1056768)
  909. - ReadIoBytes: 0
  910. - ReadIoOps: 0 (0)
  911. - ReadIoWaitTime: 0.000ns
  912. - SystemAllocTime: 3.997ms
  913. - WriteIoBytes: 0
  914. - WriteIoOps: 0 (0)
  915. - WriteIoWaitTime: 0.000ns
  916. Dequeue:
  917. - BytesDequeued (500.000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5.05 MB, 56.44 MB, 114.14 MB, 147.32 MB, 176.53 MB, 206.10 MB
  918. - FirstBatchWaitTime: 6s672ms
  919. - TotalBytesDequeued: 221.73 MB (232499480)
  920. - TotalGetBatchTime: 8s701ms
  921. - DataWaitTime: 8s677ms
  922. Enqueue:
  923. - BytesReceived (500.000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2.24 MB, 25.01 MB, 50.53 MB, 65.23 MB, 78.12 MB, 91.18 MB
  924. - DeferredQueueSize (500.000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0
  925. - DispatchTime: (Avg: 24.631us ; Min: 8.775us ; Max: 219.984us ; Number of samples: 9351)
  926. - DeserializeRowBatchTime: 683.958ms
  927. - TotalBatchesEnqueued: 9.35K (9351)
  928. - TotalBatchesReceived: 9.35K (9351)
  929. - TotalBytesReceived: 98.08 MB (102848549)
  930. - TotalEarlySenders: 0 (0)
  931. - TotalEosReceived: 3 (3)
  932. - TotalHasDeferredRPCsTime: 0.000ns
  933. - TotalRPCsDeferred: 0 (0)
  934. CodeGen:(Total: 154.949ms, non-child: 154.949ms, % non-child: 100.00%)
  935. - CodegenInvoluntaryContextSwitches: 0 (0)
  936. - CodegenTotalWallClockTime: 154.939ms
  937. - CodegenSysTime: 7.594ms
  938. - CodegenUserTime: 148.226ms
  939. - CodegenVoluntaryContextSwitches: 0 (0)
  940. - CompileTime: 38.064ms
  941. - IrGenerationTime: 3.264ms
  942. - LoadTime: 0.000ns
  943. - ModuleBitcodeSize: 2.28 MB (2393476)
  944. - NumFunctions: 57 (57)
  945. - NumInstructions: 1.63K (1626)
  946. - OptimizationTime: 87.573ms
  947. - PeakMemoryUsage: 813.00 KB (832512)
  948. - PrepareTime: 25.098ms
  949. Instance 434987288e39baec:45101a3900000004 (host=itchil806.inteliquent.com:22000):(Total: 9s745ms, non-child: 889.784us, % non-child: 0.01%)
  950. Last report received time: 2020-02-11 13:42:01.579
  951. Fragment Instance Lifecycle Event Timeline: 9s746ms
  952. - Prepare Finished: 2.025ms (2.025ms)
  953. - Open Finished: 9s745ms (9s743ms)
  954. - First Batch Produced: 9s745ms (4.893us)
  955. - First Batch Sent: 9s745ms (33.456us)
  956. - ExecInternal Finished: 9s746ms (1.333ms)
  957. - MemoryUsage (500.000ms): 137.02 KB, 137.02 KB, 137.02 KB, 137.02 KB, 137.02 KB, 137.02 KB, 137.02 KB, 137.02 KB, 137.02 KB, 137.02 KB, 137.02 KB, 137.02 KB, 137.02 KB, 137.02 KB, 52.61 MB, 106.84 MB, 160.95 MB, 164.95 MB, 182.95 MB, 108.15 MB
  958. - ThreadUsage (500.000ms): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1
  959. - AverageThreadTokens: 1.00
  960. - BloomFilterBytes: 0
  961. - ExchangeScanRatio: 0.00
  962. - PeakMemoryUsage: 192.95 MB (202327062)
  963. - PeakReservation: 192.00 MB (201326592)
  964. - PeakUsedReservation: 0
  965. - PerHostPeakMemUsage: 1.92 GB (2058856884)
  966. - RowsProduced: 1 (1)
  967. - TotalNetworkReceiveTime: 8s584ms
  968. - TotalNetworkSendTime: 917.335us
  969. - TotalStorageWaitTime: 0.000ns
  970. - TotalThreadsInvoluntaryContextSwitches: 2 (2)
  971. - TotalThreadsTotalWallClockTime: 9s744ms
  972. - TotalThreadsSysTime: 81.660ms
  973. - TotalThreadsUserTime: 1s175ms
  974. - TotalThreadsVoluntaryContextSwitches: 6.67K (6665)
  975. Buffer pool:
  976. - AllocTime: 0.000ns
  977. - CumulativeAllocationBytes: 0
  978. - CumulativeAllocations: 0 (0)
  979. - PeakReservation: 0
  980. - PeakUnpinnedBytes: 0
  981. - PeakUsedReservation: 0
  982. - ReadIoBytes: 0
  983. - ReadIoOps: 0 (0)
  984. - ReadIoWaitTime: 0.000ns
  985. - ReservationLimit: 0
  986. - SystemAllocTime: 0.000ns
  987. - WriteIoBytes: 0
  988. - WriteIoOps: 0 (0)
  989. - WriteIoWaitTime: 0.000ns
  990. Fragment Instance Lifecycle Timings:
  991. - ExecTime: 980.205us
  992. - ExecTreeExecTime: 3.542us
  993. - OpenTime: 9s743ms
  994. - ExecTreeOpenTime: 9s584ms
  995. - PrepareTime: 1.404ms
  996. - ExecTreePrepareTime: 777.217us
  997. KrpcDataStreamSender (dst_id=5):(Total: 1.026ms, non-child: 108.027us, % non-child: 10.53%)
  998. ExecOption: Unpartitioned Sender Codegen Disabled: not needed
  999. - BytesSent (500.000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0
  1000. - NetworkThroughput: (Avg: 24.21 KB/sec ; Min: 24.21 KB/sec ; Max: 24.21 KB/sec ; Number of samples: 1)
  1001. - EosSent: 1 (1)
  1002. - PeakMemoryUsage: 16.00 KB (16384)
  1003. - RowsSent: 1 (1)
  1004. - RpcFailure: 0 (0)
  1005. - RpcRetry: 0 (0)
  1006. - SerializeBatchTime: 8.096us
  1007. - TotalBytesSent: 12.00 B (12)
  1008. - UncompressedRowBatchSize: 16.00 B (16)
  1009. AGGREGATION_NODE (id=2):(Total: 9s585ms, non-child: 1.136ms, % non-child: 0.01%)
  1010. Node Lifecycle Event Timeline: 9s746ms
  1011. - Open Started: 160.531ms (160.531ms)
  1012. - Open Finished: 9s745ms (9s584ms)
  1013. - First Batch Requested: 9s745ms (22.466us)
  1014. - First Batch Returned: 9s745ms (2.236us)
  1015. - Last Batch Returned: 9s745ms (289.000ns)
  1016. - Closed: 9s746ms (997.955us)
  1017. - PeakMemoryUsage: 16.00 KB (16384)
  1018. - RowsReturned: 1 (1)
  1019. - RowsReturnedRate: 0
  1020. NonGroupingAggregator 0:
  1021. ExecOption: Codegen Enabled
  1022. - BuildTime: 651.117us
  1023. - PeakMemoryUsage: 8.00 KB (8192)
  1024. - RowsReturned: 1 (1)
  1025. AGGREGATION_NODE (id=4):(Total: 9s584ms, non-child: 954.214ms, % non-child: 9.96%)
  1026. Node Lifecycle Event Timeline: 9s745ms
  1027. - Open Started: 160.532ms (160.532ms)
  1028. - Open Finished: 9s710ms (9s550ms)
  1029. - First Batch Requested: 9s710ms (15.557us)
  1030. - First Batch Returned: 9s710ms (78.560us)
  1031. - Last Batch Returned: 9s745ms (34.804ms)
  1032. - Closed: 9s745ms (55.318us)
  1033. - PeakMemoryUsage: 192.11 MB (201441408)
  1034. - RowsReturned: 1.15M (1151702)
  1035. - RowsReturnedRate: 120.16 K/sec
  1036. GroupingAggregator 0:
  1037. ExecOption: Codegen Enabled
  1038. - BuildTime: 912.992ms
  1039. - GetResultsTime: 33.529ms
  1040. - HTResizeTime: 61.362ms
  1041. - HashBuckets: 2.10M (2097152)
  1042. - LargestPartitionPercent: 4 (4)
  1043. - MaxPartitionLevel: 0 (0)
  1044. - NumRepartitions: 0 (0)
  1045. - PartitionsCreated: 16 (16)
  1046. - PeakMemoryUsage: 192.11 MB (201437312)
  1047. - PeakReservation: 192.00 MB (201326592)
  1048. - PeakUsedReservation: 0
  1049. - RowsRepartitioned: 0 (0)
  1050. - RowsReturned: 1.15M (1151702)
  1051. - SpilledPartitions: 0 (0)
  1052. Buffer pool:
  1053. - AllocTime: 18.572ms
  1054. - CumulativeAllocationBytes: 208.00 MB (218103808)
  1055. - CumulativeAllocations: 104 (104)
  1056. - PeakReservation: 192.00 MB (201326592)
  1057. - PeakUnpinnedBytes: 0
  1058. - PeakUsedReservation: 192.00 MB (201326592)
  1059. - ReadIoBytes: 0
  1060. - ReadIoOps: 0 (0)
  1061. - ReadIoWaitTime: 0.000ns
  1062. - SystemAllocTime: 18.414ms
  1063. - WriteIoBytes: 0
  1064. - WriteIoOps: 0 (0)
  1065. - WriteIoWaitTime: 0.000ns
  1066. EXCHANGE_NODE (id=3):(Total: 8s630ms, non-child: 71.785ms, % non-child: 0.83%)
  1067. Node Lifecycle Event Timeline: 9s710ms
  1068. - Open Started: 160.533ms (160.533ms)
  1069. - Open Finished: 6s827ms (6s667ms)
  1070. - First Batch Requested: 6s828ms (809.173us)
  1071. - First Batch Returned: 6s830ms (1.902ms)
  1072. - Last Batch Returned: 9s710ms (2s879ms)
  1073. - Closed: 9s710ms (382.620us)
  1074. - ConvertRowBatchTime: 36.872ms
  1075. - PeakMemoryUsage: 832.00 KB (851968)
  1076. - RowsReturned: 1.70M (1701332)
  1077. - RowsReturnedRate: 197.13 K/sec
  1078. Buffer pool:
  1079. - AllocTime: 16.852ms
  1080. - CumulativeAllocationBytes: 365.16 MB (382902272)
  1081. - CumulativeAllocations: 18.70K (18698)
  1082. - PeakReservation: 832.00 KB (851968)
  1083. - PeakUnpinnedBytes: 0
  1084. - PeakUsedReservation: 832.00 KB (851968)
  1085. - ReadIoBytes: 0
  1086. - ReadIoOps: 0 (0)
  1087. - ReadIoWaitTime: 0.000ns
  1088. - SystemAllocTime: 1.509ms
  1089. - WriteIoBytes: 0
  1090. - WriteIoOps: 0 (0)
  1091. - WriteIoWaitTime: 0.000ns
  1092. Dequeue:
  1093. - BytesDequeued (500.000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 32.53 MB, 90.11 MB, 139.33 MB, 164.42 MB, 193.59 MB
  1094. - FirstBatchWaitTime: 6s667ms
  1095. - TotalBytesDequeued: 221.67 MB (232442744)
  1096. - TotalGetBatchTime: 8s581ms
  1097. - DataWaitTime: 8s558ms
  1098. Enqueue:
  1099. - BytesReceived (500.000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 14.41 MB, 39.90 MB, 61.69 MB, 72.77 MB, 85.66 MB
  1100. - DeferredQueueSize (500.000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0
  1101. - DispatchTime: (Avg: 28.844us ; Min: 10.155us ; Max: 301.511us ; Number of samples: 9349)
  1102. - DeserializeRowBatchTime: 658.267ms
  1103. - TotalBatchesEnqueued: 9.35K (9349)
  1104. - TotalBatchesReceived: 9.35K (9349)
  1105. - TotalBytesReceived: 98.06 MB (102825929)
  1106. - TotalEarlySenders: 0 (0)
  1107. - TotalEosReceived: 3 (3)
  1108. - TotalHasDeferredRPCsTime: 0.000ns
  1109. - TotalRPCsDeferred: 0 (0)
  1110. CodeGen:(Total: 158.322ms, non-child: 158.322ms, % non-child: 100.00%)
  1111. - CodegenInvoluntaryContextSwitches: 0 (0)
  1112. - CodegenTotalWallClockTime: 158.309ms
  1113. - CodegenSysTime: 0.000ns
  1114. - CodegenUserTime: 159.543ms
  1115. - CodegenVoluntaryContextSwitches: 0 (0)
  1116. - CompileTime: 37.953ms
  1117. - IrGenerationTime: 3.923ms
  1118. - LoadTime: 0.000ns
  1119. - ModuleBitcodeSize: 2.28 MB (2393476)
  1120. - NumFunctions: 57 (57)
  1121. - NumInstructions: 1.63K (1626)
  1122. - OptimizationTime: 88.991ms
  1123. - PeakMemoryUsage: 813.00 KB (832512)
  1124. - PrepareTime: 26.689ms
  1125. Averaged Fragment F00:(Total: 8s670ms, non-child: 1.908ms, % non-child: 0.02%)
  1126. split sizes: min: 4.61 GB, max: 5.26 GB, avg: 4.83 GB, stddev: 311.98 MB
  1127. completion times: min:9s750ms max:10s012ms mean: 9s838ms stddev:123.069ms
  1128. execution rates: min:484.12 MB/sec max:537.61 MB/sec mean:501.96 MB/sec stddev:25.21 MB/sec
  1129. num instances: 3
  1130. - AverageThreadTokens: 10.71
  1131. - BloomFilterBytes: 0
  1132. - ExchangeScanRatio: 0.07
  1133. - PeakMemoryUsage: 1.99 GB (2140482836)
  1134. - PeakReservation: 1.92 GB (2061849941)
  1135. - PeakUsedReservation: 0
  1136. - PerHostPeakMemUsage: 2.03 GB (2176278826)
  1137. - RowsProduced: 1.70M (1702077)
  1138. - TotalNetworkReceiveTime: 0.000ns
  1139. - TotalNetworkSendTime: 13.343ms
  1140. - TotalStorageWaitTime: 8s959ms
  1141. - TotalThreadsInvoluntaryContextSwitches: 64 (64)
  1142. - TotalThreadsTotalWallClockTime: 1m33s
  1143. - TotalThreadsSysTime: 900.711ms
  1144. - TotalThreadsUserTime: 23s920ms
  1145. - TotalThreadsVoluntaryContextSwitches: 19.38K (19379)
  1146. Buffer pool:
  1147. - AllocTime: 0.000ns
  1148. - CumulativeAllocationBytes: 0
  1149. - CumulativeAllocations: 0 (0)
  1150. - PeakReservation: 0
  1151. - PeakUnpinnedBytes: 0
  1152. - PeakUsedReservation: 0
  1153. - ReadIoBytes: 0
  1154. - ReadIoOps: 0 (0)
  1155. - ReadIoWaitTime: 0.000ns
  1156. - ReservationLimit: 0
  1157. - SystemAllocTime: 0.000ns
  1158. - WriteIoBytes: 0
  1159. - WriteIoOps: 0 (0)
  1160. - WriteIoWaitTime: 0.000ns
  1161. Fragment Instance Lifecycle Timings:
  1162. - ExecTime: 8s360ms
  1163. - ExecTreeExecTime: 7s119ms
  1164. - OpenTime: 306.424ms
  1165. - ExecTreeOpenTime: 495.525us
  1166. - PrepareTime: 3.356ms
  1167. - ExecTreePrepareTime: 2.605ms
  1168. KrpcDataStreamSender (dst_id=3):(Total: 1s240ms, non-child: 1s240ms, % non-child: 100.00%)
  1169. - EosSent: 3 (3)
  1170. - PeakMemoryUsage: 88.27 KB (90384)
  1171. - RowsSent: 1.70M (1702077)
  1172. - RpcFailure: 0 (0)
  1173. - RpcRetry: 0 (0)
  1174. - SerializeBatchTime: 678.173ms
  1175. - TotalBytesSent: 98.11 MB (102872388)
  1176. - UncompressedRowBatchSize: 221.77 MB (232547548)
  1177. AGGREGATION_NODE (id=1):(Total: 7s121ms, non-child: 6s900ms, % non-child: 96.89%)
  1178. - PeakMemoryUsage: 279.09 MB (292651914)
  1179. - RowsReturned: 1.70M (1702077)
  1180. - RowsReturnedRate: 239.38 K/sec
  1181. GroupingAggregator 0:
  1182. - BuildTime: 0.000ns
  1183. - GetResultsTime: 47.917ms
  1184. - HTResizeTime: 73.215ms
  1185. - HashBuckets: 3.50M (3495253)
  1186. - LargestPartitionPercent: 0 (0)
  1187. - PartitionsCreated: 16 (16)
  1188. - PeakMemoryUsage: 277.44 MB (290911701)
  1189. - PeakReservation: 277.33 MB (290805077)
  1190. - PeakUsedReservation: 0
  1191. - ReductionFactorEstimate: 7.70
  1192. - ReductionFactorThresholdToExpand: 2.00
  1193. - RowsPassedThrough: 0 (0)
  1194. - RowsReturned: 1.70M (1702077)
  1195. - StreamingTime: 6s336ms
  1196. Buffer pool:
  1197. - AllocTime: 14.013ms
  1198. - CumulativeAllocationBytes: 316.67 MB (332049066)
  1199. - CumulativeAllocations: 147 (147)
  1200. - PeakReservation: 277.33 MB (290805077)
  1201. - PeakUnpinnedBytes: 0
  1202. - PeakUsedReservation: 277.33 MB (290805077)
  1203. - ReadIoBytes: 0
  1204. - ReadIoOps: 0 (0)
  1205. - ReadIoWaitTime: 0.000ns
  1206. - SystemAllocTime: 13.854ms
  1207. - WriteIoBytes: 0
  1208. - WriteIoOps: 0 (0)
  1209. - WriteIoWaitTime: 0.000ns
  1210. HDFS_SCAN_NODE (id=0):(Total: 221.143ms, non-child: 221.143ms, % non-child: 100.00%)
  1211. - AverageHdfsReadThreadConcurrency: 0.49
  1212. - AverageScannerThreadConcurrency: 11.78
  1213. - BytesRead: 1.36 GB (1461832134)
  1214. - BytesReadDataNodeCache: 0
  1215. - BytesReadLocal: 1.36 GB (1461832134)
  1216. - BytesReadRemoteUnexpected: 0
  1217. - BytesReadShortCircuit: 1.36 GB (1461832134)
  1218. - CachedFileHandlesHitCount: 1.04K (1038)
  1219. - CachedFileHandlesMissCount: 138 (138)
  1220. - CollectionItemsRead: 0 (0)
  1221. - DataCacheHitBytes: 0
  1222. - DataCacheHitCount: 0 (0)
  1223. - DataCacheMissBytes: 0
  1224. - DataCacheMissCount: 0 (0)
  1225. - DataCachePartialHitCount: 0 (0)
  1226. - DecompressionTime: 975.586ms
  1227. - MaterializeTupleTime(*): 14s357ms
  1228. - MaxCompressedTextFileLength: 0
  1229. - NumColumns: 8 (8)
  1230. - NumDictFilteredRowGroups: 30 (30)
  1231. - NumDisksAccessed: 8 (8)
  1232. - NumRowGroups: 163 (163)
  1233. - NumScannerThreadMemUnavailable: 0 (0)
  1234. - NumScannerThreadReservationsDenied: 0 (0)
  1235. - NumScannerThreadsStarted: 31 (31)
  1236. - NumScannersWithNoReads: 0 (0)
  1237. - NumStatsFilteredRowGroups: 23 (23)
  1238. - PeakMemoryUsage: 1.90 GB (2045374139)
  1239. - PeakScannerThreadConcurrency: 31 (31)
  1240. - PerReadThreadRawHdfsThroughput: 478.41 MB/sec
  1241. - RemoteScanRanges: 0 (0)
  1242. - RowBatchBytesEnqueued: 13.42 GB (14410423370)
  1243. - RowBatchQueueGetWaitTime: 124.121ms
  1244. - RowBatchQueuePeakMemoryUsage: 37.14 MB (38945348)
  1245. - RowBatchQueuePutWaitTime: 59s334ms
  1246. - RowBatchesEnqueued: 17.98K (17976)
  1247. - RowsRead: 173.34M (173336970)
  1248. - RowsReturned: 18.01M (18014920)
  1249. - RowsReturnedRate: 87.52 M/sec
  1250. - ScanRangesComplete: 160 (160)
  1251. - ScannerIoWaitTime: 8s959ms
  1252. - ScannerThreadWorklessLoops: 0 (0)
  1253. - ScannerThreadsInvoluntaryContextSwitches: 54 (54)
  1254. - ScannerThreadsTotalWallClockTime: 1m24s
  1255. - ScannerThreadsSysTime: 336.371ms
  1256. - ScannerThreadsUserTime: 15s955ms
  1257. - ScannerThreadsVoluntaryContextSwitches: 18.62K (18617)
  1258. - TotalRawHdfsOpenFileTime(*): 299.732ms
  1259. - TotalRawHdfsReadTime(*): 3s359ms
  1260. - TotalReadThroughput: 189.96 MB/sec
  1261. Buffer pool:
  1262. - AllocTime: 47.276ms
  1263. - CumulativeAllocationBytes: 1.34 GB (1439490048)
  1264. - CumulativeAllocations: 1.14K (1141)
  1265. - PeakReservation: 1.83 GB (1967478101)
  1266. - PeakUnpinnedBytes: 0
  1267. - PeakUsedReservation: 1.25 GB (1345410389)
  1268. - ReadIoBytes: 0
  1269. - ReadIoOps: 0 (0)
  1270. - ReadIoWaitTime: 0.000ns
  1271. - SystemAllocTime: 45.536ms
  1272. - WriteIoBytes: 0
  1273. - WriteIoOps: 0 (0)
  1274. - WriteIoWaitTime: 0.000ns
  1275. CodeGen:(Total: 305.784ms, non-child: 305.784ms, % non-child: 100.00%)
  1276. - CodegenInvoluntaryContextSwitches: 1 (1)
  1277. - CodegenTotalWallClockTime: 305.772ms
  1278. - CodegenSysTime: 4.551ms
  1279. - CodegenUserTime: 300.508ms
  1280. - CodegenVoluntaryContextSwitches: 0 (0)
  1281. - CompileTime: 86.383ms
  1282. - IrGenerationTime: 6.873ms
  1283. - LoadTime: 0.000ns
  1284. - ModuleBitcodeSize: 2.28 MB (2393476)
  1285. - NumFunctions: 102 (102)
  1286. - NumInstructions: 3.39K (3387)
  1287. - OptimizationTime: 186.402ms
  1288. - PeakMemoryUsage: 1.65 MB (1734144)
  1289. - PrepareTime: 25.121ms
  1290. Fragment F00:
  1291. Instance 434987288e39baec:45101a3900000002 (host=itchil804.inteliquent.com:22000):(Total: 9s712ms, non-child: 1.949ms, % non-child: 0.02%)
  1292. Last report received time: 2020-02-11 13:42:01.839
  1293. Hdfs split stats (<volume id>:<# splits>/<split lengths>): 2:27/93.28 MB 7:25/743.47 MB 3:22/1.39 GB 4:25/209.13 MB 6:30/463.04 MB 5:28/281.73 MB 0:26/1.03 GB 1:28/1.09 GB
  1294. Fragment Instance Lifecycle Event Timeline: 9s713ms
  1295. - Prepare Finished: 5.040ms (5.040ms)
  1296. - Open Finished: 304.795ms (299.754ms)
  1297. - First Batch Produced: 8s302ms (7s997ms)
  1298. - First Batch Sent: 8s302ms (3.281us)
  1299. - ExecInternal Finished: 9s713ms (1s411ms)
  1300. - MemoryUsage (500.000ms): 1.64 GB, 1.72 GB, 1.97 GB, 2.03 GB, 1.74 GB, 1.60 GB, 1.48 GB, 1.48 GB, 1.51 GB, 1.37 GB, 1.30 GB, 1.34 GB, 1.11 GB, 1.11 GB, 865.51 MB, 508.31 MB, 300.17 MB, 180.18 MB, 80.21 MB
  1301. - ThreadUsage (500.000ms): 32, 32, 32, 32, 19, 15, 11, 11, 11, 9, 8, 8, 6, 6, 4, 2, 1, 1, 1
  1302. - AverageThreadTokens: 12.68
  1303. - BloomFilterBytes: 0
  1304. - ExchangeScanRatio: 0.07
  1305. - PeakMemoryUsage: 2.13 GB (2289763662)
  1306. - PeakReservation: 2.06 GB (2208301056)
  1307. - PeakUsedReservation: 0
  1308. - PerHostPeakMemUsage: 2.17 GB (2325567844)
  1309. - RowsProduced: 1.90M (1897875)
  1310. - TotalNetworkReceiveTime: 0.000ns
  1311. - TotalNetworkSendTime: 19.912ms
  1312. - TotalStorageWaitTime: 15s211ms
  1313. - TotalThreadsInvoluntaryContextSwitches: 89 (89)
  1314. - TotalThreadsTotalWallClockTime: 1m56s
  1315. - TotalThreadsSysTime: 1s102ms
  1316. - TotalThreadsUserTime: 27s837ms
  1317. - TotalThreadsVoluntaryContextSwitches: 22.23K (22229)
  1318. Buffer pool:
  1319. - AllocTime: 0.000ns
  1320. - CumulativeAllocationBytes: 0
  1321. - CumulativeAllocations: 0 (0)
  1322. - PeakReservation: 0
  1323. - PeakUnpinnedBytes: 0
  1324. - PeakUsedReservation: 0
  1325. - ReadIoBytes: 0
  1326. - ReadIoOps: 0 (0)
  1327. - ReadIoWaitTime: 0.000ns
  1328. - ReservationLimit: 0
  1329. - SystemAllocTime: 0.000ns
  1330. - WriteIoBytes: 0
  1331. - WriteIoOps: 0 (0)
  1332. - WriteIoWaitTime: 0.000ns
  1333. Fragment Instance Lifecycle Timings:
  1334. - ExecTime: 9s408ms
  1335. - ExecTreeExecTime: 8s054ms
  1336. - OpenTime: 299.752ms
  1337. - ExecTreeOpenTime: 470.708us
  1338. - PrepareTime: 3.932ms
  1339. - ExecTreePrepareTime: 3.153ms
  1340. KrpcDataStreamSender (dst_id=3):(Total: 1s354ms, non-child: 1s333ms, % non-child: 98.46%)
  1341. ExecOption: Hash Partitioned Sender Codegen Enabled
  1342. - BytesSent (500.000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 10.66 MB, 49.34 MB, 88.50 MB
  1343. - NetworkThroughput: (Avg: 62.29 MB/sec ; Min: 11.34 MB/sec ; Max: 119.52 MB/sec ; Number of samples: 10429)
  1344. - EosSent: 3 (3)
  1345. - PeakMemoryUsage: 88.27 KB (90384)
  1346. - RowsSent: 1.90M (1897875)
  1347. - RpcFailure: 0 (0)
  1348. - RpcRetry: 0 (0)
  1349. - SerializeBatchTime: 751.840ms
  1350. - TotalBytesSent: 109.23 MB (114535422)
  1351. - UncompressedRowBatchSize: 247.27 MB (259285196)
  1352. AGGREGATION_NODE (id=1):(Total: 8s057ms, non-child: 7s759ms, % non-child: 96.31%)
  1353. Node Lifecycle Event Timeline: 9s713ms
  1354. - Open Started: 304.313ms (304.313ms)
  1355. - Open Finished: 304.779ms (466.185us)
  1356. - First Batch Requested: 304.796ms (16.811us)
  1357. - First Batch Returned: 8s302ms (7s997ms)
  1358. - Last Batch Returned: 9s711ms (1s409ms)
  1359. - Closed: 9s713ms (2.089ms)
  1360. - PeakMemoryUsage: 321.54 MB (337162282)
  1361. - RowsReturned: 1.90M (1897875)
  1362. - RowsReturnedRate: 235.55 K/sec
  1363. GroupingAggregator 0:
  1364. ExecOption: Streaming Preaggregation, Codegen Enabled
  1365. - BuildTime: 0.000ns
  1366. - GetResultsTime: 55.603ms
  1367. - HTResizeTime: 97.615ms
  1368. - HashBuckets: 4.19M (4194304)
  1369. - LargestPartitionPercent: 0 (0)
  1370. - PartitionsCreated: 16 (16)
  1371. - PeakMemoryUsage: 320.10 MB (335650944)
  1372. - PeakReservation: 320.00 MB (335544320)
  1373. - PeakUsedReservation: 0
  1374. - ReductionFactorEstimate: 8.35
  1375. - ReductionFactorThresholdToExpand: 2.00
  1376. - RowsPassedThrough: 0 (0)
  1377. - RowsReturned: 1.90M (1897875)
  1378. - StreamingTime: 7s112ms
  1379. Buffer pool:
  1380. - AllocTime: 15.506ms
  1381. - CumulativeAllocationBytes: 370.00 MB (387973120)
  1382. - CumulativeAllocations: 169 (169)
  1383. - PeakReservation: 320.00 MB (335544320)
  1384. - PeakUnpinnedBytes: 0
  1385. - PeakUsedReservation: 320.00 MB (335544320)
  1386. - ReadIoBytes: 0
  1387. - ReadIoOps: 0 (0)
  1388. - ReadIoWaitTime: 0.000ns
  1389. - SystemAllocTime: 15.316ms
  1390. - WriteIoBytes: 0
  1391. - WriteIoOps: 0 (0)
  1392. - WriteIoWaitTime: 0.000ns
  1393. HDFS_SCAN_NODE (id=0):(Total: 297.334ms, non-child: 297.334ms, % non-child: 100.00%)
  1394. Hdfs split stats (<volume id>:<# splits>/<split lengths>): 2:27/93.28 MB 7:25/743.47 MB 3:22/1.39 GB 4:25/209.13 MB 6:30/463.04 MB 5:28/281.73 MB 0:26/1.03 GB 1:28/1.09 GB
  1395. ExecOption: PARQUET Codegen Enabled, Codegen enabled: 211 out of 211
  1396. Hdfs Read Thread Concurrency Bucket: 0:75% 1:0% 2:18.75% 3:0% 4:0% 5:6.25% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 14:0%
  1397. File Formats: PARQUET/NONE:28 PARQUET/SNAPPY:183
  1398. Node Lifecycle Event Timeline: 8s302ms
  1399. - Open Started: 304.316ms (304.316ms)
  1400. - Open Finished: 304.466ms (149.783us)
  1401. - First Batch Requested: 304.798ms (332.430us)
  1402. - First Batch Returned: 328.473ms (23.675ms)
  1403. - Last Batch Returned: 8s302ms (7s973ms)
  1404. - Closed: 8s302ms (366.206us)
  1405. - BytesRead (500.000ms): 206.54 MB, 724.60 MB, 996.93 MB, 1.21 GB, 1.33 GB, 1.33 GB, 1.33 GB, 1.33 GB, 1.36 GB, 1.40 GB, 1.41 GB, 1.42 GB, 1.43 GB, 1.46 GB, 1.47 GB, 1.48 GB
  1406. - FooterProcessingTime: (Avg: 34.210ms ; Min: 668.107us ; Max: 525.336ms ; Number of samples: 211)
  1407. - InitialRangeActualReservation: (Avg: 32.00 MB (33554432) ; Min: 32.00 MB (33554432) ; Max: 32.00 MB (33554432) ; Number of samples: 211)
  1408. - InitialRangeIdealReservation: (Avg: 71.81 KB (73533) ; Min: 8.00 KB (8192) ; Max: 128.00 KB (131072) ; Number of samples: 211)
  1409. - ParquetCompressedBytesReadPerColumn: (Avg: 187.35 MB (196448795) ; Min: 45.50 MB (47712830) ; Max: 278.76 MB (292300027) ; Number of samples: 8)
  1410. - ParquetCompressedPageSize: (Avg: 99.91 KB (102310) ; Min: 10.00 B (10) ; Max: 192.31 KB (196924) ; Number of samples: 15361)
  1411. - ParquetRowGroupActualReservation: (Avg: 41.36 MB (43370888) ; Min: 32.00 MB (33554432) ; Max: 184.00 MB (192937984) ; Number of samples: 188)
  1412. - ParquetRowGroupIdealReservation: (Avg: 9.07 MB (9513395) ; Min: 64.00 KB (65536) ; Max: 184.00 MB (192937984) ; Number of samples: 188)
  1413. - ParquetUncompressedBytesReadPerColumn: (Avg: 189.69 MB (198903044) ; Min: 45.49 MB (47695936) ; Max: 283.66 MB (297439301) ; Number of samples: 8)
  1414. - ParquetUncompressedPageSize: (Avg: 101.16 KB (103588) ; Min: 8.00 B (8) ; Max: 192.28 KB (196890) ; Number of samples: 15361)
  1415. - AverageHdfsReadThreadConcurrency: 0.69
  1416. - AverageScannerThreadConcurrency: 13.88
  1417. - BytesRead: 1.48 GB (1589431105)
  1418. - BytesReadDataNodeCache: 0
  1419. - BytesReadLocal: 1.48 GB (1589431105)
  1420. - BytesReadRemoteUnexpected: 0
  1421. - BytesReadShortCircuit: 1.48 GB (1589431105)
  1422. - CachedFileHandlesHitCount: 1.35K (1352)
  1423. - CachedFileHandlesMissCount: 196 (196)
  1424. - CollectionItemsRead: 0 (0)
  1425. - DataCacheHitBytes: 0
  1426. - DataCacheHitCount: 0 (0)
  1427. - DataCacheMissBytes: 0
  1428. - DataCacheMissCount: 0 (0)
  1429. - DataCachePartialHitCount: 0 (0)
  1430. - DecompressionTime: 1s210ms
  1431. - MaterializeTupleTime(*): 17s043ms
  1432. - MaxCompressedTextFileLength: 0
  1433. - NumColumns: 8 (8)
  1434. - NumDictFilteredRowGroups: 40 (40)
  1435. - NumDisksAccessed: 9 (9)
  1436. - NumRowGroups: 216 (216)
  1437. - NumScannerThreadMemUnavailable: 0 (0)
  1438. - NumScannerThreadReservationsDenied: 0 (0)
  1439. - NumScannerThreadsStarted: 31 (31)
  1440. - NumScannersWithNoReads: 0 (0)
  1441. - NumStatsFilteredRowGroups: 28 (28)
  1442. - PeakMemoryUsage: 2.02 GB (2169608057)
  1443. - PeakScannerThreadConcurrency: 31 (31)
  1444. - PerReadThreadRawHdfsThroughput: 312.46 MB/sec
  1445. - RemoteScanRanges: 0 (0)
  1446. - RowBatchBytesEnqueued: 14.88 GB (15976722465)
  1447. - RowBatchQueueGetWaitTime: 186.345ms
  1448. - RowBatchQueuePeakMemoryUsage: 38.42 MB (40287438)
  1449. - RowBatchQueuePutWaitTime: 1m11s
  1450. - RowBatchesEnqueued: 20.36K (20363)
  1451. - RowsRead: 189.05M (189051711)
  1452. - RowsReturned: 20.33M (20332212)
  1453. - RowsReturnedRate: 68.38 M/sec
  1454. - ScanRangesComplete: 211 (211)
  1455. - ScannerIoWaitTime: 15s211ms
  1456. - ScannerThreadWorklessLoops: 0 (0)
  1457. - ScannerThreadsInvoluntaryContextSwitches: 76 (76)
  1458. - ScannerThreadsTotalWallClockTime: 1m46s
  1459. - ScannerThreadsSysTime: 464.562ms
  1460. - ScannerThreadsUserTime: 18s973ms
  1461. - ScannerThreadsVoluntaryContextSwitches: 21.05K (21055)
  1462. - TotalRawHdfsOpenFileTime(*): 396.581ms
  1463. - TotalRawHdfsReadTime(*): 4s851ms
  1464. - TotalReadThroughput: 189.24 MB/sec
  1465. Buffer pool:
  1466. - AllocTime: 48.626ms
  1467. - CumulativeAllocationBytes: 1.55 GB (1665302528)
  1468. - CumulativeAllocations: 1.52K (1520)
  1469. - PeakReservation: 1.95 GB (2088763392)
  1470. - PeakUnpinnedBytes: 0
  1471. - PeakUsedReservation: 1.41 GB (1512538112)
  1472. - ReadIoBytes: 0
  1473. - ReadIoOps: 0 (0)
  1474. - ReadIoWaitTime: 0.000ns
  1475. - SystemAllocTime: 46.369ms
  1476. - WriteIoBytes: 0
  1477. - WriteIoOps: 0 (0)
  1478. - WriteIoWaitTime: 0.000ns
  1479. CodeGen:(Total: 299.131ms, non-child: 299.131ms, % non-child: 100.00%)
  1480. - CodegenInvoluntaryContextSwitches: 0 (0)
  1481. - CodegenTotalWallClockTime: 299.120ms
  1482. - CodegenSysTime: 3.996ms
  1483. - CodegenUserTime: 291.997ms
  1484. - CodegenVoluntaryContextSwitches: 0 (0)
  1485. - CompileTime: 85.669ms
  1486. - IrGenerationTime: 6.711ms
  1487. - LoadTime: 0.000ns
  1488. - ModuleBitcodeSize: 2.28 MB (2393476)
  1489. - NumFunctions: 102 (102)
  1490. - NumInstructions: 3.39K (3387)
  1491. - OptimizationTime: 180.688ms
  1492. - PeakMemoryUsage: 1.65 MB (1734144)
  1493. - PrepareTime: 25.022ms
  1494. Instance 434987288e39baec:45101a3900000003 (host=itchil805.inteliquent.com:22000):(Total: 8s187ms, non-child: 2.039ms, % non-child: 0.02%)
  1495. Last report received time: 2020-02-11 13:42:01.580
  1496. Hdfs split stats (<volume id>:<# splits>/<split lengths>): 7:16/1.01 GB 0:20/248.59 MB 1:20/215.93 MB 3:20/137.59 MB 4:24/975.47 MB 2:22/647.65 MB 5:16/1.11 GB 6:20/318.79 MB
  1497. Fragment Instance Lifecycle Event Timeline: 8s188ms
  1498. - Prepare Finished: 4.322ms (4.322ms)
  1499. - Open Finished: 308.287ms (303.965ms)
  1500. - First Batch Produced: 6s826ms (6s517ms)
  1501. - First Batch Sent: 6s826ms (22.520us)
  1502. - ExecInternal Finished: 8s188ms (1s361ms)
  1503. - MemoryUsage (500.000ms): 1.77 MB, 1.63 GB, 1.79 GB, 1.93 GB, 1.45 GB, 1.31 GB, 1.29 GB, 1.30 GB, 1.16 GB, 898.50 MB, 779.20 MB, 842.82 MB, 843.83 MB, 476.34 MB, 216.19 MB, 126.21 MB
  1504. - ThreadUsage (500.000ms): 1, 33, 33, 32, 17, 12, 11, 11, 8, 5, 4, 4, 4, 2, 1, 1
  1505. - AverageThreadTokens: 11.19
  1506. - BloomFilterBytes: 0
  1507. - ExchangeScanRatio: 0.07
  1508. - PeakMemoryUsage: 1.96 GB (2108619856)
  1509. - PeakReservation: 1.88 GB (2021654528)
  1510. - PeakUsedReservation: 0
  1511. - PerHostPeakMemUsage: 2.00 GB (2144411750)
  1512. - RowsProduced: 1.71M (1713711)
  1513. - TotalNetworkReceiveTime: 0.000ns
  1514. - TotalNetworkSendTime: 12.850ms
  1515. - TotalStorageWaitTime: 3s616ms
  1516. - TotalThreadsInvoluntaryContextSwitches: 52 (52)
  1517. - TotalThreadsTotalWallClockTime: 1m33s
  1518. - TotalThreadsSysTime: 855.781ms
  1519. - TotalThreadsUserTime: 22s082ms
  1520. - TotalThreadsVoluntaryContextSwitches: 18.03K (18031)
  1521. Buffer pool:
  1522. - AllocTime: 0.000ns
  1523. - CumulativeAllocationBytes: 0
  1524. - CumulativeAllocations: 0 (0)
  1525. - PeakReservation: 0
  1526. - PeakUnpinnedBytes: 0
  1527. - PeakUsedReservation: 0
  1528. - ReadIoBytes: 0
  1529. - ReadIoOps: 0 (0)
  1530. - ReadIoWaitTime: 0.000ns
  1531. - ReservationLimit: 0
  1532. - SystemAllocTime: 0.000ns
  1533. - WriteIoBytes: 0
  1534. - WriteIoOps: 0 (0)
  1535. - WriteIoWaitTime: 0.000ns
  1536. Fragment Instance Lifecycle Timings:
  1537. - ExecTime: 7s879ms
  1538. - ExecTreeExecTime: 6s575ms
  1539. - OpenTime: 303.964ms
  1540. - ExecTreeOpenTime: 515.602us
  1541. - PrepareTime: 3.454ms
  1542. - ExecTreePrepareTime: 2.646ms
  1543. KrpcDataStreamSender (dst_id=3):(Total: 1s303ms, non-child: 1s289ms, % non-child: 98.94%)
  1544. ExecOption: Hash Partitioned Sender Codegen Enabled
  1545. - BytesSent (500.000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 24.82 MB, 61.80 MB
  1546. - NetworkThroughput: (Avg: 61.54 MB/sec ; Min: 8.90 MB/sec ; Max: 111.30 MB/sec ; Number of samples: 9417)
  1547. - EosSent: 3 (3)
  1548. - PeakMemoryUsage: 88.27 KB (90384)
  1549. - RowsSent: 1.71M (1713711)
  1550. - RpcFailure: 0 (0)
  1551. - RpcRetry: 0 (0)
  1552. - SerializeBatchTime: 708.086ms
  1553. - TotalBytesSent: 99.06 MB (103866828)
  1554. - UncompressedRowBatchSize: 223.26 MB (234100915)
  1555. AGGREGATION_NODE (id=1):(Total: 6s578ms, non-child: 6s354ms, % non-child: 96.59%)
  1556. Node Lifecycle Event Timeline: 8s187ms
  1557. - Open Started: 307.762ms (307.762ms)
  1558. - Open Finished: 308.275ms (512.640us)
  1559. - First Batch Requested: 308.289ms (14.087us)
  1560. - First Batch Returned: 6s826ms (6s517ms)
  1561. - Last Batch Returned: 8s185ms (1s359ms)
  1562. - Closed: 8s187ms (2.076ms)
  1563. - PeakMemoryUsage: 289.87 MB (303951618)
  1564. - RowsReturned: 1.71M (1713711)
  1565. - RowsReturnedRate: 260.49 K/sec
  1566. GroupingAggregator 0:
  1567. ExecOption: Streaming Preaggregation, Codegen Enabled
  1568. - BuildTime: 0.000ns
  1569. - GetResultsTime: 57.212ms
  1570. - HTResizeTime: 85.321ms
  1571. - HashBuckets: 4.19M (4194304)
  1572. - LargestPartitionPercent: 0 (0)
  1573. - PartitionsCreated: 16 (16)
  1574. - PeakMemoryUsage: 288.10 MB (302096512)
  1575. - PeakReservation: 288.00 MB (301989888)
  1576. - PeakUsedReservation: 0
  1577. - ReductionFactorEstimate: 8.49
  1578. - ReductionFactorThresholdToExpand: 2.00
  1579. - RowsPassedThrough: 0 (0)
  1580. - RowsReturned: 1.71M (1713711)
  1581. - StreamingTime: 5s848ms
  1582. Buffer pool:
  1583. - AllocTime: 17.684ms
  1584. - CumulativeAllocationBytes: 338.00 MB (354418688)
  1585. - CumulativeAllocations: 153 (153)
  1586. - PeakReservation: 288.00 MB (301989888)
  1587. - PeakUnpinnedBytes: 0
  1588. - PeakUsedReservation: 288.00 MB (301989888)
  1589. - ReadIoBytes: 0
  1590. - ReadIoOps: 0 (0)
  1591. - ReadIoWaitTime: 0.000ns
  1592. - SystemAllocTime: 17.524ms
  1593. - WriteIoBytes: 0
  1594. - WriteIoOps: 0 (0)
  1595. - WriteIoWaitTime: 0.000ns
  1596. HDFS_SCAN_NODE (id=0):(Total: 224.452ms, non-child: 224.452ms, % non-child: 100.00%)
  1597. Hdfs split stats (<volume id>:<# splits>/<split lengths>): 7:16/1.01 GB 0:20/248.59 MB 1:20/215.93 MB 3:20/137.59 MB 4:24/975.47 MB 2:22/647.65 MB 5:16/1.11 GB 6:20/318.79 MB
  1598. ExecOption: PARQUET Codegen Enabled, Codegen enabled: 158 out of 158
  1599. Hdfs Read Thread Concurrency Bucket: 0:84.62% 1:7.692% 2:7.692% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 14:0%
  1600. File Formats: PARQUET/NONE:24 PARQUET/SNAPPY:134
  1601. Node Lifecycle Event Timeline: 6s826ms
  1602. - Open Started: 307.765ms (307.765ms)
  1603. - Open Finished: 307.900ms (135.202us)
  1604. - First Batch Requested: 308.291ms (390.971us)
  1605. - First Batch Returned: 323.436ms (15.144ms)
  1606. - Last Batch Returned: 6s825ms (6s502ms)
  1607. - Closed: 6s826ms (360.938us)
  1608. - BytesRead (500.000ms): 0, 678.14 MB, 920.50 MB, 1.10 GB, 1.10 GB, 1.10 GB, 1.10 GB, 1.10 GB, 1.13 GB, 1.20 GB, 1.24 GB, 1.29 GB, 1.30 GB, 1.30 GB
  1609. - FooterProcessingTime: (Avg: 8.579ms ; Min: 720.806us ; Max: 71.456ms ; Number of samples: 158)
  1610. - InitialRangeActualReservation: (Avg: 32.00 MB (33554432) ; Min: 32.00 MB (33554432) ; Max: 32.00 MB (33554432) ; Number of samples: 158)
  1611. - InitialRangeIdealReservation: (Avg: 74.18 KB (75957) ; Min: 8.00 KB (8192) ; Max: 128.00 KB (131072) ; Number of samples: 158)
  1612. - ParquetCompressedBytesReadPerColumn: (Avg: 164.67 MB (172668959) ; Min: 39.91 MB (41846921) ; Max: 249.59 MB (261709972) ; Number of samples: 8)
  1613. - ParquetCompressedPageSize: (Avg: 101.21 KB (103635) ; Min: 10.00 B (10) ; Max: 192.32 KB (196939) ; Number of samples: 13329)
  1614. - ParquetRowGroupActualReservation: (Avg: 43.15 MB (45247185) ; Min: 32.00 MB (33554432) ; Max: 184.00 MB (192937984) ; Number of samples: 139)
  1615. - ParquetRowGroupIdealReservation: (Avg: 10.13 MB (10622902) ; Min: 64.00 KB (65536) ; Max: 184.00 MB (192937984) ; Number of samples: 139)
  1616. - ParquetUncompressedBytesReadPerColumn: (Avg: 166.75 MB (174854074) ; Min: 39.89 MB (41832210) ; Max: 252.05 MB (264295961) ; Number of samples: 8)
  1617. - ParquetUncompressedPageSize: (Avg: 102.49 KB (104946) ; Min: 8.00 B (8) ; Max: 192.28 KB (196890) ; Number of samples: 13329)
  1618. - AverageHdfsReadThreadConcurrency: 0.23
  1619. - AverageScannerThreadConcurrency: 12.54
  1620. - BytesRead: 1.30 GB (1395709086)
  1621. - BytesReadDataNodeCache: 0
  1622. - BytesReadLocal: 1.30 GB (1395709086)
  1623. - BytesReadRemoteUnexpected: 0
  1624. - BytesReadShortCircuit: 1.30 GB (1395709086)
  1625. - CachedFileHandlesHitCount: 1.08K (1080)
  1626. - CachedFileHandlesMissCount: 113 (113)
  1627. - CollectionItemsRead: 0 (0)
  1628. - DataCacheHitBytes: 0
  1629. - DataCacheHitCount: 0 (0)
  1630. - DataCacheMissBytes: 0
  1631. - DataCacheMissCount: 0 (0)
  1632. - DataCachePartialHitCount: 0 (0)
  1633. - DecompressionTime: 954.463ms
  1634. - MaterializeTupleTime(*): 13s068ms
  1635. - MaxCompressedTextFileLength: 0
  1636. - NumColumns: 8 (8)
  1637. - NumDictFilteredRowGroups: 25 (25)
  1638. - NumDisksAccessed: 9 (9)
  1639. - NumRowGroups: 163 (163)
  1640. - NumScannerThreadMemUnavailable: 0 (0)
  1641. - NumScannerThreadReservationsDenied: 0 (0)
  1642. - NumScannerThreadsStarted: 32 (32)
  1643. - NumScannersWithNoReads: 0 (0)
  1644. - NumStatsFilteredRowGroups: 24 (24)
  1645. - PeakMemoryUsage: 1.85 GB (1988328687)
  1646. - PeakScannerThreadConcurrency: 32 (32)
  1647. - PerReadThreadRawHdfsThroughput: 730.42 MB/sec
  1648. - RemoteScanRanges: 0 (0)
  1649. - RowBatchBytesEnqueued: 12.20 GB (13101039531)
  1650. - RowBatchQueueGetWaitTime: 133.627ms
  1651. - RowBatchQueuePeakMemoryUsage: 39.19 MB (41094586)
  1652. - RowBatchQueuePutWaitTime: 1m6s
  1653. - RowBatchesEnqueued: 16.82K (16815)
  1654. - RowsRead: 165.82M (165821581)
  1655. - RowsReturned: 16.83M (16830795)
  1656. - RowsReturnedRate: 74.99 M/sec
  1657. - ScanRangesComplete: 158 (158)
  1658. - ScannerIoWaitTime: 3s616ms
  1659. - ScannerThreadWorklessLoops: 0 (0)
  1660. - ScannerThreadsInvoluntaryContextSwitches: 44 (44)
  1661. - ScannerThreadsTotalWallClockTime: 1m25s
  1662. - ScannerThreadsSysTime: 299.232ms
  1663. - ScannerThreadsUserTime: 14s601ms
  1664. - ScannerThreadsVoluntaryContextSwitches: 17.21K (17207)
  1665. - TotalRawHdfsOpenFileTime(*): 254.492ms
  1666. - TotalRawHdfsReadTime(*): 1s822ms
  1667. - TotalReadThroughput: 189.87 MB/sec
  1668. Buffer pool:
  1669. - AllocTime: 43.390ms
  1670. - CumulativeAllocationBytes: 1.30 GB (1395785728)
  1671. - CumulativeAllocations: 1.16K (1159)
  1672. - PeakReservation: 1.77 GB (1902116864)
  1673. - PeakUnpinnedBytes: 0
  1674. - PeakUsedReservation: 1.21 GB (1299546112)
  1675. - ReadIoBytes: 0
  1676. - ReadIoOps: 0 (0)
  1677. - ReadIoWaitTime: 0.000ns
  1678. - SystemAllocTime: 41.672ms
  1679. - WriteIoBytes: 0
  1680. - WriteIoOps: 0 (0)
  1681. - WriteIoWaitTime: 0.000ns
  1682. CodeGen:(Total: 303.288ms, non-child: 303.288ms, % non-child: 100.00%)
  1683. - CodegenInvoluntaryContextSwitches: 1 (1)
  1684. - CodegenTotalWallClockTime: 303.275ms
  1685. - CodegenSysTime: 1.679ms
  1686. - CodegenUserTime: 302.317ms
  1687. - CodegenVoluntaryContextSwitches: 0 (0)
  1688. - CompileTime: 86.690ms
  1689. - IrGenerationTime: 7.270ms
  1690. - LoadTime: 0.000ns
  1691. - ModuleBitcodeSize: 2.28 MB (2393476)
  1692. - NumFunctions: 102 (102)
  1693. - NumInstructions: 3.39K (3387)
  1694. - OptimizationTime: 183.189ms
  1695. - PeakMemoryUsage: 1.65 MB (1734144)
  1696. - PrepareTime: 25.043ms
  1697. Instance 434987288e39baec:45101a3900000001 (host=itchil806.inteliquent.com:22000):(Total: 8s111ms, non-child: 1.737ms, % non-child: 0.02%)
  1698. Last report received time: 2020-02-11 13:42:01.579
  1699. Hdfs split stats (<volume id>:<# splits>/<split lengths>): 6:11/18.95 MB 2:8/216.70 MB 1:15/1.03 GB 7:14/5.87 MB 5:16/1.32 GB 4:11/115.64 MB 0:17/1.03 GB 3:19/901.70 MB
  1700. Fragment Instance Lifecycle Event Timeline: 8s112ms
  1701. - Prepare Finished: 3.483ms (3.483ms)
  1702. - Open Finished: 319.039ms (315.556ms)
  1703. - First Batch Produced: 7s014ms (6s695ms)
  1704. - First Batch Sent: 7s014ms (3.142us)
  1705. - ExecInternal Finished: 8s112ms (1s097ms)
  1706. - MemoryUsage (500.000ms): 1.77 MB, 1.81 GB, 1.45 GB, 1.34 GB, 1.21 GB, 1.22 GB, 1.12 GB, 1.15 GB, 1.05 GB, 1.05 GB, 919.69 MB, 952.05 MB, 953.66 MB, 781.52 MB, 182.19 MB, 84.18 MB
  1707. - ThreadUsage (500.000ms): 1, 33, 18, 14, 10, 9, 7, 7, 6, 6, 5, 5, 5, 4, 1, 1
  1708. - AverageThreadTokens: 8.25
  1709. - BloomFilterBytes: 0
  1710. - ExchangeScanRatio: 0.06
  1711. - PeakMemoryUsage: 1.88 GB (2023064990)
  1712. - PeakReservation: 1.82 GB (1955594240)
  1713. - PeakUsedReservation: 0
  1714. - PerHostPeakMemUsage: 1.92 GB (2058856884)
  1715. - RowsProduced: 1.49M (1494645)
  1716. - TotalNetworkReceiveTime: 0.000ns
  1717. - TotalNetworkSendTime: 7.267ms
  1718. - TotalStorageWaitTime: 8s048ms
  1719. - TotalThreadsInvoluntaryContextSwitches: 51 (51)
  1720. - TotalThreadsTotalWallClockTime: 1m9s
  1721. - TotalThreadsSysTime: 744.102ms
  1722. - TotalThreadsUserTime: 21s841ms
  1723. - TotalThreadsVoluntaryContextSwitches: 17.88K (17877)
  1724. Buffer pool:
  1725. - AllocTime: 0.000ns
  1726. - CumulativeAllocationBytes: 0
  1727. - CumulativeAllocations: 0 (0)
  1728. - PeakReservation: 0
  1729. - PeakUnpinnedBytes: 0
  1730. - PeakUsedReservation: 0
  1731. - ReadIoBytes: 0
  1732. - ReadIoOps: 0 (0)
  1733. - ReadIoWaitTime: 0.000ns
  1734. - ReservationLimit: 0
  1735. - SystemAllocTime: 0.000ns
  1736. - WriteIoBytes: 0
  1737. - WriteIoOps: 0 (0)
  1738. - WriteIoWaitTime: 0.000ns
  1739. Fragment Instance Lifecycle Timings:
  1740. - ExecTime: 7s793ms
  1741. - ExecTreeExecTime: 6s727ms
  1742. - OpenTime: 315.556ms
  1743. - ExecTreeOpenTime: 500.264us
  1744. - PrepareTime: 2.683ms
  1745. - ExecTreePrepareTime: 2.016ms
  1746. KrpcDataStreamSender (dst_id=3):(Total: 1s065ms, non-child: 1s057ms, % non-child: 99.24%)
  1747. ExecOption: Hash Partitioned Sender Codegen Enabled
  1748. - BytesSent (500.000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 16.27 MB, 55.58 MB
  1749. - NetworkThroughput: (Avg: 80.38 MB/sec ; Min: 12.08 MB/sec ; Max: 156.91 MB/sec ; Number of samples: 8214)
  1750. - EosSent: 3 (3)
  1751. - PeakMemoryUsage: 88.27 KB (90384)
  1752. - RowsSent: 1.49M (1494645)
  1753. - RpcFailure: 0 (0)
  1754. - RpcRetry: 0 (0)
  1755. - SerializeBatchTime: 574.594ms
  1756. - TotalBytesSent: 86.04 MB (90214916)
  1757. - UncompressedRowBatchSize: 194.79 MB (204256533)
  1758. AGGREGATION_NODE (id=1):(Total: 6s729ms, non-child: 6s587ms, % non-child: 97.90%)
  1759. Node Lifecycle Event Timeline: 8s112ms
  1760. - Open Started: 318.529ms (318.529ms)
  1761. - Open Finished: 319.027ms (497.671us)
  1762. - First Batch Requested: 319.040ms (13.165us)
  1763. - First Batch Returned: 7s014ms (6s695ms)
  1764. - Last Batch Returned: 8s110ms (1s095ms)
  1765. - Closed: 8s112ms (1.848ms)
  1766. - PeakMemoryUsage: 225.87 MB (236841842)
  1767. - RowsReturned: 1.49M (1494645)
  1768. - RowsReturnedRate: 222.11 K/sec
  1769. GroupingAggregator 0:
  1770. ExecOption: Streaming Preaggregation, Codegen Enabled
  1771. - BuildTime: 0.000ns
  1772. - GetResultsTime: 30.937ms
  1773. - HTResizeTime: 36.710ms
  1774. - HashBuckets: 2.10M (2097152)
  1775. - LargestPartitionPercent: 0 (0)
  1776. - PartitionsCreated: 16 (16)
  1777. - PeakMemoryUsage: 224.10 MB (234987648)
  1778. - PeakReservation: 224.00 MB (234881024)
  1779. - PeakUsedReservation: 0
  1780. - ReductionFactorEstimate: 6.25
  1781. - ReductionFactorThresholdToExpand: 2.00
  1782. - RowsPassedThrough: 0 (0)
  1783. - RowsReturned: 1.49M (1494645)
  1784. - StreamingTime: 6s048ms
  1785. Buffer pool:
  1786. - AllocTime: 8.849ms
  1787. - CumulativeAllocationBytes: 242.00 MB (253755392)
  1788. - CumulativeAllocations: 121 (121)
  1789. - PeakReservation: 224.00 MB (234881024)
  1790. - PeakUnpinnedBytes: 0
  1791. - PeakUsedReservation: 224.00 MB (234881024)
  1792. - ReadIoBytes: 0
  1793. - ReadIoOps: 0 (0)
  1794. - ReadIoWaitTime: 0.000ns
  1795. - SystemAllocTime: 8.721ms
  1796. - WriteIoBytes: 0
  1797. - WriteIoOps: 0 (0)
  1798. - WriteIoWaitTime: 0.000ns
  1799. HDFS_SCAN_NODE (id=0):(Total: 141.643ms, non-child: 141.643ms, % non-child: 100.00%)
  1800. Hdfs split stats (<volume id>:<# splits>/<split lengths>): 6:11/18.95 MB 2:8/216.70 MB 1:15/1.03 GB 7:14/5.87 MB 5:16/1.32 GB 4:11/115.64 MB 0:17/1.03 GB 3:19/901.70 MB
  1801. ExecOption: PARQUET Codegen Enabled, Codegen enabled: 111 out of 111
  1802. Hdfs Read Thread Concurrency Bucket: 0:76.92% 1:7.692% 2:7.692% 3:0% 4:7.692% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 14:0%
  1803. File Formats: PARQUET/NONE:17 PARQUET/SNAPPY:94
  1804. Node Lifecycle Event Timeline: 7s014ms
  1805. - Open Started: 318.532ms (318.532ms)
  1806. - Open Finished: 318.631ms (99.380us)
  1807. - First Batch Requested: 319.042ms (411.175us)
  1808. - First Batch Returned: 344.258ms (25.216ms)
  1809. - Last Batch Returned: 7s014ms (6s669ms)
  1810. - Closed: 7s014ms (512.941us)
  1811. - BytesRead (500.000ms): 0, 970.24 MB, 1.05 GB, 1.05 GB, 1.05 GB, 1.05 GB, 1.07 GB, 1.19 GB, 1.21 GB, 1.26 GB, 1.29 GB, 1.30 GB, 1.30 GB, 1.30 GB
  1812. - FooterProcessingTime: (Avg: 26.418ms ; Min: 1.911ms ; Max: 127.681ms ; Number of samples: 111)
  1813. - InitialRangeActualReservation: (Avg: 32.00 MB (33554432) ; Min: 32.00 MB (33554432) ; Max: 32.00 MB (33554432) ; Number of samples: 111)
  1814. - InitialRangeIdealReservation: (Avg: 66.45 KB (68045) ; Min: 8.00 KB (8192) ; Max: 128.00 KB (131072) ; Number of samples: 111)
  1815. - ParquetCompressedBytesReadPerColumn: (Avg: 165.88 MB (173940457) ; Min: 39.75 MB (41685700) ; Max: 251.41 MB (263620723) ; Number of samples: 8)
  1816. - ParquetCompressedPageSize: (Avg: 103.61 KB (106101) ; Min: 10.00 B (10) ; Max: 192.31 KB (196930) ; Number of samples: 13115)
  1817. - ParquetRowGroupActualReservation: (Avg: 40.50 MB (42467328) ; Min: 32.00 MB (33554432) ; Max: 176.00 MB (184549376) ; Number of samples: 94)
  1818. - ParquetRowGroupIdealReservation: (Avg: 13.32 MB (13970845) ; Min: 64.00 KB (65536) ; Max: 176.00 MB (184549376) ; Number of samples: 94)
  1819. - ParquetUncompressedBytesReadPerColumn: (Avg: 166.75 MB (174852906) ; Min: 39.74 MB (41671154) ; Max: 252.39 MB (264652421) ; Number of samples: 8)
  1820. - ParquetUncompressedPageSize: (Avg: 104.16 KB (106658) ; Min: 8.00 B (8) ; Max: 192.28 KB (196890) ; Number of samples: 13115)
  1821. - AverageHdfsReadThreadConcurrency: 0.54
  1822. - AverageScannerThreadConcurrency: 8.92
  1823. - BytesRead: 1.30 GB (1400356213)
  1824. - BytesReadDataNodeCache: 0
  1825. - BytesReadLocal: 1.30 GB (1400356213)
  1826. - BytesReadRemoteUnexpected: 0
  1827. - BytesReadShortCircuit: 1.30 GB (1400356213)
  1828. - CachedFileHandlesHitCount: 682 (682)
  1829. - CachedFileHandlesMissCount: 107 (107)
  1830. - CollectionItemsRead: 0 (0)
  1831. - DataCacheHitBytes: 0
  1832. - DataCacheHitCount: 0 (0)
  1833. - DataCacheMissBytes: 0
  1834. - DataCacheMissCount: 0 (0)
  1835. - DataCachePartialHitCount: 0 (0)
  1836. - DecompressionTime: 761.586ms
  1837. - MaterializeTupleTime(*): 12s961ms
  1838. - MaxCompressedTextFileLength: 0
  1839. - NumColumns: 8 (8)
  1840. - NumDictFilteredRowGroups: 27 (27)
  1841. - NumDisksAccessed: 8 (8)
  1842. - NumRowGroups: 111 (111)
  1843. - NumScannerThreadMemUnavailable: 0 (0)
  1844. - NumScannerThreadReservationsDenied: 0 (0)
  1845. - NumScannerThreadsStarted: 32 (32)
  1846. - NumScannersWithNoReads: 0 (0)
  1847. - NumStatsFilteredRowGroups: 17 (17)
  1848. - PeakMemoryUsage: 1.84 GB (1978185673)
  1849. - PeakScannerThreadConcurrency: 32 (32)
  1850. - PerReadThreadRawHdfsThroughput: 392.34 MB/sec
  1851. - RemoteScanRanges: 0 (0)
  1852. - RowBatchBytesEnqueued: 13.18 GB (14153508115)
  1853. - RowBatchQueueGetWaitTime: 52.391ms
  1854. - RowBatchQueuePeakMemoryUsage: 33.81 MB (35454022)
  1855. - RowBatchQueuePutWaitTime: 39s316ms
  1856. - RowBatchesEnqueued: 16.75K (16750)
  1857. - RowsRead: 165.14M (165137619)
  1858. - RowsReturned: 16.88M (16881754)
  1859. - RowsReturnedRate: 119.18 M/sec
  1860. - ScanRangesComplete: 111 (111)
  1861. - ScannerIoWaitTime: 8s048ms
  1862. - ScannerThreadWorklessLoops: 0 (0)
  1863. - ScannerThreadsInvoluntaryContextSwitches: 44 (44)
  1864. - ScannerThreadsTotalWallClockTime: 1m1s
  1865. - ScannerThreadsSysTime: 245.320ms
  1866. - ScannerThreadsUserTime: 14s292ms
  1867. - ScannerThreadsVoluntaryContextSwitches: 17.59K (17590)
  1868. - TotalRawHdfsOpenFileTime(*): 248.123ms
  1869. - TotalRawHdfsReadTime(*): 3s403ms
  1870. - TotalReadThroughput: 190.78 MB/sec
  1871. Buffer pool:
  1872. - AllocTime: 49.813ms
  1873. - CumulativeAllocationBytes: 1.17 GB (1257381888)
  1874. - CumulativeAllocations: 746 (746)
  1875. - PeakReservation: 1.78 GB (1911554048)
  1876. - PeakUnpinnedBytes: 0
  1877. - PeakUsedReservation: 1.14 GB (1224146944)
  1878. - ReadIoBytes: 0
  1879. - ReadIoOps: 0 (0)
  1880. - ReadIoWaitTime: 0.000ns
  1881. - SystemAllocTime: 48.568ms
  1882. - WriteIoBytes: 0
  1883. - WriteIoOps: 0 (0)
  1884. - WriteIoWaitTime: 0.000ns
  1885. CodeGen:(Total: 314.933ms, non-child: 314.933ms, % non-child: 100.00%)
  1886. - CodegenInvoluntaryContextSwitches: 2 (2)
  1887. - CodegenTotalWallClockTime: 314.922ms
  1888. - CodegenSysTime: 7.979ms
  1889. - CodegenUserTime: 307.211ms
  1890. - CodegenVoluntaryContextSwitches: 1 (1)
  1891. - CompileTime: 86.789ms
  1892. - IrGenerationTime: 6.638ms
  1893. - LoadTime: 0.000ns
  1894. - ModuleBitcodeSize: 2.28 MB (2393476)
  1895. - NumFunctions: 102 (102)
  1896. - NumInstructions: 3.39K (3387)
  1897. - OptimizationTime: 195.328ms
  1898. - PeakMemoryUsage: 1.65 MB (1734144)
  1899. - PrepareTime: 25.297ms
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!