Re: Tracking SQLs that update data

Поиск
Список
Период
Сортировка
От Phoenix Kiula
Тема Re: Tracking SQLs that update data
Дата
Msg-id AANLkTinWBv28ozTNWfHhHwqV8u6LDEYYylxZCNgAPu9-@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Tracking SQLs that update data  (Scott Marlowe <scott.marlowe@gmail.com>)
Ответы Re: Tracking SQLs that update data
Список pgsql-general
> It's far easier to adjust the logging.
>
> psql mydb
> alter mydb set log_statement='mod';



Thanks Scott.

Two questions:

1. Will this log_statement='mod' be a permanent thing, or when I have
done my testing and identifying the problem SQL, I can set it back to
default so not too much logging is being done?

2. After this statement, how or where do I find the culprit SQL?

Thanks

В списке pgsql-general по дате отправления: