v.23.8Improvement
Add EXCEPT Clause to SYSTEM STOP/START LISTEN QUERIES Command
Add EXCEPT clause toSYSTEM STOP/START LISTEN QUERIES [ALL/DEFAULT/CUSTOM]query, for exampleSYSTEM STOP LISTEN QUERIES ALL EXCEPT TCP, HTTP. #53280 (Nikolay Degterinsky).
Why it matters
This feature enhances control over query listening by enabling users to stop or start all query types except specified ones, improving flexibility and precision in managing query monitoring and diagnostic tasks.How to use it
Use theEXCEPT clause after the SYSTEM STOP LISTEN QUERIES or SYSTEM START LISTEN QUERIES commands to exclude certain query types. For example:SYSTEM STOP LISTEN QUERIES ALL EXCEPT TCP, HTTP