Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1c7fvB-0000l5-8t for pgsql-admin@arkaria.postgresql.org; Fri, 18 Nov 2016 09:57:25 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1c7fvA-0003SS-6g for pgsql-admin@arkaria.postgresql.org; Fri, 18 Nov 2016 09:57:24 +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_2) (envelope-from ) id 1c7ftS-0001Ze-Db for pgsql-admin@postgresql.org; Fri, 18 Nov 2016 09:55:38 +0000 Received: from mwork.nabble.com ([162.253.133.43]) by magus.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1c7ftK-0007xz-2Y for pgsql-admin@postgresql.org; Fri, 18 Nov 2016 09:55:37 +0000 Received: from mben.nabble.com (unknown [162.253.133.72]) by mwork.nabble.com (Postfix) with ESMTP id C30596D285CDE for ; Fri, 18 Nov 2016 02:55:27 -0700 (MST) Date: Fri, 18 Nov 2016 02:55:27 -0700 (MST) From: rajan To: pgsql-admin@postgresql.org Message-ID: <1479462927604-5930917.post@n3.nabble.com> Subject: Why are a lot of ROLLBACK queries in idle state MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -0.3 (/) 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 Hi, When querying the pg_stat_acitivity I find a lot of ROLLBACK queries in idle state. Can someone help me know why? Thanks in advance. select query, state, waiting, query_start from pg_stat_activity where query ilike '%rollback%'; query | state | waiting | query_start -------------------------------------------------------------------------------------------------+--------+---------+------------------------------- ROLLBACK | idle | f | 2016-11-17 03:02:24.544345+00 ROLLBACK | idle | f | 2016-11-18 09:32:19.372843+00 ROLLBACK | idle | f | 2016-11-15 13:31:54.756704+00 ROLLBACK | idle | f | 2016-11-18 07:08:45.51883+00 ROLLBACK | idle | f | 2016-11-17 12:41:42.731161+00 ROLLBACK | idle | f | 2016-11-18 09:32:17.91838+00 ROLLBACK | idle | f | 2016-11-16 13:20:31.044959+00 ROLLBACK | idle | f | 2016-11-17 10:42:09.652842+00 ROLLBACK | idle | f | 2016-11-17 06:43:38.280102+00 ROLLBACK | idle | f | 2016-11-15 12:48:05.320185+00 ROLLBACK | idle | f | 2016-11-18 07:35:38.029441+00 ROLLBACK | idle | f | 2016-11-10 10:28:01.60524+00 ROLLBACK | idle | f | 2016-11-15 13:57:14.68677+00 ROLLBACK | idle | f | 2016-11-18 09:33:49.067333+00 ROLLBACK | idle | f | 2016-11-17 13:10:14.768031+00 ROLLBACK | idle | f | 2016-11-18 03:18:21.688177+00 ROLLBACK | idle | f | 2016-11-17 12:41:42.719949+00 select query, state, waiting, query_start from pg_stat_activity where query ilike '%rollback%'; | active | f | 2016-11-18 09:55:05.476337+00 ROLLBACK | idle | f | 2016-11-18 08:24:59.286648+00 ROLLBACK | idle | f | 2016-11-17 13:10:14.767571+00 ROLLBACK | idle | f | 2016-11-18 09:32:19.448064+00 ROLLBACK | idle | f | 2016-11-15 13:57:14.680491+00 ROLLBACK | idle | f | 2016-11-11 09:18:26.057973+00 ROLLBACK | idle | f | 2016-11-15 12:24:52.661909+00 ROLLBACK | idle | f | 2016-11-11 09:18:26.064561+00 ROLLBACK | idle | f | 2016-11-18 06:56:57.2566+00 ROLLBACK | idle | f | 2016-11-11 09:16:21.458585+00 ROLLBACK | idle | f | 2016-11-16 13:21:02.534579+00 ----- -- Thanks, Rajan. -- View this message in context: http://postgresql.nabble.com/Why-are-a-lot-of-ROLLBACK-queries-in-idle-state-tp5930917.html Sent from the PostgreSQL - admin mailing list archive at Nabble.com. -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin