Openmrs db high cpu usage(>1000%) in bahmni docker standard

We are using bahmni docker standard version and we have High CPU usage mostly above 1000%. What can we do about this we are looking at long running queries and trying to optimize them is their any configuration that can help up debug or solve this problem. Thank You!

@abenezeramre We would need more details to investigate?

  1. Is the high CPU usage consistent always ? Is it above 1000% always? Or is decreases when system not in use ?
  2. What is your data volume ?
  3. Do you have any reports running ?
  4. Also is the Database being queried by any other clients other than application?