Information that can be collected is categorized into the following types:
Information common to PostgreSQL
Information added by Fujitsu Enterprise Postgres
Information common to PostgreSQL
See
Refer to "Monitoring Database Activity" under "Server Administration" in the PostgreSQL Documentation for information on information common to PostgreSQL.
Information added by Fujitsu Enterprise Postgres
You can collect the following information added by Fujitsu Enterprise Postgres.
View name | Description |
|---|---|
pgx_stat_lwlock | Displays statistic related to lightweight lock, with each type of content displayed on a separate line. This information helps to detect bottlenecks. Refer to "D.2 pgx_stat_lwlock" for details. |
pgx_stat_latch | Displays statistics related latches, with each type of wait information within Fujitsu Enterprise Postgres displayed on a separate line. This information helps to detect bottlenecks. Refer to "D.3 pgx_stat_latch" for details. |
pgx_stat_walwriter | Displays statistics related to WAL writing, in a single line. Refer to "D.4 pgx_stat_walwriter" for details. |
pgx_stat_sql | Displays statistics related to SQL statement executions, with each type of SQL statement displayed on a separate line. Refer to "D.5 pgx_stat_sql" for details. |
pgx_stat_gmc | Displays statistics related to Global Meta Cache hit ration and used memory size. Refer to “D.6 pgx_stat_gmc” for detail. Also refer to Chapter 14 Global Meta Cache" for information on the Global Meta Cache. |
