Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1ZZIRZ-0000f6-Mp for pgsql-admin@arkaria.postgresql.org; Tue, 08 Sep 2015 12:56:13 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1ZZIRZ-00015i-9W for pgsql-admin@arkaria.postgresql.org; Tue, 08 Sep 2015 12:56:13 +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 1ZZIRY-00014F-EQ for pgsql-admin@postgresql.org; Tue, 08 Sep 2015 12:56:12 +0000 Received: from nm8-vm9.bullet.mail.gq1.yahoo.com ([98.136.218.232]) by magus.postgresql.org with esmtps (TLS1.0:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84) (envelope-from ) id 1ZZIRV-0005Dp-4u for pgsql-admin@postgresql.org; Tue, 08 Sep 2015 12:56:11 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=ymail.com; s=s2048; t=1441716966; bh=WjHl9gUdJ1HThc3prZx/95JadEv0+ggas/q6F9DoF6c=; h=Date:From:Reply-To:To:In-Reply-To:References:Subject:From:Subject; b=al3SwxsbMRSTZK41KZZRiK8R4meYDqmQlDreS4Qvjp/MX6xQZ2G2iPEXk9oklU86hQivliuTSIgJMJlItGEvctOzDhZOfS6RLFs4g/At/cEYQeOOaLZb7x5K5ll01pRiMd7awmpfuUuoe4ChjaLAnucSSjMjJXVAp7cbT6quNS+J9XP9H862ZGZlDcZ3xPA6YVMtX4/lvAuK4ZMlVIU+V2Ba2sOWsIcABJPp9IYAovyONCjHL7BuDk6Od92d3utPfrLBio25RjNDsWTutJ6vrIuoVUHf54Ku+02QbSke3E2wrHS6Arq+SpDVDxNgLkWHe9x8SaD6LoGDwrLk3lGI/w== Received: from [98.137.12.56] by nm8.bullet.mail.gq1.yahoo.com with NNFMP; 08 Sep 2015 12:56:06 -0000 Received: from [98.137.12.201] by tm1.bullet.mail.gq1.yahoo.com with NNFMP; 08 Sep 2015 12:56:06 -0000 Received: from [127.0.0.1] by omp1009.mail.gq1.yahoo.com with NNFMP; 08 Sep 2015 12:56:06 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 130637.91215.bm@omp1009.mail.gq1.yahoo.com X-YMail-OSG: Zv4koCMVM1nOgUTq3jGa.4KDAC6kPsLj2C5LPBhaXu41PnEQ96gIbExap6echti lyeFYGYnF5XTS_yRtu_uWtQsvAScjJYTPPUPoFwL9CDEEkuL27lUf5zqNGnKH9kt46oXRMz9J48C C5zj60kY5MVvvr84Bflxnqx0AMS8LGL.IaQ5wU3Zbl7aP3DP8SSJ5G3lXVrIqQCt_Giyu2vehOPW A5bev7HPefHQAlB7sjvHkO4SB0LeGqlVJzh.lgr2DQyBL87uLKkXj3XSZqbQwEqzT0_hEdLZUUZs ZqIDTBK26tppV_81nPN.G.61aLhh06tfnLNK7Wd2udPZgMzGDrFa9jxe60h3hkQbDsrwA.WWuGS5 f047T0OgdOoJgv02oc7lUZkBzGllt8NBR8zFzfPfjKwsRNU1_95IvZXUI2PbbkRPQkHZ4UE8MwBB FxXWxJubGOSs.dQ3ZZ9DOqKoNxhIZzHdVi9QwjcXVPFAFR.jEConsjXyyWfjaXqFBLQvBXLHiWc_ b7WfDR5C9SIM8NnhIijTHSfgs Received: by 98.137.12.48; Tue, 08 Sep 2015 12:56:05 +0000 Date: Tue, 8 Sep 2015 12:56:05 +0000 (UTC) From: Kevin Grittner Reply-To: Kevin Grittner To: "Armand Pirvu (gmail)" , "pgsql-admin@postgresql.org" Message-ID: <1118639083.2187087.1441716965175.JavaMail.yahoo@mail.yahoo.com> In-Reply-To: <60217767-53CA-49C0-9A80-C1EAB4E24D5F@gmail.com> References: <60217767-53CA-49C0-9A80-C1EAB4E24D5F@gmail.com> Subject: Re: counting transactions MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit Content-Length: 413 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 Armand Pirvu (gmail) wrote: > is there any way to really count the transactions ? In Ingres for > example I can look in logdump output or in imadb 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. -- Kevin Grittner EDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin