Querylog procedures

Querylog procedures dinther Thu, 07/30/2020 - 22:45
Procedure Description Example
sys.querylog_disable() stop logging queries call sys.querylog_disable();
sys.querylog_empty() empty the query log call sys.querylog_empty();
sys.querylog_enable() start logging queries call sys.querylog_enable();
sys.querylog_enable(threshold_in_ms integer) start logging queries but only the ones which execution time exceeds the threshold_in_ms time. call sys.querylog_enable(123);


These procedures are used with: QueryTiming / QueryHistory.