graph wal_bytes?

[stelb]

Hello, I am currently trying to identify who/which statement is creating the current amount of wal, pg_stat_statements track this, but a graph would be handy, can this be implemented?

Regards

Stefan

[rjuju]

Hi,

It should already be the case since version 4.1.0:

• added in powa-archivist as of https://github.com/powa-team/powa-archivist/commit/62db048e409da6e9c57268f17407d5e75ff8c558
• added graphs in powa-web as of https://github.com/powa-team/powa-web/commit/94aa5fb2de7e1120951a7dc411e7991f72f2fea6

The WAL info should be available in graphs and charts for the server, per-database and per-query.

[stelb]

Oops, ok, I can see wal_bytes attribute in powa_statements_history_current now, I see it in powa-web source, but not in webui.

[stelb]

searching in powa-web source I found this:

..
        if pgss18:
            # Add WALs graphs
..

pgss18 is a check for pg_stat_statements:

        pgss18 = self.has_extension_version(self.path_args[0],
                                            'pg_stat_statements', '1.8')

I have

│ pg_stat_statements │ 1.9     │ public     │ track planning and execution statistics of all SQL statements executed │

[stelb]

My bad, postgres has 1.9, powa db has 1.6 :-( I upgrade and hope it will work

[stelb]

OK, i forgot to upgrade the extensions in powa database. It's working now. Thank you!

[rjuju]

Great news, thanks a lot for the confirmation!