comdb2 icon indicating copy to clipboard operation
comdb2 copied to clipboard
verified publisher icon bloomberg

log long running SQLs executed from a stored procedure

Open aakash10292 opened this issue 1 year ago • 3 comments

aakash10292 avatar Oct 07 '24 20:10 aakash10292

cdb2test Oct 11 11:13:28 2024 in-comdb2db aar_longreqs.R20241011.2

aakash10292 avatar Oct 11 '24 16:10 aakash10292

Instead of overwriting clnt->sql, how about adding a version of reqlog_end_request which takes the request string. You can get the sql string from the sqlite_stmt object just before it is reset or finalized.

akshatsikarwar avatar Oct 21 '24 13:10 akshatsikarwar

cdb2test Oct 22 23:39:56 2024 in-comdb2db aar_longreqs.R20241022.11

aakash10292 avatar Oct 23 '24 14:10 aakash10292