I have installed Apache Skywalking APM. I have chosen Postgresql for the backend (https://skywalking.apache.org/docs/main/v9.2.0/en/setup/backend/backend-storage/). All services are launched with docker. Infrasture metrics are getting pushed.
I am observing that Postgresql is taking almost all resources (CPU, Memory, and Disk) at one point in time.
When I analyzed it, I found that there is a particular process utilizing more resources. The process name has some junk value. It is running under the user profile "lxd" (which is controlled by PostgreSQL's all background processes). I tried to kill it and it is getting relaunched. This process is killed only when I restart the PostgreSQL container.
Help me to resolve it. Thanks in advance.
2: