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 1oErRr-0007GS-Uf for pgsql-hackers@arkaria.postgresql.org; Fri, 22 Jul 2022 12:08:03 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oErRq-0006eY-Pw for pgsql-hackers@arkaria.postgresql.org; Fri, 22 Jul 2022 12:08:02 +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 1oErRq-0006e8-FF for pgsql-hackers@lists.postgresql.org; Fri, 22 Jul 2022 12:08:02 +0000 Received: from mail-ej1-x62b.google.com ([2a00:1450:4864:20::62b]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1oErRo-0000A9-26 for pgsql-hackers@postgresql.org; Fri, 22 Jul 2022 12:08:02 +0000 Received: by mail-ej1-x62b.google.com with SMTP id ez10so8126269ejc.13 for ; Fri, 22 Jul 2022 05:07:59 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=mime-version:references:in-reply-to:from:date:message-id:subject:to :cc; bh=AoOeIGtAJHKK7vq/LnaHGHU78z+bI09YKLG3WAs6mUE=; b=l8lx5LJTK3/BU9bplx0Xe1rWrSG9KBB9OmSUA3VFqp9x7xaCuxUisU/7h+DvsFJiHd 7P/5KQRo6Fa72Dp9vvCtlj/jOiw0xPU/DU88eFpZ2aWYB5xM8EME6Gk+HfnfvjEu95Et HkSkl/PxrABki2sawCKC6AZxmjGaG6PqEd1OoYuCPwC4xa1ILpOmL5iGISTc1swjJaSx 2jd0wOzAVjHbOIeHEGUhVauye0QzIkpDMJAJlxOIV7lqrffGaQ8RoRNQDWES3AauG4ed 7V/nem5o+6ePlS1/475nPNN0VpE0RXOcNGaZ9e4RDCe5CWcG0n9elZmaDQjwSkJQpOcw qqmg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to:cc; bh=AoOeIGtAJHKK7vq/LnaHGHU78z+bI09YKLG3WAs6mUE=; b=hZZFNElaLco3ekvkuVn+Yn28Krj+5zYl3mezZKbNfBB8uDZam9R3s84x6ijb1lnR9x pPIdXY65Wez14urd0fSnqOjYdyHNVtJvkRmduKozZ0AUnKt2aXP/Qwm53zIbryLssQlN n8iuIgxvnMVHnkW429+Y5JS1+s8YQfYQSh69V1AhN+nHdV6s4VQCZorQvk89NVLzOPuG nYVj/zwujsSxnhCAQq3PA5Wko1/EqpV6p4d74FeSL2npg6y2zm+J+sWv3oJon6Nzdx5p 9OXbfPLW4fkCmeItlitFofvxlJhjWB+5cR5Ly6X9xShNPF14/maBebZzn3wwZs8CLOll QnBg== X-Gm-Message-State: AJIora9mkI2weaaNMZcqdjXiT/QBZvRlznFjVI396d58WXz1K1lMRwgw VI0w4Sos5yNPfJ2ktQcoyBcdZz/zbd6e8zW7e9o= X-Google-Smtp-Source: AGRyM1sXrs+yUZ4k1RmYns5uk0onReC1Ay08zsiDTs1drRX+ER+HZ4O8bmMMYlm8EZQX+uk93Q/od+iWPrECRkKzf34= X-Received: by 2002:a17:907:16ab:b0:72c:7533:7262 with SMTP id hc43-20020a17090716ab00b0072c75337262mr252450ejc.288.1658491677926; Fri, 22 Jul 2022 05:07:57 -0700 (PDT) MIME-Version: 1.0 References: <20220707222015.GD13040@telsasoft.com> In-Reply-To: From: Robert Haas Date: Fri, 22 Jul 2022 08:07:46 -0400 Message-ID: Subject: Re: explain analyze rows=%.0f To: Amit Kapila Cc: Justin Pryzby , Peter Geoghegan , Greg Stark , vignesh C , Ibrar Ahmed , "David G. Johnston" , pgsql-hackers , Simon Riggs , Ron Mayer , Euler Taveira de Oliveira , Tom Lane Content-Type: text/plain; charset="UTF-8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Fri, Jul 22, 2022 at 6:47 AM Amit Kapila wrote: > I feel the discussion has slightly deviated which makes it unclear > whether this patch is required or not? My opinion is that showing some fractional digits at least when loops>1 would be better than what we have now. It might not be the best thing we could do, but it would be better than doing nothing. -- Robert Haas EDB: http://www.enterprisedb.com