If the Symfoware Server version that was used to create the instance is V12.0.0 or V12.0.0A, execute "CREATE EXTENSION" in order to reference Information added by Symfoware Server.
See
Refer to "Information that can be Collected" in the Operation Guide for information on Information added by Symfoware Server.
Follow the procedure below to install any missing extensions:
Check if CREATE EXTENSION is required for the target database.
Use the psql command to connect to the target database (in the example below, "postgres"), and then execute the following SELECT statements:
postgres=# SELECT * FROM pgx_stat_sql; ERROR: Relation "pgx_stat_sql" does not exist (10292) postgres=# SELECT * FROM pgx_stat_lwlock; ERROR: Relation "pgx_stat_lwlock" does not exist (10292) postgres=# SELECT * FROM pgx_stat_latch; ERROR: Relation "pgx_stat_latch" does not exist (10292) postgres=# SELECT * FROM pgx_stat_walwriter; ERROR: Relation "pgx_stat_walwriter" does not exist (10292)
CREATE EXTENSION is required if the view specified in the SELECT statement does not exist.
Execute the statements below to install the statistics views independently added by Symfoware Server and that were not displayed in step 1. If there are multiple databases, execute the statements for all of them.
If the connected database is not a registration target, these views cannot be browsed. If the database has been registered for template1, there is no need to consider this point for databases added thereafter.
The statistics are reset when the view is installed.
postgres=# CREATE EXTENSION pgx_stat_sql; CREATE EXTENSION postgres=# CREATE EXTENSION pgx_stat_lwlock; CREATE EXTENSION postgres=# CREATE EXTENSION pgx_stat_latch; CREATE EXTENSION postgres=# CREATE EXTENSION pgx_stat_walwriter; CREATE EXTENSION postgres=# \q
