Comments (4)
Would it be possible to add a small section to the docs highlighting what extensions are needed for what feature? Perhaps even showing the ideal/expected settings associated for each.
That sounds useful, will add. Thanks for the suggestion!
from pgmetrics.
Currently, pgmetrics can only parse local log files that are actually present as files in the filesystem.
In case of remote servers, you'll have to first fetch the log files (over scp/rsync or similar) to the server where pgmetrics is running, and then invoke pgmetrics. In future, we plan to support an scp-like syntax for the --log-file/--log-dir options.
Syslog/journald also will have to be pulled out into a file somehow before invoking pgmetrics. Not sure if we'll be adding support for this in the future though. Note that the extracted file should have lines that match the "log_line_prefix" configuration setting.
and seemingly associated info in the output, like Slow Queries
pgmetrics currently collects (1) autovacuum runs, (2) deadlocks and (3) auto_explain query plans from log files. Slow queries output comes from pg_stat_statements.
from pgmetrics.
you'll have to first fetch the log files (over scp/rsync or similar) to the server where pgmetrics is running
That's a reasonable workaround for the time being. Thanks for the info.
pgmetrics currently collects (1) autovacuum runs, (2) deadlocks and (3) auto_explain query plans from log files. Slow queries output comes from pg_stat_statements.
Ah, thanks for clarifying. The docs were not super clear on this front, it seemed to imply that there were some magic that grabbed log lines from log_min_duration_statement
no explicit mention of pg_stat_statements
for that.
Would it be possible to add a small section to the docs highlighting what extensions are needed for what feature? Perhaps even showing the ideal/expected settings associated for each.
Thanks again for the very nice project!
from pgmetrics.
Thanks very much @mdevan
Feel free to close this now, or if you prefer to keep it opened until such docs have been added, that's fine too.
Cheers
from pgmetrics.
Related Issues (20)
- use iso date format everywhere in report
- How to read some values reported by pgmetrics (e.g. shared_buffers, max_wal_size) HOT 6
- 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
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.