Thread: Global tables
Hi all,
With regards to system views/tables pg_stat_database, pg_stat_activity, pg_stat_statements, pg_database_conflicts etc provide cluster wide information and not specific to database.
However views such as pg_stat_user_tables, pg_stat_user_indexes ..etc shows db specific information.
So I want to know how do I identify where are all the views that shows cluster wide info or db specific?
Hi Rajesh
You can identify them by official documentation.
Regards
Kashif Zeeshan
Bitnine Global
On Mon, May 27, 2024 at 10:26 AM Rajesh Kumar <rajeshkumar.dba09@gmail.com> wrote:
Hi all,With regards to system views/tables pg_stat_database, pg_stat_activity, pg_stat_statements, pg_database_conflicts etc provide cluster wide information and not specific to database.However views such as pg_stat_user_tables, pg_stat_user_indexes ..etc shows db specific information.So I want to know how do I identify where are all the views that shows cluster wide info or db specific?
On Sunday, May 26, 2024, Rajesh Kumar <rajeshkumar.dba09@gmail.com> wrote:
With regards to system views/tables pg_stat_database, pg_stat_activity,pg_stat_statements[…] provide cluster wide information and not specific to database.
The first two (and databases) indeed work that way, the documentation for the pg_stat_statements extension indicate it is handled per-database.
However views such as pg_stat_user_tables, pg_stat_user_indexes ..etc shows db specific information.
Yes, object-specific data that resides within a database gets isolated.
So I want to know how do I identify where are all the views that shows cluster wide info or db specific?
The descriptions for each view make it clear what data they show. I’m unaware of any metadata within the system to track and query this dynamic.
David J.