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 1v2F8t-001fAM-6U for pgsql-hackers@arkaria.postgresql.org; Fri, 26 Sep 2025 20:34:11 +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 1v2F8p-005itA-Tx for pgsql-hackers@arkaria.postgresql.org; Fri, 26 Sep 2025 20:34:08 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1v2F8p-005it0-G6 for pgsql-hackers@lists.postgresql.org; Fri, 26 Sep 2025 20:34:08 +0000 Received: from mail-ej1-x641.google.com ([2a00:1450:4864:20::641]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1v2F8n-0005Vn-1V for pgsql-hackers@postgresql.org; Fri, 26 Sep 2025 20:34:07 +0000 Received: by mail-ej1-x641.google.com with SMTP id a640c23a62f3a-b35f6f43351so452980166b.1 for ; Fri, 26 Sep 2025 13:34:05 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=f10-com-br.20230601.gappssmtp.com; s=20230601; t=1758918844; x=1759523644; darn=postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=a4jLabpmYt3nsuxn8dXUeU/H/vKGejo7Mthql+6YcGo=; b=h1yhJdgsu31f7lG8+7xaXJbOhiXGjlfF0fSEp4bo11N8uOMGOM624wfMfhLl0kh9WA 4mj+NPNXCNVDOpgzuHZqwZB/ftOrilqemVuAVg7XpcqdRzLKcydQvelQ+/glHlZEWEj7 0CVI+Ba4iZSp2HD7GxrKTkfrMmqS3ocFjIJq1twWI4sx8pHTsA5hZ2brGNaUyyYOM/lR CPh1CW+G9JA8JGRgKLHJshVMd3A7M5AAZD0xPfOUy6+kOTkcvjLVYNTi9O4lTQYBx1AO xEpiw1iFR1XPGKJGsP9Q/ZlGSJYXt0Dv+fdIBmXPcBXYuDtUMqiou630nhe3f7mqaIDF uApw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1758918844; x=1759523644; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=a4jLabpmYt3nsuxn8dXUeU/H/vKGejo7Mthql+6YcGo=; b=GdH3guukAF+mhBIue2VBRdZUBLUavVjMhiB/u50YS9sJiPXplXJOP7QSHYGGUXfcdL B9sO6RvrgFehTRS12yBgDm+5w4O/OS1JffgPCH++olevaC1exGWDuUA/EtBWEhdqWjsS edqmEICQki2MlEVyju6OiRJ9LvzjVXKUMZUg0ze2o5KLO29TKJwkgEcjrwO0vCX24Rwv pti7JrZmrNrH6QFjmkuWP3C9L66qRroxl3RpfR3EZolRLNtg6AjUS71LNAWMppc6ezW3 yLWwGWknqHe3St2idxeV5EwcF4msKplkm9OX2pwWzNVtgau9EZ9seCNQSns/3jTlBAmD OdDA== X-Gm-Message-State: AOJu0YxclWm05udHWFZgwpjFwL0kPP4ue6fuYN/9DN4MyK7Nibb2Oary QGwz3FsbsKBhoaQd+J2yWNR1NuFY6eFDWSI7MTzvCHhwpn4efDjWWFl5fqVweXsaNhTniNFmJ1F 53aVUB9oDBuCbgsIwJPwWPDl1MqiB9yzS1G7Pl4HHu3FnMwxw15Oc5sSL8zKxtg== X-Gm-Gg: ASbGnctrAS8otmo/1MUKBSIrNrz2KTT5q21wQazFFQdpagwLd0AxYbTgvo7skw1Ug3c 7R4fzoltw8P7dSHfrYxPpL/U6b3jPW3HqJ6jOaMbs2vDOBmNC47SNm8XmcVaOy7aSsRKcp07oqE RdCQPLQrIY3V5A0opLm+eVpLs2qnCETKU3RBkHtl01v1RDwHg6k54Kc0WILSvNB1N6PVUM4Gczq RUPWJZAAuZg95Q= X-Google-Smtp-Source: AGHT+IGqX3JzJgHTzqwv0uIoQP8llJb2S4QvLKmGBYzQYGC5o4Z0Bi2qScq/LbI38BvDkmtcTz3oqI+Qr2WzRPIEApA= X-Received: by 2002:a17:907:2d24:b0:b04:32ff:5d3a with SMTP id a640c23a62f3a-b34b0ea3efdmr975934366b.0.1758918843887; Fri, 26 Sep 2025 13:34:03 -0700 (PDT) MIME-Version: 1.0 From: Marcos Pegoraro Date: Fri, 26 Sep 2025 17:33:26 -0300 X-Gm-Features: AS18NWCjGnHJKk4Yk3erKU0ZWflc2OWZBcXIpjeEYdSGTlSXyO3vDeRkdKov5Bs Message-ID: Subject: V18 change on EXPLAIN ANALYZE To: pgsql-hackers Content-Type: multipart/alternative; boundary="000000000000e103b3063fba34c4" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000e103b3063fba34c4 Content-Type: text/plain; charset="UTF-8" Robert Hass committed ddb17e387aa28d61521227377b00f997756b8a27, which changed how EXPLAIN indicates fractional rows. That's cool but I have to see that change on sources because it's not explained on DOCs. One can understand that cost=4.36, that actual time=0.009, but what means rows=10.43 ? Costs and Time having decimals are fine but what is a row and a half ? So, I don't know exactly how to explain this change but I think it would be good to have a new paragraph on [1] and explain that now when nloops > 1, we now display two digits after the decimal point, rather than none. [1] - https://www.postgresql.org/docs/current/using-explain.html#USING-EXPLAIN-ANALYZE regards Marcos --000000000000e103b3063fba34c4 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Robert Hass committed ddb17e387aa28= d61521227377b00f997756b8a27, which=C2=A0changed how EXPLAIN indicates fract= ional rows. That's cool but I have to see that change on sources becaus= e it's not explained on DOCs.

One can understand that=C2=A0cost=3D4.36, that=C2=A0actual = time=3D0.009, but what means rows=3D10.43 ? Costs and Time having decimals = are fine but what is a row and a half ?

So, I don't know exactly how to explai= n this change but I think it would be good to have a new paragraph on [1] a= nd e= xplain that now when nloops > 1, we now display two digits after the dec= imal point,=C2=A0rather than none.=C2=A0

=
[1] - https://www.postgresql.org/= docs/current/using-explain.html#USING-EXPLAIN-ANALYZE

regards=
Marcos
--000000000000e103b3063fba34c4--