Skip to Content

HANA Statement execution statistics

Many systems have a method to profile a command or block of commands. I am looking for one that can instrument HANA SQL statements.

How can one get execution stats for a HANA SQL statement (e.g. a call procedure or a dynamic execute sql) in terms of

number of rows read

memory consumed

cpu consumed

Then, if yes, can it be applied on a statement block, like, begin instrumentation ...stuff... end instrumentation? It would be great if there was an example to follow.



Add comment
10|10000 characters needed characters exceeded

  • Please do some own research first. The Performance and Troubleshooting guide as well as the HANA Administration guide contain information on this topic. Also, there had been lots of blogs and discussions here in the community - a quick search will get you good leads here, too.

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Oct 04, 2017 at 03:45 PM

    you can use Visualized Plan from HANA studio to display HANA SQL execution plan, inlcude CPU time, records returned from each HANA execution step and network traffic

    Add comment
    10|10000 characters needed characters exceeded