Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1ZZV3K-00059g-99 for pgsql-admin@arkaria.postgresql.org; Wed, 09 Sep 2015 02:24:02 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1ZZV3J-0004O3-FA for pgsql-admin@arkaria.postgresql.org; Wed, 09 Sep 2015 02:24:01 +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 1ZZV3H-0004Na-HW for pgsql-admin@postgresql.org; Wed, 09 Sep 2015 02:23:59 +0000 Received: from mail-oi0-x22a.google.com ([2607:f8b0:4003:c06::22a]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84) (envelope-from ) id 1ZZV38-000470-Qq for pgsql-admin@postgresql.org; Wed, 09 Sep 2015 02:23:58 +0000 Received: by oiev17 with SMTP id v17so70261329oie.1 for ; Tue, 08 Sep 2015 19:23:49 -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 :message-id:references:to; bh=eIilLC1ac+TCtxEhNXEaNpY8rj7Qei5veNvMO6IZ4eo=; b=M30FknLPEvSYa2Lao8rPk1cVnIvZtQ6fwhCZy9W8AykZZTvEIrElpYygZ+zKwlN+rd KMpu3EZ1A3pCk5suvl57gRybmdc2KdSuIC/nxt870OMW+1IKkqKolTrhsMxVncz8oz3K nUgCqxOnutobhIRxrsi5tP/coWKTtrwhqvoX+CD6xOWIUZmFyfzbWhAS65Xiao4pr/jv SN3MfGjYHkGFQ7pZbEsTHVvGGLUNpRQ2hKuh+rlgTHKjNGiggATvbKOGTSBoO1Oolb0P 77y47y9iQfEesYy9kwW7a7XIGAm94DGCbazQfBcVnMcuip9edsF4UqnNM5y6uP44GSd9 qOlA== X-Received: by 10.202.3.10 with SMTP id 10mr23095823oid.127.1441765428881; Tue, 08 Sep 2015 19:23:48 -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 rg1sm3237979oeb.11.2015.09.08.19.23.47 (version=TLSv1 cipher=ECDHE-RSA-RC4-SHA bits=128/128); Tue, 08 Sep 2015 19:23:48 -0700 (PDT) Content-Type: multipart/alternative; boundary="Apple-Mail=_3BC9AF3C-C55F-4D24-9C52-5645C1DF65BB" Mime-Version: 1.0 (Mac OS X Mail 7.3 \(1878.6\)) Subject: Re: counting transactions From: "Armand Pirvu (home)" In-Reply-To: Date: Tue, 8 Sep 2015 21:23:46 -0500 Cc: Kevin Grittner , "pgsql-admin@postgresql.org" Message-Id: References: <60217767-53CA-49C0-9A80-C1EAB4E24D5F@gmail.com> <1118639083.2187087.1441716965175.JavaMail.yahoo@mail.yahoo.com> To: Keith 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 --Apple-Mail=_3BC9AF3C-C55F-4D24-9C52-5645C1DF65BB Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii Great deal Keith Thanks for the info Armand On Sep 8, 2015, at 8:48 PM, Keith wrote: >=20 >=20 > On Tue, Sep 8, 2015 at 9:28 PM, Armand Pirvu (home) = wrote: > Perfect Kevin >=20 > Many thanks. > On the same token anyway I can count the number of = connects/disconnects for a specific database ? >=20 >=20 >=20 > Thanks > Armand >=20 >=20 > Set connections and disconnections to be logged in postgresql.conf and = then use pg_badger on the logs. Nothing in the database itself that I'm = aware of. > You may also want to look into the pg_stat_statements extension. Be = aware that it does add some overhead to your DB load, but it can provide = a wealth of query statistics for you. pgbadger gives you a lot of that = same data as well, though, just delayed until log analysis runs and = limited to the top 20 or so such statements. >=20 > http://dalibo.github.io/pgbadger/ >=20 > Keith >=20 > =20 >=20 > On Sep 8, 2015, at 7:56 AM, Kevin Grittner wrote: >=20 > > 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 >=20 >=20 >=20 > -- > Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-admin --Apple-Mail=_3BC9AF3C-C55F-4D24-9C52-5645C1DF65BB Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=us-ascii Great = deal Keith


Thanks for the =  info


Armand

On Sep 8, 2015, at 8:48 PM, Keith <keith@keithf4.com> = wrote:



On = Tue, Sep 8, 2015 at 9:28 PM, Armand Pirvu (home) <armand.pirvu@gmail.com> wrote:
Perfect Kevin

Many = thanks.
On the same token anyway I can count the number of = connects/disconnects for a specific database = ?



Thanks
Armand


Set connections and disconnections to be logged in = postgresql.conf and then use pg_badger on the logs. Nothing in the = database itself that I'm aware of.
You may also want to look into = the pg_stat_statements extension. Be aware that it does add some = overhead to your DB load, but it can provide a wealth of query = statistics for you. pgbadger gives you a lot of that same data as well, = though, just delayed until log analysis runs and limited to the top 20 = or so such statements.


Keith

 = ;

On = Sep 8, 2015, at 7:56 AM, Kevin Grittner <kgrittn@ymail.com> = wrote:

> Armand Pirvu (gmail) <armand.pirvu@gmail.com> = 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
=

= --Apple-Mail=_3BC9AF3C-C55F-4D24-9C52-5645C1DF65BB--