Ben Webber wrote: > Hi, > > I wrote a shell script to find the duration and the related statement in the log file and place them one after the other if the duration is over a specified time like this:- > > 2008-10-31 02:00:49 GMT [23683] [mp_live] LOG: statement: CLUSTER; > 2008-10-31 02:04:42 GMT [23683] [mp_live] LOG: duration: 232783.684 ms I wonder if you'd benefit from doing CSV logs and then storing them into a table. Querying using SQL is probably going to be easier (and more robust -- it'd work even with embedded newlines etc). -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
