"David Esposito" <dvesposito(at)newnetco(dot)com> writes:
> i took a peek at pg_stat_activity and it doesn't appear as though any of the
> processes are doing anything ... they all have blanks for "current_query"
Read
http://www.ca.postgresql.org/users-lounge/docs/7.2/postgres/monitoring-stats.html
> Is there any way to get timestamps turned on in the log file?
There's a flag in postgresql.conf. You might wanna turn on log_pid too.
regards, tom lane