This is a requesting for info question and not a technical issue.
An relatively new to presto and looking to optimize presto queries based on query resource utilization and wall time. Can you please help me with below queries:
-
What are the proportion for Heap memory , General memory and Reserved memory on each node.
Can you please provide the corresponding settings. Can they be changed at query level. -
Can you please confirm that trino allocate all the available memory (subject to node level limits per query) to a single query if no other queries are running.
-
What is the formula/description for Parallelism , Scheduled Time/s, CPU Time which are displayed in webui.
-
Description about the attributes that are exposed on the output of json on trino web ui.
for example :query_max_run_time , resourceEstimates . -
Overall , what are the parameters to consider to identify a badly written query in trino.
Can you please answer this. Thanks in advance.