Reduce GKE workload logs

[xin-hedera]

Problem

All workload logs in our GKE clusters are by default sent to google cloud logging's _Default bucket with 30 days retention period.

While rest api logs may need to be kept so the log-downloader tool can continue to work, we need to fine tuning logs for other workloads to reduce the amount of logs storage and the cost.

Solution

1. research how to change logs routing sink configuration to only include logs we want and store them in _Default bucket, references 1, 2, and 3
2. in addition, citus pods logs excessive temporary files creation events mainly due to repartition queries, research if it can be disabled in postgresql config

Alternatives

No response