Re: [PERFORM] Log update query along with username who has executed thesame. - Mailing list pgsql-performance

You need to include "%u" in the log_line_prefix setting in your postgresql.conf.  Like this:

log_line_prefix = '%m %d %h %u '

#log_line_prefix = ''           # special values:

                    #   %a = application name

                    #   %u = user name

                    #   %d = database name

                    #   %r = remote host and port

                    #   %h = remote host

                    #   %p = process ID

                    #   %t = timestamp without milliseconds

                    #   %m = timestamp with milliseconds

                    #   %n = timestamp with milliseconds (as a Unix epoch)

                    #   %i = command tag

                    #   %e = SQL state

                    #   %c = session ID

                    #   %l = session line number

                    #   %s = session start timestamp

                    #   %v = virtual transaction ID

                    #   %x = transaction ID (0 if none)

                    #   %q = stop here in non-session

                    #        processes

                    #   %% = '%'

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