Hana - Visual Plan - Execution Time and Memory Allocation

bhaskar_v3 — Wed, 23 May 2018 16:16:49 GMT

In Visual Plan Overview screen we can see SQL Statement Execution Time and Memory Allocation details.

Execution Time - gives the time of preparing and actually executing the query.

Memory Allocation details - Gives the dynamic memory allocation on each user.

My Question is:

Is there any table which stores this information when a SQL Statement is executed.

Is there any Standard Procedures where we can pass SQL Statement to get the above information.

Thanks for your valuable help.

Thanks and Regards,

Bhaskar V

Re: Hana - Visual Plan - Execution Time and Memory Allocation

lbreddemann — Thu, 24 May 2018 02:53:41 GMT

Is there any table which stores this information when a SQL Statement is executed.

>> No, there isn't

Is there any Standard Procedures where we can pass SQL Statement to get the above information.

>> No, again. While PlanViz operates via a built-in internal procedure, there is no public interface or documentation available for this procedure.