Re: psql \watch 2nd argument: iteration count

Поиск
Список
Период
Сортировка
От Stephen Frost
Тема Re: psql \watch 2nd argument: iteration count
Дата
Msg-id Y/OGUo+nTiCkustL@tamriel.snowman.net
обсуждение исходный текст
Ответ на Re: psql \watch 2nd argument: iteration count  (Peter Eisentraut <peter.eisentraut@enterprisedb.com>)
Ответы Re: psql \watch 2nd argument: iteration count  (Andrey Borodin <amborodin86@gmail.com>)
Список pgsql-hackers
Greetings,

* Peter Eisentraut (peter.eisentraut@enterprisedb.com) wrote:
> 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.

watch doesn't ... but top does, and I can certainly see how our watch
having an iterations count could be helpful in much the same way as
top's batch mode does.

> > 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.

And should probably be independent patches.

Thanks,

Stephen

Вложения

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Justin Pryzby
Дата:
Сообщение: Re: Add support for unit "B" to pg_size_pretty()
Следующее
От: Erik Rijkers
Дата:
Сообщение: Re: SQL/JSON revisited