The procedure for configuring collection depends on the information content.
Information common to PostgreSQL
Information added by Symfoware Server
Information common to PostgreSQL
See
Refer to "The Statistics Collector" in "Monitoring Database Activity" under "Server Administration" in the PostgreSQL Documentation for information on information common to PostgreSQL.
Information added by Symfoware Server
Information added by Symfoware Server is collected by default.
To enable or disable information collection, change the configuration parameters in postgresql.conf. The following table lists the views for which you can enable or disable information collection, and the configuration parameters.
View name | Parameter |
|---|---|
pgx_stat_lwlock pgx_stat_latch | track_waits |
pgx_stat_sql | track_sql |
Remarks: You cannot change the collection status for pgx_stat_walwriter.
Refer to "Appendix A Parameters" for information on the parameters.
Note
To reference information added by Symfoware Server in instances created using Symfoware Server V12.0.0, add system views. Refer to "Symfoware Server Migration Procedures" in the Installation and Setup Guide for Server for details.
