Index: doc/src/sgml/monitoring.sgml =================================================================== RCS file: /cvsroot/pgsql/doc/src/sgml/monitoring.sgml,v retrieving revision 1.7 diff -c -r1.7 monitoring.sgml *** doc/src/sgml/monitoring.sgml 22 Mar 2002 19:20:14 -0000 1.7 --- doc/src/sgml/monitoring.sgml 31 Jul 2002 01:42:11 -0000 *************** *** 481,490 **** pg_stat_get_backend_pid(integer) integer ! PID of backend process --- 481,498 ---- + backend_pid() + integer + + Process ID of current backend + + + + pg_stat_get_backend_pid(integer) integer ! Process ID of all backend processes Index: src/backend/utils/adt/pgstatfuncs.c =================================================================== RCS file: /cvsroot/pgsql/src/backend/utils/adt/pgstatfuncs.c,v retrieving revision 1.5 diff -c -r1.5 pgstatfuncs.c *** src/backend/utils/adt/pgstatfuncs.c 31 Jul 2002 00:40:40 -0000 1.5 --- src/backend/utils/adt/pgstatfuncs.c 31 Jul 2002 01:42:12 -0000 *************** *** 19,25 **** 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 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); --- 19,25 ---- extern Datum pg_stat_get_blocks_hit(PG_FUNCTION_ARGS); extern Datum pg_stat_get_backend_idset(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,219 **** Datum ! pg_stat_get_backend_mypid(PG_FUNCTION_ARGS) { PG_RETURN_INT32(MyProcPid); } --- 213,219 ---- Datum ! backend_pid(PG_FUNCTION_ARGS) { PG_RETURN_INT32(MyProcPid); } Index: src/include/catalog/pg_proc.h =================================================================== RCS file: /cvsroot/pgsql/src/include/catalog/pg_proc.h,v retrieving revision 1.247 diff -c -r1.247 pg_proc.h *** src/include/catalog/pg_proc.h 31 Jul 2002 00:40:40 -0000 1.247 --- src/include/catalog/pg_proc.h 31 Jul 2002 01:42:20 -0000 *************** *** 2703,2710 **** 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 = 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_ )); --- 2703,2710 ---- 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 ( 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_ ));