From: | Chris <dmagick(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: is any of the SQL parser exposed ? |
Date: | 2010-11-25 02:34:50 |
Message-ID: | 4CEDCB4A.2020704@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 25/11/10 13:04, Mark Rostron wrote:
> Hi
>
> We are running a mixture of 8.3 and 8.4 server versions.
>
> We are putting together a historical log of statement patterns of long
> running statement output ( via log_min_duration_statement), extracted
> from csv files in pg_log.
>
> I would like to take a statement of form, say,
>
> “select columns from mytable where column1 = “hard-code-text-value’” (or
> whatever)
>
> And then store it as a more general pattern like
> “select columns from mytable where column1 = $1”
>
> The latter form would be more useful for profiling an app.
Check out pgfouine - http://pgfouine.projects.postgresql.org/ - it
already does all of that sort of thing for you.
--
Postgresql & php tutorials
http://www.designmagick.com/
From | Date | Subject | |
---|---|---|---|
Next Message | Troy Rasiah | 2010-11-25 05:34:43 | Use of search path in plpgsql functions, PG 8.3.12 |
Previous Message | Mark Rostron | 2010-11-25 02:04:22 | is any of the SQL parser exposed ? |