Re: [COMMITTERS] pgsql: Provide much better wait information in pg_stat_activity.

rhaas=# select query, state, wait_event, wait_event_type from pg_stat_activity;
                                  query
  | state  |  wait_event   | wait_event_type
-------------------------------------------------------------------------+--------+---------------+-----------------
 select query, state, wait_event, wait_event_type from
pg_stat_activity; | active |               |
 select * from foo for update;
  | active | transactionid | Lock
(2 rows)

...which looks right to me.

> session two:
> rollback; begin; select * from foo where a = 10 for update;
> session two is waiting again

I don't see how you can do this here - the session is blocked.

There could well be a bug here, but I need a little more help to find it.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company