diff options
author | Magnus Hagander <magnus@hagander.net> | 2012-01-20 12:23:26 +0100 |
---|---|---|
committer | Magnus Hagander <magnus@hagander.net> | 2012-01-20 12:23:26 +0100 |
commit | a65023e7decf5f5ba9b17bd86db8fe1ea4b6c331 (patch) | |
tree | 5b348a16031dd9b7055f36d827187be27b1948e6 /doc/src | |
parent | 6e3323d41dc45e93700a3420fd27ca05db6a64a7 (diff) | |
download | postgresql-a65023e7decf5f5ba9b17bd86db8fe1ea4b6c331.tar.gz postgresql-a65023e7decf5f5ba9b17bd86db8fe1ea4b6c331.zip |
Further doc cleanups from the pg_stat_activity changes
Fujii Masao
Diffstat (limited to 'doc/src')
-rw-r--r-- | doc/src/sgml/catalogs.sgml | 2 | ||||
-rw-r--r-- | doc/src/sgml/config.sgml | 4 | ||||
-rw-r--r-- | doc/src/sgml/func.sgml | 2 | ||||
-rw-r--r-- | doc/src/sgml/monitoring.sgml | 6 |
4 files changed, 7 insertions, 7 deletions
diff --git a/doc/src/sgml/catalogs.sgml b/doc/src/sgml/catalogs.sgml index be4bbc736c7..ea98cb72aa1 100644 --- a/doc/src/sgml/catalogs.sgml +++ b/doc/src/sgml/catalogs.sgml @@ -7320,7 +7320,7 @@ <para> The <structfield>pid</structfield> column can be joined to the - <structfield>procpid</structfield> column of the + <structfield>pid</structfield> column of the <structname>pg_stat_activity</structname> view to get more information on the session holding or waiting to hold each lock. Also, if you are using prepared transactions, the diff --git a/doc/src/sgml/config.sgml b/doc/src/sgml/config.sgml index 58e8ede239f..e55b5035e26 100644 --- a/doc/src/sgml/config.sgml +++ b/doc/src/sgml/config.sgml @@ -3857,7 +3857,7 @@ local0.* /var/log/postgresql identifier from <literal>pg_stat_activity</>, use this query: <programlisting> SELECT to_hex(EXTRACT(EPOCH FROM backend_start)::integer) || '.' || - to_hex(procpid) + to_hex(pid) FROM pg_stat_activity; </programlisting> @@ -4153,7 +4153,7 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv; <para> Specifies the number of bytes reserved to track the currently executing command for each active session, for the - <structname>pg_stat_activity</>.<structfield>current_query</> field. + <structname>pg_stat_activity</>.<structfield>query</> field. The default value is 1024. This parameter can only be set at server start. </para> diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index 43b72f695c2..48631cc341c 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -14322,7 +14322,7 @@ SELECT set_config('log_statement_stats', 'off', false); send signals (<systemitem>SIGINT</> or <systemitem>SIGTERM</> respectively) to backend processes identified by process ID. The process ID of an active backend can be found from - the <structfield>procpid</structfield> column of the + the <structfield>pid</structfield> column of the <structname>pg_stat_activity</structname> view, or by listing the <command>postgres</command> processes on the server (using <application>ps</> on Unix or the <application>Task diff --git a/doc/src/sgml/monitoring.sgml b/doc/src/sgml/monitoring.sgml index 225918019d6..dadfd24313c 100644 --- a/doc/src/sgml/monitoring.sgml +++ b/doc/src/sgml/monitoring.sgml @@ -1462,8 +1462,8 @@ postgres: <replaceable>user</> <replaceable>database</> <replaceable>host</> <re example, to show the <acronym>PID</>s and current queries of all server processes: <programlisting> -SELECT pg_stat_get_backend_pid(s.backendid) AS procpid, - pg_stat_get_backend_activity(s.backendid) AS current_query +SELECT pg_stat_get_backend_pid(s.backendid) AS pid, + pg_stat_get_backend_activity(s.backendid) AS query FROM (SELECT pg_stat_get_backend_idset() AS backendid) AS s; </programlisting> </para> @@ -1670,7 +1670,7 @@ SELECT pg_stat_get_backend_pid(s.backendid) AS procpid, <entry>statement-status</entry> <entry>(const char *)</entry> <entry>Probe that fires anytime the server process updates its - <structname>pg_stat_activity</>.<structfield>current_query</> status. + <structname>pg_stat_activity</>.<structfield>status</>. arg0 is the new status string.</entry> </row> <row> |