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 1qHmuc-0004yU-GJ for pgsql-general@arkaria.postgresql.org; Fri, 07 Jul 2023 14:58:22 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1qHmub-0003tK-8R for pgsql-general@arkaria.postgresql.org; Fri, 07 Jul 2023 14:58:21 +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 1qHmua-0003tB-UA for pgsql-general@lists.postgresql.org; Fri, 07 Jul 2023 14:58:20 +0000 Received: from mail-yw1-x1133.google.com ([2607:f8b0:4864:20::1133]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qHmuY-002kVi-Ho for pgsql-general@lists.postgresql.org; Fri, 07 Jul 2023 14:58:20 +0000 Received: by mail-yw1-x1133.google.com with SMTP id 00721157ae682-579e5d54e68so24464957b3.1 for ; Fri, 07 Jul 2023 07:58:18 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20221208; t=1688741896; x=1691333896; h=content-transfer-encoding:in-reply-to:from:references:to :content-language:subject:user-agent:mime-version:date:message-id :from:to:cc:subject:date:message-id:reply-to; bh=yljbqtMrFWtTK+QkltSvZnJVp8sowm46Ox2ZhHmzfIs=; b=sKk9cDIvkWCJsbooTwj691zZ4EiWTMfIjqHnR3aRfaQSKAWVbOjfxB3LJgNLGGzGAk +RLTeEYfvN6eW60aIsSeHJ5ufz3KY77nZWohldECmbbs8GTxA8aZB4Eeas9qVRR88kgu cJoKZuUlCu1gas2EbesWz6VJE2HhD+ZxaNwJW5MSyKh1xFIjOlnoehQ3hPLizeuM8T2B n0i6adMYnAUd4+slHGhqd6ZDOWYOMhHpKyKZgerHsvqvY65KHmYcBZLR2Jh0lhXgMlJM 7skwtSAsnA6MDd4dY8wIpA1O6t0yiu2hE9D7hkVZ9HWKVV0ebnQNIAbgmuNPAAFf/WuX 8H/w== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1688741896; x=1691333896; h=content-transfer-encoding:in-reply-to:from:references:to :content-language:subject:user-agent:mime-version:date:message-id :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=yljbqtMrFWtTK+QkltSvZnJVp8sowm46Ox2ZhHmzfIs=; b=PGEfahNMyINhaIpewy9D+xnn1sEYo6MzBJcqdlXAB/zz2UBQBC0wR75BkHH7uIKJfU zc0P6p89qEPVc4cb/eP+qgyS7IRzRMXKqd1vKPZEpVUWWIlBODuxuXeeLQl9254Oq/lX j4ifdjWzVYXvZvNyXuhU0GJ68piVcvk30kQSu0Xt8oIRHLOsrdsouhf5JKZn9zkiz7r1 +xw+ZiwPcDpqfYAyINK1+/wYVfva1xy9JccOyH51zlcIEiLsu3V3DD3WYc3EpMJtGV5K rrVEAXhE60cmSQD+j/mW+8uUIL4/1Obw9yw+Hieeay3fQe2p98sIvTXwxcO6au7LVtB8 sx4Q== X-Gm-Message-State: ABy/qLab3E5FI03pvax9a5TTzBuOM2sMeoGDoBWAUh7tnLAmy32X1ZA/ bRZAy3wflwg+x0yAZ5CKjN+26Janom0= X-Google-Smtp-Source: APBJJlFZSy1TfQ2TMGy08dUCkUmLWDdMW9WuI5SZG+kssezbD3vDz7xpLVwUHmtoEK2A6FBD5yjmDg== X-Received: by 2002:a0d:f385:0:b0:56d:1cc4:3335 with SMTP id c127-20020a0df385000000b0056d1cc43335mr5396290ywf.11.1688741896560; Fri, 07 Jul 2023 07:58:16 -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 s64-20020a818243000000b00559fb950d9fsm1089216ywf.45.2023.07.07.07.58.16 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Fri, 07 Jul 2023 07:58:16 -0700 (PDT) Message-ID: <922daef0-4093-d07c-4cf1-84c04fda8e5f@gmail.com> Date: Fri, 7 Jul 2023 09:58:15 -0500 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.11.0 Subject: Re: track_activity_query_size max practical size? Content-Language: en-US To: pgsql-general@lists.postgresql.org References: <0d08dd4d-3860-e85d-984d-0ed676dbdf1e@gmail.com> <1a7063f7-1d7d-dbf4-a919-a55f733560f2@aklaver.com> <1cf118ea-91da-d9bf-2ed9-c079e2653964@aklaver.com> From: Ron In-Reply-To: <1cf118ea-91da-d9bf-2ed9-c079e2653964@aklaver.com> 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 On 7/7/23 09:55, Adrian Klaver wrote: > On 7/7/23 07:51, Adrian Klaver wrote: >> On 7/7/23 07:42, Ron wrote: >>> We've got some Very Large Queries that take a long time. >> >> An EXPLAIN(ANALYZE BUFFERS) would go a long way here. >> >>> Even setting taqs to 10KB isn't adequate, so I want to significantly >>> bump it, but am >> >> It is before coffee here, so you will need to spell out what taqs is? > > Did I mention lack of coffee? I see  track_activity_query_size in the > subject. So the issue is what with the current setting? 10KB isn't enough to capture the whole query.  Are there any bad side effects of increasing it from 10KB to 48KB or 64KB? > >> >>> concerned about side effects of setting it to 48KB or even 64KB. >>> >> > -- Born in Arizona, moved to Babylonia.