Monitoring Object access

From: adi hirschtein <adiso75(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Monitoring Object access
Date: 2010-09-12 10:52:57
Message-ID: AANLkTinUDW8vwmFF935u8yuY3vSWuQpea6tEEfQzaPeU@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 of I/O wait/reads.

Thanks in advance,
Adi

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2010-09-12 11:32:00 Re: Incrementally Updated Backups
Previous Message J. Roeleveld 2010-09-12 10:18:10 Re: Incrementally Updated Backups