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 1sk7xD-007vQJ-5E for pgsql-hackers@arkaria.postgresql.org; Fri, 30 Aug 2024 20:10:43 +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 1sk7xA-00A9du-TN for pgsql-hackers@arkaria.postgresql.org; Fri, 30 Aug 2024 20:10:41 +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 1sk7xA-00A9dm-JY for pgsql-hackers@lists.postgresql.org; Fri, 30 Aug 2024 20:10:41 +0000 Received: from mail-qt1-x832.google.com ([2607:f8b0:4864:20::832]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sk7x6-002IYb-UF for pgsql-hackers@postgresql.org; Fri, 30 Aug 2024 20:10:40 +0000 Received: by mail-qt1-x832.google.com with SMTP id d75a77b69052e-456774a0fe7so12139531cf.0 for ; Fri, 30 Aug 2024 13:10:37 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=dunslane-net.20230601.gappssmtp.com; s=20230601; t=1725048635; x=1725653435; darn=postgresql.org; h=in-reply-to:autocrypt:content-language:from:references:cc:to :subject:user-agent:mime-version:date:message-id:from:to:cc:subject :date:message-id:reply-to; bh=pBycirEUIpaS+joLY5d1a9wPgLM6VthL9LPxZ7Q2PE4=; b=MLH5onudqUHacyagDl+d+p4dYNgticTsG5wY5YEjMSY6kboymipGfTR1zP11qtzJvG 1ye0x2SGPLcsZPgtBwJR8XOEzK8S8uS5pIlC4KpOpnITUlXyT8hti6F+ClGl8boyhKK7 3fHtaTQoM1LS6JALEUEPBxiNze/K2Z/4+kKgpEDkgRk+lBWwEDJ0TGzQwd5bvoVtAl4H hz9fdOq1MtpkzSCLXI887T1XYhhLeRscT8HW7pA6mk4SvDpXCj2ebRggZLQjwJC+++nK snBTI4k25kC8IOL56uUtf2F3NlfPrL9BV0kaJ9vewhB13AkQ6EYjm26nE+CYPK+11QLt 5EyQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1725048635; x=1725653435; h=in-reply-to:autocrypt:content-language:from:references:cc:to :subject:user-agent:mime-version:date:message-id:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=pBycirEUIpaS+joLY5d1a9wPgLM6VthL9LPxZ7Q2PE4=; b=t7XIjO6r4ijxKIxgfMu+19BXfsbRaGqlefQaxXEC65F8Z4Br2ILY+lF2vSNCK9GXCN 6pX6/BP2ZtNrXYpTjzQNuWSepUVlhyV6CP5tVMaXupCJ+yOJd3RZ4EmF7RGXPQLfx7R1 46nmpSMIzOptqqI+lxS3KjHl5N60jX96o9LGAy9tt/zlaHORytmtJnYZfut5QfM4HB7i 3ZISgkWcaEBqlHO4UXzUR+us4gP5Bay/AL1g2AXsN94vlpF6LNN6INii7On8cDviOJuy csOD2S2t0RybwyyZJMwQErIoQf0y8QolTYG/G52H/nakFTMIY3Ia4vsXqONq/y70K8hL U2yA== X-Gm-Message-State: AOJu0YyLqN+znOrDV3Z5AarhsphK45hiRlPB1KdiH7ls9szCCYBhzhU8 zqneHNmthwenxzyp5QEN7t/gD9WRXBaAeD0yP5tTo3q9UEw+N3CstIUFT6Hgxpo= X-Google-Smtp-Source: AGHT+IHEms8kj5lL+0p5djkCwpLSCZpBAJRsyGkKsrgpjKjSnGfkg3z6aKRwNJXxdxxwse2H6biNOw== X-Received: by 2002:a05:622a:1e08:b0:457:2196:c4e0 with SMTP id d75a77b69052e-4572196c547mr3391391cf.60.1725048635387; Fri, 30 Aug 2024 13:10:35 -0700 (PDT) Received: from ?IPV6:2605:a601:9180:9800::2bb? ([2605:a601:9180:9800::2bb]) by smtp.googlemail.com with ESMTPSA id d75a77b69052e-45682c827e7sm17023641cf.18.2024.08.30.13.10.34 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Fri, 30 Aug 2024 13:10:34 -0700 (PDT) Content-Type: multipart/alternative; boundary="------------UkS5a2JrIyV1F0bN0EpGQIqw" Message-ID: <34cc0828-d988-4503-9944-ea6288f0ca8a@dunslane.net> Date: Fri, 30 Aug 2024 16:10:32 -0400 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: [PATCH] pg_stat_activity: make slow/hanging authentication more visible To: Jacob Champion , Noah Misch Cc: PostgreSQL Hackers , Euler Taveira References: <20240630174812.d1.nmisch@google.com> From: Andrew Dunstan Content-Language: en-US Autocrypt: addr=andrew@dunslane.net; keydata= xsBNBE7KWFkBCAClridxur2AIc7eW2AR7izbfp3EnNefie2HbLF0izW5Ik5UjX2HBXBx4syI gY6b0ugohXrr274+baoAlvSbq6cAoQuEVrk5IZFzt20b1Xkx65FwGSEj526yiKLocqkJceSq Xr9xcA5SGY+FZv441chh5SU92v4q6z+6LPpoHOh97ptAVXZYNTtU0LevyvD5lja0TzbvJm6C eFXitJfnm1pLEr0DGJCR/iUOl/N62Kh4855zZC7NHIjQHPOvV5Stz/l5ilDhvGVk+xkXFPys SjZoUr1rXhYLpiyi5sR0X9FHXT0KnGuz1F5ERO7ZTLSSQ6fJwPj6gOk9K+vvoKvoeql5ABEB AAHNJEFuZHJldyBEdW5zdGFuIDxhbmRyZXdAZHVuc2xhbmUubmV0PsLAmwQTAQgARQIbAwIX gAIZAQULCQgHAgMiAgEGFQoJCAsCBBYCAwECHgcWIQTkPlhGHfx8v0RpFaWZ+n/LWfw7gQUC ZFlxxwUJGVGAbgAKCRCZ+n/LWfw7gXikB/9ZdcUy6CTBFIIuL/bVsc1eLEW/gJBjJBF6HxNY xgEkAgXAp4Lg4A5U+QB9GouFr7+GYxF0BU4hzoGhNPUWltxnHdMWP8nC/38LAqgMi8L/bbsm HW5YPBdWYaAZAPJQVfOAgjTbRUb26KSprpyrrJKW0ZmrZfjhNPcQ72jpWzoPLQqx2X6B0fru 1jq+cBh8lb6r1mJTim1T3JIn+F/v5VpdQS+EL8xqsHkfzKjIPsW3CIXpkypSk6saA55Rkkbl 26AW8ftPVB0Q6Lnn6FLt9CP0MGNixBQ55yq8r1K+nCBvCCjvQjM8RDm0UUum0WNl+ifQgTLO E8TWEnwVtkBf+3QWzsBNBE7KWFkBCADRnOM0FCzsYW6jtncg+dWIagjUZpvaClmqn/sJluLa Q3v1VXMQJzYs3eC1gh386W+XBwLRpDj3jzH81lX+p73Re3d3oJW7X+ffsxuzu5ZVdMUkqBYo nkAbKxr6gyJ12F/+JkUVzLcoTN+d/7YsQvUVi7NaKH8mJgjz112O4fUe3p9wfAaFa0RXHc5S GPzRTYRRlv/XZBIho4J2tkZOnteZJZ+GbxQVlINt6fd8P6al3MWOvpP/ExJPguEfjOsO6Njy xjo3WfpD4lHMOR/Oc3/8mScEF84rF2jXbsFgelWnbPWAvXY+pD0dXOFRkagGmC/viwBDqq5b 5tk76kKmUbZxABEBAAHCwHwEGAEIACYCGwwWIQTkPlhGHfx8v0RpFaWZ+n/LWfw7gQUCZFlx 5wUJGVGAjgAKCRCZ+n/LWfw7gf+iB/4g8CPY5jihf5r/8EsoIGe2H+dpVmpPF8YGBzTIvCz/ fQoOq8AX/pE76QEuFnFZWfjw+wgBXgCVmkox2Eflkk6z4ND3pcwGZ6CfCxTQCDk/dij+2DQ4 6bmDCy/sBgcbz9mTpoLC11HLoPae6YN9nBNQRZDcEFEu54OaVOqlIdbA6m+POIBCXZdHOFc0 WoDTgxHRzC1jgQNidyd6tKqcsVJs0dzF0oKTmFFmUAqTdJO12LBuNA1rlqrR3EtpYk8B/wtS 5dIMD7Q8hwQpL+4C6GNpb6ZKnPkLi47pDOLhz2qBrqN+rqUEsT3YnExYpzj5yOBi+FlmV1Hw 49QYe1sn2ZPs In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------UkS5a2JrIyV1F0bN0EpGQIqw Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit On 2024-08-29 Th 4:44 PM, Jacob Champion wrote: > As for the other patches, I'll ping Andrew about 0001, Patch 0001 looks sane to me. cheers andrew -- Andrew Dunstan EDB:https://www.enterprisedb.com --------------UkS5a2JrIyV1F0bN0EpGQIqw Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 7bit


On 2024-08-29 Th 4:44 PM, Jacob Champion wrote:
As for the other patches, I'll ping Andrew about 0001,


Patch 0001 looks sane to me.


cheers


andrew

--
Andrew Dunstan
EDB: https://www.enterprisedb.com
--------------UkS5a2JrIyV1F0bN0EpGQIqw--