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 1tmdwf-008NYe-Hq for pgsql-hackers@arkaria.postgresql.org; Mon, 24 Feb 2025 19:16:50 +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 1tmdwe-006jRG-Qv for pgsql-hackers@arkaria.postgresql.org; Mon, 24 Feb 2025 19:16:48 +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 1tmdwe-006jR8-Gv for pgsql-hackers@lists.postgresql.org; Mon, 24 Feb 2025 19:16:48 +0000 Received: from mail-ed1-x533.google.com ([2a00:1450:4864:20::533]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tmdwb-000aSV-2E for pgsql-hackers@lists.postgresql.org; Mon, 24 Feb 2025 19:16:48 +0000 Received: by mail-ed1-x533.google.com with SMTP id 4fb4d7f45d1cf-5e058ca6806so8685105a12.3 for ; Mon, 24 Feb 2025 11:16:45 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1740424605; x=1741029405; darn=lists.postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=BkQDSFuxgnI1qbrGG3FoAjEQK5EPpeIEE0rpNk5rJj8=; b=i2CpF8+KO14PNR9I9GhqecJFT02FUpRuDuyasZbxAeCmJw2HoCXJzr7yo6/mpqA6gI jVGX7Pm/9hXkNUpNH36KKf92ntf/7nZy/jYxP/xutxZHJBWCyMYKbKJujCNiXeVW9czX NTxFNvB9oc56r6IlfFp619FI/CT7Rya8I6jfnGRumMTW2LJmUo2VIldRwWinP9DFT3UJ hgrEQTr1VHLO+K7PvX0xjKyZgP3cGrzI861n6aiwA1n4EwVfqeHaLgqkz17lGqCRUbbn IJLgPQSl4R73wT3fkOtp4NqErA7g+mFHoQDagycKM6PhNUe5YRdz9gKDVtH5UBAr22Sg JZPg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1740424605; x=1741029405; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=BkQDSFuxgnI1qbrGG3FoAjEQK5EPpeIEE0rpNk5rJj8=; b=n0cmEI7mO29EBT9P4v04sFjxLzeCK7zbGO1ZxJ+//wxd4d3f/slK1ZH9lhs+Prk83y DFvnTgG+j9+WSoAcu+gLOHqrW72a+RIbUS2sR+sv+kpKi79xFYTWmbfv0saYfIri4162 xOig93/LL5UOSNMHE7/ue7FGWoFdGwqj7EyMuSYtcdO7XUK9M+R4jMqAXWNFaCIsYnqC 9O8SwIDUIARXa0ro2O2FKfoCtzfDAInVHSa2YANh7uj8EosT7OqyCPY2vyVR/P57Plxy wRveX3uDPklqGe6wOwM3MQzTmDzN8AzKd6s9QeVeB/vd4g0bpXpXdhU/XWNXfCB2hWlI vtRQ== X-Forwarded-Encrypted: i=1; AJvYcCXB1kXfB2H7WVbY07B3l5Gtu6ORHT6A+brok7zrMUkwoFShRNvdp9BeFzXxMRiPbEoDp9uxhifllW0kK6Ur@lists.postgresql.org X-Gm-Message-State: AOJu0YxqaXXyz5LGKq5Ffw86wDP0k2xcq37vn3K6By2hNcOnX35/REkL MUn5t9jJ9JjysTG99468t0Qopa+zVsRVZXhfyCJ7LTCxm1lw6/s+qb31H17crew9fhFGxLsRZKI DALB8n3k4xMVgeVnIfkf8CmO5Go8Ynw== X-Gm-Gg: ASbGnctuf6TbNvaTnKdJNYriVN+EwUtXqLgPKFvCNXIS3bkGTHfyHA63sLRvoanOj3s d58moORPM2JWa7eUntvthFG3Zi6pLQFJgP+HKvmp80M4VuSn8ixiJgxnmXag8YgWFhfcRwhzRst 4TI8scVNo= X-Google-Smtp-Source: AGHT+IH723iQm6chL1KwQDo9o+5Kox3tUKcEcmqmQW16ipFhkClAYL2FCMRAXKxQrmYPRG/DOq9iwRHMze3Q+bycU40= X-Received: by 2002:a17:906:31cf:b0:ab7:6d59:3b4c with SMTP id a640c23a62f3a-abc0d9e5e51mr1138138466b.21.1740424604797; Mon, 24 Feb 2025 11:16:44 -0800 (PST) MIME-Version: 1.0 References: <3365160.1739385615@sss.pgh.pa.us> <0e4c813a-18eb-41e2-8edb-89b78d43c82d@gmail.com> <01ec86c1-e04b-4cbe-b641-22cae8b87604@tantorlabs.com> <73e2440e-7d8b-4860-974d-931a93326d95@gmail.com> <3737950.1740182671@sss.pgh.pa.us> <3816053.1740190267@sss.pgh.pa.us> <40663fc5-edac-4b45-a2aa-a76976700ed9@tantorlabs.com> In-Reply-To: <40663fc5-edac-4b45-a2aa-a76976700ed9@tantorlabs.com> From: Robert Haas Date: Mon, 24 Feb 2025 14:16:32 -0500 X-Gm-Features: AWEUYZnku5wGPGN8YAbwbyClsiESrBXH5Z_BNlhFhEI1KjbkxXqshxJT1FOrFnw Message-ID: Subject: Re: explain analyze rows=%.0f To: Ilia Evdokimov Cc: Tom Lane , Andrei Lepikhov , pgsql-hackers@lists.postgresql.org Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Mon, Feb 24, 2025 at 12:12=E2=80=AFPM Ilia Evdokimov wrote: > If no one is concerned about rows being a non-integer, then I support > this, as it's quite strange for the average rows to be an integer only > for me. If we go with this approach, we should also update all examples > in the documentation accordingly. I attached patch with changes in > documentation. Thanks, that's very helpful. If we go forward with this, I'll commit your patch and mine together. --=20 Robert Haas EDB: http://www.enterprisedb.com