On Sun, Jan 4, 2009 at 7:01 PM, Craig Ringer <[email protected]> wrote: > Alternately, rather than doing everything within PL/PgSQL, just do it from > normal SQL, issued through psql. That way you can just use \timing . > > For simple one-liners, instead of: > > psql -d DB1 -c 'select execute_function_foo();' > > you can write: > > psql -d DB1 <<__END__ > \timing > select execute_function_foo(); > __END__
Or just add \timing to your .psqlrc file for simplicity eg. $ cat ~postgres/.psqlrc \timing -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
