Description
bool pg_trace
(string
filename [, string
mode [, int
connection]])
Enables tracing of the PostgreSQL frontend/backend communication
to a debugging file. To fully understand the results one needs to
be familiar with the internals of PostgreSQL communication
protocol. For those who are not, it can still be useful for
tracing errors in queries sent to the server, you could do for
example grep '^To backend' trace.log and see
what query actually were sent to the PostgreSQL server.
Filename and mode
are the same as in fopen()
(mode defaults to 'w'),
connection specifies the connection to
trace and defaults to the last one opened.
Returns TRUE if filename could be opened
for logging, FALSE otherwise.
See also fopen() and
pg_untrace().