Re: [HACKERS] stats_command_string default? - Mailing list pgsql-patches

From Bruce Momjian
Subject Re: [HACKERS] stats_command_string default?
Date
Msg-id 200303201851.h2KIpLd29900@candle.pha.pa.us
Whole thread Raw
In response to Re: [HACKERS] stats_command_string default?  (Kevin Brown <kevin@sysexperts.com>)
List pgsql-patches
Patch applied.  Thanks.

I merge the SGML in around recent additions.

---------------------------------------------------------------------------



Kevin Brown wrote:
> Tom Lane wrote:
> > Kevin Brown <kevin@sysexperts.com> writes:
> > >>> It would also be handy if users could see their own queries while the
> > >>> rest remain blank.
> > >>
> > >> Seems reasonable offhand ...
> >
> > > Here's the patch to make this happen.  The first is against 7.2.4, the
> > > second is against CVS tip.
> >
> > You forgot documentation fixes.  Certainly the entry in
> > http://www.ca.postgresql.org/users-lounge/docs/7.3/postgres/monitoring-stats.html#MONITORING-STATS-VIEWS
> > needs to change; not sure if there are any other places, but that's your
> > task to look...
>
> Ooops.  Okay, the attached patch attached fixes that as well.  The
> only references to pg_stat_get_backend_activity(), pg_stat_activity,
> or stats_command_string that needed to be changed were those in
> doc/src/monitoring.sgml.  If I missed something let me know.
>
> So: the following patch fixes doc/src/monitoring.sgml and
> src/backend/utils/adt/pgstatfuncs.c to make it possible to see your
> own queries when looking at pg_stat_activity or when using the
> pg_stat_get_backend_activity function.  The patch is against the
> current (as of now :-) CVS tip.
>
> --
> Kevin Brown                          kevin@sysexperts.com

[ Attachment, skipping... ]

>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

pgsql-patches by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: pg_autovacuum (pg_avd version 2)
Next
From: Bruce Momjian
Date:
Subject: Re: Dump CLUSTER in pg_dump