From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Melvin Davidson <melvin6925(at)gmail(dot)com>, "Kumar, Virendra" <Virendra(dot)Kumar(at)guycarp(dot)com> |
Cc: | "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:21:56 |
Message-ID: | fca96e52-6d6d-8ed4-1163-33b87938bdf2@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 7/18/19 2:13 PM, Melvin Davidson wrote:
>
> 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
Except the OP shows a command that is not in the above, authentication.
Also this:
https://www.postgresql.org/docs/11/event-trigger-interface.html
The command tag associated with the event for which the event trigger is
run, for example "CREATE FUNCTION".
I suspect it comes from the commands listed here:
/src/include/commands
/src/backend/commands
How to pull out the complete list is beyond me at the moment.
>
> On Thu, Jul 18, 2019 at 5:04 PM Kumar, Virendra
> <Virendra(dot)Kumar(at)guycarp(dot)com <mailto: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
>
> (5 rows)
>
> Regads,
> Virendra
>
>
> -----Original Message-----
> From: Adrian Klaver [mailto:adrian(dot)klaver(at)aklaver(dot)com
> <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
> <mailto: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 <mailto: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!
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2019-07-18 21:22:38 | Re: Possible Values of Command Tag in PG Log file |
Previous Message | Melvin Davidson | 2019-07-18 21:13:01 | Re: Possible Values of Command Tag in PG Log file |