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.mc...@gmail.com > CC: pgsql-general@postgresql.org > Subject: Re: [GENERAL] PG connections going to 'waiting' > Date: Sat, 5 Sep 2009 15:24:55 -0400 > From: t...@sss.pgh.pa.us > > Alan McKay <alan.mc...@gmail.com> 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@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general _________________________________________________________________ Click less, chat more: Messenger on MSN.ca http://go.microsoft.com/?linkid=9677404
