# pgbadger /data/pg_log/9.4/* -f stderr  -o 4.htm  --prefix '|%m|%h|%u|%d|%a|%e'
[========================>] Parsed 343 bytes of 343 (100.00%), queries: 0, events: 0
[========================>] Parsed 5243083 bytes of 5243083 (100.00%), queries: 0, events: 0
[========================>] Parsed 5243172 bytes of 5243172 (100.00%), queries: 0, events: 0
[========================>] Parsed 5243004 bytes of 5243004 (100.00%), queries: 0, events: 0
[========================>] Parsed 5243114 bytes of 5243114 (100.00%), queries: 0, events: 0
[========================>] Parsed 4853141 bytes of 4841711 (100.24%), queries: 0, events: 0
LOG: Ok, generating html report...

#------------------------------------------------------------------------------
# ERROR REPORTING AND LOGGING
#------------------------------------------------------------------------------

# - Where to Log -

log_destination = 'stderr'              # Valid values are combinations of
                                        # stderr, csvlog, syslog, and eventlog,
                                        # depending on platform.  csvlog
                                        # requires logging_collector to be on.

# This is used when logging to stderr:
logging_collector = on          # Enable capturing of stderr and csvlog
                                        # into log files. Required to be on for
                                        # csvlogs.
                                        # (change requires restart)

# These are only used if logging_collector is on:
log_directory = '/data/pg_log/9.4'              # directory where log files are written,
                                        # can be absolute or relative to PGDATA
log_filename ='postgresql-%Y-%m-%d_%H%M%S.log'      #'%Y%m%d_%H%M%S.log'        # log file name pattern,
                                        # can include strftime() escapes
#log_file_mode = 0600                   # creation mode for log files,
                                        # begin with 0 to use octal notation
log_truncate_on_rotation = on           # If on, an existing log file with the
                                        # same name as the new log file will be
                                        # truncated rather than appended to.
                                        # But such truncation only occurs on
                                        # time-driven rotation, not on restarts
                                        # or size-driven rotation.  Default is
                                        # off, meaning append to existing files
                                        # in all cases.
log_rotation_age = 1d                   # Automatic rotation of logfiles will
                                        # happen after that time.  0 disables.
log_rotation_size = 5MB                 # Automatic rotation of logfiles will
                                        # happen after that much log output.
                                        # 0 disables.

    

log_min_duration_statement = 1000       # -1 is disabled, 0 logs all statements
                                        # and their durations, > 0 logs only
                                        # statements running at least this number
                                        # of milliseconds


# - What to Log -

#debug_print_parse = off
#debug_print_rewritten = off
#debug_print_plan = off
#debug_pretty_print = on
log_checkpoints = on
log_connections = on
log_disconnections = on
log_duration = on
log_error_verbosity = verbose           # terse, default, or verbose messages
log_hostname = on
log_line_prefix = '|%m|%h|%u|%d|%a|%e'                  # 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
                                        #   %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> '
log_lock_waits = on                     # log lock waits >= deadlock_timeout
log_statement = 'all'                   # none, ddl, mod, all
log_temp_files = 0                      # log temporary files equal or larger
                                        # than the specified size in kilobytes;
                                        # -1 disables, 0 logs all temp files
log_timezone = 'W-SU'

#  pgbadger /data/pg_log/9.4/* -f stderr  -o 4.htm  --prefix '%t [%p]: [%l-1] user=%u,db=%d,app=%a,client=%h'
[========================>] Parsed 756934 bytes of 756934 (100.00%), queries: 0, events: 0
[========================>] Parsed 3033435 bytes of 3026089 (100.24%), queries: 0, events: 0
LOG: Ok, generating html report...

