<!--

$PostgreSQL: pgsql/doc/src/sgml/runtime.sgml,v 1.249 2004/03/12 00:56:00 neilc Exp $

$PostgreSQL: pgsql/doc/src/sgml/runtime.sgml,v 1.250 2004/03/15 15:56:21 momjian Exp $

-->

<Chapter Id="runtime">

<para>

Causes the duration of every completed statement to be logged.

To use this option, it is recommended that you also enable

<varname>log_statement</> and <varname>log_pid</> so that you

<varname>log_statement</> and if not using <application>syslog</>

log the PID using <varname>log_line_prefix</> so that you

can link the statement to the duration using the process

ID. The default is off. Only superusers can turn off this

option if it is enabled by the administrator.

processes without controlling sessions. <application>Syslog</> produces its own

timestamp and process ID information, so you probably do not want to

use those escapes if you are using <application>syslog</>.

This option can only be set at server start or in the

<filename>postgresql.conf</filename> configuration file.

<informaltable>

<tgroup cols="3">

<thead>

<row>

<entry><literal>%c</literal></entry>

<entry>Session ID. A unique identifier for each session.

It is 2 4-byte hexadecimal numbers separated by a dot. The numbers

It is 2 4-byte hexadecimal numbers (without leading zeros)

separated by a dot. The numbers

are the Session Start Time and the Process ID, so this can also

be used as a space saving way of printing these items.</entry>

<entry>Yes</entry>

</listitem>

</varlistentry>

<varlistentry>

<term><varname>log_pid</varname> (<type>boolean</type>)</term>

<listitem>

<para>

Prefixes each message in the server log file with the process ID of

the server process. This is useful to sort out which messages

pertain to which connection. The default is off. This parameter

does not affect messages logged via <application>syslog</>, which

always contain the process ID.

</para>

</listitem>

</varlistentry>

<varlistentry id="guc-log-statement" xreflabel="log_statement">

<term><varname>log_statement</varname> (<type>boolean</type>)</term>

<listitem>

</listitem>

</varlistentry>

<varlistentry id="guc-log-timestamp" xreflabel="log_timestamp">

<term><varname>log_timestamp</varname> (<type>boolean</type>)</term>

<listitem>

<para>

Prefixes each server log message with a time stamp. The default

is off.

</para>

</listitem>

</varlistentry>

<varlistentry id="guc-log-hostname" xreflabel="log_hostname">

<term><varname>log_hostname</varname> (<type>boolean</type>)</term>

<listitem>

</listitem>

</varlistentry>

<varlistentry id="guc-log-source-port" xreflabel="log_source_port">

<term><varname>log_source_port</varname> (<type>boolean</type>)</term>

<listitem>

<para>

Shows the outgoing port number of the connecting host in the

connection log messages. You could trace back the port number

to find out what user initiated the connection. Other than

that, it's pretty useless and therefore off by default. This

option can only be set at server start.

</para>

</listitem>

</varlistentry>

</variablelist>

</sect3>

</sect2>

intCheckPointWarning=30;

time_tLastSignalledCheckpoint=0;

boollog_hostname;/* for ps display */

boolLogSourcePort;

boollog_hostname;/* for ps display and logging */

boolLog_connections= false;

boolDb_user_namespace= false;

structtimezonetz;

charremote_host[NI_MAXHOST];

charremote_port[NI_MAXSERV];

charremote_ps_data[NI_MAXHOST];

IsUnderPostmaster= true;/* we are a postmaster subprocess now */

remote_port,sizeof(remote_port),

NI_NUMERICHOST |NI_NUMERICSERV);

}

snprintf(remote_ps_data,sizeof(remote_ps_data),

remote_port[0]=='\0' ?"%s" :"%s(%s)",

remote_host,remote_port);

if (Log_connections)

ereport(LOG,

(errmsg("connection received: host=%s port=%s",

remote_host,remote_port)));

if (LogSourcePort)

{

chartmphost[NI_MAXHOST];

snprintf(tmphost,sizeof(tmphost),"%s(%s)",remote_host,remote_port);

StrNCpy(remote_host,tmphost,sizeof(remote_host));

}

