Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1knlDE-0003dd-Jc for pgsql-admin@arkaria.postgresql.org; Fri, 11 Dec 2020 16:24:08 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1knlDD-0002DF-Ip for pgsql-admin@arkaria.postgresql.org; Fri, 11 Dec 2020 16:24:07 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1knlDD-0002D8-As for pgsql-admin@lists.postgresql.org; Fri, 11 Dec 2020 16:24:07 +0000 Received: from mout.perfora.net ([74.208.4.194]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1knlDA-0000oq-Dv for pgsql-admin@lists.postgresql.org; Fri, 11 Dec 2020 16:24:06 +0000 Received: from [192.168.1.165] ([72.205.30.64]) by mrelay.perfora.net (mreueus003 [74.208.5.2]) with ESMTPSA (Nemesis) id 0MC3mA-1kwatl2Qme-008ptX; Fri, 11 Dec 2020 17:24:01 +0100 Subject: Re: How to gather transaction information for reporting in postgress To: "Tharmarajah, Sam" Cc: "pgsql-admin@lists.postgresql.org" References: From: MichaelDBA Message-ID: <0cf5855e-39d9-244e-1523-be0416a432fc@sqlexec.com> Date: Fri, 11 Dec 2020 11:23:59 -0500 User-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:52.0) Gecko/20100101 PostboxApp/7.0.41 MIME-Version: 1.0 In-Reply-To: Content-Type: multipart/alternative; boundary="------------00E5BA4A5DA80A6AB11A4E98" Content-Language: en-US X-Provags-ID: V03:K1:0bZw/Bv/xz0BfkPRvKgHf0pXTT02kr4yokxeIW3s5geCUvcuSB6 NmAo6CUMpDxaRKl9V3Z6/0LfkXlHLfEuNJrvzUSyCyEp1MYxiDg6aswmgQy+W2Z+bPApaHC CLbvnDG7Wf3uR1BidiXOeVnINz5oTjRps0heqnol3pY2DbQjEVVDPd8uHkHtHCmyxExLwrw BsxuMhEKxtG8DAbO77v1g== X-Spam-Flag: NO X-UI-Out-Filterresults: notjunk:1;V03:K0:EyzTITm/p08=:lB7o3Jvit2/WuTqLcW5GTc 6NWYE8mMX2MN4feVMAsjAyijFFnwvMsRUOn/yQVu0v+n7cVZnAlOVGCG0zpiyInNF9y+kx5NE vpaYMZvHSkaP3TQZCt+6p3fpVgocwCbSJLrzgy+Jaf6KX1tyG7KK26vhT/YJhnOsrW9HBCHBb GqdmgwXe1HsyOoiXl34yKZbfuH25wYZF7TnSOwjQ3EYiuGRVcgxFgf7FC5nVNXvkpv5jrBoKz 0BqYmzbrxM229CXP1nIOzx9qq3iR2vAPfjZFFLDf9DLXkmzNd89zJruqE4YuSdxo35Po3QWKt 66nlKUlBN36kp5PAKIDLAZ5EkO9FhEfFlmqVznk2w9arlf5NJoK6UmeWy4M1Xh1BO7yq3qyTE rS/Omt4tONb3YuDFvbQKUyayck2N3dwP51KWmGdr1aYS6gpXihf5bXgoWr4us8KXPeQ55lPqH kh7OHRhgRg== List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk This is a multi-part message in MIME format. --------------00E5BA4A5DA80A6AB11A4E98 Content-Type: text/plain; charset=windows-1252; format=flowed Content-Transfer-Encoding: 7bit You can get transactions per time duration aka TPS from pg_stat_database table for commit and rollbacks. Regards, Michael Vitale Tharmarajah, Sam wrote on 12/11/2020 10:49 AM: > > Hi All, > > I am new to postgress. We have postgress 9.3 and we have been > requested to gather transaction information from the database. I there > any views or tables that we can use to gather those information? > > My advance thanks for all the helps. > > Thanx, > > Sam > --------------00E5BA4A5DA80A6AB11A4E98 Content-Type: text/html; charset=windows-1252 Content-Transfer-Encoding: 8bit You can get transactions per time duration aka TPS from pg_stat_database table for commit and rollbacks.

Regards,
Michael Vitale

Tharmarajah, Sam wrote on 12/11/2020 10:49 AM:

Hi All,

I am new to postgress. We have postgress 9.3 and we have been requested to gather transaction information from the database. I there any views or tables that we can use to gather those information?

My advance thanks for all the helps.

Thanx,

Sam

--------------00E5BA4A5DA80A6AB11A4E98--