2015-07-30 14:28:18 MSK [3031]: [4-1] user=user1,db=test,app=[н/д],client=server1.tex.localПОЛОЖЕНИЕ: PerformAuthentication, postinit.c:253
2015-07-30 14:28:18 MSK [3030]: [5-1] user=user1,db=test,app=testCalc,client=server1.tex.localОТМЕТКА:  00000: отключение: время сеанса: 0:00:00.033 пользователь=user1 база данных=test компьютер=server1.tex.local port=59944
2015-07-30 14:28:18 MSK [3030]: [6-1] user=user1,db=test,app=testCalc,client=server1.tex.localПОЛОЖЕНИЕ: log_disconnections, postgres.c:4511
2015-07-30 14:28:18 MSK [3032]: [1-1] user=[н/д],db=[н/д],app=[н/д],client=ОТМЕТКА:  00000: принято подключение: узел=server1.tex.local порт=59946
2015-07-30 14:28:18 MSK [3032]: [2-1] user=[н/д],db=[н/д],app=[н/д],client=ПОЛОЖЕНИЕ: BackendInitialize, postmaster.c:4003
2015-07-30 14:28:18 MSK [3032]: [3-1] user=user1,db=test,app=[н/д],client=server1.tex.localОТМЕТКА:  00000: подключение авторизовано: пользователь=user1, база=test, SSL включён (протокол=TLSv1, шифр=DHE-RSA-AES256-SHA, сжатие=выкл.)
2015-07-30 14:28:18 MSK [3032]: [4-1] user=user1,db=test,app=[н/д],client=server1.tex.localПОЛОЖЕНИЕ: PerformAuthentication, postinit.c:253
2015-07-30 14:28:18 MSK [3032]: [5-1] user=user1,db=test,app=testCalc,client=server1.tex.localОТМЕТКА:  00000: отключение: время сеанса: 0:00:00.033 пользователь=user1 база данных=test компьютер=server1.tex.local port=59946
2015-07-30 14:28:18 MSK [3032]: [6-1] user=user1,db=test,app=testCalc,client=server1.tex.localПОЛОЖЕНИЕ: log_disconnections, postgres.c:4511
2015-07-30 14:28:18 MSK [3033]: [1-1] user=[н/д],db=[н/д],app=[н/д],client=ОТМЕТКА:  00000: принято подключение: узел=server1.tex.local порт=59947
2015-07-30 14:28:18 MSK [3033]: [2-1] user=[н/д],db=[н/д],app=[н/д],client=ПОЛОЖЕНИЕ: BackendInitialize, postmaster.c:4003
2015-07-30 14:28:18 MSK [3031]: [5-1] user=user1,db=test,app=testCalc,client=server1.tex.localОТМЕТКА:  00000: отключение: время сеанса: 0:00:00.065 пользователь=user1 база данных=test компьютер=server1.tex.local port=59945
2015-07-30 14:28:18 MSK [3031]: [6-1] user=user1,db=test,app=testCalc,client=server1.tex.localПОЛОЖЕНИЕ: log_disconnections, postgres.c:4511
2015-07-30 14:28:18 MSK [3034]: [1-1] user=[н/д],db=[н/д],app=[н/д],client=ОТМЕТКА:  00000: принято подключение: узел=server1.tex.local порт=59948
2015-07-30 14:28:18 MSK [3034]: [2-1] user=[н/д],db=[н/д],app=[н/д],client=ПОЛОЖЕНИЕ: BackendInitialize, postmaster.c:4003
2015-07-30 14:28:18 MSK [3033]: [3-1] user=user1,db=test,app=[н/д],client=server1.tex.localОТМЕТКА:  00000: подключение авторизовано: пользователь=user1, база=test, SSL включён (протокол=TLSv1, шифр=DHE-RSA-AES256-SHA, сжатие=выкл.)
2015-07-30 14:28:18 MSK [3033]: [4-1] user=user1,db=test,app=[н/д],client=server1.tex.localПОЛОЖЕНИЕ: PerformAuthentication, postinit.c:253
2015-07-30 14:46:59 MSK [15746]: [21-1] user=postgres,db=test,app=EMS SQL Manager for PostgreSQL,client=s1.tex.localОТМЕТКА:  00000: продолжительность: 2002.194 мс, оператор: SELECT pg_sleep(2)
2015-07-30 14:46:59 MSK [15746]: [22-1] user=postgres,db=test,app=EMS SQL Manager for PostgreSQL,client=s1.tex.localПОЛОЖЕНИЕ: exec_simple_query, postgres.c:1149