The procedure for configuring collection depends on the information content.
Information common to PostgreSQL
Information added by Fujitsu Enterprise Postgres
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 Fujitsu Enterprise Postgres
Information added by Fujitsu Enterprise Postgres 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 (*1) |
pgx_stat_sql | track_sql |
pgx_stat_gmc | track_gmc |
Remarks: You cannot change the collection status for pgx_stat_walwriter.
*1: When executing the SQL statement with EXPLAIN ANALYZE, processing time may increase because of this information collection. It is recommended to set this parameter to "off" when executing EXPLAIN ANALYZE to check the processing time.
Refer to "Appendix A Parameters" for information on the parameters.
