> 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.)
