Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1upN9t-003rmi-5W for pgsql-admin@arkaria.postgresql.org; Fri, 22 Aug 2025 08:30:02 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1upN9r-0042uJ-I6 for pgsql-admin@arkaria.postgresql.org; Fri, 22 Aug 2025 08:30:00 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1upN9r-0042uA-5Y for pgsql-admin@lists.postgresql.org; Fri, 22 Aug 2025 08:29:59 +0000 Received: from mail-wm1-x329.google.com ([2a00:1450:4864:20::329]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1upN9p-001F40-1l for pgsql-admin@lists.postgresql.org; Fri, 22 Aug 2025 08:29:59 +0000 Received: by mail-wm1-x329.google.com with SMTP id 5b1f17b1804b1-45a1b00f23eso10600395e9.0 for ; Fri, 22 Aug 2025 01:29:57 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec.at; s=google; t=1755851396; x=1756456196; darn=lists.postgresql.org; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:from:to:cc:subject:date :message-id:reply-to; bh=MbYqpxW6JW/6S68v0EgfJjei6NV5mkfHv+U5vTt79UI=; b=SewuTu1TQIsW/K07d4j6vpTr2TlOnXP13f72p7WkPHFiGs2h9a/iwKt2VbOz7Lr2kA NYlSfVlWFlQMCeKGjo0gzh4NUvKfzwk7NOXLZuZd51p4khUAbD8aQQe9JjWc+6vTYnuW ASz7v2ZCCL3HiJLnJQfMddUExUFjVFYIvRPeH9jDxMlujjqk7uICaHOG241vF08nQkWw /WnblXS0CP+rX5na4XMb3Paobb7y226gwgMMNK1+4SvnK+bqb23Tl6K8k9TpMB40E1VJ w+ElfzORc0dQqQhR+Su3qEkqeKa2FcOMhqgxRi59RcGa/afMaaBdsX0G2PZWlfeO5tat sp/w== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1755851396; x=1756456196; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=MbYqpxW6JW/6S68v0EgfJjei6NV5mkfHv+U5vTt79UI=; b=kF4TuxcZH+oRXUW9pigNOHev7iwGHxybFXt8YtwyEVjQevz/a3jhPemz3MVNsvzLhE 4SN+JvL42nt+7U4PI/t7tYfer0t39SurwefEzPhwPmofRrZX9EckUvsUu/Z9TqofwZO4 xMoGVTjunGEv6NX44VddNkeaqU1cDolAobjlUgXjXI+lLUAXIt1UMOQPUHIj4F82zmSG U9yautoD6S3S7guJ0ev5GKxYjdlQ7jNfYrb7mJ/Xg0osjy8rTddZlyjfTPYW9X0M/1DA iBIib8XnM+qkJEEv1QYxEuHAxhP2d1J2u65TrgnjY4sECV03PNB5EzM87YePR+lzG2tw YAfQ== X-Forwarded-Encrypted: i=1; AJvYcCWgZshMGEBNgvAsQ7mdTT7hUnCI9dRIMzXK1i4ie8hP996IJpygcHFvGYLI3L57gmyXg8BmzUR5uAQEWQ==@lists.postgresql.org X-Gm-Message-State: AOJu0YwZELcGMyS1C0p8oXD54cVvPd54FjddHivTeus6dZfb4hTazrt7 v+mkdmJckb97jziCeUXr9LR5AdCVCXDYCPVSSQki6BycYf3CluRJl36GY0Bacw/6ruQ= X-Gm-Gg: ASbGncu0MSJcA1GnG3Jgco/4AHcZ4yqoxNvurv5P7DFpKVIbNasD61fixqjNG+IJ2fb FE4yQrKxm4uaLyzeafdFlmx6TFUHomkwi/R3N5UkXji2E7xNmrdYGON6Oc5eMd91dcT1Zx4VVYx NMtbCwity1CStFW+hyxGIe5GU/TgpKT5h6ozgW+h60yjNSOMYVF1mY5R5Oc3rOGu3j+vcFl15ln AKLcLbdP4AqNfRX/9qP72MBNvEk8GpWUaKopkQr0FqbOccjsoeFwQYsiaITkrjsM39zKgZgGdJ5 HkOy0Cm0YckyvLMVHDANODIBHnhI98yM0UT7k2pChOSH/a3KPXr+DgxQ2KHDvp8tvVXJ4Rz9uUM vZKztYm1PZoReA2nWgENYQkM6x4SgF1KOieDUaD8+NkH//kYdFaFOuLuTofYscNA= X-Google-Smtp-Source: AGHT+IHaFGuJy/INZKBoUCpLoXPn2f3/+q43F2fryHZnb3Ko+HB0STsdKCuO/rkhCoJ9OvIIhgv/bA== X-Received: by 2002:a05:600c:820a:b0:458:bbed:a806 with SMTP id 5b1f17b1804b1-45b553eb4aemr5658535e9.22.1755851396318; Fri, 22 Aug 2025 01:29:56 -0700 (PDT) Received: from laurenz.albe-K4N0CV00F97414D ([2001:871:260:80a1:2aee:4573:b37b:fb9d]) by smtp.gmail.com with ESMTPSA id 5b1f17b1804b1-45b50de8ea4sm28313895e9.14.2025.08.22.01.29.54 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Fri, 22 Aug 2025 01:29:55 -0700 (PDT) Message-ID: <4f9c0d5dd74fa057481778fbe925f4817f9322ce.camel@cybertec.at> Subject: Re: The same again with 16.9 : was Re: PostgreSQL 16.6 , query stuck with STAT Ssl, wait_event_type : IPC , wait_event : ParallelFinish From: Laurenz Albe To: Achilleas Mantzios , pgsql-admin@lists.postgresql.org Date: Fri, 22 Aug 2025 10:29:54 +0200 In-Reply-To: <1332203e-fe17-4800-aadc-4de4a93fc85d@cloud.gatewaynet.com> References: <3049794.1748751598@sss.pgh.pa.us> <6be8d715-a9a7-4be8-8ebc-8b6bdb98da2e@cloud.gatewaynet.com> <1332203e-fe17-4800-aadc-4de4a93fc85d@cloud.gatewaynet.com> Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.56.2 (3.56.2-1.fc42) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Fri, 2025-08-22 at 09:16 +0100, Achilleas Mantzios wrote: > we had the same problem today again. >=20 > postgres@[local]/dynacom=3D# select * from pg_stat_activity where applica= tion_name~*'dbmirr';=20 > =C2=A0-[ RECORD 1 ]----+-------------------------------------------------= ---------------------------------------------- > [...] > =C2=A0pid =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0| 1821681=20 > [...] > =C2=A0wait_event_type =C2=A0| IPC=20 > =C2=A0wait_event =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0| ParallelFinish=20 > =C2=A0state =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0| active=20 >=20 > postgres@smadb:~$ ps -u -p 1821681=20 > =C2=A0USER =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0PID %CPU %MEM = =C2=A0=C2=A0=C2=A0VSZ =C2=A0=C2=A0RSS TTY =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0STA= T START =C2=A0=C2=A0TIME COMMAND=20 > =C2=A0postgres 1821681 =C2=A00.5 =C2=A04.8 37111844 3177260 ? =C2=A0=C2= =A0=C2=A0Ssl =C2=A003:58 =C2=A0=C2=A02:25 postgres: postgres dynacom 10.9.0= .10(45051) SELECT=20 Did you check whether the Perl function you mentioned before starts threads= , like Tom suggested? That would be the probable cause, and the solution is not to start any threads in a PostgreSQL function. Yours, Laurenz Albe