"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