postgres=# SELECT procpid,current_query FROM pg_stat_activity WHERE current_query !='<IDLE>';
 procpid |                                                                                                                         current_query
---------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    6192 | INSERT INTO File (FileIndex, JobId, PathId, FilenameId, LStat, MD5)SELECT batch.FileIndex, batch.JobId, Path.PathId, Filename.FilenameId,batch.LStat, batch.MD5 FROM batch JOIN Path ON (batch.Path = Path.Path) JOIN Filename ON (batch.Name = Filename.Name)
   20287 | INSERT INTO Path (Path) SELECT a.Path FROM (SELECT DISTINCT Path FROM batch) AS a WHERE NOT EXISTS (SELECT Path FROM Path WHERE Path = a.Path)
   24498 | SELECT procpid,current_query FROM pg_stat_activity WHERE current_query !='<IDLE>';
   21732 | INSERT INTO File (FileIndex, JobId, PathId, FilenameId, LStat, MD5)SELECT batch.FileIndex, batch.JobId, Path.PathId, Filename.FilenameId,batch.LStat, batch.MD5 FROM batch JOIN Path ON (batch.Path = Path.Path) JOIN Filename ON (batch.Name = Filename.Name)
(4 ROWS)

postgres=# SELECT DISTINCT pid,mode  FROM pg_locks;
  pid  |         mode
-------+-----------------------
  6192 | AccessShareLock
  6192 | ExclusiveLock
  6192 | RowExclusiveLock
 20287 | AccessShareLock
 20287 | ExclusiveLock
 20287 | RowExclusiveLock
 20287 | ShareRowExclusiveLock
 21732 | AccessShareLock
 21732 | ExclusiveLock
 21732 | RowExclusiveLock
 24498 | AccessShareLock
 24498 | ExclusiveLock
(12 ROWS)