init_ps_display(port->user_name,port->database_name,remote_host);

init_ps_display(port->user_name,port->database_name,remote_ps_data);

set_ps_display("authentication");

snprintf(dbname,sizeof(dbname)," database=%s",port->database_name);

snprintf(remote_host,sizeof(remote_host)," host=%s",

port->remote_host);

if (!LogSourcePort&&strlen(port->remote_port))

snprintf(remote_port,sizeof(remote_port)," port=%s",port->remote_port);

remote_port[0]='\0';

snprintf(remote_port,sizeof(remote_port)," port=%s",port->remote_port);

gettimeofday(&end,NULL);

PGErrorVerbosityLog_error_verbosity=PGERROR_VERBOSE;

boolLog_timestamp= false;/* show timestamps in stderr

boolLog_pid= false;/* show PIDs in stderr output */

char*Log_line_prefix="";/* format for extra log line info */

staticchar*expand_fmt_string(constchar*fmt,ErrorData*edata);

staticconstchar*useful_strerror(interrnum);

staticconstchar*error_severity(intelevel);

staticconstchar*print_timestamp(void);

staticconstchar*print_pid(void);

staticvoidappend_with_tabs(StringInfobuf,constchar*str);

staticconstchar*log_line_prefix(void);

case'r':

j+=snprintf(result+j,result_len-j,"%s",

MyProcPort->remote_host);

if (!LogSourcePort&&strlen(MyProcPort->remote_port))

if (strlen(MyProcPort->remote_port)>0)

j+=snprintf(result+j,result_len-j,"(%s)",

MyProcPort->remote_port);

break;

fprintf(stderr,"%s%s%s",

Log_timestamp ?print_timestamp() :"",

Log_pid ?print_pid() :"",

buf.data);

fprintf(stderr,"%s",buf.data);

}

pfree(buf.data);

}

print_timestamp(void)

{

time_tcurtime;

staticcharbuf[21];/* format `YYYY-MM-DD HH:MM:SS ' */

curtime=time(NULL);

strftime(buf,sizeof(buf),

"%Y-%m-%d %H:%M:%S ",

localtime(&curtime));

returnbuf;

}

print_pid(void)

{

staticcharbuf[10];/* allow `[123456] ' */

snprintf(buf,sizeof(buf),"[%d] ", (int)MyProcPid);

returnbuf;

}

&Log_disconnections,

false,NULL,NULL

},

{

{"log_timestamp",PGC_SIGHUP,LOGGING_WHAT,

gettext_noop("Prefixes server log messages with a time stamp."),

},

&Log_timestamp,

false,NULL,NULL

},

{

{"log_pid",PGC_SIGHUP,LOGGING_WHAT,

gettext_noop("Prefixes server log messages with the server PID."),

},

&Log_pid,

false,NULL,NULL

},

{

&log_hostname,

false,NULL,NULL

},

{

{"log_source_port",PGC_SIGHUP,LOGGING_WHAT,

gettext_noop("Logs the outgoing port number of the connecting host."),

},

&LogSourcePort,

false,NULL,NULL

},

{

{"sql_inheritance",PGC_USERSET,COMPAT_OPTIONS_PREVIOUS,

gettext_noop("Causes subtables to be included by default in various commands."),

#log_connections = false

#log_disconnections = false

#log_duration = false

#log_pid = false

#log_line_prefix = ''# e.g. '<%u%%%d> '

# %u=user name %d=database name

# %r=remote host and port

# %x=stop here in non-session processes

# %%='%'

#log_statement = false

#log_timestamp = false

#log_hostname = false

#log_source_port = false

#---------------------------------------------------------------------------

externboolInError;

externCommandDestwhereToSendOutput;

externboollog_hostname;

externboolLogSourcePort;

externDLLIMPORTconstchar*debug_query_string;

externchar*rendezvous_name;

}PGErrorVerbosity;

externPGErrorVerbosityLog_error_verbosity;

externboolLog_timestamp;

externboolLog_pid;

externchar*Log_line_prefix;