Commitf67cb71

committed

Add function to access backend pid, pg_stat_get_backend_mypid.

1 parentb8efa87 commitf67cb71Copy full SHA for f67cb71

File tree

+11

-1

lines changed

+11

-1

lines changed

Lines changed: 8 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -19,6 +19,7 @@ extern Datum pg_stat_get_blocks_fetched(PG_FUNCTION_ARGS);`
`19`	`19`	`externDatumpg_stat_get_blocks_hit(PG_FUNCTION_ARGS);`
`20`	`20`
`21`	`21`	`externDatumpg_stat_get_backend_idset(PG_FUNCTION_ARGS);`
	`22`	`+externDatumpg_stat_get_backend_mypid(PG_FUNCTION_ARGS);`
`22`	`23`	`externDatumpg_stat_get_backend_pid(PG_FUNCTION_ARGS);`
`23`	`24`	`externDatumpg_stat_get_backend_dbid(PG_FUNCTION_ARGS);`
`24`	`25`	`externDatumpg_stat_get_backend_userid(PG_FUNCTION_ARGS);`
`@@ -211,6 +212,13 @@ pg_stat_get_backend_idset(PG_FUNCTION_ARGS)`
`211`	`212`	`}`
`212`	`213`
`213`	`214`
	`215`	`+Datum`
	`216`	`+pg_stat_get_backend_mypid(PG_FUNCTION_ARGS)`
	`217`	`+{`
	`218`	`+PG_RETURN_INT32(MyProcPid);`
	`219`	`+}`
	`220`	`+`
	`221`	`+`
`214`	`222`	`Datum`
`215`	`223`	`pg_stat_get_backend_pid(PG_FUNCTION_ARGS)`
`216`	`224`	`{`

Lines changed: 3 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -7,7 +7,7 @@`
`7`	`7`	`* Portions Copyright (c) 1996-2002, PostgreSQL Global Development Group`
`8`	`8`	`* Portions Copyright (c) 1994, Regents of the University of California`
`9`	`9`	`*`
`10`		`- * $Id: pg_proc.h,v 1.246 2002/07/24 19:11:13 petere Exp $`
	`10`	`+ * $Id: pg_proc.h,v 1.247 2002/07/31 00:40:40 momjian Exp $`
`11`	`11`	`*`
`12`	`12`	`* NOTES`
`13`	`13`	`* The script catalog/genbki.sh reads this file and generates .bki`
`@@ -2703,6 +2703,8 @@ DATA(insert OID = 1935 ( pg_stat_get_blocks_hitPGNSP PGUID 12 f f t f s 1 20`
`2703`	`2703`	`DESCR("Statistics: Number of blocks found in cache");`
`2704`	`2704`	`DATA(insertOID=1936 (pg_stat_get_backend_idsetPGNSPPGUID12fftts023""pg_stat_get_backend_idset-_null_ ));`
`2705`	`2705`	`DESCR("Statistics: Currently active backend IDs");`
	`2706`	`+DATA(insertOID=2026 (pg_stat_get_backend_mypidPGNSPPGUID12fftfs023""pg_stat_get_backend_mypid-_null_ ));`
	`2707`	`+DESCR("Statistics: My backend ID");`
`2706`	`2708`	`DATA(insertOID=1937 (pg_stat_get_backend_pidPGNSPPGUID12fftfs123"23"pg_stat_get_backend_pid-_null_ ));`
`2707`	`2709`	`DESCR("Statistics: PID of backend");`
`2708`	`2710`	`DATA(insertOID=1938 (pg_stat_get_backend_dbidPGNSPPGUID12fftfs126"23"pg_stat_get_backend_dbid-_null_ ));`

Comments

(0)