Re: Proposal: %T Prompt parameter for psql for current time (like Oracle has) - Mailing list pgsql-hackers

From Daniel Gustafsson
Subject Re: Proposal: %T Prompt parameter for psql for current time (like Oracle has)
Date
Msg-id 022B754A-0D51-4549-9F9E-DB1CA62353F2@yesql.se
Whole thread Raw
In response to Re: Proposal: %T Prompt parameter for psql for current time (like Oracle has)  (Heikki Linnakangas <hlinnaka@iki.fi>)
Responses Re: Proposal: %T Prompt parameter for psql for current time (like Oracle has)
List pgsql-hackers
> On 22 Feb 2023, at 19:14, Heikki Linnakangas <hlinnaka@iki.fi> wrote:

> How about a new backslash command or psql variable to show how long the previous statement took? Something like:
>
> postgres=# select <unexpectedly slow query>
> ?column?
> ----------
>      123
> (1 row)
>
> postgres=# \time
>
> Time: 14011.975 ms (00:14.012)
>
> This would solve the "I forgot to time something" problem.

I don't have an opinion on adding a prompt option, but I've wanted this
(without realizing this was the format of it) many times.

--
Daniel Gustafsson




pgsql-hackers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: Proposal: %T Prompt parameter for psql for current time (like Oracle has)
Next
From: Pavel Stehule
Date:
Subject: Re: Proposal: %T Prompt parameter for psql for current time (like Oracle has)