Commita65023e

committed

Further doc cleanups from the pg_stat_activity changes

Fujii Masao

1 parent6e3323d commita65023eCopy full SHA for a65023e

File tree

-8

lines changed

-8

lines changed

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -7320,7 +7320,7 @@`
`7320`	`7320`
`7321`	`7321`	`<para>`
`7322`	`7322`	`The <structfield>pid</structfield> column can be joined to the`
`7323`		`- <structfield>procpid</structfield> column of the`
	`7323`	`+ <structfield>pid</structfield> column of the`
`7324`	`7324`	`<structname>pg_stat_activity</structname> view to get more`
`7325`	`7325`	`information on the session holding or waiting to hold each lock.`
`7326`	`7326`	`Also, if you are using prepared transactions, the`

Lines changed: 2 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -3857,7 +3857,7 @@ local0.* /var/log/postgresql`
`3857`	`3857`	`identifier from <literal>pg_stat_activity</>, use this query:`
`3858`	`3858`	`<programlisting>`
`3859`	`3859`	`SELECT to_hex(EXTRACT(EPOCH FROM backend_start)::integer) \|\| '.' \|\|`
`3860`		`- to_hex(procpid)`
	`3860`	`+ to_hex(pid)`
`3861`	`3861`	`FROM pg_stat_activity;`
`3862`	`3862`	`</programlisting>`
`3863`	`3863`
`@@ -4153,7 +4153,7 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv;`
`4153`	`4153`	`<para>`
`4154`	`4154`	`Specifies the number of bytes reserved to track the currently`
`4155`	`4155`	`executing command for each active session, for the`
`4156`		`- <structname>pg_stat_activity</>.<structfield>current_query</> field.`
	`4156`	`+ <structname>pg_stat_activity</>.<structfield>query</> field.`
`4157`	`4157`	`The default value is 1024. This parameter can only be set at server`
`4158`	`4158`	`start.`
`4159`	`4159`	`</para>`

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -14322,7 +14322,7 @@ SELECT set_config('log_statement_stats', 'off', false);`
`14322`	`14322`	`send signals (<systemitem>SIGINT</> or <systemitem>SIGTERM</>`
`14323`	`14323`	`respectively) to backend processes identified by process ID.`
`14324`	`14324`	`The process ID of an active backend can be found from`
`14325`		`- the <structfield>procpid</structfield> column of the`
	`14325`	`+ the <structfield>pid</structfield> column of the`
`14326`	`14326`	`<structname>pg_stat_activity</structname> view, or by listing the`
`14327`	`14327`	`<command>postgres</command> processes on the server (using`
`14328`	`14328`	`<application>ps</> on Unix or the <application>Task`

Lines changed: 3 additions & 3 deletions

Original file line number	Diff line number	Diff line change
`@@ -1462,8 +1462,8 @@ postgres: <replaceable>user</> <replaceable>database</> <replaceable>host</> <re`
`1462`	`1462`	`example, to show the <acronym>PID</>s and current queries of all server processes:`
`1463`	`1463`
`1464`	`1464`	`<programlisting>`
`1465`		`-SELECT pg_stat_get_backend_pid(s.backendid) ASprocpid,`
`1466`		`- pg_stat_get_backend_activity(s.backendid) AScurrent_query`
	`1465`	`+SELECT pg_stat_get_backend_pid(s.backendid) ASpid,`
	`1466`	`+ pg_stat_get_backend_activity(s.backendid) ASquery`
`1467`	`1467`	`FROM (SELECT pg_stat_get_backend_idset() AS backendid) AS s;`
`1468`	`1468`	`</programlisting>`
`1469`	`1469`	`</para>`
`@@ -1670,7 +1670,7 @@ SELECT pg_stat_get_backend_pid(s.backendid) AS procpid,`
`1670`	`1670`	`<entry>statement-status</entry>`
`1671`	`1671`	`<entry>(const char *)</entry>`
`1672`	`1672`	`<entry>Probe that fires anytime the server process updates its`
`1673`		`- <structname>pg_stat_activity</>.<structfield>current_query</> status.`
	`1673`	`+ <structname>pg_stat_activity</>.<structfield>status</>.`
`1674`	`1674`	`arg0 is the new status string.</entry>`
`1675`	`1675`	`</row>`
`1676`	`1676`	`<row>`

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -2362,7 +2362,7 @@ static struct config_int ConfigureNamesInt[] =`
`2362`	`2362`
`2363`	`2363`	`{`
`2364`	`2364`	`{"track_activity_query_size",PGC_POSTMASTER,RESOURCES_MEM,`
`2365`		`-gettext_noop("Sets the size reserved for pg_stat_activity.current_query, in bytes."),`
	`2365`	`+gettext_noop("Sets the size reserved for pg_stat_activity.query, in bytes."),`
`2366`	`2366`	`NULL,`
`2367`	`2367`	`},`
`2368`	`2368`	`&pgstat_track_activity_query_size,`

Comments

(0)