GISDEV=# select version(); version ------------------------------------------------------------------------------------------ PostgreSQL 8.1.5 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.4.2 (mingw-special) (1 row) GISDEV=# select * from pg_catalog.pg_stat_activity; datid | datname | procpid | usesysid | usename | current_query | query_start | backend_start | client_addr | client_port -------+----------+---------+----------+----------+------------------------------+----------------------------+----------------------------+----------------+------------- 19015 | GISDEV | 3584 | 17024 | gisadmin | | 2007-06-04 10:04:46.172-04 | 2007-06-04 09:33:18.399-04 | 130.100.30.124 | 3491 19015 | GISDEV | 2460 | 17024 | gisadmin | | 2007-06-04 09:34:33.07-04 | 2007-06-04 09:34:33.07-04 | 130.100.30.124 | 3493 19015 | GISDEV | 4156 | 17024 | gisadmin | | 2007-06-04 10:03:40.267-04 | 2007-06-04 09:57:56.005-04 | 130.100.30.124 | 3589 19015 | GISDEV | 2960 | 17024 | gisadmin | | 2007-06-04 09:34:26.398-04 | 2007-06-01 14:49:20.534-04 | 130.100.30.124 | 2874 19015 | GISDEV | 3288 | 17024 | gisadmin | drop table tmp.kpsall3buff ; create table tmp.kpsall3buff with oids as select pole_id,string,filename,len,buffer(geo,32.5) from tmp.jpsall3 --limit 50 | 2007-06-01 10:20:45.969-04 | 2007-06-01 10:12:51.472-04 | 130.100.30.124 | 2130 10793 | postgres | 392 | 17024 | gisadmin | | 2007-06-04 09:33:18.837-04 | 2007-06-04 09:33:18.134-04 | 130.100.30.124 | 3490 19015 | GISDEV | 1860 | 10 | postgres | | 2007-06-04 11:07:12.874-04 | 2007-06-04 10:31:18.089-04 | 130.100.30.124 | 3666 19015 | GISDEV | 5216 | 10 | postgres | | 2007-06-04 11:07:12.843-04 | 2007-06-04 10:34:38.977-04 | 130.100.30.124 | 3720 19015 | GISDEV | 5024 | 10 | postgres | | 2007-06-04 11:08:50.685-04 | 2007-06-01 17:36:36.707-04 | 130.100.30.124 | 3057 (9 rows) GISDEV=# select * from pg_catalog.pg_locks ; locktype | database | relation | page | tuple | transactionid | classid | objid | objsubid | transaction | pid | mode | granted ---------------+----------+----------+------+-------+---------------+---------+-------+----------+-------------+------+---------------------+--------- relation | 19015 | 5220813 | | | | | | | 15820036 | 3288 | AccessExclusiveLock | t relation | 19015 | 5223128 | | | | | | | 15820036 | 3288 | ShareLock | t relation | 19015 | 5223126 | | | | | | | 15820036 | 3288 | AccessExclusiveLock | t relation | 19015 | 5223130 | | | | | | | 15820036 | 3288 | ShareLock | t relation | 19015 | 5223130 | | | | | | | 15820036 | 3288 | AccessExclusiveLock | t transactionid | | | | | 15822393 | | | | 15822393 | 3564 | ExclusiveLock | t relation | 19015 | 5220811 | | | | | | | 15820036 | 3288 | AccessExclusiveLock | t object | 0 | | | | | 1260 | 17024 | 0 | 15820036 | 3288 | AccessShareLock | t relation | 19015 | 5220811 | | | | | | | 15822393 | 3564 | AccessShareLock | f transactionid | | | | | 15820036 | | | | 15820036 | 3288 | ExclusiveLock | t transactionid | | | | | 15844904 | | | | 15844904 | 5024 | ExclusiveLock | t relation | 19015 | 10342 | | | | | | | 15844904 | 5024 | AccessShareLock | t relation | 19015 | 5220815 | | | | | | | 15820036 | 3288 | AccessExclusiveLock | t relation | 19015 | 3781129 | | | | | | | 15820036 | 3288 | AccessShareLock | t (14 rows) GISDEV=#