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
-
psql: add an optional execution-count limit to \watch.
- 00beecfe839c 16.0 landed
-
Improve handling of psql \watch's interval argument
- 6f9ee74d45aa 16.0 landed