clean up memory usage #55
Description
Clickhouse container (Chronicler) is using too much memory, most of which is system logs.
| Table | Total Size | Compressed Size | System Log |
|---|---|---|---|
| trace_log | 419.24 GiB | 16.67 GiB | ✓ |
| text_log | 61.27 GiB | 9.53 GiB | ✓ |
| processors_profile_log | 15.27 GiB | 1.71 GiB | ✓ |
| asynchronous_metric_log | 11.17 GiB | 413.22 MiB | ✓ |
| query_log | 10.74 GiB | 1.72 GiB | ✓ |
| metric_log | 6.07 GiB | 1.04 GiB | ✓ |
| part_log | 5.74 GiB | 1.14 GiB | ✓ |
| query_views_log | 1.28 GiB | 215.00 MiB | ✓ |
| results | 954.04 MiB | 105.37 MiB | |
| error_log | 19.45 MiB | 809.95 KiB | ✓ |
| block_explorer_heights | 17.88 MiB | 2.47 MiB | |
| query_metric_log | 738.38 KiB | 257.71 KiB | ✓ |
| targets | 6.80 KiB | 5.04 KiB |
Container logs are also growing fast
| Container | Total Log Size | Daily Growth |
|---|---|---|
| hosh-checker-btc-1 | 160M | 90M/day |
| checker-zec | 20M | 12M/day |
| hosh-checker-http-1 | 19M | 11M/day |
| publisher | 4.4M | 2.5M/day |
| hosh-nats-1 | 1.9K | 1.1K/day |
| tor | 1.2K | 667/day |
| chronicler | 854 | 478/day |
| nostr-alert | 55K | 80K/day |
| web | 42K | 70K/day |
| discovery | 0 | 0/day |