Message-ID: <e0320ffa-97ac-5976-ea76-2b9e87dd054c@iki.fi>
Date: Thu, 23 Feb 2023 14:09:19 +0200
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101
 Thunderbird/102.6.0
Subject: Re: Proposal: %T Prompt parameter for psql for current time (like
 Oracle has)
Content-Language: en-US
To: Peter Eisentraut <peter.eisentraut@enterprisedb.com>,
 Nikolay Samokhvalov <samokhvalov@gmail.com>, Tom Lane <tgl@sss.pgh.pa.us>,
 Kirk Wolak <wolakk@gmail.com>
Cc: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>,
 Pavel Stehule <pavel.stehule@gmail.com>, amborodin86@gmail.com,
 Laurenz Albe <laurenz.albe@cybertec.at>
References: <CACLU5mSRwHr_8z=enMj-nXF1tmC7+Jn5heZQNiKuLyxYUtL2fg@mail.gmail.com>
 <157609.1677088525@sss.pgh.pa.us>
 <CANNMO+KqqM0YpVUmVDec+9nku9ai9T=Y5Tp=pZ0rp1jR3d8kqA@mail.gmail.com>
 <f4013949-746d-23e7-118d-6a7e9fa70c37@iki.fi>
 <2f1c8cb9-6f4d-2a03-d069-c4f9c2b574ab@enterprisedb.com>
From: Heikki Linnakangas <hlinnaka@iki.fi>
In-Reply-To: <2f1c8cb9-6f4d-2a03-d069-c4f9c2b574ab@enterprisedb.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Archived-At: <https://www.postgresql.org/message-id/e0320ffa-97ac-5976-ea76-2b9e87dd054c%40iki.fi>
Precedence: bulk

On 23/02/2023 13:20, Peter Eisentraut wrote:
> On 22.02.23 19:14, Heikki Linnakangas wrote:
>> How about a new backslash command or psql variable to show how long the
>> previous statement took? Something like:
> 
> If you don't have \timing turned on before the query starts, psql won't
> record what the time was before the query, so you can't compute the run
> time afterwards.  This kind of feature would only work if you always
> take the start time, even if \timing is turned off.

Correct. That seems acceptable though? gettimeofday() can be slow on 
some platforms, but I doubt it's *that* slow, that we couldn't call it 
two times per query.

- Heikki