How to calculate how much resources a SQL uses, including CPU and memory #24407
Unanswered
A-little-bit-of-data
asked this question in
Q&A
Replies: 1 comment 4 replies
-
it's right there in your output. 78.4MB of memory during peak consumption - 1.94GB is the integral of memory usage over the query duration (hence GB-seconds). 4.21s of CPU time spread out across the cluster of which 66.98ms was spent during planning on the coordinator. However unless you define what you want to do the numbers are useless. |
Beta Was this translation helpful? Give feedback.
4 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
The cluster has one coordinator and seven workers. The coordinator configuration is 16C 64G, and the worker configuration is 12C 64G.
I ran a SQL statement and the following information was displayed on the web UI:
How to calculate how much resources this SQL task consumes?
Beta Was this translation helpful? Give feedback.
All reactions