Re: trailing comment ghost-timing - Mailing list pgsql-hackers

From Andres Freund
Subject Re: trailing comment ghost-timing
Date
Msg-id 20131224141934.GG26564@alap2.anarazel.de
Whole thread Raw
In response to trailing comment ghost-timing  ("Erik Rijkers" <er@xs4all.nl>)
Responses Re: trailing comment ghost-timing
Re: trailing comment ghost-timing
List pgsql-hackers
Hi,

On 2013-12-24 02:05:23 +0100, Erik Rijkers wrote:
> With \timing on, a trailing comment yields a timing.
> 
> # test.sql
> select 1;
> 
> /*
> select 2
> */
> 
> $ psql -f test.sql
>  ?column?
> ----------
>         1
> (1 row)
> 
> Time: 0.651 ms
> Time: 0.089 ms
> 
> I assume it is timing something about that comment (right?).
> 
> Confusing and annoying, IMHO.  Is there any chance such trailing ghost-timings can be removed?

Maybe I am thinking to technical here, but why would that be a good
idea? After all, the comment will have triggered sending a statement to
the server and waiting for the result. The user might want to know about
that.

Greetings,

Andres Freund

-- Andres Freund                       http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training &
Services



pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: better atomics - v0.2
Next
From: Andres Freund
Date:
Subject: Re: preserving forensic information when we freeze