On Wed, Aug 20, 2014 at 6:46 PM, Thomas Kellerer <spam_ea...@gmx.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