Re: relationship of backend_start, query_start, state_change

From: Michael Lewis <mlewis(at)entrata(dot)com>
To: Si Chen <sichen(at)opensourcestrategies(dot)com>
Cc: PostgreSQL General <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: relationship of backend_start, query_start, state_change
Date: 2020-04-23 16:46:44
Message-ID: CAHOFxGoubxj-nX-_DcjDeHe6KCD=9OfOhKbZzB5NYkL5pPEs=A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

If you use a connection pooler, this would likely be expected behavior
since the connection is getting reused many times. Else, some app is
connected and not closing their connection between queries. At least they
aren't idle in transaction though.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Olivier Gautherot 2020-04-23 16:54:53 Re: relationship of backend_start, query_start, state_change
Previous Message Preethi S 2020-04-23 16:43:26 Re: Reg: Help to understand the source code