2009/5/15 paulo matadr <[email protected]>: > Pessoal , to com uma duvida > eu to tentando abilitar o log_min_duration_statement para 2 min , assim > pondo > log_min_duration_statement = 120000 > e nao ta funcionando, existe a relaçao desse parametro com outro no > postgresql.conf para que ele funcione; > meu conf para logs abaixo: > # - Where to Log - > > #log_destination = 'stderr' # Valid values are combinations of > # stderr, syslog and eventlog, > # depending on platform. > > # This is used when logging to stderr: > redirect_stderr = on # Enable capturing of stderr into > log > # files > # (change requires restart) > > # These are only used if redirect_stderr is on: > #log_directory = 'pg_log' # Directory where log files are > written > # Can be absolute or relative to > PGDATA > #log_filename = 'postgresql-%Y-%m-%d_%H%M%S.log' # Log file name pattern. > # Can include strftime() escapes > #log_truncate_on_rotation = off # If on, any existing log file of 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 to > # disable. > #log_rotation_size = 10MB # Automatic rotation of logfiles > will > # happen after that much log > # output. 0 to disable. > > # These are relevant when logging to syslog: > #syslog_facility = 'LOCAL0' > #syslog_ident = 'postgres' > > > # - When to Log - > > #client_min_messages = notice # Values, in order of decreasing > detail: > # debug5 > # debug4 > # debug3 > # debug2 > # debug1 > # log > # notice > # warning > # error > > #log_min_messages = notice # Values, in order of decreasing > detail: > # debug5 > # debug4 > # debug3 > # debug2 > # debug1 > # info > # notice > # warning > # error > # log > # fatal > # panic > > #log_error_verbosity = default # terse, default, or verbose > messages > > #log_min_error_statement = error # Values in order of increasing > severity: > # debug5 > # debug4 > # debug3 > # debug2 > # debug1 > # info > # notice > # warning > # error > # fatal > # panic (effectively off) > > log_min_duration_statement = 120000 # -1 is disabled, 0 logs all statements > # and their durations. > > #silent_mode = off # DO NOT USE without syslog or > # redirect_stderr > # (change requires restart) > > # - What to Log - > > #debug_print_parse = off > #debug_print_rewritten = off > #debug_print_plan = off > #debug_pretty_print = off > #log_connections = off > #log_disconnections = off > #log_duration = off > log_line_prefix = '%t [%p]: [%l-1] > ' # Special values: > > # %u = user name > #log_line_prefix = '%u %d %h %t %i' tava antes teste > pgfouine # %d = database name > > # %r = remote host and port > > # %h = remote host > > # %p = PID > > # %t = timestamp (no milliseconds) > > # %m = timestamp with milliseconds > > # %i = command tag > > # %c = session id > > # %l = session line number > > # %s = session start timestamp > > # %x = transaction id > > # %q = stop here in non-session > > # processes > > # %% = '%' > > # e.g. '<%u%%%d> ' > log_statement = > 'ddl' # none, ddl, > mod, all > #log_hostname = off >
Repare que está especificado "log_statement = 'ddl' ". É isto mesmo? Você está interessado apenas nos comandos ddl? Osvaldo _______________________________________________ pgbr-geral mailing list [email protected] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
