psql \timing vs failed statements
Right now, psql \timing output only gives output for successful
queries. Is there any actual reason for this, or just a "it happened"?
In particular,I just had a very long run of a CREATE UNIQUE INDEX fail
pretty far in - and I would've really liked to have timing output for
that one even though it failed.
Thus - if I were to change psql to output timing on failed queries as
well, will anybody object? ;)
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
On Tue, Jan 17, 2012 at 10:01 AM, Magnus Hagander <magnus@hagander.net> wrote:
Right now, psql \timing output only gives output for successful
queries. Is there any actual reason for this, or just a "it happened"?In particular,I just had a very long run of a CREATE UNIQUE INDEX fail
pretty far in - and I would've really liked to have timing output for
that one even though it failed.Thus - if I were to change psql to output timing on failed queries as
well, will anybody object? ;)
I won't.
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
On Tue, Jan 17, 2012 at 04:01:23PM +0100, Magnus Hagander wrote:
Thus - if I were to change psql to output timing on failed queries as
well, will anybody object? ;)
+1
On Wed, Jan 18, 2012 at 06:28, Noah Misch <noah@leadboat.com> wrote:
On Tue, Jan 17, 2012 at 04:01:23PM +0100, Magnus Hagander wrote:
Thus - if I were to change psql to output timing on failed queries as
well, will anybody object? ;)+1
Done and applied.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/