No subject

companyname=# select * from pg_stat_activity where procpid = 22890;
  datid   |   datname    | procpid | usesysid |   usename    |
application_name |  client_addr  | client_hostname | client_port |
backend_start         |          xact_start           |         query_start
       | waiting |

     current_query


----------+--------------+---------+----------+--------------+------------------+---------------+-----------------+-------------+-------------------------------+-------------------------------+------------------------------+---------+-------------------
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------
 15216748 | companyname |   22890 |    16394 | companyname |
| 10.11.22.23 |                 |       52847 | 2012-07-17 21:21:37.955751+00
| 2012-07-17 21:21:39.604965+00 | 2012-07-17 21:21:44.15175+00 | f       |
INSERT INTO "agent
_commands" ("agent_instance_id", "created_at", "customer_id",
"daemon_completed_at", "daemon_started_at", "last_error", "payload",
"priority", "requested_by_id", "status", "type", "updated_at", "uuid") VALUES
($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $1
1, $12, $13) RETURNING "id"
(1 row)

You can find the locks here:

http://www.hungry.com/~tspencer/pgpoolBugFromDB.txt