Thread: track row / field usage
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
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