graph wal_bytes?

Question

graph wal_bytes?

stelb opened this issue 2 years ago · 6 comments

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

Answer 1 · 2022-11-29T09:36:29.000Z

Hi,

It should already be the case since version 4.1.0:

added in powa-archivist as of powa-team/powa-archivist@62db048
added graphs in powa-web as of powa-team/powa-web@94aa5fb

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

Answer 2 · 2022-11-29T12:01:44.000Z

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.

Answer 3 · 2022-11-29T12:21:40.000Z

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 │

Answer 4 · 2022-11-29T13:12:17.000Z

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

Answer 5 · 2022-11-29T13:24:36.000Z

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

Answer 6 · 2022-12-02T13:35:25.000Z

Great news, thanks a lot for the confirmation!