Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id A41819FB428 for ; Fri, 6 Oct 2006 11:23:14 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 65461-01-3 for ; Fri, 6 Oct 2006 11:23:01 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from ciao.gmane.org (main.gmane.org [80.91.229.2]) by postgresql.org (Postfix) with ESMTP id 7B7509FB414 for ; Fri, 6 Oct 2006 11:23:01 -0300 (ADT) Received: from list by ciao.gmane.org with local (Exim 4.43) id 1GVqaT-0007tt-Tp for pgsql-admin@postgresql.org; Fri, 06 Oct 2006 16:22:05 +0200 Received: from pirus.securax.be ([213.16.46.130]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Fri, 06 Oct 2006 16:22:05 +0200 Received: from milen by pirus.securax.be with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Fri, 06 Oct 2006 16:22:05 +0200 X-Injected-Via-Gmane: http://gmane.org/ To: pgsql-admin@postgresql.org From: "Milen A. Radev" Subject: Re: anyway to get a transaction count? Date: Fri, 06 Oct 2006 17:21:24 +0300 Lines: 18 Message-ID: References: <1d219a6f0610060700s4d8c7eb4u5dea161f474bb10d@mail.gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit X-Complaints-To: usenet@sea.gmane.org X-Gmane-NNTP-Posting-Host: pirus.securax.be User-Agent: Mozilla Thunderbird 1.5.0.7 (Windows/20060909) In-Reply-To: <1d219a6f0610060700s4d8c7eb4u5dea161f474bb10d@mail.gmail.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.018 tagged_above=0 required=5 tests=AWL, SPF_HELO_PASS, SPF_PASS X-Spam-Level: X-Archive-Number: 200610/43 X-Sequence-Number: 23346 Chris Hoover написа: > Is there an easy way to get a count on the number of transactions postgres > is processing a min/hour/day/etc.? If so, can it be broken down by the > individual databases in the cluster? > > Thanks, > > Chris > You could monitor the "xact_commit" column from the "pg_stat_database" system view. More info here - http://www.postgresql.org/docs/8.1/static/monitoring-stats.html#MONITORING-STATS-VIEWS -- Milen A. Radev