Re: Why in pgAdmin an active session is marked/highlighted in Red

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Shaozhong SHI <shishaozhong(at)gmail(dot)com>, Pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Why in pgAdmin an active session is marked/highlighted in Red
Date: 2021-11-11 16:06:36
Message-ID: fe8aa33a4800b290bf90097bba807a91a2496b23.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, 2021-11-11 at 13:24 +0000, Shaozhong SHI wrote:
> I never came across this before and wonder why?

I think I remember that means that the session is stuck behind a lock,
but I am not certain. Look for "wait_event_type" in "pg_stat_statement".

Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message sch8el 2021-11-11 18:39:49 Are all unlogged tables in any case truncated after a server-crash?
Previous Message Jean Baro 2021-11-11 14:23:57 Re: Phonetic representation LENGHT for DMETAPHONE, is there a way to make it longer?