On Wed, Feb 22, 2023 at 07:17:37PM +0100, Daniel Gustafsson wrote: >> On 22 Feb 2023, at 19:14, Heikki Linnakangas <hlinn...@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.
+1 -- Nathan Bossart Amazon Web Services: https://aws.amazon.com
