Re: How to know server status variable in postgresql?

Поиск
Список
Период
Сортировка
От Sameer Kumar
Тема Re: How to know server status variable in postgresql?
Дата
Msg-id CADp-Sm6-O7dWM-BQ-tUL7c5sstK7LVf=Ppf=hi_TgW59pC7wuw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: How to know server status variable in postgresql?  (ambilalmca <ambilalmca@gmail.com>)
Ответы Re: How to know server status variable in postgresql?
Re: How to know server status variable in postgresql?
Список pgsql-general
Дерево обсуждения

On Fri, Jan 10, 2014 at 2:57 PM, ambilalmca <ambilalmca@gmail.com> wrote:
@ sameer khan,
That's Sameer Kumar :-)
i got query for all except
 
*Number of cached blocks read,
check pg_stat_all_tables
Number of cached index blocks read,
check pg_stat_all_indexes
Number of cached sequence blocks read*.
Why do you need this info?
can you tell query for these three counters only?



--
View this message in context: http://postgresql.1045698.n5.nabble.com/How-to-know-server-status-variable-in-postgresql-tp5785677p5786228.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

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

Предыдущее
От: Seref Arikan
Дата:
Сообщение: Do you have any best practices for managing large file's metadata with postgres?
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: pg_upgrade & tablespaces