Re: [GENERAL] idle in transaction, why

On 11/06/2017 01:17 PM, Tom Lane wrote:
> "David G. Johnston" <david.g.johnston@gmail.com> writes:
>> You should probably login as your application user and do "show
>> idle_in_transaction_session_timeout" to see what a clean session has for a
>> value and then figure out from there where that value is coming from.
> You don't have to guess about the latter: the pg_settings view will tell
> you exactly where the active value came from.  See the source, sourcefile,
> sourceline columns.
>
>             regards, tom lane
select name, setting, source, sourcefile, sourceline, extra_desc, 
context from pg_settings where name ~ 'idle';                name                 | setting | source  | sourcefile | 
sourceline |              extra_desc               | context

-------------------------------------+---------+---------+------------+------------+---------------------------------------+---------
idle_in_transaction_session_timeout| 0       | default |            
 
|            | A value of 0 turns off the timeout. | user tcp_keepalives_idle                 | 7200    | default |
      
 
|            | A value of 0 uses the system default. | user
(2 rows)



-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general