| From: | Neto pr <netopr9(at)gmail(dot)com> | 
|---|---|
| To: | postgres performance list <pgsql-performance(at)postgresql(dot)org> | 
| Subject: | POWA doesn't show queries executed | 
| Date: | 2017-11-18 01:52:04 | 
| Message-ID: | CA+wPC0NK+GCEED80iX4_82dLds9CxDK_ak4R9WhoCBSqkd2YMQ@mail.gmail.com | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-performance | 
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>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mariel Cherkassky | 2017-11-20 09:02:40 | PostgreSQL 9.6 wals management | 
| Previous Message | David Rowley | 2017-11-15 23:47:29 | Re: CREATE STATISTICS and join selectivity |