Search Postgresql Archives

How to echo statements in sourced file?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux