| From: | Peter Eisentraut <peter(dot)eisentraut(at)enterprisedb(dot)com> |
|---|---|
| To: | Andrey Borodin <amborodin86(at)gmail(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: psql \watch 2nd argument: iteration count |
| Date: | 2023-02-20 14:23:27 |
| Message-ID: | 8f133e7d-0803-9280-78ba-19d2db796176@enterprisedb.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bharath Rupireddy | 2023-02-20 14:30:00 | Re: Add WAL read stats to pg_stat_wal |
| Previous Message | Peter Eisentraut | 2023-02-20 14:04:54 | Re: some namespace.c refactoring |