Comments (6)
Saw this and realised I could help.
shared_buffers
without units is specified in blocks, typically 8kB – docs
max_wal_size
without units is specified in segment files, typically 16MB – docs
from pgmetrics.
Yes, @mchristofides is correct. pgmetrics is showing the literal value in defined units of the setting, and in paranthesis, the effective value in bytes. In the line:
| shared_buffers | 524288 (4.0 GiB) |
it is trying to say that the value is 524288 blocks, which means 4.0 GB since each block is of size 8192 bytes.
from pgmetrics.
Thanks @mchristofides and @mdevan. So I'm OK with shared_buffers
as 524288 blocks (4.0 GiB) is consistent with my settings. Maybe a default blocks
unit would be worth but pgmetrics is ok, let's say it's and enhancement request.
Now, I understand max_wal_size
and pgmetrics seems wrong on the left figure misinterpreting the default unit as 16MB, one should read 2048 (MB) (4 GiB) and not 2048 (16MB) (32 GiB) to be consistent with my settings. In that case it's closer to a bug maybe.
from pgmetrics.
Hmm, yes, you're right, there is a bug here.
For Postgres 9.4 and below, the setting was called checkpoint_segments
(as the number of segments, unitless). For 9.5 and 9.6 the setting is max_wal_size
with a unit of 16MB and for 10 and above it is max_wal_size
with a unit of 1MB.
pgmetrics reporting code assumes 16MB for 9.5+, it does not use 1MB for 10+. Are you using Postgres 10 or above?
Will fix.
from pgmetrics.
For this specific case, it's PostgreSQL 12 indeed.
from pgmetrics.
Fixed in 513dcc0. Thanks for reporting.
from pgmetrics.
Related Issues (20)
- Log parsing clarification HOT 4
- Postgres 13: wal_keep_segments displays no value HOT 2
- What determines the sort order for list of table details in pgmetrics output? HOT 2
- Incorrect min_wal_size displayed for PG ver >= 10 HOT 2
- Improve heuristic to check if PG is local HOT 4
- Slow bloat query HOT 4
- AWS RDS, Aurora cloudwatch collection error HOT 3
- pg_stat_archiver query failed: sql: Scan error on column index 6, name "date_part": converting NULL to int64 is unsupported HOT 2
- Omitting retrieval of index definition HOT 1
- Please, add building instructions HOT 2
- Support Citus 11 HOT 2
- Crashes PSQL when table has high Partition Count HOT 2
- Break up the Postgres shared memory is not available in pgmetrics/pgDash currently.
- how to collect system info with pgmetrics HOT 1
- [Feature] Support connect by Keyword/Value Connection Strings HOT 1
- support PG16 HOT 2
- PgMetrics not working for AWS Aurora Instances HOT 1
- PGBOUNCER 1.21 breaking change. HOT 1
- pg_stat(io)_user_tables query failed: ERROR: canceling statement due to lock timeout (SQLSTATE 55P03) HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from pgmetrics.