Thread: 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/