Re: track row / field usage

Поиск
Список
Период
Сортировка
От brian
Тема Re: track row / field usage
Дата
Msg-id 46B8ECF2.9030407@zijn-digital.com
обсуждение исходный текст
Ответ на track row / field usage  ("John Smith" <jayzee.smith@gmail.com>)
Список pgsql-general
John Smith wrote:
> guys,
> i want to track just how many times a particular row, field or
> contained value gets queried / fetched? i guess a trigger like so
> would do the trick:
> on query, update value in column
> even a log and then parsing it would help. but is there a cooler way-
> some built-in stats counter? just trying to see which rows, fields or
> values are most sort after.
> cheers, jzs
>

Set the log_statement line in postgresql.conf to "all".

brian

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

Предыдущее
От: Kristo Kaiv
Дата:
Сообщение: Re: List tables in load order
Следующее
От: "Scott Marlowe"
Дата:
Сообщение: Re: Take your postgresSql on the road, and live to tell of it.