Why is Cumulative User Memory so large on Resource Utilization Summary Web #18637
Replies: 4 comments
-
cc: @raunaqmorarka @sopel39 Seems wrong on a quick look. @hanson2021 Can you grab the query info JSON for this query? |
Beta Was this translation helpful? Give feedback.
-
@hashhar grab the query info JSON from Web UI by creating new query |
Beta Was this translation helpful? Give feedback.
-
Yeah, that seems wrong. |
Beta Was this translation helpful? Give feedback.
-
#18714 is a fix |
Beta Was this translation helpful? Give feedback.
Uh oh!
There was an error while loading. Please reload this page.
-
(1)Trino Version:403
(2) The Resource Utilization Summary of trino task from web ui are as following. I found the value of Cumulative User Memory is very large . How did it statistic?
(3)My QuerySql:
select
t1.query_id,t1.started,t2.physical_input_size,t1.user,t1.query
from
(select
query_id,at_timezone(started,current_timezone()) as started,user,query,
to_milliseconds(now()-at_timezone(started,current_timezone())) as exectime
from system.runtime.queries
where at_timezone(started,current_timezone())<=date_add('minute',-5,now())
and state='RUNNING'
and query<>'select 1'
) t1
left join
(
select query_id,
sum(if(physical_input_bytes is not null,physical_input_bytes,0.00))/(102410241024.0) as physical_input_size
from system.runtime.tasks
group by query_id
)t2
on t1.query_id=t2.query_id
where t1.exectime/(1000*60)>=10 or t2.physical_input_size>=1024
Beta Was this translation helpful? Give feedback.
All reactions