track row / field usage

From: "John Smith" <jayzee(dot)smith(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: track row / field usage
Date: 2007-08-07 20:15:32
Message-ID: f029597e0708071315x297ab52dpf9b1acf11ff271fa@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Owen Hartnett 2007-08-07 20:40:01 Take your postgresSql on the road, and live to tell of it.
Previous Message Arthernan 2007-08-07 19:53:14 Re: Internal Postgre SQL documentation