Re: psql \watch 2nd argument: iteration count - Mailing list pgsql-hackers

From Stephen Frost
Subject Re: psql \watch 2nd argument: iteration count
Date
Msg-id Y/OGUo+nTiCkustL@tamriel.snowman.net
Whole thread Raw
In response to Re: psql \watch 2nd argument: iteration count  (Peter Eisentraut <peter.eisentraut@enterprisedb.com>)
Responses Re: psql \watch 2nd argument: iteration count
List 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

Attachment

pgsql-hackers by date:

Previous
From: Justin Pryzby
Date:
Subject: Re: Add support for unit "B" to pg_size_pretty()
Next
From: Erik Rijkers
Date:
Subject: Re: SQL/JSON revisited