Skip to main content

Querylog procedures

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.