| From: | "Albe Laurenz" <laurenz(dot)albe(at)wien(dot)gv(dot)at> |
|---|---|
| To: | "Arvind Singh *EXTERN*" <arvindps(at)hotmail(dot)com>, <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: application for postgres Log |
| Date: | 2012-09-14 11:16:33 |
| Message-ID: | D960CB61B694CF459DCFB4B0128514C2086C15A5@exadv11.host.magwien.gv.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andres Freund | 2012-09-14 12:35:08 | Re: Need help in reclaiming disk space by deleting the selected records |
| Previous Message | Arvind Singh | 2012-09-14 10:32:46 | Re: application for postgres Log |