how to get memory usage and cpu usage by query?

[lemmg]

Does anyone know how I can get memory and cpu usage of one query at a time in SQL in sap hana cockpit?

[Dan_vL]

Following the execution of a SQL query in the SAP HANA database explorer, in the messages tab, there are details on the query time and memory usage.

A screenshot of this is shown below.

I believe these metrics are also available if you are executing the query using one of the SAP HANA Client interfaces. An example for the Node.js client is the getServerMemoryUsage() Method.

Regards,
Dan van Leeuwen