MIME-Version: 1.0
References: <CAA5-nLDmkuRbjHJvf2-Sz0FxtJtoFdrg4mUTy6N84UpZtGZJwQ@mail.gmail.com>
 <3147833.1725894012@sss.pgh.pa.us> <CAA5-nLAqRy5-3DkoDZn-k2quAvqUx6KwT=_JcHouAqX4poMm0A@mail.gmail.com>
 <CAA5-nLD9tFX_AMNP2hbh_OD2FHoSfjp0PQHR4BTzDNO4NvUiBg@mail.gmail.com>
In-Reply-To: <CAA5-nLD9tFX_AMNP2hbh_OD2FHoSfjp0PQHR4BTzDNO4NvUiBg@mail.gmail.com>
From: Greg Sabino Mullane <htamfids@gmail.com>
Date: Wed, 11 Sep 2024 08:29:40 -0400
Message-ID: <CAKAnmmKyoo3WB1-j4gz8Si11OGcgSfCCVbu+N=rmzyBHJ8=GSQ@mail.gmail.com>
Subject: Re: infinite loop in an update statement
To: Fabrice Chapuis <fabrice636861@gmail.com>
Cc: pgsql-general@postgresql.org
Content-Type: multipart/alternative; boundary="000000000000115f720621d727b5"
Archived-At: <https://www.postgresql.org/message-id/CAKAnmmKyoo3WB1-j4gz8Si11OGcgSfCCVbu%2BN%3DrmzyBHJ8%3DGSQ%40mail.gmail.com>
Precedence: bulk

--000000000000115f720621d727b5
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Wed, Sep 11, 2024 at 6:14=E2=80=AFAM Fabrice Chapuis <fabrice636861@gmai=
l.com>
wrote:

> status =3D active
>> wait event =3D NULL
>> wait event type =3D NULL
>>
>
That seems quite unlikely. Perhaps you are seeing the pg_stat_activity
query itself? Try this:

select state, now()-state_change, wait_event_type, wait_event, query
from pg_stat_activity where query ~ 'SELECT MIN' and pg_backend_pid() <>
pid;

Cheers,
Greg

--000000000000115f720621d727b5
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">On Wed, Sep 11, 2024 at 6:14=E2=80=AFAM F=
abrice Chapuis &lt;<a href=3D"mailto:fabrice636861@gmail.com">fabrice636861=
@gmail.com</a>&gt; wrote:<br></div><div class=3D"gmail_quote"><blockquote c=
lass=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px soli=
d rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr"><div class=3D"gmail_q=
uote"><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;b=
order-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr">st=
atus =3D active<div>wait event =3D NULL</div><div>wait event type =3D NULL<=
/div></div></blockquote></div></div></blockquote><div><br></div><div>That s=
eems quite unlikely. Perhaps you are seeing the pg_stat_activity query itse=
lf? Try this:</div><div><br></div><div>select state, now()-state_change, wa=
it_event_type, wait_event, query</div><div>from pg_stat_activity where quer=
y ~ &#39;SELECT MIN&#39; and pg_backend_pid() &lt;&gt; pid;<br></div><div><=
br></div><div>Cheers,</div><div>Greg</div><div><br></div><div>=C2=A0</div><=
/div></div>

--000000000000115f720621d727b5--