Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 8CA0C650329 for ; Fri, 11 Jul 2008 18:47:13 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 66017-02 for ; Fri, 11 Jul 2008 18:47:07 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail.silentmedia.com (earth.silentmedia.com [216.254.19.12]) by postgresql.org (Postfix) with ESMTP id 756D464FCE7 for ; Fri, 11 Jul 2008 18:47:10 -0300 (ADT) Received: by mail.silentmedia.com (Postfix, from userid 99) id 7B65B108923; Fri, 11 Jul 2008 14:47:08 -0700 (PDT) Received: from GRD (GRD [10.125.42.6]) by mail.silentmedia.com (Postfix) with ESMTP id A75E5108922; Fri, 11 Jul 2008 14:47:07 -0700 (PDT) Date: Fri, 11 Jul 2008 14:47:07 -0700 (PDT) From: Ben X-X-Sender: bench@localhost.localdomain To: "Campbell, Lance" cc: pgsql-performance@postgresql.org Subject: Re: How many updates and inserts In-Reply-To: Message-ID: References: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200807/113 X-Sequence-Number: 30713 Have a look at the pg_stat_user_tables table. On Fri, 11 Jul 2008, Campbell, Lance wrote: > PostgreSQL: 8.2 > > How can I identify how many inserts and updates are being done in a > given time frame for a database? > > > > Thanks, > > > > > > Lance Campbell > > Project Manager/Software Architect > > Web Services at Public Affairs > > University of Illinois > > 217.333.0382 > > http://webservices.uiuc.edu > > My e-mail address has changed to lance@illinois.edu > > > >