Re: Connections - Postgres 9.2

On 05/16/2016 09:56 AM, Charles Clavadetscher wrote:
> Hello
>
> On 16.05.2016, at 18:32, Francisco Olarte <folarte(at)peoplecall(dot)com
> <mailto:folarte(at)peoplecall(dot)com>> wrote:
>
>> Hi Lucas
>>
>> On Mon, May 16, 2016 at 4:10 AM, Lucas Possamai <drum(dot)lucas(at)gmail(dot)com
>> <mailto:drum(dot)lucas(at)gmail(dot)com>> wrote:
>>
>>
>> Those IDLE connections, might be because the user/application
>> didn't commit the transaction?
>>
>>
>> ​IIRC Those would be 'Idle in transaction' ( which are normally bad if
>> numerous, unless your app has a reason for them, as they are the ones
>> which can block things ). Plain 'Idle' are normally connections
>> between transactions, totally normal if you use poolers, or if your
>> app keeps connection opens while it does other things ( like preparing
>> for a transaction ).
>>
>
> There really is a state 'Idle in transaction'? Good to learn.

http://www.postgresql.org/docs/9.5/static/monitoring-stats.html
"
state text Current overall state of this backend. Possible values are:

active: The backend is executing a query.

idle: The backend is waiting for a new client command.

idle in transaction: The backend is in a transaction, but is not
currently executing a query.

idle in transaction (aborted): This state is similar to idle in
transaction, except one of the statements in the transaction caused an
error.

fastpath function call: The backend is executing a fast-path function.

disabled: This state is reported if track_activities is disabled in
this backend.
"

> Thank you and bye
> Charles
>
>> Francisco Olarte.
>>
>>
>>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com