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 uses POWA, knows if they have to configure something so that the queries are monitored and show suggestions ?? ---------------------- Printscreens of my environment partially working:-------------- https://sites.google.com/site/eletrolareshop/repositorio/powa1.jpeg https://sites.google.com/site/eletrolareshop/repositorio/powa2.jpeg https://sites.google.com/site/eletrolareshop/repositorio/powa3.jpeg ------------------------------------------------------------------------------------------------------- ------------------------ 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 Paulo | 4000000 Chui | 6 (5 rows) <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail> Livre de vírus. www.avast.com <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>. <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
