Re: fetch all from "<unnamed portal 1>"

From: Ganesh Korde <ganeshakorde(at)gmail(dot)com>
To: Siraj G <tosiraj(dot)g(at)gmail(dot)com>
Cc: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: fetch all from "<unnamed portal 1>"
Date: 2026-09-09 05:12:09
Message-ID: CAPNyb0Uih2BR1fWXCKGjeREvys2qG_ZL7EDk+Q96LKTLmFxywg@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Wed, 9 Sept 2026, 10:01 am Siraj G, <tosiraj(dot)g(at)gmail(dot)com> wrote:

> Hello Admin experts!
>
> Postgres version 14 and the instance is a GCP cloud SQL.
>
> We have several application connections in ACTIVE state for several hours
> and the query text shows just *fetch all from "<unnamed portal 1>"*.
> What does it indicate? Could these sessions be in hung state?
>
> Regards
> Siraj
>

What do you see in wait events column in pg_stat_activity?

>

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Laurenz Albe 2026-09-09 06:14:02 Re: fetch all from "<unnamed portal 1>"
Previous Message Siraj G 2026-09-09 04:31:23 fetch all from "<unnamed portal 1>"