v.23.8Improvement

Add EXCEPT Clause to SYSTEM STOP/START LISTEN QUERIES Command

Add EXCEPT clause to SYSTEM STOP/START LISTEN QUERIES [ALL/DEFAULT/CUSTOM] query, for example SYSTEM STOP LISTEN QUERIES ALL EXCEPT TCP, HTTP. #53280 (Nikolay Degterinsky).
Added an EXCEPT clause to the SYSTEM STOP/START LISTEN QUERIES [ALL/DEFAULT/CUSTOM] commands, allowing users to exclude specific query types from being stopped or started.

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 the EXCEPT 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