Re: application for postgres Log

Поиск
Список
Период
Сортировка
От Albe Laurenz
Тема Re: application for postgres Log
Дата
Msg-id D960CB61B694CF459DCFB4B0128514C2086C15A5@exadv11.host.magwien.gv.at
обсуждение исходный текст
Ответ на Re: application for postgres Log  (Arvind Singh <arvindps@hotmail.com>)
Ответы Re: application for postgres Log  (Arvind Singh <arvindps@hotmail.com>)
Список pgsql-general
Arvind Singh wrote:
> I have enabled the csvlog option.
>
> There seem to be 24 columns in the Log. I have difficulty in
understanding the following columns
>
> - virtual_transaction_id

Such a transaction ID is given to every transaction.
Can be used to track transactions in the log.

> - transaction_id

Such a transaction ID is given to a transaction
that modifies the database.

> - hint

Part of the error message (like "detail" and "context").

> - internal_query
> - internal_query_pos

These are used a handful of times in the code, I'm not
100% sure what for.
You may never encouter one of those.

> - context

Describes where the error ocurred.

Yours,
Laurenz Albe


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

Предыдущее
От: Arvind Singh
Дата:
Сообщение: Re: application for postgres Log
Следующее
От: Andres Freund
Дата:
Сообщение: Re: Need help in reclaiming disk space by deleting the selected records