|
Is the any way to look at the statistics on the name of table, length and type over a period of time? Or, would we have to use munin and capture these stats for analysis later? Chris > To: alan.mckay@xxxxxxxxx > CC: pgsql-general@xxxxxxxxxxxxxx > Subject: Re: PG connections going to 'waiting' > Date: Sat, 5 Sep 2009 15:24:55 -0400 > From: tgl@xxxxxxxxxxxxx > > Alan McKay <alan.mckay@xxxxxxxxx> writes: > >> pg_locks? Somebody taking exclusive lock on a widely-used table might > >> explain that. > > > OK, in theory we could do the following, no? > > > Use our PITR logs to restore a tertiary system to the point when we > > were having the problem (we have a pretty wide 2 or 3 hour window to > > hit), then query the pg_locks table on that system? > > No, that wouldn't tell you a single thing. pg_locks is a dynamic view > of current system state. You would have to look at it while having > the problem. > > regards, tom lane > > -- > Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general Faster Hotmail access now on the new MSN homepage. |
