Ad Widget

Collapse

Metric pgsql.wal.write is not in MB but it looks like MB/s

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • darko11z
    Junior Member
    • Jun 2022
    • 18

    #1

    Metric pgsql.wal.write is not in MB but it looks like MB/s

    Hi,
    we have Zabbix v6 in production environment.

    I am looking at PostgreSQL database metric "pgsql.wal.write" from https://git.zabbix.com/projects/AP/r...Frelease%2F6.0

    Click image for larger version  Name:	image.png Views:	0 Size:	52.3 KB ID:	490627​​

    and from SQL it does the difference between current WAL file and 0/00000000. According to this calculation metric should always increase, because there are more and more bytes from beginning.

    But from my system metric I see the following graph:
    Click image for larger version  Name:	image.png Views:	0 Size:	31.1 KB ID:	490626
    From graph it is obvious that metric does not increases all the time (like expected if metric is in bytes).

    It looks like this metric is not measured in bytes, but something like "bytes per some time", it looks to me this metric is "bytes per second", so the graph in my case is showing "MB/s" (mega bytes per second and not only mega bytes).

    Is this defect in measurement metric? Currently it reports the metric is in "bytes", but it looks like it is "bytes per second".

    Last edited by darko11z; 02-09-2024, 16:20.
  • cyber
    Senior Member
    Zabbix Certified SpecialistZabbix Certified Professional
    • Dec 2006
    • 4807

    #2
    Click image for larger version  Name:	image.png Views:	0 Size:	19.9 KB ID:	490680

    There is some preprocessing in pgsql.wal.write item. You are correct, that query returns evergrowing number, but preprocessing recalculates it to "per sec"...
    Last edited by cyber; 03-09-2024, 12:49.

    Comment

    Working...