File tree Expand file tree Collapse file tree 3 files changed +15
-7
lines changed
Expand file tree Collapse file tree 3 files changed +15
-7
lines changed Original file line number Diff line number Diff line change 11<!--
2- $Header: /cvsroot/pgsql/doc/src/sgml/monitoring.sgml,v 1.7 2002/03/22 19:20:14 petere Exp $
2+ $Header: /cvsroot/pgsql/doc/src/sgml/monitoring.sgml,v 1.8 2002/07/31 01:49:12 momjian Exp $
33-->
44
55<chapter id="monitoring">
@@ -480,11 +480,19 @@ postgres: <replaceable>user</> <replaceable>database</> <replaceable>host</> <re
480480 </entry>
481481 </row>
482482
483+ <row>
484+ <entry><function>backend_pid</function>()</entry>
485+ <entry><type>integer</type></entry>
486+ <entry>
487+ Process ID of current backend
488+ </entry>
489+ </row>
490+
483491 <row>
484492 <entry><function>pg_stat_get_backend_pid</function>(<type>integer</type>)</entry>
485493 <entry><type>integer</type></entry>
486494 <entry>
487- PID of backend process
495+ Process ID of all backend processes
488496 </entry>
489497 </row>
490498
Original file line number Diff line number Diff line change @@ -19,7 +19,7 @@ extern Datum pg_stat_get_blocks_fetched(PG_FUNCTION_ARGS);
1919extern Datum pg_stat_get_blocks_hit (PG_FUNCTION_ARGS );
2020
2121extern Datum pg_stat_get_backend_idset (PG_FUNCTION_ARGS );
22- extern Datum pg_stat_get_backend_mypid (PG_FUNCTION_ARGS );
22+ extern Datum backend_pid (PG_FUNCTION_ARGS );
2323extern Datum pg_stat_get_backend_pid (PG_FUNCTION_ARGS );
2424extern Datum pg_stat_get_backend_dbid (PG_FUNCTION_ARGS );
2525extern Datum pg_stat_get_backend_userid (PG_FUNCTION_ARGS );
@@ -213,7 +213,7 @@ pg_stat_get_backend_idset(PG_FUNCTION_ARGS)
213213
214214
215215Datum
216- pg_stat_get_backend_mypid (PG_FUNCTION_ARGS )
216+ backend_pid (PG_FUNCTION_ARGS )
217217{
218218 PG_RETURN_INT32 (MyProcPid );
219219}
Original file line number Diff line number Diff line change 77 * Portions Copyright (c) 1996-2002, PostgreSQL Global Development Group
88 * Portions Copyright (c) 1994, Regents of the University of California
99 *
10- * $Id: pg_proc.h,v 1.247 2002/07/31 00:40:40 momjian Exp $
10+ * $Id: pg_proc.h,v 1.248 2002/07/31 01:49:13 momjian Exp $
1111 *
1212 * NOTES
1313 * 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
27032703DESCR ("Statistics: Number of blocks found in cache" );
27042704DATA (insert OID = 1936 ( pg_stat_get_backend_idset PGNSP PGUID 12 f f t t s 0 23 "" pg_stat_get_backend_idset - _null_ ));
27052705DESCR ("Statistics: Currently active backend IDs" );
2706- 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_ ));
2707- DESCR ("Statistics: My backend ID" );
2706+ DATA (insert OID = 2026 ( backend_pid PGNSP PGUID 12 f f t f s 0 23 "" backend_pid - _null_ ));
2707+ DESCR ("Statistics: Current backend ID" );
27082708DATA (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_ ));
27092709DESCR ("Statistics: PID of backend" );
27102710DATA (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_ ));
You can’t perform that action at this time.
0 commit comments