Postgres Pro
Downloads
Home   >   mailing lists

Monitoring Object access - Mailing list pgsql-general

From adi hirschtein
Subject Monitoring Object access
Date
Msg-id AANLkTinUDW8vwmFF935u8yuY3vSWuQpea6tEEfQzaPeU@mail.gmail.com
Whole thread Raw
Responses Re: Monitoring Object access  (Craig Ringer <craig@postnewspapers.com.au>)
Re: Monitoring Object access  (Greg Smith <greg@2ndquadrant.com>)
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: sunpeng
Date:
Subject: hi, how to let the inserted tuple visible to other backend when current backend hasn't finish?
Next
From: "J. Roeleveld"
Date:
Subject: Re: Incrementally Updated Backups