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/ -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
