Re: Needs Suggestion

[SUBHAM ROY <subham.iem@xxxxxxxxx>]

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.