pg.ddx.io pgsql-admin@postgresql.org mailing list archive help / color / mirror / Atom feed From: rajan <vgmonnet@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Why are a lot of ROLLBACK queries in idle state
Date: Fri, 18 Nov 2016 02:55:27 -0700 (MST)
Message-ID: <1479462927604-5930917.post@n3.nabble.com> (raw )
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
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
view thread (6+ messages) latest in thread
Message-ID: <1479462927604-5930917.post@n3.nabble.com>
Permalink: ../1479462927604-5930917.post@n3.nabble.com/
Also on: postgresql.org/message-id/1479462927604-5930917.post@n3.nabble.com
copy link · copy postgr.es
reply Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: vgmonnet@gmail.com
Subject: Re: Why are a lot of ROLLBACK queries in idle state
In-Reply-To: <1479462927604-5930917.post@n3.nabble.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox