Re: Needs Suggestion

Поиск
Список
Период
Сортировка
От SUBHAM ROY
Тема Re: Needs Suggestion
Дата
Msg-id BANLkTi=N5Ot_b0G+G5ha+AiygR1=c0gwxQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Needs Suggestion  (raghu ram <raghuchennuru@gmail.com>)
Список 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.

В списке pgsql-general по дате отправления:

Предыдущее
От: Eric McKeeth
Дата:
Сообщение: Re: converting databases form SQL_ASCII to UTF8
Следующее
От: Steve Crawford
Дата:
Сообщение: Re: converting databases form SQL_ASCII to UTF8