datname |
relname |
transactionid |
mode |
granted |
usename |
substr |
query_start |
age |
procpid |
tissupath |
doctor_pkey |
|
AccessShareLock |
t |
postgres |
<IDLE> in transaction |
2009-03-09 09:46:13.471743+11 |
00:01:03.46 |
8450 |
tissupath |
doctor_internalid_key |
|
AccessShareLock |
t |
postgres |
<IDLE> in transaction |
2009-03-09 09:46:13.471743+11 |
00:01:03.46 |
8450 |
tissupath |
|
|
ExclusiveLock |
t |
postgres |
<IDLE> in transaction |
2009-03-09 09:46:13.471743+11 |
00:01:03.46 |
8450 |
tissupath |
title_pkey |
|
AccessShareLock |
t |
postgres |
<IDLE> in transaction |
2009-03-09 09:46:13.471743+11 |
00:01:03.46 |
8450 |
tissupath |
doctor_hl7id_key |
|
AccessShareLock |
t |
postgres |
<IDLE> in transaction |
2009-03-09 09:46:13.471743+11 |
00:01:03.46 |
8450 |
tissupath |
users_doctor |
|
AccessShareLock |
t |
postgres |
<IDLE> in transaction |
2009-03-09 09:46:13.471743+11 |
00:01:03.46 |
8450 |
tissupath |
doctor |
|
AccessShareLock |
t |
postgres |
<IDLE> in transaction |
2009-03-09 09:46:13.471743+11 |
00:01:03.46 |
8450 |
tissupath |
title |
|
AccessShareLock |
t |
postgres |
<IDLE> in transaction |
2009-03-09 09:46:13.471743+11 |
00:01:03.46 |
8450 |
tissupath |
|
|
ExclusiveLock |
t |
postgres |
alter table Doctor drop constr |
2009-03-09 09:46:49.063751+11 |
00:00:27.87 |
8456 |
tissupath |
doctor |
|
AccessExclusiveLock |
f |
postgres |
alter table Doctor drop constr |
2009-03-09 09:46:49.063751+11 |
00:00:27.87 |
8456 |
tissupath |
pg_class_oid_index |
|
AccessShareLock |
t |
postgres |
select pg_stat_activity.datnam |
2009-03-09 09:47:16.93356+11 |
00:00:00 |
7517 |
tissupath |
pg_database_oid_index |
|
AccessShareLock |
t |
postgres |
select pg_stat_activity.datnam |
2009-03-09 09:47:16.93356+11 |
00:00:00 |
7517 |
tissupath |
pg_authid_oid_index |
|
AccessShareLock |
t |
postgres |
select pg_stat_activity.datnam |
2009-03-09 09:47:16.93356+11 |
00:00:00 |
7517 |
tissupath |
|
|
ExclusiveLock |
t |
postgres |
select pg_stat_activity.datnam |
2009-03-09 09:47:16.93356+11 |
00:00:00 |
7517 |
tissupath |
pg_locks |
|
AccessShareLock |
t |
postgres |
select pg_stat_activity.datnam |
2009-03-09 09:47:16.93356+11 |
00:00:00 |
7517 |
tissupath |
pg_stat_activity |
|
AccessShareLock |
t |
postgres |
select pg_stat_activity.datnam |
2009-03-09 09:47:16.93356+11 |
00:00:00 |
7517 |
tissupath |
pg_authid |
|
AccessShareLock |
t |
postgres |
select pg_stat_activity.datnam |
2009-03-09 09:47:16.93356+11 |
00:00:00 |
7517 |
tissupath |
pg_class_relname_nsp_index |
|
AccessShareLock |
t |
postgres |
select pg_stat_activity.datnam |
2009-03-09 09:47:16.93356+11 |
00:00:00 |
7517 |
tissupath |
pg_database |
|
AccessShareLock |
t |
postgres |
select pg_stat_activity.datnam |
2009-03-09 09:47:16.93356+11 |
00:00:00 |
7517 |
tissupath |
pg_database_datname_index |
|
AccessShareLock |
t |
postgres |
select pg_stat_activity.datnam |
2009-03-09 09:47:16.93356+11 |
00:00:00 |
7517 |
tissupath |
pg_class |
|
AccessShareLock |
t |
postgres |
select pg_stat_activity.datnam |
2009-03-09 09:47:16.93356+11 |
00:00:00 |
7517 |
tissupath |
pg_authid_rolname_index |
|
AccessShareLock |
t |
postgres |
select pg_stat_activity.datnam |
2009-03-09 09:47:16.93356+11 |
00:00:00 |
7517 |