Feng Ruohang

* Compatible with Grafana 8.0 * Add support for echarts 5.0 echarts-gl 2.0.4 * Add world map and china map geojson

Cutomize postgers patroni pgbouncer log dir

1

There is a draft implementation https://github.com/Vonng/pigsty/pull/127 Which will be tested ASAP, and may merge & release on 1.5.1 or 1.6.0 New variable: `pg_log_dir` which controls postgres, pgbouncer, patroni logs.

Provide yet another cli wrapper to seal ansible primitives. for example: ```bash NAME pigsty -- Pigsty Command-Line Interface v0.8 SYNOPSIS meta setup meta nodes init|fetch|repo|cache|ansible node setup database nodes init|tune|dcs|remove|ping|bash|ssh|admin...

## Propose Set a per-database parameters for pgbouncer [database] Add `pgbouncer_poolmode` and `pgbouncer_max_db_conn` to database definition. ```yaml pg_databases: # define business databases on this cluster, array of database definition #...

Low priority.

PG 15 beta metrics

1

https://www.postgresql.org/docs/15/release-15.html Some new features about monitoring * new system view [`pg_stat_subscription_stats`](https://www.postgresql.org/docs/15/monitoring-stats.html#MONITORING-PG-STAT-SUBSCRIPTION_STATS) * `pg_ls_logicalsnapdir()`, `pg_ls_logicalmapdir()`, and `pg_ls_replslotdir()`.

Add pgpass & pg_service.conf support

1

Add `~/.pg_service.conf` and `~/.pgpass`

Schedule policy support to run collector on specific database

2

Can be used for application level metrics collector. For example. ```sql -- get realtime biz user count SELECT count(*) FROM users; SELECT reltuples FROM pg_class WHERE relname = 'users' ```

Built-in metrics definition

2

Embed a default metrics definition into `pg_exporter` which support PG 10 - 14. * Embed static config into binary with Go 1.16 embed * Add option to disabled default metrics....

Histogram are perfect for lock & session duration distribution. e.g ```yaml pg_lock_histo{le=0} pg_lock_histo{le=10} pg_lock_histo{le=50} pg_lock_histo{le=100} pg_lock_histo{le=1000} ... ```