Re: SQL statement logging: picking up strange queries from "pg_catalog"

Graham Leggett <minfrin@sharp.fm> writes:
> Does postgresql have an access log where the lifetime of database
> connections are tracked? Specifically tracking when the client
> connected, and how long the client stayed connected for.

See log_connections and log_disconnections.  You probably want to
add PID to log_line_prefix, too, so that you can associate different
log entries for the same session.

            regards, tom lane