From: | Melvin Davidson <melvin6925(at)gmail(dot)com> |
---|---|
To: | "Kumar, Virendra" <Virendra(dot)Kumar(at)guycarp(dot)com> |
Cc: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Possible Values of Command Tag in PG Log file |
Date: | 2019-07-18 21:13:01 |
Message-ID: | CANu8FiwU+7W93xwaHNg5fHo17XOYcnF0kgQvMRGzmNEVRQCVNQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
The values and explanations are listed here:
https://www.postgresql.org/docs/11/protocol-message-formats.html
Or simply INSERT, UPDATE, DELETE, SELECT, MOVE, FETCH and/or COPY
On Thu, Jul 18, 2019 at 5:04 PM Kumar, Virendra <Virendra(dot)Kumar(at)guycarp(dot)com>
wrote:
> Here is it:
> --
> https://www.postgresql.org/docs/10/protocol-message-formats.html
>
> CommandComplete (B), string value of this section.
>
> I loaded log file (csv format) into postgres_log table as per below
> document and can see entries like:
> https://www.postgresql.org/docs/10/runtime-config-logging.html
>
> postgres=# select command_tag from postgres_log where command_tag is not
> null limit 5;
> command_tag
> ----------------
>
> authentication
>
> authentication
>
> (5 rows)
>
> Regads,
> Virendra
>
>
> -----Original Message-----
> From: Adrian Klaver [mailto:adrian(dot)klaver(at)aklaver(dot)com]
> Sent: Thursday, July 18, 2019 4:55 PM
> To: Kumar, Virendra; pgsql-general(at)lists(dot)postgresql(dot)org
> Subject: Re: Possible Values of Command Tag in PG Log file
>
> On 7/18/19 12:58 PM, Kumar, Virendra wrote:
> > Hello Team,
> >
> > Can somebody redirect me to document which lists all possible value of
> > command tag in instance log of PostgreSQL instance.
>
> Can you show example of a command tag in the log?
>
> >
> > Regards,
> >
> > Virendra
> >
> >
> > ------------------------------------------------------------------------
> >
> > This message is intended only for the use of the addressee and may
> contain
> > information that is PRIVILEGED AND CONFIDENTIAL.
> >
> > If you are not the intended recipient, you are hereby notified that any
> > dissemination of this communication is strictly prohibited. If you have
> > received this communication in error, please erase all copies of the
> message
> > and its attachments and notify the sender immediately. Thank you.
>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com
>
> ________________________________
>
> This message is intended only for the use of the addressee and may contain
> information that is PRIVILEGED AND CONFIDENTIAL.
>
> If you are not the intended recipient, you are hereby notified that any
> dissemination of this communication is strictly prohibited. If you have
> received this communication in error, please erase all copies of the
> message
> and its attachments and notify the sender immediately. Thank you.
>
>
>
--
*Melvin Davidson*
*Maj. Database & Exploration Specialist*
*Universe Exploration Command – UXC*
Employment by invitation only!
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2019-07-18 21:21:56 | Re: Possible Values of Command Tag in PG Log file |
Previous Message | Kumar, Virendra | 2019-07-18 21:02:51 | RE: Possible Values of Command Tag in PG Log file |