# How is the value of app.sql\_fds\_open\_limit calculated?

**URL:** <https://community.netdata.cloud/t/how-is-the-value-of-app-sql-fds-open-limit-calculated/5600>\
**Category:** Help\
**Created:** [July 11, 2024, 11:10pm UTC](https://community.netdata.cloud/t/how-is-the-value-of-app-sql-fds-open-limit-calculated/5600 "2024-07-11T23:10:41Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![unwiredjengel](https://avatars.discourse-cdn.com/v4/letter/u/82dd89/32.png) [@unwiredjengel](https://community.netdata.cloud/u/unwiredjengel)\
**Post date:** [July 11, 2024, 11:10pm UTC](https://community.netdata.cloud/t/how-is-the-value-of-app-sql-fds-open-limit-calculated/5600/1 "2024-07-11T23:10:41Z")

</div>

**Suggested template:**

## Problem/Question

We have a server running a database and this warning in netdata pops up frequently recently:

```auto
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](https://www.postgresql.org/message-id/8751.1466518180%40sss.pgh.pa.us) 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.

---

<div class="post-metadata">

**Author:** ![ilyam8](https://yyz1.discourse-cdn.com/flex029/user_avatar/community.netdata.cloud/ilyam8/32/134_2.png) [@ilyam8](https://community.netdata.cloud/u/ilyam8)\
**Post date:** [July 12, 2024, 6:35am UTC](https://community.netdata.cloud/t/how-is-the-value-of-app-sql-fds-open-limit-calculated/5600/2 "2024-07-12T06:35:56Z")

</div>

Hi. See [[Bug]: Spam from apps\_group\_file\_descriptors\_utilization · Issue #17332 · netdata/netdata · GitHub](https://github.com/netdata/netdata/issues/17332#issuecomment-2042106300).

---

<div class="post-metadata">

**Author:** ![unwiredjengel](https://avatars.discourse-cdn.com/v4/letter/u/82dd89/32.png) [@unwiredjengel](https://community.netdata.cloud/u/unwiredjengel)\
**Post date:** [July 12, 2024, 6:35pm UTC](https://community.netdata.cloud/t/how-is-the-value-of-app-sql-fds-open-limit-calculated/5600/3 "2024-07-12T18:35:10Z")

</div>

Thank you much, this is very helpful.
