No statements populated on the PostgreSQL statements dashboard data for PostgreSQL.
Error messages like "ERROR: relation "pg_stat_statements" does not exist" may appear in the PostgreSQL agent log file.
RESOLUTION 1
Installation of the pg_stat_statements module and creation of the extension in a database is required for statement tracking. Basic steps follow below. For more information on how to install this, refer to the relevant PostgreSQL documentation for your version
shared_preload_libraries = 'pg_stat_statements'
pg_stat_statements.max = 1000
pg_stat_statements.track = all
More info on properties: https://www.postgresql.org/docs/current/static/pgstatstatements.html
CREATE EXTENSION pg_stat_statements;
The pg_stat_statements view should appear in DB's public schema. If the public schema does not exist, create this first.
If the view is present and the statements do not display, try recreating the view in the database and ensure that the Foglight user has access to the view.
RESOLUTION 2
Run the following command in each database where pg_stat_statements has been installed.
ALTER EXTENSION pg_stat_statements UPDATE
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. 利用規約 プライバシー Cookie Preference Center