Re: RFC: replace pg_stat_activity.waiting with something more descriptive - Mailing list pgsql-hackers

From Tom Lane
Subject Re: RFC: replace pg_stat_activity.waiting with something more descriptive
Date
Msg-id 24985.1435008159@sss.pgh.pa.us
Whole thread Raw
In response to Re: RFC: replace pg_stat_activity.waiting with something more descriptive  (Merlin Moncure <mmoncure@gmail.com>)
List pgsql-hackers
Merlin Moncure <mmoncure@gmail.com> writes:
> On Mon, Jun 22, 2015 at 12:37 PM, Robert Haas <robertmhaas@gmail.com> wrote:
>> ...  The basic idea is that pg_stat_activity.waiting would be
>> replaced by a new column pg_stat_activity.wait_event, which would
>> display the reason why that backend is waiting.

> Instead of changing the column, can't we add a new one?  Adjusting
> columns in PSA requires the innumerable queries written against it to
> be adjusted along with all the wiki instructions to dev ops for
> emergency stuck query detection etc etc.

+1.  Removing the boolean column seems like it will arbitrarily break
a whole lot of client-side code, for not-very-adequate reasons.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Rajeev rastogi
Date:
Subject: Re: 9.5 release notes
Next
From: Tom Lane
Date:
Subject: Re: NULL passed as an argument to memcmp() in parse_func.c