Sha256: 4e5c1eff7e0d626fed5dae086b20ca7a78b00b2b1610ccb4991093294a73065c
Contents?: true
Size: 1.53 KB
Versions: 39
Compression:
Stored size: 1.53 KB
Contents
# Query Stats The [pg_stat_statements module](http://www.postgresql.org/docs/9.3/static/pgstatstatements.html) is used for query stats. ## Installation If you have trouble enabling query stats from the dashboard, try doing it manually. Add the following to your `postgresql.conf`: ```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: ```psql CREATE extension pg_stat_statements; ``` #### Amazon RDS Change `shared_preload_libraries` to `pg_stat_statements` in your [Parameter Group](https://console.aws.amazon.com/rds/home?region=us-east-1#parameter-groups:) and restart the database instance. As a superuser from the `psql` console, run: ```psql CREATE extension pg_stat_statements; ``` ## Common Issues #### pg_stat_statements must be loaded via shared_preload_libraries Follow the instructions above. #### FATAL: could not access file "pg_stat_statements": No such file or directory Run `apt-get install postgresql-contrib-9.3` and follow the instructions above. #### The database user does not have permission to ... The database user is not a superuser. You can manually enable stats from the `psql` console with: ```psql CREATE extension pg_stat_statements; ``` and reset stats with: ```psql SELECT pg_stat_statements_reset(); ``` #### Queries show up as `<insufficient privilege>` For security reasons, only superusers can see queries executed by other users.
Version data entries
39 entries across 39 versions & 1 rubygems