Re: Possible Values of Command Tag in PG Log file

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
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:22:38
Message-ID: 15306.1563484958@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Kumar, Virendra" <Virendra(dot)Kumar(at)guycarp(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Elaina Gerhold 2019-07-18 22:40:07 Payroll Potential Business Lead
Previous Message Adrian Klaver 2019-07-18 21:21:56 Re: Possible Values of Command Tag in PG Log file