search

powa-team / powa

PostgreSQL Workload Analyzer
http://powa.readthedocs.io/
PostgreSQL License
764 stars 57 forks source link

Cannot get query details from pg_qualstats #47

Closed inDream closed 9 years ago

inDream commented 9 years ago

I'm using postgresql 9.4 and here's extension details.

                                     List of installed extensions
        Name        | Version |   Schema   |                        Description
--------------------+---------+------------+-----------------------------------------------------------
 btree_gist         | 1.0     | public     | support for indexing common datatypes in GiST
 pg_qualstats       | 0.0.4   | public     | An extension collecting statistics about quals
 pg_stat_kcache     | 2.0.2   | public     | Kernel cache statistics gathering
 pg_stat_statements | 1.2     | public     | track execution statistics of all SQL statements executed
 plpgsql            | 1.0     | pg_catalog | PL/pgSQL procedural language
 powa               | 2.0     | public     | PostgreSQL Workload Analyser-core

postgresql.conf

shared_preload_libraries = 'pg_stat_statements,powa,pg_stat_kcache,pg_qualstats'
track_activity_query_size = 2048
pg_stat_statements.max = 1000
pg_stat_statements.track = all
pg_qualstats.enabled = true

The query details are empty and powaqualstats* tables are empty too.

inDream commented 9 years ago

Solved by SELECT powa_qualstats_register(); Thanks @rjuju