# postgres chart postgres\_smadb.wal\_files\_count, postgres\_smadb.wal\_archiving\_files\_count are empty

**URL:** <https://community.netdata.cloud/t/postgres-chart-postgres-smadb-wal-files-count-postgres-smadb-wal-archiving-files-count-are-empty/3963>\
**Category:** Help\
**Tags:** agent, collectors\
**Created:** [March 14, 2023, 11:02am UTC](https://community.netdata.cloud/t/postgres-chart-postgres-smadb-wal-files-count-postgres-smadb-wal-archiving-files-count-are-empty/3963 "2023-03-14T11:02:26Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![pgro](https://yyz1.discourse-cdn.com/flex029/user_avatar/community.netdata.cloud/pgro/32/2654_2.png) [@pgro](https://community.netdata.cloud/u/pgro)\
**Post date:** [March 14, 2023, 11:02am UTC](https://community.netdata.cloud/t/postgres-chart-postgres-smadb-wal-files-count-postgres-smadb-wal-archiving-files-count-are-empty/3963/1 "2023-03-14T11:02:26Z")

</div>

Hi,

it seems that Charts for PostgreSQL _postgres\_smadb.wal\_files\_count, postgres\_smadb.wal\_archiving\_files\_count are empty,_ are empty is there any way to troubleshoot the reason?

 ![image](https://canada1.discourse-cdn.com/flex029/uploads/netdata2/original/2X/9/9d0d6de3d0b80dbbdb9fa466ab0a45910a557b24.png)

---

<div class="post-metadata">

**Author:** ![pgro](https://yyz1.discourse-cdn.com/flex029/user_avatar/community.netdata.cloud/pgro/32/2654_2.png) [@pgro](https://community.netdata.cloud/u/pgro)\
**Post date:** [March 14, 2023, 11:10am UTC](https://community.netdata.cloud/t/postgres-chart-postgres-smadb-wal-files-count-postgres-smadb-wal-archiving-files-count-are-empty/3963/2 "2023-03-14T11:10:01Z")

</div>

After a search i found

\*\* wal\_files\_count, wal\_archiving\_files\_count and replication\_slot\_files\_count need [superuser](https://www.postgresql.org/docs/current/role-attributes.html) status.\*

So I will provide superuser perm on my user and I will revert.

---

<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:** [March 14, 2023, 11:26am UTC](https://community.netdata.cloud/t/postgres-chart-postgres-smadb-wal-files-count-postgres-smadb-wal-archiving-files-count-are-empty/3963/3 "2023-03-14T11:26:09Z")

</div>

Hi, @pgro. The fact that Netdata creates the charts (wal\_files\_count, wal\_archiving\_files\_count) despite the fact that the user is not a superuser is a bug. On the other hand, if Netdata wouldn’t create them, it is very likely that you wouldn’t notice their absence.

---

<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:** [March 14, 2023, 5:17pm UTC](https://community.netdata.cloud/t/postgres-chart-postgres-smadb-wal-files-count-postgres-smadb-wal-archiving-files-count-are-empty/3963/4 "2023-03-14T17:17:06Z")

</div>

> The fact that Netdata creates the charts (wal\_files\_count, wal\_archiving\_files\_count) despite the fact that the user is not a superuser is a bug

Fixed in [netdata/go.d.plugin#1122](https://github.com/netdata/go.d.plugin/pull/1122)