| From: | SUBHAM ROY <subham(dot)iem(at)gmail(dot)com> |
|---|---|
| To: | raghu ram <raghuchennuru(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Needs Suggestion |
| Date: | 2011-04-22 18:12:55 |
| Message-ID: | BANLkTi=N5Ot_b0G+G5ha+AiygR1=c0gwxQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Sorry, but I'm not able to understand about how to use pgsnap for measuring
query performance. I have installed pgsnap. when I run pgsnap it shows some
error:
*Connecting to test database...
Adding some HTML files...
Getting Misc informations...
Getting General informations...
sh: pg_controldata: not found
Getting Global Informations...
pg_buffercache unavailable!
Getting Database Informations...
pg_buffercache unavailable!
pgstattuple unavailable!
pgstattuple on indexes unavailable!
Getting Current Activities Informations...
Getting Statistical Informations...
Getting Tools Informations...
pgPool unavailable!*
However,it generates few reports on the mentioned directory. But I am not
able to understand how to use it to measure the performance for each query
that I run.
--
Thank You,
Subham Roy,
CSE IIT Bombay.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Steve Crawford | 2011-04-22 18:35:44 | Re: converting databases form SQL_ASCII to UTF8 |
| Previous Message | Eric McKeeth | 2011-04-22 16:46:51 | Re: converting databases form SQL_ASCII to UTF8 |