<!-- $PostgreSQL: pgsql/doc/src/sgml/config.sgml,v 1.66 2006/06/19 01:51:21 tgl Exp $ -->

<!-- $PostgreSQL: pgsql/doc/src/sgml/config.sgml,v 1.67 2006/06/27 19:07:50 momjian Exp $ -->

<chapter Id="runtime-config">

<title>Server Configuration</title>

<para>

Enables the collection of information on the currently

executing command of each session, along with the time at

which that command began execution. This parameter isoff by

which that command began execution. This parameter ison by

default. Note that even when enabled, this information is not

visible to all users, only to superusers and the user owning

the session being reported on; so it should not represent a

<!-- $PostgreSQL: pgsql/doc/src/sgml/monitoring.sgml,v 1.34 2006/06/19 01:51:21 tgl Exp $ -->

<!-- $PostgreSQL: pgsql/doc/src/sgml/monitoring.sgml,v 1.35 2006/06/27 19:07:50 momjian Exp $ -->

<chapter id="monitoring">

<title>Monitoring Database Activity</title>

<note>

<para>

Since the parameters <varname>stats_command_string</varname>,

<varname>stats_block_level</varname>, and

Since the parameters <varname>stats_block_level</varname>, and

<varname>stats_row_level</varname> default to <literal>false</>,

very few statistics are collected in the default

configuration. Enablingone or more of these configuration

variables will significantlyenhance the amount of useful data

configuration. Enablingeither of these configuration

variables will significantlyincrease the amount of useful data

produced by the statistics facilities, at the expense of

additional run-time overhead.

</para>

process <acronym>ID</>, user OID, user name, current query, time at

which the current query began execution, time at which the process

was started, and client's address and port number. The columns

that report data on the current query areonlyavailableif the

that report data on the current query are availableunless the

parameter <varname>stats_command_string</varname> has been

turnedon. Furthermore, these columnsread as null unless the

turnedoff. Furthermore, these columnsare only visible if the

user examining the view is a superuser or the same as the user

owning the process being reported on.

</entry>

<entry><literal><function>pg_stat_get_backend_activity</function>(<type>integer</type>)</literal></entry>

<entry><type>text</type></entry>

<entry>

Active command of the given server process (null if the

current user isnota superusernor the same user as that of

the session being queried, or

<varname>stats_command_string</varname> isnoton)

Active command of the given server process, but only if the

current user is a superuseror the same user as that of

the session being queried (and

<varname>stats_command_string</varname> is on)

</entry>

</row>

<entry><type>timestamp with time zone</type></entry>

<entry>

The time at which the given server process' currently

executing query was started (null if the

current user isnota superusernor the same user as that of

the session being queried, or

<varname>stats_command_string</varname> isnoton)

executing query was started, but only if the

current user is a superuseror the same user as that of

the session being queried (and

<varname>stats_command_string</varname> is on)

</entry>

</row>

"at which that command began execution.")

},

&pgstat_collect_querystring,

false,NULL,NULL

true,NULL,NULL

},

{

# - Query/Index Statistics Collector -

#stats_command_string =off

#stats_command_string =on

#stats_start_collector = on# needed for block or row stats

#stats_block_level = off

#stats_row_level = off