Does pgcenter suppor all statistic of postgresql14?

[wasiualhasib]

pgcenter really a very nice tools you made. Want all statistics information listed below. Also looking for documentation of this tools to learn it more details. Where I can get more details about it?

pg_stat_activity,pg_stat_replication,pg_stat_replication_slots,pg_stat_wal_receiver,pg_stat_subscription,pg_stat_archiver,
pg_stat_bgwriter,pg_stat_wal,pg_stat_database,pg_stat_database_conflicts,pg_stat_all_tables,pg_stat_all_indexes,pg_statio_all_tables
pg_statio_all_indexes, pg_statio_all_sequences.

Waiting for your reply.

[lesovsky]

Please read README carefully, there is a list of supported statistics.

The following ones are not supported by pgcenter:

• pg_stat_replication_slots
• pg_stat_wal_receiver
• pg_stat_subscription
• pg_stat_archiver
• pg_stat_bgwriter
• pg_stat_database_conflicts

When using "pgcenter top" use hotkeys to switch between statistics. Press 'h' to show help screen with all possible hotkeys.

[wasiualhasib]

Oh sorry for that. I liked your suggestion. i love what you captured at pgcenter. Try to add more feature if possible. Where i can know about your upcoming feature of those tools what you made? Is there any personal facebook or other group?

…

On Thu, 16 Jun 2022, 6:47 pm Lesovsky Alexey, ***@***.***> wrote: Please read README carefully, there is a list <https://github.com/lesovsky/pgcenter#postgresql-statistics> of supported statistics. The following ones are *not* supported by pgcenter: - pg_stat_replication_slots - pg_stat_wal_receiver - pg_stat_subscription - pg_stat_archiver - pg_stat_bgwriter - pg_stat_database_conflicts When using "pgcenter top" use hotkeys to switch between statistics. Press 'h' to show help screen with all possible hotkeys. — Reply to this email directly, view it on GitHub <#114 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ALRTUCEA4ACDQ5CBCEYMCJTVPMO5VANCNFSM5Y572KFA> . You are receiving this because you authored the thread.Message ID: ***@***.***>

[lesovsky]

Hmm, you can use "watch" button to get notifications about pgcenter or follow me on Github

[lesovsky]

Btw, adding such views listed above is not supposed because they are not widely used in practice. Maybe archiver and bgwriter will be added in future.

[wasiualhasib]

As a DBA I feel WAL archive , checkpoint and bgwriter is the core feature of PostgreSQL. If we can monitor and understand those thing live and clearly then it could be better to understanding what is actually happening inside. I already included pgcenter in all postgresql node, it is working well. I feel you can add something like checkpoint, bgwriter and archiver activity then it will help me and others also. I appreciate about, all your nice project .

[lesovsky]

I am a DBA too, and all my practice experience told me that checkpoint and bgwriter stats are almost useless. Read this for explanation. Archiver stats are also is rarely used.

Finally I have not see a strong reasons to add all exotic stats views. The wish of one person is not the reason.