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 1to3N6-005LSa-04 for pgsql-hackers@arkaria.postgresql.org; Fri, 28 Feb 2025 16:37:56 +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 1to3N6-00A8yk-Ua for pgsql-hackers@arkaria.postgresql.org; Fri, 28 Feb 2025 16:37:55 +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 1to3N6-00A8ya-L5 for pgsql-hackers@lists.postgresql.org; Fri, 28 Feb 2025 16:37:55 +0000 Received: from mail-wr1-f44.google.com ([209.85.221.44]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1to3N2-000CP4-2w for pgsql-hackers@postgresql.org; Fri, 28 Feb 2025 16:37:54 +0000 Received: by mail-wr1-f44.google.com with SMTP id ffacd0b85a97d-38f406e9f80so1943266f8f.2 for ; Fri, 28 Feb 2025 08:37:52 -0800 (PST) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1740760669; x=1741365469; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=HZzIu+FTao4x9/nKIMBl+d7VsW/DPRq611rSauj+huI=; b=q11cvYW2aXF29e5LVZY+ERuCHVCHf0fkBYkjrs4+TGMlAcfkNsl3z47mE+UzjpDlK9 lv/8GTVcsEb/rdvPbjXYo5Hyg9R9NGmWAsGNYkcKodCm/nHBCxSKA9+ZQdHoVpxxilwK lUzp8+hnhd/mhYjGtslFzKXw6iOEgNNsNdBM2OoCd0lLAnU3nCBu8ChRSe4EbQrR323k mwBGAwtqfC2Tzapw8bQ2DljbT6js+Z4lVM0uVCnDg7aJTFwLvy5ZFsDTLNep62vCgsBb oMhWWOseabixDWXj/NQyBr61siH3dGx1LMK/kg922vdUmuXleS0DH8U0LXONAlqAlwj8 fXJw== X-Gm-Message-State: AOJu0YzMA8CaCmqGdF/fbmHumGz1UPlrC78Xw2iHx9Js0lD2wZLjecAh v0ZqIVpxBhvYBKLEWWViXTWSIklBVCamP0WWXxyTg6DDA6669lGMi0xW0Xhmfu+flQ1Cb8Xsj1Y /aQpS+iggYssoyMUbd+djIqVjGfvVUf2C X-Gm-Gg: ASbGnctYc4KrU+Q4Y9Ccc7RajToKQ4yOJ2rvQfYgEY3qt/tk0wTdHMSOfSedruOU/13 ghLb3E1SPAnPNUxg6jw0VN66QWrUX/idefbJDrm2k6FAMSCg8O1KuWttJC8o3u/WIt8wXwty7p3 vpHZaQ/mOL X-Google-Smtp-Source: AGHT+IF03weuhF12wkjLZJ3kO+7pD63oGvAdSzpj6s+zvtQsFGlmmM/umyNKNR3OOf/RNSj6V2KHwg/29bDiVHrJtb4= X-Received: by 2002:a5d:5f84:0:b0:390:e311:a8c7 with SMTP id ffacd0b85a97d-390ec7ca224mr3598250f8f.5.1740760668925; Fri, 28 Feb 2025 08:37:48 -0800 (PST) MIME-Version: 1.0 From: Thom Brown Date: Fri, 28 Feb 2025 16:37:20 +0000 X-Gm-Features: AQ5f1Jqb-03dPMIhnVlLicZDaM9Apynn6xVwScmPWj_2y-EnzlHfhI5AI0Ru6mM Message-ID: Subject: Space missing from EXPLAIN output To: PostgreSQL-development Content-Type: multipart/mixed; boundary="0000000000004f8f66062f366dd7" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000004f8f66062f366dd7 Content-Type: text/plain; charset="UTF-8" Hi, Commit ddb17e387aa introduced fractional row counts, but the rejigging has introduced a formatting issue: Worker 0: actual time=34.779..34.780rows=0 loops=1 Buffers: shared hit=1200 Worker 1: actual time=39.737..39.738rows=0 loops=1 Buffers: shared hit=1084 A space is missing between the time values and the "rows" label. Patch attached to fix. Regards Thom --0000000000004f8f66062f366dd7 Content-Type: application/x-patch; name="fix_explain_analyze_spacing.diff" Content-Disposition: attachment; filename="fix_explain_analyze_spacing.diff" Content-Transfer-Encoding: base64 Content-ID: X-Attachment-Id: f_m7ozvdlu0 ZGlmZiAtLWdpdCBhL3NyYy9iYWNrZW5kL2NvbW1hbmRzL2V4cGxhaW4uYyBiL3NyYy9iYWNrZW5k L2NvbW1hbmRzL2V4cGxhaW4uYwppbmRleCBjMGQ2MTQ4NjZhLi5hMTM5NWVkYzhjIDEwMDY0NAot LS0gYS9zcmMvYmFja2VuZC9jb21tYW5kcy9leHBsYWluLmMKKysrIGIvc3JjL2JhY2tlbmQvY29t bWFuZHMvZXhwbGFpbi5jCkBAIC0yMDc1LDcgKzIwNzUsNyBAQCBFeHBsYWluTm9kZShQbGFuU3Rh dGUgKnBsYW5zdGF0ZSwgTGlzdCAqYW5jZXN0b3JzLAogCQkJCUV4cGxhaW5JbmRlbnRUZXh0KGVz KTsKIAkJCQlhcHBlbmRTdHJpbmdJbmZvKGVzLT5zdHIsICJhY3R1YWwgIik7CiAJCQkJaWYgKGVz LT50aW1pbmcpCi0JCQkJCWFwcGVuZFN0cmluZ0luZm8oZXMtPnN0ciwgInRpbWU9JS4zZi4uJS4z ZiIsIHN0YXJ0dXBfbXMsIHRvdGFsX21zKTsKKwkJCQkJYXBwZW5kU3RyaW5nSW5mbyhlcy0+c3Ry LCAidGltZT0lLjNmLi4lLjNmICIsIHN0YXJ0dXBfbXMsIHRvdGFsX21zKTsKIAogCQkJCWlmIChu bG9vcHMgPiAxKQogCQkJCQlhcHBlbmRTdHJpbmdJbmZvKGVzLT5zdHIsICJyb3dzPSUuMmYgbG9v cHM9JS4wZlxuIiwgcm93cywgbmxvb3BzKTsK --0000000000004f8f66062f366dd7--