|
Server : Apache/2.2.2 (Fedora) System : Linux App1.pathumtani.go.th 2.6.20-1.2320.fc5smp #1 SMP Tue Jun 12 19:40:16 EDT 2007 i686 User : apache ( 48) PHP Version : 5.2.9 Disable Function : NONE Directory : /proc/self/root/usr/share/doc/postgresql-8.1.9/html/ |
Upload File : |
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<HTML
><HEAD
><TITLE
>Run-Time Statistics</TITLE
><META
NAME="GENERATOR"
CONTENT="Modular DocBook HTML Stylesheet Version 1.79"><LINK
REV="MADE"
HREF="mailto:pgsql-docs@postgresql.org"><LINK
REL="HOME"
TITLE="PostgreSQL 8.1.9 Documentation"
HREF="index.html"><LINK
REL="UP"
TITLE="Server Configuration"
HREF="runtime-config.html"><LINK
REL="PREVIOUS"
TITLE="Error Reporting and Logging"
HREF="runtime-config-logging.html"><LINK
REL="NEXT"
TITLE="Automatic Vacuuming"
HREF="runtime-config-autovacuum.html"><LINK
REL="STYLESHEET"
TYPE="text/css"
HREF="stylesheet.css"><META
HTTP-EQUIV="Content-Type"
CONTENT="text/html; charset=ISO-8859-1"><META
NAME="creation"
CONTENT="2007-04-20T04:40:08"></HEAD
><BODY
CLASS="SECT1"
><DIV
CLASS="NAVHEADER"
><TABLE
SUMMARY="Header navigation table"
WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
><TR
><TH
COLSPAN="5"
ALIGN="center"
VALIGN="bottom"
>PostgreSQL 8.1.9 Documentation</TH
></TR
><TR
><TD
WIDTH="10%"
ALIGN="left"
VALIGN="top"
><A
HREF="runtime-config-logging.html"
ACCESSKEY="P"
>Prev</A
></TD
><TD
WIDTH="10%"
ALIGN="left"
VALIGN="top"
><A
HREF="runtime-config.html"
>Fast Backward</A
></TD
><TD
WIDTH="60%"
ALIGN="center"
VALIGN="bottom"
>Chapter 17. Server Configuration</TD
><TD
WIDTH="10%"
ALIGN="right"
VALIGN="top"
><A
HREF="runtime-config.html"
>Fast Forward</A
></TD
><TD
WIDTH="10%"
ALIGN="right"
VALIGN="top"
><A
HREF="runtime-config-autovacuum.html"
ACCESSKEY="N"
>Next</A
></TD
></TR
></TABLE
><HR
ALIGN="LEFT"
WIDTH="100%"></DIV
><DIV
CLASS="SECT1"
><H1
CLASS="SECT1"
><A
NAME="RUNTIME-CONFIG-STATISTICS"
>17.8. Run-Time Statistics</A
></H1
><DIV
CLASS="SECT2"
><H2
CLASS="SECT2"
><A
NAME="RUNTIME-CONFIG-STATISTICS-MONITOR"
>17.8.1. Statistics Monitoring</A
></H2
><P
></P
><DIV
CLASS="VARIABLELIST"
><DL
><DT
><TT
CLASS="VARNAME"
>log_statement_stats</TT
> (<TT
CLASS="TYPE"
>boolean</TT
>)<BR><TT
CLASS="VARNAME"
>log_parser_stats</TT
> (<TT
CLASS="TYPE"
>boolean</TT
>)<BR><TT
CLASS="VARNAME"
>log_planner_stats</TT
> (<TT
CLASS="TYPE"
>boolean</TT
>)<BR><TT
CLASS="VARNAME"
>log_executor_stats</TT
> (<TT
CLASS="TYPE"
>boolean</TT
>)</DT
><DD
><P
> For each query, write performance statistics of the respective
module to the server log. This is a crude profiling
instrument. <TT
CLASS="VARNAME"
>log_statement_stats</TT
> reports total
statement statistics, while the others report per-module statistics.
<TT
CLASS="VARNAME"
>log_statement_stats</TT
> cannot be enabled together with
any of the per-module options. All of these options are disabled by
default. Only superusers can change these settings.
</P
></DD
></DL
></DIV
></DIV
><DIV
CLASS="SECT2"
><H2
CLASS="SECT2"
><A
NAME="RUNTIME-CONFIG-STATISTICS-COLLECTOR"
>17.8.2. Query and Index Statistics Collector</A
></H2
><P
></P
><DIV
CLASS="VARIABLELIST"
><DL
><DT
><A
NAME="GUC-STATS-START-COLLECTOR"
></A
><TT
CLASS="VARNAME"
>stats_start_collector</TT
> (<TT
CLASS="TYPE"
>boolean</TT
>)</DT
><DD
><P
> Controls whether the server should start the
statistics-collection subprocess. This is on by default, but
may be turned off if you know you have no interest in
collecting statistics. This option can only be set at server
start.
</P
></DD
><DT
><A
NAME="GUC-STATS-COMMAND-STRING"
></A
><TT
CLASS="VARNAME"
>stats_command_string</TT
> (<TT
CLASS="TYPE"
>boolean</TT
>)</DT
><DD
><P
> Enables the collection of statistics on the currently
executing command of each session, along with the time at
which that command began execution. This option is off 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
security risk. This data can be accessed via the
<TT
CLASS="STRUCTNAME"
>pg_stat_activity</TT
> system view; refer
to <A
HREF="monitoring.html"
>Chapter 24</A
> for more information.
</P
></DD
><DT
><A
NAME="GUC-STATS-BLOCK-LEVEL"
></A
><TT
CLASS="VARNAME"
>stats_block_level</TT
> (<TT
CLASS="TYPE"
>boolean</TT
>)</DT
><DD
><P
> Enables the collection of block-level statistics on database
activity. This option is disabled by default. If this option
is enabled, the data that is produced can be accessed via the
<TT
CLASS="STRUCTNAME"
>pg_stat</TT
> and
<TT
CLASS="STRUCTNAME"
>pg_statio</TT
> family of system views;
refer to <A
HREF="monitoring.html"
>Chapter 24</A
> for more information.
</P
></DD
><DT
><A
NAME="GUC-STATS-ROW-LEVEL"
></A
><TT
CLASS="VARNAME"
>stats_row_level</TT
> (<TT
CLASS="TYPE"
>boolean</TT
>)</DT
><DD
><P
> Enables the collection of row-level statistics on database
activity. This option is disabled by default. If this option
is enabled, the data that is produced can be accessed via the
<TT
CLASS="STRUCTNAME"
>pg_stat</TT
> and
<TT
CLASS="STRUCTNAME"
>pg_statio</TT
> family of system views;
refer to <A
HREF="monitoring.html"
>Chapter 24</A
> for more information.
</P
></DD
><DT
><A
NAME="GUC-STATS-RESET-ON-SERVER-START"
></A
><TT
CLASS="VARNAME"
>stats_reset_on_server_start</TT
> (<TT
CLASS="TYPE"
>boolean</TT
>)</DT
><DD
><P
> If on, collected statistics are zeroed out whenever the server
is restarted. If off, statistics are accumulated across server
restarts. The default is <TT
CLASS="LITERAL"
>off</TT
>. This option can only
be set at server start.
</P
></DD
></DL
></DIV
></DIV
></DIV
><DIV
CLASS="NAVFOOTER"
><HR
ALIGN="LEFT"
WIDTH="100%"><TABLE
SUMMARY="Footer navigation table"
WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
><A
HREF="runtime-config-logging.html"
ACCESSKEY="P"
>Prev</A
></TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
><A
HREF="index.html"
ACCESSKEY="H"
>Home</A
></TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
><A
HREF="runtime-config-autovacuum.html"
ACCESSKEY="N"
>Next</A
></TD
></TR
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
>Error Reporting and Logging</TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
><A
HREF="runtime-config.html"
ACCESSKEY="U"
>Up</A
></TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
>Automatic Vacuuming</TD
></TR
></TABLE
></DIV
></BODY
></HTML
>