psql now shows zero elapsed time after an error
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Peter Eisentraut <peter.eisentraut@enterprisedb.com>,
Fabien COELHO <coelho@cri.ensmp.fr>
Cc: pgsql-hackers@lists.postgresql.org
Date: 2022-05-09T15:56:05Z
Lists: pgsql-hackers
Example (you need up-to-the-minute HEAD for this particular test
case, but anything that runs a little while before failing will do):
regression=# \timing
Timing is on.
regression=# select * from generate_series('2022-01-01 00:00'::timestamptz,
'infinity'::timestamptz,
'1 month'::interval) limit 10;
ERROR: timestamp out of range
Time: 0.000 ms
That timing is wrong. It visibly takes more-or-less half a second
on my machine, and v14 psql reports that accurately:
regression=# \timing
Timing is on.
regression=# select * from generate_series('2022-01-01 00:00'::timestamptz,
'infinity'::timestamptz,
'1 month'::interval) limit 10;
ERROR: timestamp out of range
Time: 662.107 ms
While I've not bisected, I think it's a dead cinch that 7844c9918
is what broke this.
regards, tom lane
Commits
-
psql: Update \timing also in case of an error
- 9520f8d92a86 15.0 landed