Suggested template:
Problem/Question
We have a server running a database and this warning in netdata pops up frequently recently:
server-name-01 needs attention, `app.sql_fds_open_limit`, **App group sql file descriptors utilization = 97%**
App group sql file descriptors utilization = 97%| REDACTED
Open files percentage against the processes limits, among all PIDs in application group
app.sql_fds_open_limit
chart
Relevant docs you followed/actions you took to solve the issue
Initially I thought it was an open file limit. I tried using unit file extensions to bump the open file limit for postgresql.
I did find info from postgresql that it is actually a setting within the postgres program itself, namely halving the value max_files_per_process within the postgres config file. This was changed yesterday and I haven’t gotten that particular warning since, when it would normally be open or getting ready to re-open soon.
Does anyone know how app.sql_fds_open_limit is calculated? Also, does the change I made fix this?
Environment/Browser/Agent’s version etc
This server is a vm in a vSphere cluster, running on Ubuntu 20.04.
Browser is usually Firefox but this isn’t necessarily a webpage issue.
Current netdata script on this box: netdata v1.46.2
What I expected to happen
Someone responds to this topic and helps show how this value is calculated, and whether or not my changing of a postgres setting actually is appropriate for handling this issue.