diff options
| author | Bruce Momjian <bruce@momjian.us> | 2002-09-01 23:26:06 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2002-09-01 23:26:06 +0000 |
| commit | 548d646e65223318e4ccbfdbb25a003568d4c703 (patch) | |
| tree | 481b5e8caa2dab79deca1bb48155e6736a8b323d /doc/src | |
| parent | f4abdd8212380a81e90e6b5bf340a60dfb3068f2 (diff) | |
| download | postgresql-548d646e65223318e4ccbfdbb25a003568d4c703.tar.gz postgresql-548d646e65223318e4ccbfdbb25a003568d4c703.zip | |
Add log_duration to GUC/postgresql.conf.
Rename debug_print_query to log_statement and rename show_query_stats to
show_statement_stats.
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/func.sgml | 4 | ||||
| -rw-r--r-- | doc/src/sgml/runtime.sgml | 27 |
2 files changed, 25 insertions, 6 deletions
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index e954f8e7bf9..ee8cc7d3f60 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/func.sgml,v 1.118 2002/08/29 05:17:55 tgl Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/func.sgml,v 1.119 2002/09/01 23:26:05 momjian Exp $ PostgreSQL documentation --> @@ -5241,7 +5241,7 @@ select current_setting('DateStyle'); <literal>false</literal> instead. It is the equivalent to the SQL <command>SET</command> command. For example: <programlisting> -select set_config('show_query_stats','off','f'); +select set_config('show_statement_stats','off','f'); set_config ------------ off diff --git a/doc/src/sgml/runtime.sgml b/doc/src/sgml/runtime.sgml index fbbe6274dc0..42677b20e14 100644 --- a/doc/src/sgml/runtime.sgml +++ b/doc/src/sgml/runtime.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/runtime.sgml,v 1.131 2002/08/30 22:18:05 tgl Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/runtime.sgml,v 1.132 2002/09/01 23:26:06 momjian Exp $ --> <Chapter Id="runtime"> @@ -928,7 +928,6 @@ env PGOPTIONS='-c geqo=off' psql </varlistentry> <varlistentry> - <term><varname>DEBUG_PRINT_QUERY</varname> (<type>boolean</type>)</term> <term><varname>DEBUG_PRINT_PARSE</varname> (<type>boolean</type>)</term> <term><varname>DEBUG_PRINT_REWRITTEN</varname> (<type>boolean</type>)</term> <term><varname>DEBUG_PRINT_PLAN</varname> (<type>boolean</type>)</term> @@ -993,6 +992,26 @@ env PGOPTIONS='-c geqo=off' psql </varlistentry> <varlistentry> + <term><varname>LOG_STATEMENT</varname> (<type>boolean</type>)</term> + <listitem> + <para> + Prints each query received. + </para> + </listitem> + </varlistentry> + + <varlistentry> + <term><varname>LOG_DURATION</varname> (<type>boolean</type>)</term> + <listitem> + <para> + Prints the duration of every completed query. To use this option, + enable LOG_STATEMENT and LOG_PID so you can link the original query + to the duration using the process id. + </para> + </listitem> + </varlistentry> + + <varlistentry> <term><varname>LOG_TIMESTAMP</varname> (<type>boolean</type>)</term> <listitem> <para> @@ -1003,7 +1022,7 @@ env PGOPTIONS='-c geqo=off' psql </varlistentry> <varlistentry> - <term><varname>SHOW_QUERY_STATS</varname> (<type>boolean</type>)</term> + <term><varname>SHOW_STATEMENT_STATS</varname> (<type>boolean</type>)</term> <term><varname>SHOW_PARSER_STATS</varname> (<type>boolean</type>)</term> <term><varname>SHOW_PLANNER_STATS</varname> (<type>boolean</type>)</term> <term><varname>SHOW_EXECUTOR_STATS</varname> (<type>boolean</type>)</term> @@ -2072,7 +2091,7 @@ dynamic_library_path = '/usr/local/lib/postgresql:/home/my_project/lib:$libdir' </row> <row> <entry><option>-s</option></entry> - <entry><literal>show_query_stats = on</></entry> + <entry><literal>show_statement_stats = on</></entry> <entry>*</entry> </row> <row> |