Re: track row / field usage

From: brian <brian(at)zijn-digital(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: track row / field usage
Date: 2007-08-07 22:06:42
Message-ID: 46B8ECF2.9030407@zijn-digital.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2007-08-07 22:13:33 Re: Take your postgresSql on the road, and live to tell of it.
Previous Message Kristo Kaiv 2007-08-07 21:58:44 Re: List tables in load order