Обсуждение: is possible enforce \timing on from command line
Helllo I try to search simple solution and I didn't find anything. It is possible? Regards Pavel Stehule
postgres=# \timing Timing is on. postgres=# SELECT now(); now ----------------------------2012-12-17 15:56:39.655+07 (1 row) Time: 11.429 ms postgres=# -- View this message in context: http://postgresql.1045698.n5.nabble.com/is-possible-enforce-timing-on-from-command-line-tp5736858p5736860.html Sent from the PostgreSQL - hackers mailing list archive at Nabble.com.
On Mon, December 17, 2012 09:54, Pavel Stehule wrote: > Helllo > > I try to search simple solution and I didn't find anything. It is possible? > Perhaps not strictly 1 commandline but I often use this: echo '\timing on \\ select 1+2' | psql Erik Rijkers
Hello Thank you, batI though a o.s. command line. Best regards Pavel Stehule 2012/12/17 classical_89 <luongnx512@gmail.com>: > > > postgres=# \timing > Timing is on. > postgres=# SELECT now(); > now > ---------------------------- > 2012-12-17 15:56:39.655+07 > (1 row) > > > Time: 11.429 ms > postgres=# > > > > > > -- > View this message in context: http://postgresql.1045698.n5.nabble.com/is-possible-enforce-timing-on-from-command-line-tp5736858p5736860.html > Sent from the PostgreSQL - hackers mailing list archive at Nabble.com. > > > -- > Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-hackers