So the query is just the latest query and the time is the transaction time since this query, i suppose ? Thanks for your answer, i will try to make the transaction shorter as you suggest.
On Tue, Jan 30, 2018 at 12:29 AM, Nikolay Samokhvalov <samokhva...@gmail.com > wrote: > On Mon, Jan 29, 2018 at 3:19 PM, Jan De Moerloose <j...@sensolus.com> > wrote: > >> The state is 'idle in transaction'. >> > > So you have long-running *transactions*, not queries. This is not good for > an OLTP system, because some transaction can wait of others, which are > "idle in transaction" but do nothing at the moment. Think how you can make > them shorter, commit faster. > > Also, if your server version is 9.6+ consider setting > idle_in_transaction_session_timeout to some low value: > https://www.postgresql.org/docs/current/static/runtime- > config-client.html#GUC-IDLE-IN-TRANSACTION-SESSION-TIMEOUT > >
