Horton

Re: Add connection active, idle time to pg_stat_activity

David G. Johnston <david.g.johnston@gmail.com>

View thread
From: "David G. Johnston" <david.g.johnston@gmail.com>
To: Andres Freund <andres@anarazel.de>
Cc: Sergey Dudoladov <sergey.dudoladov@gmail.com>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>, torikoshia <torikoshia@oss.nttdata.com>, "Drouvot, Bertrand" <bdrouvot@amazon.com>, Julien Rouhaud <rjuju123@gmail.com>, Kyotaro Horiguchi <horikyota.ntt@gmail.com>, Kuntal Ghosh <kuntalghosh.2007@gmail.com>, Rafia Sabih <rafia.pghackers@gmail.com>
Date: 2022-11-09T02:43:54Z
Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

  1. Remove unstable pg_amcheck tests.

On Tue, Nov 8, 2022 at 7:37 PM Andres Freund <andres@anarazel.de> wrote:

> On 2022-11-08 19:25:27 -0700, David G. Johnston wrote:
> > Actually two, because I also suggest that not only is the duration
> recorded,
> > but a counter be incremented each time a given state becomes the
> currently
> > active state.  Seems like having access to a divisor of some form may be
> > useful.
>
> What for?
>

Because 5 hours of idle-in-transaction time in a single block means
something different than the same 5 hours accumulated across 300 mini-idles.

David J.