Re: Monitor the ddl and dml activities in logs

Поиск
Список
Период
Сортировка
От Ben Chobot
Тема Re: Monitor the ddl and dml activities in logs
Дата
Msg-id 6EAD17FA-D8BD-4C15-89A5-B2ECFDE2E6B0@silentmedia.com
обсуждение исходный текст
Ответ на Monitor the ddl and dml activities in logs  (Nanda Kumar <Nanda.Kumar@smartstream-stp.com>)
Список pgsql-general
Дерево обсуждения

On Mar 6, 2019, at 5:58 AM, Nanda Kumar <Nanda.Kumar@smartstream-stp.com> wrote:

Hello Team,
 
I would like to know where I can monitor the ddl and dml operations happens in the production environment .

The documentation is your friend, particularly https://www.postgresql.org/docs/9.6/runtime-config-logging.html. By setting log_statement appropriately, you can see ddl and dml in your server logs.

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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: query has no destination for result data
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Monitor the ddl and dml activities in logs