Re: Monitor what command is executing at the backend - Mailing list pgsql-sql

>    Is there a way to see from the log files on what sql statement is
> currently by which user?  In other words, I want to monitor
> the DB activity.

for a current snapshot you don't need the logs, try:

  select * from pg_stat_activity;

(command string needs to be enabled for your database.)