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 1qHmsj-0004tZ-Ff for pgsql-general@arkaria.postgresql.org; Fri, 07 Jul 2023 14:56:25 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1qHmsi-0008BP-CD for pgsql-general@arkaria.postgresql.org; Fri, 07 Jul 2023 14:56:24 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1qHmsi-0008BE-2I for pgsql-general@lists.postgresql.org; Fri, 07 Jul 2023 14:56:24 +0000 Received: from mail-yb1-xb2b.google.com ([2607:f8b0:4864:20::b2b]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qHmsf-002YN7-FQ for pgsql-general@lists.postgresql.org; Fri, 07 Jul 2023 14:56:22 +0000 Received: by mail-yb1-xb2b.google.com with SMTP id 3f1490d57ef6-bd61dd9a346so2160182276.2 for ; Fri, 07 Jul 2023 07:56:21 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20221208; t=1688741780; x=1691333780; 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=oWAvoQ4OMw3BeV4eAaUZJDJJQS8POI5yiq2nZUC/2aI=; b=YmT5n8M/qJ66jHK4OHG3+d7/BnDRzIPv2fR8JPBMDndKqL3lpnHzjw3HnHrsnoKNOq QeV7EoRG+0GjnV2ITZn0TpoL8I1zUDk0Qhi5/T0sjF1VLLPyoOKo+vOex9AwaOXmEr2A FPM++T+pbWR74bU2UPCor0iXeeog+BroaLqiG+Iv+PgLLxnHDs4ewUvBHAYhbhdcNjCV kk0T6KzkzG/7KHxkKg7x5IPzCaf7DF5Zq7vaOBwIsdmQ9dNXy3NAtKrklLy81Sp3imEu 2mibU2SMxVPd3W9Nx0Rz+J97zeT55Yo5w3ayueoGbuBJa3z/jylUVMPeRwM+7ctrxuGo Os5w== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1688741780; x=1691333780; 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=oWAvoQ4OMw3BeV4eAaUZJDJJQS8POI5yiq2nZUC/2aI=; b=cbZzpxKM/hUpBwWPybId9oT5oaRXIWqnSoTrSZRbmAMCDY5KdzxoiFGj8LQQyOtE7P b7VMGWSE4UeuQehh1RopJgV84NFKx5vjTxpRZj4kGz2UQ46hQg5cGbXdfyWKot5jSiM8 27vZyEP3kMLFuGMKIFiQRB1Hd7ErsgO/V7SkWQH5JARp/tlCJ1yVLgx0pVu2R1glnKfD x6gRGFnLqxGsTE2IGQsQPCZrsqzCvyLWQoP2nQl/ngBhDbXedgH64dznVGR4RmyUiq5F SFTv1vRSP8Ko36RYL0HwB43Wq4gwm3U/81HSqzbHgLmfobGXbpr1KBcl+h+lL/ylwn4g 6OpA== X-Gm-Message-State: ABy/qLa/ZUyY6jqR9iUcDXXTS+DqILmbCY5MKrza9JJE2Va5wPh8D2w8 7IpC7kC2eRRXtxWB6hz42t+MWOL5t+8= X-Google-Smtp-Source: APBJJlFp+l5mElQR26fOdVQU10OP47nHgK44uGB1blXzHCKWrDoXqz422nAeOofWQyjW6f0s3JqCgA== X-Received: by 2002:a25:ea43:0:b0:c5d:c5c2:b46d with SMTP id o3-20020a25ea43000000b00c5dc5c2b46dmr4779200ybe.55.1688741780348; Fri, 07 Jul 2023 07:56:20 -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 t44-20020a25aaaf000000b00bc68b767cf9sm971363ybi.41.2023.07.07.07.56.20 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Fri, 07 Jul 2023 07:56:20 -0700 (PDT) Message-ID: <16c2a469-802c-d21c-a200-fd2516af77dd@gmail.com> Date: Fri, 7 Jul 2023 09:56:19 -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> From: Ron In-Reply-To: <1a7063f7-1d7d-dbf4-a919-a55f733560f2@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: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. You can't run EXPLAIN(ANALYZE BUFFERS) if you don't have a query to run.  That's what track_activity_query_size is for. > >> 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? track_activity_query_size > >> concerned about side effects of setting it to 48KB or even 64KB. >> > -- Born in Arizona, moved to Babylonia.