Horton

Re: doc fix for pg_stat_activity.backend_type

John Naylor <jcnaylor@gmail.com>

View thread View on postgr.es
From: John Naylor <jcnaylor@gmail.com>
To: Amit Kapila <amit.kapila16@gmail.com>
Cc: Michael Paquier <michael@paquier.xyz>, pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2018-11-13T12:56:37Z
Lists: pgsql-hackers 
On 11/13/18, Amit Kapila <amit.kapila16@gmail.com> wrote:
> On Tue, Nov 13, 2018 at 3:37 PM John Naylor <jcnaylor@gmail.com> wrote:
>>
>> On 11/13/18, Amit Kapila <amit.kapila16@gmail.com> wrote:
>> >
>> > Don't you need to remove <literal>background worker</literal>?
>>
>> It's handled in pgstat_get_backend_desc(), so I assumed not. If that's
>> just a place holder, then it's probably better left out, as in the
>> attached.
>>
>
> I don't think 'background worker' can be displayed as backend_type.

I think you're right (pgstatfuncs.c, starting at line 826).

-John Naylor

Commits

  1. Fix the omission in docs.

  2. Add background worker type

  3. Show more processes in pg_stat_activity.