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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings