diff options
| -rw-r--r-- | doc/src/sgml/monitoring.sgml | 12 | ||||
| -rw-r--r-- | src/backend/utils/adt/pgstatfuncs.c | 4 | ||||
| -rw-r--r-- | src/include/catalog/pg_proc.h | 6 |
3 files changed, 15 insertions, 7 deletions
diff --git a/doc/src/sgml/monitoring.sgml b/doc/src/sgml/monitoring.sgml index 88b7e29a924..4c07f372941 100644 --- a/doc/src/sgml/monitoring.sgml +++ b/doc/src/sgml/monitoring.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/monitoring.sgml,v 1.7 2002/03/22 19:20:14 petere Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/monitoring.sgml,v 1.8 2002/07/31 01:49:12 momjian Exp $ --> <chapter id="monitoring"> @@ -481,10 +481,18 @@ postgres: <replaceable>user</> <replaceable>database</> <replaceable>host</> <re </row> <row> + <entry><function>backend_pid</function>()</entry> + <entry><type>integer</type></entry> + <entry> + Process ID of current backend + </entry> + </row> + + <row> <entry><function>pg_stat_get_backend_pid</function>(<type>integer</type>)</entry> <entry><type>integer</type></entry> <entry> - PID of backend process + Process ID of all backend processes </entry> </row> diff --git a/src/backend/utils/adt/pgstatfuncs.c b/src/backend/utils/adt/pgstatfuncs.c index 6780665a11d..cc1f6488928 100644 --- a/src/backend/utils/adt/pgstatfuncs.c +++ b/src/backend/utils/adt/pgstatfuncs.c @@ -19,7 +19,7 @@ extern Datum pg_stat_get_blocks_fetched(PG_FUNCTION_ARGS); extern Datum pg_stat_get_blocks_hit(PG_FUNCTION_ARGS); extern Datum pg_stat_get_backend_idset(PG_FUNCTION_ARGS); -extern Datum pg_stat_get_backend_mypid(PG_FUNCTION_ARGS); +extern Datum backend_pid(PG_FUNCTION_ARGS); extern Datum pg_stat_get_backend_pid(PG_FUNCTION_ARGS); extern Datum pg_stat_get_backend_dbid(PG_FUNCTION_ARGS); extern Datum pg_stat_get_backend_userid(PG_FUNCTION_ARGS); @@ -213,7 +213,7 @@ pg_stat_get_backend_idset(PG_FUNCTION_ARGS) Datum -pg_stat_get_backend_mypid(PG_FUNCTION_ARGS) +backend_pid(PG_FUNCTION_ARGS) { PG_RETURN_INT32(MyProcPid); } diff --git a/src/include/catalog/pg_proc.h b/src/include/catalog/pg_proc.h index 66f4ea8a2c6..2c5979f9a45 100644 --- a/src/include/catalog/pg_proc.h +++ b/src/include/catalog/pg_proc.h @@ -7,7 +7,7 @@ * Portions Copyright (c) 1996-2002, PostgreSQL Global Development Group * Portions Copyright (c) 1994, Regents of the University of California * - * $Id: pg_proc.h,v 1.247 2002/07/31 00:40:40 momjian Exp $ + * $Id: pg_proc.h,v 1.248 2002/07/31 01:49:13 momjian Exp $ * * NOTES * The script catalog/genbki.sh reads this file and generates .bki @@ -2703,8 +2703,8 @@ DATA(insert OID = 1935 ( pg_stat_get_blocks_hit PGNSP PGUID 12 f f t f s 1 20 DESCR("Statistics: Number of blocks found in cache"); DATA(insert OID = 1936 ( pg_stat_get_backend_idset PGNSP PGUID 12 f f t t s 0 23 "" pg_stat_get_backend_idset - _null_ )); DESCR("Statistics: Currently active backend IDs"); -DATA(insert OID = 2026 ( pg_stat_get_backend_mypid PGNSP PGUID 12 f f t f s 0 23 "" pg_stat_get_backend_mypid - _null_ )); -DESCR("Statistics: My backend ID"); +DATA(insert OID = 2026 ( backend_pid PGNSP PGUID 12 f f t f s 0 23 "" backend_pid - _null_ )); +DESCR("Statistics: Current backend ID"); DATA(insert OID = 1937 ( pg_stat_get_backend_pid PGNSP PGUID 12 f f t f s 1 23 "23" pg_stat_get_backend_pid - _null_ )); DESCR("Statistics: PID of backend"); DATA(insert OID = 1938 ( pg_stat_get_backend_dbid PGNSP PGUID 12 f f t f s 1 26 "23" pg_stat_get_backend_dbid - _null_ )); |