Hana - Visual Plan - Execution Time and Memory Allocation

[bhaskar_v3]

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.

Or

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

[lbreddemann · Accepted solution]

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.