diff options
| author | Neil Conway <neilc@samurai.com> | 2005-05-09 11:31:34 +0000 |
|---|---|---|
| committer | Neil Conway <neilc@samurai.com> | 2005-05-09 11:31:34 +0000 |
| commit | 4744c1a0a16d4fdad4196c9874e050936e1133ed (patch) | |
| tree | f7d0464971f8d6046e0b3e8522e211869e14bbc7 /src/backend/postmaster | |
| parent | d8c21181ce406b313bddfdaf49d66458942c16ed (diff) | |
| download | postgresql-4744c1a0a16d4fdad4196c9874e050936e1133ed.tar.gz | |
Complete the following TODO items:
* Add session start time to pg_stat_activity
* Add the client IP address and port to pg_stat_activity
Original patch from Magnus Hagander, code review by Neil Conway. Catalog
version bumped. This patch sends the client IP address and port number in
every statistics message; that's not ideal, but will be fixed up shortly.
Diffstat (limited to 'src/backend/postmaster')
| -rw-r--r-- | src/backend/postmaster/pgstat.c | 12 |
1 files changed, 7 insertions, 5 deletions
diff --git a/src/backend/postmaster/pgstat.c b/src/backend/postmaster/pgstat.c index e21adab7ca..a219637319 100644 --- a/src/backend/postmaster/pgstat.c +++ b/src/backend/postmaster/pgstat.c @@ -13,7 +13,7 @@ * * Copyright (c) 2001-2005, PostgreSQL Global Development Group * - * $PostgreSQL: pgsql/src/backend/postmaster/pgstat.c,v 1.92 2005/04/14 20:32:42 tgl Exp $ + * $PostgreSQL: pgsql/src/backend/postmaster/pgstat.c,v 1.93 2005/05/09 11:31:33 neilc Exp $ * ---------- */ #include "postgres.h" @@ -1300,6 +1300,7 @@ pgstat_setheader(PgStat_MsgHdr *hdr, int mtype) hdr->m_procpid = MyProcPid; hdr->m_databaseid = MyDatabaseId; hdr->m_userid = GetSessionUserId(); + memcpy(&hdr->m_clientaddr, &MyProcPort->raddr, sizeof(hdr->m_clientaddr)); } @@ -2032,12 +2033,15 @@ pgstat_add_backend(PgStat_MsgHdr *msg) beentry->databaseid = msg->m_databaseid; beentry->procpid = msg->m_procpid; beentry->userid = msg->m_userid; + beentry->start_sec = + GetCurrentAbsoluteTimeUsec(&beentry->start_usec); beentry->activity_start_sec = 0; beentry->activity_start_usec = 0; + memcpy(&beentry->clientaddr, &msg->m_clientaddr, sizeof(beentry->clientaddr)); MemSet(beentry->activity, 0, PGSTAT_ACTIVITY_SIZE); /* - * Lookup or create the database entry for this backends DB. + * Lookup or create the database entry for this backend's DB. */ dbentry = (PgStat_StatDBEntry *) hash_search(pgStatDBHash, (void *) &(msg->m_databaseid), @@ -2072,9 +2076,7 @@ pgstat_add_backend(PgStat_MsgHdr *msg) HASH_ELEM | HASH_FUNCTION); } - /* - * Count number of connects to the database - */ + /* Count the number of connects to the database */ dbentry->n_connects++; return 0; |