track row / field usage

Started by John Smithover 18 years ago2 messagesgeneral
Jump to latest
#1John Smith
jayzee.smith@gmail.com

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

#2brian
brian@zijn-digital.com
In reply to: John Smith (#1)
Re: track row / field usage

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