From: | Kevin Brown <kevin(at)sysexperts(dot)com> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Cc: | pgsql-patches(at)postgresql(dot)org |
Subject: | Re: stats_command_string default? |
Date: | 2003-03-07 07:07:52 |
Message-ID: | 20030307070752.GW1833@filer |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-patches |
Tom Lane wrote:
> Kevin Brown <kevin(at)sysexperts(dot)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(at)sysexperts(dot)com
Attachment | Content-Type | Size |
---|---|---|
pgsql-tip-stat-activity.diff | text/plain | 2.5 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2003-03-07 08:18:47 | Re: Win32 Powerfail testing |
Previous Message | Christopher Kings-Lynne | 2003-03-07 05:48:53 | Re: Brain dump: btree collapsing |
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2003-03-07 16:27:13 | Re: [PATCHES] ALTER SEQUENCE |
Previous Message | Tom Lane | 2003-03-07 05:07:56 | Re: stats_command_string default? |