Information that can be collected is categorized into the following two types:
Information common to PostgreSQL
Information added by Symfoware Server
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 Symfoware Server
You can collect the following information added by Symfoware Server.
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 "C.2 pgx_stat_lwlock" for details. |
pgx_stat_latch | Displays statistics related latches, with each type of wait information within Symfoware Server displayed on a separate line. This information helps to detect bottlenecks. Refer to "C.3 pgx_stat_latch" for details. |
pgx_stat_walwriter | Displays statistics related to WAL writing, in a single line. Refer to "C.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 "C.5 pgx_stat_sql" for details. |
