Postgres Pro
Downloads
Home   >   mailing lists

Re: idle transactions vs memory - Mailing list pgsql-admin

From Atul Kumar
Subject Re: idle transactions vs memory
Date
Msg-id CA+ONtZ4qAb8VSpWacOiSTOJ5-y-Pb_uhHUW_kGkO4gDMthb4Sw@mail.gmail.com
Whole thread Raw
In response to Re: idle transactions vs memory  (Scott Ribe <scott_ribe@elevated-dev.com>)
Responses Re: idle transactions vs memory  ("David G. Johnston" <david.g.johnston@gmail.com>)
Re: idle transactions vs memory  (Laurenz Albe <laurenz.albe@cybertec.at>)
List pgsql-admin
Tree view 
Hi,

The transactions state is 'idle' from more than 15 minutes, so my
question is that are they occupying any amount of RAM?

are these 'idle' transactions are using CPU ?


Please help me.



Regards,
Atul

On 12/7/20, Scott Ribe <scott_ribe@elevated-dev.com> wrote:
>> On Dec 6, 2020, at 7:29 PM, Atul Kumar <akumar14871@gmail.com> wrote:
>>
>> I have a basic query that do idle transactions (idle more than 5
>> minutes) occupy system memory (RAM) or CPU usage ?
>
> Actual idle transaction? Or just idle connections not currently in
> transactions?
>
>

pgsql-admin by date:

Previous
From: Scott Ribe
Date:
Subject: Re: idle transactions vs memory
Next
From: "David G. Johnston"
Date:
Subject: Re: idle transactions vs memory