"Kumar, Virendra" <Virendra.Kumar@xxxxxxxxxxx> 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