Re: POWA tool

On Wed, Aug 20, 2014 at 6:46 PM, Thomas Kellerer <spam_eater(at)gmx(dot)net> wrote:

> Ramesh T schrieb am 20.08.2014 um 17:41:
> > Hello,
> >
> > when i ran following query,
> > postgres=# SELECT * FROM pg_stat_statements;
> >
> >
> > ERROR: relation "pg_stat_statements" does not exist
> > LINE 1: SELECT * FROM pg_stat_statements;
> >
> >
> > i need to install POWA..i got powa.zip
>
> No, you need to install the extension pg_stat_statements:
>
> http://www.postgresql.org/docs/current/static/pgstatstatements.html
> http://www.postgresql.org/docs/current/static/sql-createextension.html
>

You also need the extensions plpgsql (which should already be installed)
and btree_gist.

When installing the powa extension (CREATE EXTENSION powa;), postgres will
warn you of missing dependancy if any.

You can also refer to the installation documentation (
https://github.com/dalibo/powa/blob/master/README.md).

Regards.
--
Julien Rouhaud
http://www.dalibo.com