Re: Dynamic Catalog Views
| От | raghavendra t |
|---|---|
| Тема | Re: Dynamic Catalog Views |
| Дата | |
| Msg-id | g2ibc7de5a31004131004ucdf055eas6db58a160b1dc193@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Dynamic Catalog Views (tv@fuzzy.cz) |
| Ответы |
Re: Dynamic Catalog Views
|
| Список | pgsql-general |
Hi All,
Thank you for your support.
Yes, i tried with pg_buffercache, it is giving the information on the hit ratio of shared_buffers. Can we get the dynamic information like in oracle(v$) views. Same as in postgresql buffers(shared,temp,wal) & cache(maintainence_work_me, effective_mem).
Thanks & Regards
Raghavendra
2010/4/13 <tv@fuzzy.cz>
It's not accessible by default, but there is contrib package called> raghavendra t wrote:
>> Hi All,
>>
>> Could please guide me in knowing the Dynamic Catalog views which will
>> tell about the Buffers and Cache information using System Catalogs.
>>
>
> you mean, stuff like
> http://www.postgresql.org/docs/current/static/catalog-pg-statistic.html ?
>
> afaik, data about whats in the cache and buffers is not accessible via
> any pg_catalog schema tables.
'pg_buffercache':
I guess that might provide the information about buffers.
Tomas
--
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 по дате отправления: