The pg_stat_statements module is used for query stats.
If you have trouble enabling query stats from the dashboard, try doing it manually.
Add the following to your postgresql.conf
:
shared_preload_libraries = 'pg_stat_statements'
pg_stat_statements.track = all
pg_stat_statements.max = 10000
track_activity_query_size = 2048
Then restart PostgreSQL. As a superuser from the psql
console, run:
CREATE extension pg_stat_statements;
Change shared_preload_libraries
to pg_stat_statements
in your Parameter Group and restart the database instance.
As a superuser from the psql
console, run:
CREATE extension pg_stat_statements;
Follow the instructions above.
Run apt-get install postgresql-contrib-9.3
and follow the instructions above.
The database user is not a superuser. You can manually enable stats from the psql
console with:
CREATE extension pg_stat_statements;
and reset stats with:
SELECT pg_stat_statements_reset();
For security reasons, only superusers can see queries executed by other users.