SQL statement - execution and elapsed time history

[danielsapbasis]

Hi Experts,

How to find out the execution time, elapsed time and scanned records count history of a particular SQL statement.

Please answer.

Thanks in advance

[Abhishek_Hazra · Accepted solution]

Have you looked into : 2180165 - FAQ: SAP HANA Expensive Statements Trace ?

You can basically get the information from M_EXPENSIVE_STATEMENTS based on the STATEMENT_STRING column.

Best Regards,
Abhi

[danielsapbasis · Accepted solution]

Hi Abhishek,

It does not have the execution and elapsed time information.

Please mention the ideal one can be used.

Thanks in advance

[Abhishek_Hazra · Accepted solution]

Hello again danielsapbasis,

Have you gone through all the columns? How about columns : START_TIME & DURATION_MICROSEC? Why can you not use these two?

Regards,
Abhi

[ghoshsayantan3 · Accepted solution]

Hi Daniel,

You can refer to m_expensive_statements monitoring view and query it with respect to statement_string to find the required query and the records column would help to get the results records count.

The operation column would tell you for which operation its for .(select,call etc)

hope this helps

Re

Sayantan