[PERFORM] How to profile an SQL script?

2008-12-03 Thread Kynn Jones
Hi. I have a longish collection of SQL statements stored in a file that I run periodically via cron. Running this script takes a bit too long, even for a cron job, and I would like to streamline it. Is there a way to tell Postgres to print out, after each SQL statement is executed, how long it

Re: [PERFORM] How to profile an SQL script?

2008-12-03 Thread Andreas Kretschmer
Kynn Jones [EMAIL PROTECTED] schrieb: Hi. I have a longish collection of SQL statements stored in a file that I run periodically via cron. Running this script takes a bit too long, even for a cron job, and I would like to streamline it. Is there a way to tell Postgres to print out, after

Re: [PERFORM] How to profile an SQL script?

2008-12-03 Thread Heikki Linnakangas
Andreas Kretschmer wrote: Kynn Jones [EMAIL PROTECTED] schrieb: Hi. I have a longish collection of SQL statements stored in a file that I run periodically via cron. Running this script takes a bit too long, even for a cron job, and I would like to streamline it. Is there a way to tell

Re: [PERFORM] How to profile an SQL script?

2008-12-03 Thread Kynn Jones
Andreas, Heikki: Thanks! Kynn