Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1ZZUBd-0003Dd-3w for pgsql-admin@arkaria.postgresql.org; Wed, 09 Sep 2015 01:28:33 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1ZZUBc-0003X2-99 for pgsql-admin@arkaria.postgresql.org; Wed, 09 Sep 2015 01:28:32 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1ZZUBb-0003Wu-Tq for pgsql-admin@postgresql.org; Wed, 09 Sep 2015 01:28:31 +0000 Received: from mail-pa0-x22a.google.com ([2607:f8b0:400e:c03::22a]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84) (envelope-from ) id 1ZZUBY-00033N-5A for pgsql-admin@postgresql.org; Wed, 09 Sep 2015 01:28:31 +0000 Received: by pacex6 with SMTP id ex6so139955099pac.0 for ; Tue, 08 Sep 2015 18:28:26 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=content-type:mime-version:subject:from:in-reply-to:date:cc :content-transfer-encoding:message-id:references:to; bh=RCLxXhCJ3b6P3Th2XsdfxZ0m63hyniNHODeEE2bviOE=; b=c5Gjg6aHDlwAXUl8PP9TnCi0tcVWlIKfW/YI28PokQyG7W7tR++WYpVAuLOm4jkFRM pUYyk3dTGXBd4qgI6UGFv39zGOfIN7Fp3fvYhRJrRuC8aBiCgHMQQboNXuCC9CofVe7b ByALAbhSSDUNInqjHBVoofQd96dTSDKUONdDep7a0m95cKtPpc88FGhsYkf3YOibmplU VEVmSyNkxOdQzQivEqlaoof6TiDMKGMtppbiIle4+4lLnPsiyqrldlWYrkGYHUeeEPHq HeRsezCRxjX14GXKK4jfXPOY7ShMwxBjifUbkiqLDtMbYjMlGf1FTn2yGJLR+sDRw+0I Wo6w== X-Received: by 10.66.193.132 with SMTP id ho4mr56552957pac.154.1441762105841; Tue, 08 Sep 2015 18:28:25 -0700 (PDT) Received: from ?IPv6:2602:306:37d8:1e20:206e:4c93:e0d6:ac6c? ([2602:306:37d8:1e20:206e:4c93:e0d6:ac6c]) by smtp.gmail.com with ESMTPSA id zn9sm4900883pac.11.2015.09.08.18.28.24 (version=TLSv1/SSLv3 cipher=OTHER); Tue, 08 Sep 2015 18:28:25 -0700 (PDT) Content-Type: text/plain; charset=us-ascii Mime-Version: 1.0 (Mac OS X Mail 7.3 \(1878.6\)) Subject: Re: counting transactions From: "Armand Pirvu (home)" In-Reply-To: <1118639083.2187087.1441716965175.JavaMail.yahoo@mail.yahoo.com> Date: Tue, 8 Sep 2015 20:28:23 -0500 Cc: "pgsql-admin@postgresql.org" Content-Transfer-Encoding: quoted-printable Message-Id: References: <60217767-53CA-49C0-9A80-C1EAB4E24D5F@gmail.com> <1118639083.2187087.1441716965175.JavaMail.yahoo@mail.yahoo.com> To: Kevin Grittner X-Mailer: Apple Mail (2.1878.6) X-Pg-Spam-Score: -2.7 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org Perfect Kevin Many thanks.=20 On the same token anyway I can count the number of connects/disconnects for= a specific database ? Thanks Armand On Sep 8, 2015, at 7:56 AM, Kevin Grittner wrote: > Armand Pirvu (gmail) wrote: >=20 >> is there any way to really count the transactions ? In Ingres for >> example I can look in logdump output or in imadb >=20 > If you only care about transactions that modify the database, you > could look at the output of the pg_controldata utility and pick off > the NextXID value. >=20 > -- > Kevin Grittner > EDB: http://www.enterprisedb.com > The Enterprise PostgreSQL Company --=20 Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin