Hi. I have a 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 profile it. I learned from Andreas Kretschmer (in another thread, in the pgsql-performance list) about the \timing directive, which is useful for this.
Now, after turning timing on, when I "source" the script from within psql, with mydb=> \i /path/to/my/script ...I get output lines like this Time: 38.519 ms right in my psql terminal after each statement in the file gets executed. But now I need a way to have these statements that are being timed themselves echoed to the terminal. Is there a way to do this? TIA! Kynn
