Thread: Possible Values of Command Tag in PG Log file
Hello Team,
Can somebody redirect me to document which lists all possible value of command tag in instance log of PostgreSQL instance.
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.
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.klaver@aklaver.com
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.klaver@aklaver.com] Sent: Thursday, July 18, 2019 4:55 PM To: Kumar, Virendra; pgsql-general@lists.postgresql.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.klaver@aklaver.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.
The values and explanations are listed here:
Or simply INSERT, UPDATE, DELETE, SELECT, MOVE, FETCH and/or COPY
On Thu, Jul 18, 2019 at 5:04 PM Kumar, Virendra <Virendra.Kumar@guycarp.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.klaver@aklaver.com]
Sent: Thursday, July 18, 2019 4:55 PM
To: Kumar, Virendra; pgsql-general@lists.postgresql.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.klaver@aklaver.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!
Maj. Database & Exploration Specialist
Universe Exploration Command – UXC
Employment by invitation only!
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.Kumar@guycarp.com <mailto:Virendra.Kumar@guycarp.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.klaver@aklaver.com > <mailto:adrian.klaver@aklaver.com>] > Sent: Thursday, July 18, 2019 4:55 PM > To: Kumar, Virendra; pgsql-general@lists.postgresql.org > <mailto:pgsql-general@lists.postgresql.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.klaver@aklaver.com <mailto:adrian.klaver@aklaver.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.klaver@aklaver.com
"Kumar, Virendra" <Virendra.Kumar@guycarp.com> writes: > 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 That's actually the "activity" portion of the process status display, which there's no formal specification for. You'd have to root around in the source code looking for set_ps_display() calls if you really want to know. regards, tom lane