[ADMIN] POWA-tool doesn't show queries executed

Dear all

I have successfully installed POWA (http://dalibo.github.io/powa), including all required extensions, see the following Printscreen of its operation of end email.

But when executing queries in psql- comand line, this queries are not monitored by powa. I have checked that only Postgresql internal catalog queries are shown. .

I need the Optimize Query functionality and mainly the suggestion of indexes. 

But that does not work, by clicking on the optimize query option, returns zero suggestions.

See below that I created a scenario, with a table with a large amount of data, to check if the tool would suggest some index, and when making a complex query, no index is suggested.

Someone knows if they have to configure something so that the queries are monitored and show suggestions ??

--------------- Printscreens of my environment partially working:--------------

-------------------------------------------------------------------------------

---------------- scenario to verify the suggestion of indices -----------------

postgres=# create table city_habitant (number_habitant text);

CREATE TABLE

postgres=# insert into  city_habitant (number_habitant) select 'São Paulo' from (select generate_series (1, 4000000)) a;

INSERT 0 4000000

postgres=# insert into  city_habitant (number_habitant) select 'Rio de Janeiro' from (select generate_series (1, 8000000)) a;

INSERT 0 8000000

postgres=# insert into  city_habitant (number_habitant) select 'Recife' from (select generate_series (1, 6000000)) a;

INSERT 0 6000000

postgres=# insert into  city_habitant (number_habitant) select 'Santos' from (select generate_series (1, 2000000)) a;

INSERT 0 2000000

postgres=# insert into  city_habitant (number_habitant) select 'Chui' from (select generate_series (1, 6)) a;

INSERT 0 6

postgres=# SELECT number_habitant, count(number_habitant) FROM city_habitant GROUP BY number_habitant;

 number_habitant   |  count

-------------------+------

 Rio de Janeiro    | 8000000

 Recife            | 6000000

 Santos            | 2000000

 São Pauo          | 4000000

 Chui              |  6

(5 rows)