PG admin 3:

activity
1588		rmv	postgres	::1:49275	2012-06-15 12:12:01.09-04	2012-06-15 13:47:35.494-04	2012-06-15 13:47:35.494-04	2940	ALTER TABLE vins DROP COLUMN owner_type;
	
1736		rmv	postgres	::1:49231	2012-06-15 09:50:12.891-04	2012-06-15 13:36:22.997-04	2012-06-15 13:36:22.997-04		insert into inspections
select * from inspections_1	
2096		rmv	postgres	::1:49234	2012-06-15 09:57:55.797-04	2012-06-15 10:25:08.329-04	2012-06-15 10:25:08.329-04		vacuum (analyze, verbose, full)	
2316		postgres	postgres	::1:49301	2012-06-15 13:44:52.795-04				<IDLE>	
2620		postgres	postgres	::1:49227	2012-06-15 09:44:12.139-04				<IDLE>	
2716		rmv	postgres	::1:49228	2012-06-15 09:44:15.684-04				<IDLE>	
2844		rmv	postgres	::1:49303	2012-06-15 13:50:29.021-04	2012-06-15 13:50:46.417-04	2012-06-15 13:50:46.417-04	2940	select count(*) from vins	
2940		rmv	postgres	::1:49273	2012-06-15 12:01:34.756-04	2012-06-15 13:34:53.55-04	2012-06-15 13:34:53.55-04		
update vins
set insp_count=vc.count
from vin_counts vc
where id = vc.vin_id;
	
3028		postgres	postgres	::1:49232	2012-06-15 09:52:11.764-04				<IDLE>	

locks:
1588	rmv	33074	postgres		11/71	AccessExclusiveLock	No	2012-06-15 13:47:35.494-04	ALTER TABLE vins DROP COLUMN owner_type;
	
1588			postgres	11/71	11/71	ExclusiveLock	Yes	2012-06-15 13:47:35.494-04	ALTER TABLE vins DROP COLUMN owner_type;
	
1736	rmv	33350	postgres		6/39	RowExclusiveLock	Yes	2012-06-15 13:36:22.997-04	insert into inspections
select * from inspections_1	
1736	rmv	33081	postgres		6/39	RowExclusiveLock	Yes	2012-06-15 13:36:22.997-04	insert into inspections
select * from inspections_1	
1736	rmv	33352	postgres		6/39	RowExclusiveLock	Yes	2012-06-15 13:36:22.997-04	insert into inspections
select * from inspections_1	
1736	rmv	33084	postgres		6/39	RowExclusiveLock	Yes	2012-06-15 13:36:22.997-04	insert into inspections
select * from inspections_1	
1736	rmv	33351	postgres		6/39	RowExclusiveLock	Yes	2012-06-15 13:36:22.997-04	insert into inspections
select * from inspections_1	
1736	rmv	33349	postgres		6/39	RowExclusiveLock	Yes	2012-06-15 13:36:22.997-04	insert into inspections
select * from inspections_1	
1736	rmv	49899	postgres		6/39	AccessShareLock	Yes	2012-06-15 13:36:22.997-04	insert into inspections
select * from inspections_1	
1736			postgres		6/39	ExclusiveLock	Yes	2012-06-15 13:36:22.997-04	insert into inspections
select * from inspections_1	
1736	rmv	49896	postgres		6/39	AccessShareLock	Yes	2012-06-15 13:36:22.997-04	insert into inspections
select * from inspections_1	
1736			postgres	6/39	6/39	ExclusiveLock	Yes	2012-06-15 13:36:22.997-04	insert into inspections
select * from inspections_1	
2096	rmv	33528	postgres		8/151	AccessExclusiveLock	Yes	2012-06-15 10:25:08.329-04	vacuum (analyze, verbose, full)	
2096	rmv	50267	postgres		8/151	AccessExclusiveLock	Yes	2012-06-15 10:25:08.329-04	vacuum (analyze, verbose, full)	
2096			postgres		8/151	ExclusiveLock	Yes	2012-06-15 10:25:08.329-04	vacuum (analyze, verbose, full)	
2096			postgres	8/151	8/151	ExclusiveLock	Yes	2012-06-15 10:25:08.329-04	vacuum (analyze, verbose, full)	
2844			postgres	5/27	5/27	ExclusiveLock	Yes	2012-06-15 13:50:46.417-04	select count(*) from vins	
2844	rmv	33074	postgres		5/27	AccessShareLock	No	2012-06-15 13:50:46.417-04	select count(*) from vins	
2940	rmv	33079	postgres		2/251	RowExclusiveLock	Yes	2012-06-15 13:34:53.55-04	
update vins
set insp_count=vc.count
from vin_counts vc
where id = vc.vin_id;
	
2940	rmv	41681	postgres		2/251	AccessShareLock	Yes	2012-06-15 13:34:53.55-04	
update vins
set insp_count=vc.count
from vin_counts vc
where id = vc.vin_id;
	
2940	rmv	33074	postgres		2/251	RowExclusiveLock	Yes	2012-06-15 13:34:53.55-04	
update vins
set insp_count=vc.count
from vin_counts vc
where id = vc.vin_id;
	
2940			postgres		2/251	ExclusiveLock	Yes	2012-06-15 13:34:53.55-04	
update vins
set insp_count=vc.count
from vin_counts vc
where id = vc.vin_id;
	
2940			postgres	2/251	2/251	ExclusiveLock	Yes	2012-06-15 13:34:53.55-04	
update vins
set insp_count=vc.count
from vin_counts vc
where id = vc.vin_id;
	
2940	rmv	50265	postgres		2/251	RowExclusiveLock	Yes	2012-06-15 13:34:53.55-04	
update vins
set insp_count=vc.count
from vin_counts vc
where id = vc.vin_id;
	
2940	rmv	41684	postgres		2/251	AccessShareLock	Yes	2012-06-15 13:34:53.55-04	
update vins
set insp_count=vc.count
from vin_counts vc
where id = vc.vin_id;