Monitoring Object access

Поиск
Список
Период
Сортировка
От adi hirschtein
Тема Monitoring Object access
Дата
Msg-id AANLkTinUDW8vwmFF935u8yuY3vSWuQpea6tEEfQzaPeU@mail.gmail.com
обсуждение исходный текст
Ответы Re: Monitoring Object access  (Craig Ringer <craig@postnewspapers.com.au>)
Re: Monitoring Object access  (Greg Smith <greg@2ndquadrant.com>)
Список 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

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

Предыдущее
От: sunpeng
Дата:
Сообщение: hi, how to let the inserted tuple visible to other backend when current backend hasn't finish?
Следующее
От: "J. Roeleveld"
Дата:
Сообщение: Re: Incrementally Updated Backups