Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1qHmgL-0004K6-5G for pgsql-general@arkaria.postgresql.org; Fri, 07 Jul 2023 14:43:37 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1qHmfK-0003AM-Cj for pgsql-general@arkaria.postgresql.org; Fri, 07 Jul 2023 14:42:34 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1qHmfK-0003AC-2E for pgsql-general@lists.postgresql.org; Fri, 07 Jul 2023 14:42:34 +0000 Received: from mail-yb1-xb2b.google.com ([2607:f8b0:4864:20::b2b]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qHmfH-002kMK-Di for pgsql-general@lists.postgresql.org; Fri, 07 Jul 2023 14:42:33 +0000 Received: by mail-yb1-xb2b.google.com with SMTP id 3f1490d57ef6-c17534f4c63so2147747276.0 for ; Fri, 07 Jul 2023 07:42:31 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20221208; t=1688740949; x=1691332949; h=content-transfer-encoding:subject:from:content-language:to :user-agent:mime-version:date:message-id:from:to:cc:subject:date :message-id:reply-to; bh=HXrD8EU74/knqyBuJDaMk4azuPhfclV+Hqs/R7r/wps=; b=mMF9naBEKhukWA7xPSITdMkIdjnp+xIhwj1VdoLewJNQy/2zALLDJ8Eklge7Q/kXmC oXY2S4YyRl1HfV/XUi40RIYH7a6gxw4fvIb1QccHqO9mSDb3jNU4YnlC1sBLseW+dtog cs6MfiqdoiUZl3omcXpMu39WOovUxEvu8sjkgf/xSO+HF057wt6pOEVitTDobeugKE1T X0dU7tO8Jx8G2Qj58y3Mb7W3WEd5WITto+e9aOIBrKU+mcapHH80qH2SWCZb1OZYD1cR /WJGbF/JLXuG7N9wn+3WRxYwEkFn4BBFD5Sy87px3EL33snwViECzo+UB8iQX7ZQotRJ lgYg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1688740949; x=1691332949; h=content-transfer-encoding:subject:from:content-language:to :user-agent:mime-version:date:message-id:x-gm-message-state:from:to :cc:subject:date:message-id:reply-to; bh=HXrD8EU74/knqyBuJDaMk4azuPhfclV+Hqs/R7r/wps=; b=KyGmwpgySob9n3y8anQc3BVgtVPAVCYzked3hYj8plPyZRD1vjGu2ADJb0GezeVU5w aEunfdIqGZFKHeCdvI8wOOryQXnTh+oBwuogetB6NTMYqmt71a+LUIg4Rj57SzMMwtbo uUczWhwYC9O0VWj9kla96vQ8yjFYmH+loOfSBgMBKmh7U6iLUSbmbFvvxfTqtsON4Mmw Ej4/OpRLpEc81Qwbfm36lMYN7WUar0yFYYuWTSPK08hWYkdq8NKePUZvJyqu55Qcei29 Xn33TOiPWOYfC74oaRon3+RHDZhrkv0VnR1MbFEdNkEt556Gnf4/x07qGepFsKdsItdU 9B6Q== X-Gm-Message-State: ABy/qLaXo/DQsfnXO0BB2zrc9MQ3bhvd940wYqUe2YWe54IXKbRes/p+ TCbcbBAuCRDmYKZpIcUeH6SaQTxlDIA= X-Google-Smtp-Source: APBJJlHm3fTc+ZgX9wOaogjLCfXl9sBr1VFV9T6zGsVrPOss9CmFUplFbInfbO/WRUzf0cH8ixxP2A== X-Received: by 2002:a05:6902:1352:b0:c19:6a03:2704 with SMTP id g18-20020a056902135200b00c196a032704mr4112124ybu.25.1688740949231; Fri, 07 Jul 2023 07:42:29 -0700 (PDT) Received: from ?IPV6:2600:1700:bd2c:b810:bd3c:e5b9:912:994c? ([2600:1700:bd2c:b810:bd3c:e5b9:912:994c]) by smtp.googlemail.com with ESMTPSA id x63-20020a25ce42000000b00c5f99a71eaasm954061ybe.57.2023.07.07.07.42.28 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Fri, 07 Jul 2023 07:42:28 -0700 (PDT) Message-ID: <0d08dd4d-3860-e85d-984d-0ed676dbdf1e@gmail.com> Date: Fri, 7 Jul 2023 09:42:28 -0500 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.11.0 To: pgsql-general@lists.postgresql.org Content-Language: en-US From: Ron Subject: track_activity_query_size max practical size? Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk We've got some Very Large Queries that take a long time.  Even setting taqs to 10KB isn't adequate, so I want to significantly bump it, but am concerned about side effects of setting it to 48KB or even 64KB. -- Born in Arizona, moved to Babylonia.