Re: Question about buffers_alloc in pg_stat_bgwriter view formonitoring - Mailing list pgsql-general

Hi,

> Am 29.03.2018 um 10:30 schrieb Gunnar Nick Bluth <gunnar.bluth@pro-open.de>:
>
> Thus, buffer_alloc is the global count of buffers allocated in the
> cluster. That it appears in the bgwriter statistics is more or less
> coincidental.

So it is the number of shared_buffers used?

This isn’t possible:

postgres=# SELECT buffers_alloc*current_setting('block_size')::numeric/1024/1024/1024,
current_setting('shared_buffers')FROM pg_stat_bgwriter; 
      ?column?        | current_setting
-----------------------+-----------------
1219.7707748413085938 | 64450MB
(1 row)


About 64 GB shared buffers and 1219 used? ;-)


Or other machine:

      ?column?       | current_setting
----------------------+-----------------
126.4642944335937500 | 64450MB
(1 row)


My Private:

      ?column?      | current_setting
--------------------+-----------------
 3.3014221191406250 | 6GB
(1 Zeile)




Ciao
  Alvar

--
Alvar C.H. Freude | http://alvar.a-blast.org
https://blog.alvar-freude.de/
https://www.wen-waehlen.de/