Tom Lane wrote:
> Alvaro Herrera <[EMAIL PROTECTED]> writes:
> > The problem is that pgstat_bestart (called in InitPostgres, which
> > autovac calls) deliberately ignores autovacuum, due to not having a
> > client address. We could create a fake client address (which doesn't
> > seem easy to do), or we could change pg_stat_activity to use an OUTER
> > JOIN. Not sure what other options are there.
>
> Seems like the client address should read as NULL. Not sure if that's
> hard or not. Changing the view definition is no fun (at least for an
> 8.1 back-patch) because it'd require initdb.
This seems to work for me. I'd appreciate input, as I'm not sure how
would other archs (or even my own) cope with the zeroed client address
trick (note the memcmp ...)
This is the 8.1 version of the patch; I haven't looked at HEAD yet, but
I think it's slightly different.
(The actual activity reported is a bit bogus ... I'd appreciate
suggestions for better wording. Do I waste cycles in obtaining the
relname? My answer is yes. What if there are multiple rels (a case
currently not exercised)?. Should it explicitly say that it's
autovacuum? My answer is no.)
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
Index: src/backend/postmaster/autovacuum.c
===================================================================
RCS file: /home/alvherre/cvs/pgsql/src/backend/postmaster/autovacuum.c,v
retrieving revision 1.5.2.5
diff -c -r1.5.2.5 autovacuum.c
*** src/backend/postmaster/autovacuum.c 20 Jan 2006 15:17:13 -0000 1.5.2.5
--- src/backend/postmaster/autovacuum.c 18 May 2006 23:02:56 -0000
***************
*** 108,113 ****
--- 108,115 ----
List **toast_table_ids);
static void autovacuum_do_vac_analyze(List *relids, bool dovacuum,
bool doanalyze, bool freeze);
+ static void autovac_report_activity(VacuumStmt *vacstmt,
+ List *relids);
/*
***************
*** 892,897 ****
--- 894,902 ----
VacuumStmt *vacstmt;
MemoryContext old_cxt;
+ /* Let pgstat know what we're doing */
+ autovac_report_activity(vacstmt, relids);
+
/*
* The node must survive transaction boundaries, so make sure we create
it
* in a long-lived context
***************
*** 922,927 ****
--- 927,951 ----
MemoryContextSwitchTo(old_cxt);
}
+ static void
+ autovac_report_activity(VacuumStmt *vacstmt, List *relids)
+ {
+ #define MAX_AUTOVAC_ACTIV_LEN 64
+ char activity[MAX_AUTOVAC_ACTIV_LEN];
+
+ if (list_length(relids) == 0)
+ snprintf(activity, MAX_AUTOVAC_ACTIV_LEN,
+ "whole database vacuum");
+ else if (list_length(relids) == 1)
+ snprintf(activity, MAX_AUTOVAC_ACTIV_LEN,
+ "VACUUM rel %u", linitial_oid(relids));
+ else
+ snprintf(activity, MAX_AUTOVAC_ACTIV_LEN,
+ "VACUUM rels %u ...", linitial_oid(relids));
+
+ pgstat_report_activity(activity);
+ }
+
/*
* AutoVacuumingActive
* Check GUC vars and report whether the autovacuum process should
be
Index: src/backend/postmaster/pgstat.c
===================================================================
RCS file: /home/alvherre/cvs/pgsql/src/backend/postmaster/pgstat.c,v
retrieving revision 1.111.2.2
diff -c -r1.111.2.2 pgstat.c
*** src/backend/postmaster/pgstat.c 18 Jan 2006 20:35:16 -0000
1.111.2.2
--- src/backend/postmaster/pgstat.c 18 May 2006 23:05:10 -0000
***************
*** 691,707 ****
/*
* We may not have a MyProcPort (eg, if this is the autovacuum process).
! * For the moment, punt and don't send BESTART --- would be better to
work
! * out a clean way of handling "unknown clientaddr".
*/
if (MyProcPort)
- {
- pgstat_setheader(&msg.m_hdr, PGSTAT_MTYPE_BESTART);
- msg.m_databaseid = MyDatabaseId;
- msg.m_userid = GetSessionUserId();
memcpy(&msg.m_clientaddr, &MyProcPort->raddr,
sizeof(msg.m_clientaddr));
! pgstat_send(&msg, sizeof(msg));
! }
/*
* Set up a process-exit hook to ensure we flush the last batch of
--- 691,707 ----
/*
* We may not have a MyProcPort (eg, if this is the autovacuum process).
! * Send an all-zeroes client address, which is dealt with specially in
! * pg_stat_get_backend_client_addr and pg_stat_get_backend_client_port.
*/
+ pgstat_setheader(&msg.m_hdr, PGSTAT_MTYPE_BESTART);
+ msg.m_databaseid = MyDatabaseId;
+ msg.m_userid = GetSessionUserId();
if (MyProcPort)
memcpy(&msg.m_clientaddr, &MyProcPort->raddr,
sizeof(msg.m_clientaddr));
! else
! MemSet(&msg.m_clientaddr, 0, sizeof(msg.m_clientaddr));
! pgstat_send(&msg, sizeof(msg));
/*
* Set up a process-exit hook to ensure we flush the last batch of
Index: src/backend/postmaster/postmaster.c
===================================================================
RCS file: /home/alvherre/cvs/pgsql/src/backend/postmaster/postmaster.c,v
retrieving revision 1.475.2.4
diff -c -r1.475.2.4 postmaster.c
*** src/backend/postmaster/postmaster.c 18 Mar 2006 22:10:11 -0000
1.475.2.4
--- src/backend/postmaster/postmaster.c 18 May 2006 20:50:33 -0000
***************
*** 2135,2140 ****
--- 2135,2143 ----
{
AutoVacPID = 0;
autovac_stopped();
+ /* Tell the collector about process termination */
+ pgstat_beterm(pid);
+
if (exitstatus != 0)
HandleChildCrash(pid, exitstatus,
_("autovacuum
process"));
Index: src/backend/utils/adt/pgstatfuncs.c
===================================================================
RCS file: /home/alvherre/cvs/pgsql/src/backend/utils/adt/pgstatfuncs.c,v
retrieving revision 1.26
diff -c -r1.26 pgstatfuncs.c
*** src/backend/utils/adt/pgstatfuncs.c 17 Oct 2005 16:24:19 -0000 1.26
--- src/backend/utils/adt/pgstatfuncs.c 18 May 2006 23:10:41 -0000
***************
*** 389,394 ****
--- 389,395 ----
pg_stat_get_backend_client_addr(PG_FUNCTION_ARGS)
{
PgStat_StatBeEntry *beentry;
+ SockAddr zero_clientaddr;
int32 beid;
char remote_host[NI_MAXHOST];
int ret;
***************
*** 405,410 ****
--- 406,417 ----
if (!superuser() && beentry->userid != GetUserId())
PG_RETURN_NULL();
+ /* A zeroed client addr means we don't know */
+ memset(&zero_clientaddr, 0, sizeof(zero_clientaddr));
+ if (memcmp(&(beentry->clientaddr), &zero_clientaddr,
+ sizeof(zero_clientaddr) == 0))
+ PG_RETURN_NULL();
+
switch (beentry->clientaddr.addr.ss_family)
{
case AF_INET:
***************
*** 432,437 ****
--- 439,445 ----
pg_stat_get_backend_client_port(PG_FUNCTION_ARGS)
{
PgStat_StatBeEntry *beentry;
+ SockAddr zero_clientaddr;
int32 beid;
char remote_port[NI_MAXSERV];
int ret;
***************
*** 448,453 ****
--- 456,467 ----
if (!superuser() && beentry->userid != GetUserId())
PG_RETURN_NULL();
+ /* A zeroed client addr means we don't know */
+ memset(&zero_clientaddr, 0, sizeof(zero_clientaddr));
+ if (memcmp(&(beentry->clientaddr), &zero_clientaddr,
+ sizeof(zero_clientaddr) == 0))
+ PG_RETURN_NULL();
+
switch (beentry->clientaddr.addr.ss_family)
{
case AF_INET:
Index: src/interfaces/libpq/fe-connect.c
===================================================================
RCS file: /home/alvherre/cvs/pgsql/src/interfaces/libpq/fe-connect.c,v
retrieving revision 1.323.2.1
diff -c -r1.323.2.1 fe-connect.c
*** src/interfaces/libpq/fe-connect.c 22 Nov 2005 18:23:29 -0000
1.323.2.1
--- src/interfaces/libpq/fe-connect.c 18 May 2006 22:04:15 -0000
***************
*** 2081,2087 ****
* A copy is needed to be able to cancel a running query from a different
* thread. If the same structure is used all structure members would have
* to be individually locked (if the entire structure was locked, it would
! * be impossible to cancel a synchronous query becuase the structure would
* have to stay locked for the duration of the query).
*/
PGcancel *
--- 2081,2087 ----
* A copy is needed to be able to cancel a running query from a different
* thread. If the same structure is used all structure members would have
* to be individually locked (if the entire structure was locked, it would
! * be impossible to cancel a synchronous query because the structure would
* have to stay locked for the duration of the query).
*/
PGcancel *
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
