How to improve Clickhouse performance (both after restart and using Signoz)?

[KieranP]

When I run OS updates, and docker is updated, the ClickHouse docker image is restarted. After this happens, it seems that no data is preloaded into memory/cache, so clicking around Signoz once it is back up is super slow (>10s) as data gets loaded for the first time.

After clicking around Signoz for a few minutes, loading most pages are faster (within 3 seconds). Is there any way to cause ClickHouse to load all indexes into memory on boot, or some other action, so that queries are quicker sooner?

Further, my EC2 instance has 15.34GB of RAM available, but Clickhouse is using only 2.3GB of that. And loading some pages are super slow even with a warm cache, so perhaps there are some config settings for clickhouse docker standalone that I haven't set to make better use of the RAM?

Here is my docker stats:

CONTAINER ID   NAME                    CPU %     MEM USAGE / LIMIT     MEM %     NET I/O           BLOCK I/O         PIDS 
6b0f28cc487d   signoz-otel-collector   0.92%     676.8MiB / 15.34GiB   4.31%     1.07GB / 16.1GB   113MB / 24.6kB    11 
43b6467dd1b8   signoz                  0.00%     108.5MiB / 15.34GiB   0.69%     297MB / 97.7MB    72.9MB / 9.23MB   12 
07e255bf659c   signoz-clickhouse       25.36%    2.295GiB / 15.34GiB   14.96%    19.5GB / 3.21GB   5.35GB / 49.9GB   960 
aafb635a9322   signoz-zookeeper-1      0.13%     724.8MiB / 15.34GiB   4.61%     72MB / 99MB       1.98GB / 1.62GB   60 

I'm guessing that the main thing that is needed here is probably more indexes being added? What is the best/preferred way to find slow Signoz queries and report them to you for optimization?