Thread: POWA tool
On 20/08/2014 16:41, Ramesh T wrote: > 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 > please let me know how to install POWA.ZIP for my postgres using putty > tool .. What is POWA? Ray. -- Raymond O'Donnell :: Galway :: Ireland rod@iol.ie
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
On 08/20/2014 08:41 AM, Ramesh T wrote: > 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 > please let me know how to install POWA.ZIP for my postgres using putty > tool .. Have no idea what POWA is. As to your error: http://www.postgresql.org/docs/9.3/static/pgstatstatements.html > > thanks, > -- Adrian Klaver adrian.klaver@aklaver.com
On Wed, Aug 20, 2014 at 10:08 PM, Raymond O'Donnell <rod@iol.ie> wrote:
On 20/08/2014 16:41, Ramesh T wrote:
> 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
> please let me know how to install POWA.ZIP for my postgres using putty
> tool ..
Ramesh T schrieb am 20.08.2014 um 17:41:> Hello,No, you need to install the extension pg_stat_statements:
>
> 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
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
On Wed, Aug 20, 2014 at 10:08 PM, Raymond O'Donnell <rod@iol.ie> wrote:
On 20/08/2014 16:41, Ramesh T wrote:
> 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
> please let me know how to install POWA.ZIP for my postgres using putty
> tool ..are you referring below Tool ?PoWA is PostgreSQL Workload Analyzer that gathers performance stats and provides real-time charts and graph to help monitor and tune your PostgreSQL servers. It is similar to Oracle AWR or SQL Server MDW.Thanks & RegardsRaghu Ram
On Wed, Aug 20, 2014 at 6:46 PM, Thomas Kellerer <spam_eater@gmx.net> wrote:Ramesh T schrieb am 20.08.2014 um 17:41:> Hello,No, you need to install the extension pg_stat_statements:
>
> 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
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).
I just installed POWA and don't understand what mean in readme the configure guc ?
Added extension and I get working the GUI, I can login, but have no databases. How to add?
Thanks
Levi
Never mind. ... forget to restart the server with powa in shared_preload_librariesOn 20/08/2014 23:27, Julien Rouhaud wrote:On Wed, Aug 20, 2014 at 6:46 PM, Thomas Kellerer <spam_eater@gmx.net> wrote:Ramesh T schrieb am 20.08.2014 um 17:41:> Hello,No, you need to install the extension pg_stat_statements:
>
> 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
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).
I just installed POWA and don't understand what mean in readme the configure guc ?
Added extension and I get working the GUI, I can login, but have no databases. How to add?
Levi
yes,in my postgres.conf pg_stat_statements is not their needs powa is released 19 aug.On Wed, Aug 20, 2014 at 10:17 PM, Raghu Ram <raghuchennuru@gmail.com> wrote:On Wed, Aug 20, 2014 at 10:08 PM, Raymond O'Donnell <rod@iol.ie> wrote:
On 20/08/2014 16:41, Ramesh T wrote:
> 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
> please let me know how to install POWA.ZIP for my postgres using putty
> tool ..are you referring below Tool ?PoWA is PostgreSQL Workload Analyzer that gathers performance stats and provides real-time charts and graph to help monitor and tune your PostgreSQL servers. It is similar to Oracle AWR or SQL Server MDW.Thanks & RegardsRaghu Ram
How to include pg_stat_statements in postgres.conf.powa is need it.any help..
Below are the steps to Install POWA Tool:
Step 1: Download POWA tool from below Website
https://github.com/dalibo/powa/archive/REL_1_1.zip
Step 2: Unpack the Downloaded file
[root@localhost tmp]# cd /tmp/
[root@localhost powa-REL_1_1]# unzip powa-REL_1_1.zip
Step 3: Install POWA Software
[root@localhost powa-REL_1_1]# export PATH=/opt/PostgreSQL/9.3/bin:$PATH
[root@localhost powa-REL_1_1]# export LD_LIBRARY_PATH=/opt/PostgreSQL/9.3/lib:$LD_LIBRARY_PATH
[root@localhost powa-REL_1_1]# make install
gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -fpic -I. -I. -I/opt/PostgreSQL/9.3/include/postgresql/server -I/opt/PostgreSQL/9.3/include/postgresql/internal -D_GNU_SOURCE -I/opt/local/20140108/fc7f8f12-7861-11e3-aaff-000c29d23b02/include/libxml2 -I/usr/local/include/libxml2 -I/usr/local/include -c -o powa.o powa.c
gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -fpic -L/opt/PostgreSQL/9.3/lib -L/opt/local/20140108/fc7f8f12-7861-11e3-aaff-000c29d23b02/lib -L/usr/local/lib -Wl,--as-needed -Wl,-rpath,'/opt/PostgreSQL/9.3/lib',--enable-new-dtags -shared -o powa.so powa.o
/bin/mkdir -p '/opt/PostgreSQL/9.3/share/postgresql/extension'
/bin/mkdir -p '/opt/PostgreSQL/9.3/share/postgresql/extension'
/bin/mkdir -p '/opt/PostgreSQL/9.3/lib/postgresql'
/bin/mkdir -p '/opt/PostgreSQL/9.3/doc/postgresql/extension'
/usr/bin/install -c -m 644 ./powa.control '/opt/PostgreSQL/9.3/share/postgresql/extension/'
/usr/bin/install -c -m 644 ./powa--1.0.sql ./powa--1.1.sql '/opt/PostgreSQL/9.3/share/postgresql/extension/'
/usr/bin/install -c -m 755 powa.so '/opt/PostgreSQL/9.3/lib/postgresql/'
/usr/bin/install -c -m 644 ./README.md '/opt/PostgreSQL/9.3/doc/postgresql/extension/'
Step 4: Create a POWA database & Create requires extensions
-bash-4.1$ /opt/PostgreSQL/9.3/bin/psql -p 5435
Password:
psql.bin (9.3.5)
Type "help" for help.
postgres=# create database powa;
CREATE DATABASE
postgres=# \c powa
You are now connected to database "powa" as user "postgres".
powa=# create extension pg_stat_statements ;
CREATE EXTENSION
powa=# create extension btree_gist ;
CREATE EXTENSION
powa=# create extension powa;
CREATE EXTENSION
powa=# \dt
List of relations
Schema | Name | Type | Owner
--------+---------------------------------+-------+----------
public | powa_functions | table | postgres
public | powa_last_aggregation | table | postgres
public | powa_last_purge | table | postgres
public | powa_statements | table | postgres
public | powa_statements_history | table | postgres
public | powa_statements_history_current | table | postgres
(6 rows)
Step 5: add "power" & "pg_stat_statements" in the shared_preload_libraries in postgresql.conf file
-bash-4.1$ more /opt/PostgreSQL/9.3/data/postgresql.conf |grep shared_preload
# Note: Increasing max_prepared_transactions costs ~600 bytes of shared memory
shared_preload_libraries = 'powa,pg_stat_statements' # (change requires restart)
-bash-4.1$ /opt/PostgreSQL/9.3/bin/pg_ctl -D /opt/PostgreSQL/9.3/data/ start
server starting
-bash-4.1$ 2014-07-25 03:48:20 IST LOG: registering background worker "powa"
2014-07-25 03:48:20 IST LOG: loaded library "powa"
2014-07-25 03:48:20 IST LOG: loaded library "pg_stat_statements"
2014-07-25 03:48:20 IST LOG: redirecting log output to logging collector process
2014-07-25 03:48:20 IST HINT: Future log output will appear in directory "pg_log".
Step 6: Install Mojolicious Software
[root@localhost ui]# pwd
/tmp/powa-REL_1_1/ui
[root@localhost ui]# ls -l
total 36
drwxr-xr-x 4 root root 4096 Aug 19 2014 lib
-rw-r--r-- 1 root root 393 Jul 25 04:05 powa.conf
-rw-r--r-- 1 root root 393 Aug 19 2014 powa.conf-dist
drwxr-xr-x 6 root root 4096 Aug 19 2014 public
-rw-r--r-- 1 root root 2121 Aug 19 2014 README.md
drwxr-xr-x 2 root root 4096 Aug 19 2014 script
drwxr-xr-x 2 root root 4096 Aug 19 2014 t
drwxr-xr-x 6 root root 4096 Aug 19 2014 templates
-rw-r--r-- 1 root root 4 Aug 19 2014 VERSION
[root@localhost ui]# cp powa.conf-dist powa.conf
[root@localhost ~]# /usr/bin/curl get.mojolicio.us | sh
% Total % Received % Xferd Average Speed Time Time Time Current
Dload Upload Total Spent Left Speed
0 54 0 54 0 0 179 0 --:--:-- --:--:-- --:--:-- 184
% Total % Received % Xferd Average Speed Time Time Time Current
Dload Upload Total Spent Left Speed
100 262k 100 262k 0 0 70788 0 0:00:03 0:00:03 --:--:-- 120k
--> Working on Mojolicious
Fetching http://www.cpan.org/authors/id/S/SR/SRI/Mojolicious-5.33.tar.gz ... OK
Configuring Mojolicious-5.33 ... OK
Building Mojolicious-5.33 ... OK
Successfully installed Mojolicious-5.33
1 distribution installed
[root@localhost ui]# morbo script/powa
[Tue Aug 26 00:46:29 2014] [debug] Reading configuration file "/tmp/powa-REL_1_1/ui/powa.conf".
[Tue Aug 26 00:46:29 2014] [info] Listening at "http://*:3000".
Server available at http://127.0.0.1:3000.
Step 7: Run http://127.0.0.1:3000 in web browser.
Thanks & Regards
Raghu Ram
i downloaded But where i need to unzip powa-REL_1_1.zip i'm using putty tool remote server..-bash-4.1$ unzip powa-REL_1_1.zip-bash: unzip: command not found
1 | apt-get install unzip |
for Red Hat Linux/Fedora/CentOS users:
1 | yum install unzip |
i downloaded But where i need to unzip powa-REL_1_1.zip i'm using putty tool remote server..-bash-4.1$ unzip powa-REL_1_1.zip-bash: unzip: command not foundYou need to Install "unzip" utility. Once you installed "unzip" utility,you can extract in "/tmp" directory.
John McKown
On Fri, Aug 22, 2014 at 4:40 PM, Ramesh T <rameshparnanditech@gmail.com> wrote:How to include pg_stat_statements in postgres.conf.powa is need it.any help..Below are the steps to Install POWA Tool:
Step 1: Download POWA tool from below Website
https://github.com/dalibo/powa/archive/REL_1_1.zipStep 2: Unpack the Downloaded file
[root@localhost tmp]# cd /tmp/
[root@localhost powa-REL_1_1]# unzip powa-REL_1_1.zipStep 3: Install POWA Software
[root@localhost powa-REL_1_1]# export PATH=/opt/PostgreSQL/9.3/bin:$PATH
[root@localhost powa-REL_1_1]# export LD_LIBRARY_PATH=/opt/PostgreSQL/9.3/lib:$LD_LIBRARY_PATH
[root@localhost powa-REL_1_1]# make install
gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -fpic -I. -I. -I/opt/PostgreSQL/9.3/include/postgresql/server -I/opt/PostgreSQL/9.3/include/postgresql/internal -D_GNU_SOURCE -I/opt/local/20140108/fc7f8f12-7861-11e3-aaff-000c29d23b02/include/libxml2 -I/usr/local/include/libxml2 -I/usr/local/include -c -o powa.o powa.c
gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -fpic -L/opt/PostgreSQL/9.3/lib -L/opt/local/20140108/fc7f8f12-7861-11e3-aaff-000c29d23b02/lib -L/usr/local/lib -Wl,--as-needed -Wl,-rpath,'/opt/PostgreSQL/9.3/lib',--enable-new-dtags -shared -o powa.so powa.o
/bin/mkdir -p '/opt/PostgreSQL/9.3/share/postgresql/extension'
/bin/mkdir -p '/opt/PostgreSQL/9.3/share/postgresql/extension'
/bin/mkdir -p '/opt/PostgreSQL/9.3/lib/postgresql'
/bin/mkdir -p '/opt/PostgreSQL/9.3/doc/postgresql/extension'
/usr/bin/install -c -m 644 ./powa.control '/opt/PostgreSQL/9.3/share/postgresql/extension/'
/usr/bin/install -c -m 644 ./powa--1.0.sql ./powa--1.1.sql '/opt/PostgreSQL/9.3/share/postgresql/extension/'
/usr/bin/install -c -m 755 powa.so '/opt/PostgreSQL/9.3/lib/postgresql/'
/usr/bin/install -c -m 644 ./README.md '/opt/PostgreSQL/9.3/doc/postgresql/extension/'Step 4: Create a POWA database & Create requires extensions
-bash-4.1$ /opt/PostgreSQL/9.3/bin/psql -p 5435
Password:
psql.bin (9.3.5)
Type "help" for help.
postgres=# create database powa;
CREATE DATABASE
postgres=# \c powa
You are now connected to database "powa" as user "postgres".
powa=# create extension pg_stat_statements ;
CREATE EXTENSION
powa=# create extension btree_gist ;
CREATE EXTENSION
powa=# create extension powa;
CREATE EXTENSION
powa=# \dt
List of relations
Schema | Name | Type | Owner
--------+---------------------------------+-------+----------
public | powa_functions | table | postgres
public | powa_last_aggregation | table | postgres
public | powa_last_purge | table | postgres
public | powa_statements | table | postgres
public | powa_statements_history | table | postgres
public | powa_statements_history_current | table | postgres
(6 rows)Step 5: add "power" & "pg_stat_statements" in the shared_preload_libraries in postgresql.conf file
-bash-4.1$ more /opt/PostgreSQL/9.3/data/postgresql.conf |grep shared_preload
# Note: Increasing max_prepared_transactions costs ~600 bytes of shared memory
shared_preload_libraries = 'powa,pg_stat_statements' # (change requires restart)
-bash-4.1$ /opt/PostgreSQL/9.3/bin/pg_ctl -D /opt/PostgreSQL/9.3/data/ start
server starting
-bash-4.1$ 2014-07-25 03:48:20 IST LOG: registering background worker "powa"
2014-07-25 03:48:20 IST LOG: loaded library "powa"
2014-07-25 03:48:20 IST LOG: loaded library "pg_stat_statements"
2014-07-25 03:48:20 IST LOG: redirecting log output to logging collector process
2014-07-25 03:48:20 IST HINT: Future log output will appear in directory "pg_log".Step 6: Install Mojolicious Software
[root@localhost ui]# pwd
/tmp/powa-REL_1_1/ui
[root@localhost ui]# ls -l
total 36
drwxr-xr-x 4 root root 4096 Aug 19 2014 lib
-rw-r--r-- 1 root root 393 Jul 25 04:05 powa.conf
-rw-r--r-- 1 root root 393 Aug 19 2014 powa.conf-dist
drwxr-xr-x 6 root root 4096 Aug 19 2014 public
-rw-r--r-- 1 root root 2121 Aug 19 2014 README.md
drwxr-xr-x 2 root root 4096 Aug 19 2014 script
drwxr-xr-x 2 root root 4096 Aug 19 2014 t
drwxr-xr-x 6 root root 4096 Aug 19 2014 templates
-rw-r--r-- 1 root root 4 Aug 19 2014 VERSION
[root@localhost ui]# cp powa.conf-dist powa.conf
[root@localhost ~]# /usr/bin/curl get.mojolicio.us | sh
% Total % Received % Xferd Average Speed Time Time Time Current
Dload Upload Total Spent Left Speed
0 54 0 54 0 0 179 0 --:--:-- --:--:-- --:--:-- 184
% Total % Received % Xferd Average Speed Time Time Time Current
Dload Upload Total Spent Left Speed
100 262k 100 262k 0 0 70788 0 0:00:03 0:00:03 --:--:-- 120k
--> Working on Mojolicious
Fetching http://www.cpan.org/authors/id/S/SR/SRI/Mojolicious-5.33.tar.gz ... OK
Configuring Mojolicious-5.33 ... OK
Building Mojolicious-5.33 ... OK
Successfully installed Mojolicious-5.33
1 distribution installed
[root@localhost ui]# morbo script/powa
[Tue Aug 26 00:46:29 2014] [debug] Reading configuration file "/tmp/powa-REL_1_1/ui/powa.conf".
[Tue Aug 26 00:46:29 2014] [info] Listening at "http://*:3000".
Server available at http://127.0.0.1:3000.
Step 7: Run http://127.0.0.1:3000 in web browser.
Thanks & Regards
Raghu Ram