Hi,
Using the catalog tables, is there any way to correlate session id/user id
to which object (i.e. tables, indexes etc) it access and much how disk reads
or I/O wait has been done against the objects.
in general, I'd like to see which objects are being accessed by which user
and the time/amount o
S buffer cache, I need to monitor it as
well.
is there any place rather than pg_stat_activity that you think I should take
a look at?
Best Regard,
Adi
On Sun, Sep 12, 2010 at 4:04 PM, Craig Ringer
wrote:
> On 09/12/2010 06:52 PM, adi hirschtein wrote:
>
>> Hi,
>> Using the catalog ta
Thanks!
I'll look into those system tools and probably come back with some more
questions...
Best,
Adi
On Mon, Sep 13, 2010 at 4:58 AM, Craig Ringer
wrote:
> On 09/12/2010 10:02 PM, adi hirschtein wrote:
>
>> Hi Craig,
>>
>> Thanks a lot for the quick response!
ssion?
On Mon, Sep 13, 2010 at 6:57 PM, Greg Smith wrote:
> adi hirschtein wrote:
>
>> Using the catalog tables, is there any way to correlate session id/user id
>> to which object (i.e. tables, indexes etc) it access and much how disk reads
>> or I/O wait has been done
