Postgres query

From: Ian Dauncey <Ian(dot)Dauncey(at)bankzero(dot)co(dot)za>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Postgres query
Date: 2022-03-11 10:02:39
Message-ID: DBAPR08MB56872F9A7E2437CE08968BFFC00C9@DBAPR08MB5687.eurprd08.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi All

Can anyone assist in shedding some light here.

We getting this query popping up in our postgresql log file at the same time as the connections to the databases starts increasing.
Not sure what is initiating this query, but we get around a hundred per second until we restart our applications.
Any help will be appreciated.

The Query :

"select $1[s], s - pg_catalog.array_lower($1,1) + 1
from pg_catalog.generate_series(pg_catalog.array_lower($1,1),
pg_catalog.array_upper($1,1),1) as g(s)"

Regards
Ian

Disclaimer

The information contained in this communication from the sender is confidential. It is intended solely for use by the recipient and others authorized to receive it. If you are not the recipient, you are hereby notified that any disclosure, copying, distribution or taking action in relation of the contents of this information is strictly prohibited and may be unlawful.

This email has been scanned for viruses and malware, and may have been automatically archived by Mimecast, a leader in email security and cyber resilience. Mimecast integrates email defenses with brand protection, security awareness training, web security, compliance and other essential capabilities. Mimecast helps protect large and small organizations from malicious activity, human error and technology failure; and to lead the movement toward building a more resilient world. To find out more, visit our website.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message hubert depesz lubaczewski 2022-03-11 10:57:02 Re: Postgres query
Previous Message Durumdara 2022-03-11 08:53:44 Am I in the same transaction block in complex PLPGSQL?