Debugging memory issues

When encountering memory issues or a memory leak, knowing what queries and resources are consuming a significant amount of memory is helpful. Below are queries that can help debug and find which queries, databases, and tables can be optimized:

List currently running processes by peak memory usage

List metrics for memory usage

List tables by current memory usage

Output total memory used by merges

Output total memory used by currently running processes

Output total memory used by dictionaries

Output total memory used by primary keys