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 1rgCya-004nwO-Bl for pgsql-hackers@arkaria.postgresql.org; Sat, 02 Mar 2024 00:11:40 +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 1rgCyX-00FTjv-Aj for pgsql-hackers@arkaria.postgresql.org; Sat, 02 Mar 2024 00:11:37 +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 1rgCyX-00FTjn-1F for pgsql-hackers@lists.postgresql.org; Sat, 02 Mar 2024 00:11:37 +0000 Received: from mail-ej1-x62e.google.com ([2a00:1450:4864:20::62e]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1rgCyP-002Kb9-NP for pgsql-hackers@postgresql.org; Sat, 02 Mar 2024 00:11:36 +0000 Received: by mail-ej1-x62e.google.com with SMTP id a640c23a62f3a-a3d484a58f6so427516866b.3 for ; Fri, 01 Mar 2024 16:11:29 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb.com; s=google; t=1709338288; x=1709943088; darn=postgresql.org; 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=vbeZRv6iQC2cqSgf35HgSFl8Q4hfoR33RlG3hzP0Qvs=; b=g/XgfY0lUx0P12BmcOhJ0iYmY2K2WmCdOX+EMYAKUolxjWGDVR43+jTonatd/rPq/z 3mY+fkIc4kyAgXwVxIjyVqkzaCM2mIXBqcz1vjEXHWVE4121TR9toglkXJw/2ktiw46e vupEGcT9O0SKLwfO6DBPUH7hj2l3O0XYPZUbcv5vcw/ntCvgonJHV4zqfYZ1X+36r2t9 UTWx7/uGjKCJ2B3w34Gz5g/ub5YHpFnEe2rW9PxDi/EQy3+kDlV7PpcKQu/lGczINbZc tHQoZVCDN0U2KPozfN/L1shBQamghFnMtOVmUuy6woznihCaresoIvXDBHKm4YUMXGTb fA+g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1709338288; x=1709943088; 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=vbeZRv6iQC2cqSgf35HgSFl8Q4hfoR33RlG3hzP0Qvs=; b=wiO4J8XGx0gTusHP/FuFkWtZHzSudixcQJ0g+bbMrYWayTW2IGOqGFEW3PBEfneLYm 2saD28QhVwd3oeQGqHEhCe5o1vl30k9tbWiO66RwjX8qQdJTptuYz54auGrJ4BBNaMuv jJdElg99xzYk5hyFVIrLevEphVScH503d1Lg6KhiFELXxm00YXMEE/S9Jk7trXJ2IXaf enLrcKWjhenudw542D8zEdinkiwlQkoA4p281az4lToT6NWnaWfGD9JkD93sQAnBS1mp AUlSCz7s4r1PpMWYJXmI5SDLR3TOoSPdF/soierrcDj/5NV0DTWT6jAZy9ejI5x+y6z3 JHBA== X-Forwarded-Encrypted: i=1; AJvYcCVBvmMR6AEbpG0qKnsbSdCeWvW10oj0XeSgIx7HI7XzyVfWlIyjMKpRqrtfxqN+MWhM6zmBEdSh2HA5BD5yUUXYWpVleqJ4IaHtkkUa X-Gm-Message-State: AOJu0YwB090SYR3UE+1Ggd3mWt6m6oEZmghWnCFgHVGOu+7MsRk7qQKu CT8LjjJKsGuP/2mARRD/j1Q8sUNMgZyRHpdYjXoltEBkjWsNDIUbstKFiJoDkA== X-Google-Smtp-Source: AGHT+IHH5cj0m6wj+0Cwitra+mzgdIKH+fGcRDXzlYgwBC4pdAOYO3em4B1oZBAuUTBGdUZh/q5u/g== X-Received: by 2002:a17:906:cc93:b0:a43:e46b:7a80 with SMTP id oq19-20020a170906cc9300b00a43e46b7a80mr2135463ejb.43.1709338288137; Fri, 01 Mar 2024 16:11:28 -0800 (PST) Received: from [10.137.0.18] (ip-86-49-229-30.bb.vodafone.cz. [86.49.229.30]) by smtp.gmail.com with ESMTPSA id i27-20020a170906265b00b00a441c8c56d0sm2150368ejc.218.2024.03.01.16.11.27 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Fri, 01 Mar 2024 16:11:27 -0800 (PST) Message-ID: <67ef034a-ff73-4428-a86d-d61a25e3ef0d@enterprisedb.com> Date: Sat, 2 Mar 2024 01:11:26 +0100 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Showing applied extended statistics in explain Part 2 Content-Language: en-US To: Tatsuro Yamada , PostgreSQL Hackers References: From: Tomas Vondra In-Reply-To: Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 3/1/24 01:19, Tatsuro Yamada wrote: > Hi, > > This original patch made by Tomas improves the usability of extended statistics, > so I rebased it on 362de947, and I'd like to re-start developing it. > > The previous thread [1] suggested something to solve. I'll try to solve it as > best I can, but I think this feature is worth it with some limitations. > Please find the attached file. > Thank you for the interest in moving this patch forward. And I agree it's worth to cut some of the stuff if it's necessary to make it work. regards -- Tomas Vondra EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company