Re: psql \watch 2nd argument: iteration count

Peter Eisentraut <peter.eisentraut@enterprisedb.com>

From: Peter Eisentraut <peter.eisentraut@enterprisedb.com>
To: Andrey Borodin <amborodin86@gmail.com>, pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2023-02-20T14:23:27Z
Lists: pgsql-hackers
On 17.02.23 00:33, Andrey Borodin wrote:
>  From time to time I want to collect some stats from locks, activity
> and other stat views into one table from different time points. In
> this case the \watch psql command is very handy. However, it's not
> currently possible to specify the number of times a query is
> performed.

The watch command on my OS has a lot of options, but this is not one of 
them.  So probably no one has really needed it so far.

> Also, if we do not provide a timespan, 2 seconds are selected. But if
> we provide an incorrect argument - 1 second is selected.
> PFA the patch that adds iteration count argument and makes timespan
> argument more consistent.

That should probably be fixed.




Commits

  1. psql: add an optional execution-count limit to \watch.

  2. Improve handling of psql \watch's interval argument