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 1sQePx-00Awpg-E4 for pgsql-hackers@arkaria.postgresql.org; Mon, 08 Jul 2024 02:47:53 +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 1sQePv-000H2c-00 for pgsql-hackers@arkaria.postgresql.org; Mon, 08 Jul 2024 02:47:51 +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 1sQePu-000H2U-MU for pgsql-hackers@lists.postgresql.org; Mon, 08 Jul 2024 02:47:50 +0000 Received: from mail-lf1-x134.google.com ([2a00:1450:4864:20::134]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sQePs-000wZb-4d for pgsql-hackers@lists.postgresql.org; Mon, 08 Jul 2024 02:47:49 +0000 Received: by mail-lf1-x134.google.com with SMTP id 2adb3069b0e04-52e9c55febcso4332137e87.2 for ; Sun, 07 Jul 2024 19:47:47 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1720406865; x=1721011665; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=sZKH+jnNapAFCfo729WfdIMlmwfkZRowvjvx48aIrQw=; b=S7f1LUMEK8o/mMQ47Hn8SfLcPeJAcLNr/HygKwpMvR2SvwBeKQLCg/QRaeAJFcywpo 4VtuMMSSHjsrYpWCnME2JeDmw4wHAtqOp+ofAAZ7D0PErUx28VE5iJZ/W4arp1G/ZoQf fR1yvN/85H0hQ0gjJkUsNb/QQ1lQj+ZA0ReXYXeZmSpoKByunTLgJWrfNecNLbfh0pf9 v0e9kn/QEvygh9tHByWqYnkb/LFeuHZE6eMhUJ63BeT9KN8Z2Iwc407xNGGI4Uya7U0Q R71aKH/NmlHEKY9uo1vQgvNH0DvmQVTzmTESjgi3M6GSUfbGHqyVS7WuAB+m4ma+99eg 4l3A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1720406865; x=1721011665; h=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=sZKH+jnNapAFCfo729WfdIMlmwfkZRowvjvx48aIrQw=; b=pHpJbSX6yNZS57N/UaJhOzzqMsxzQ1qdVqc97HKV1DD6BE8o3W0SInLrpFAkuslOZs 53fdSbfxQvHX5kDrvgbLCgEYmCxTnkJge0n7knqZJfrFKX1OjGyr8qgV/iyu3jJJS/zP rBMvc7u4V46lgKQG+TfTUSgocPwxD/zHiaM7eDieydUQzXp5dDPTRhtVO2wuVEWoi/DV EIe7acbi1nY75UeVVLv/X4MRH4FPZRjjdWDhInspnEa+RG3u4P5cFoRxHX2GUY1J+IWc HDc2d5TE6a8vGyHtFb9mPzxLko474tQL/F6UXMe2C6K7HBem9PpodHzt42TgQgcKEyeZ K1vA== X-Forwarded-Encrypted: i=1; AJvYcCVpcSZs4buLdocMSRlIyuR4a52Nw8uCwyCuQFPx9JISIprWqBaJUj06bgmOgO5XEbYq5NJDb7hjPSVL4LzKLbt6ubD90JlJziMTxA0Nm7Y2gPGC X-Gm-Message-State: AOJu0Yw/Ma4PJIe7YfC+/rMWWts+MZFXGLegKWYYO9jGVDVMipGLmOXD GYQrdZyb37NqAnOa3/godmRMyT+PvVdQ4ekoile/fiO8/E6IcJ4iVd2twk1gCZHH71StoOiInMe KPc1AMrSihH1UtZV0EmaRk1nho7c= X-Google-Smtp-Source: AGHT+IGzG1mHeRKhTWgamfMD2vK51ie4Gl86iizt4DAcMOqk4rhOu/ffA67W7GdzOT4MNE+EHRlGZXbih/XY0aiuXD0= X-Received: by 2002:ac2:554f:0:b0:52e:9bed:f9cc with SMTP id 2adb3069b0e04-52ea071274fmr6980233e87.65.1720406865268; Sun, 07 Jul 2024 19:47:45 -0700 (PDT) MIME-Version: 1.0 References: <13bd913f-94b6-43cf-b849-4d762e5297d8@yandex.ru> In-Reply-To: From: David Rowley Date: Mon, 8 Jul 2024 14:47:33 +1200 Message-ID: Subject: Re: Parallel Bitmap Heap Scan reports per-worker stats in EXPLAIN ANALYZE To: Masahiro.Ikeda@nttdata.com Cc: lena.ribackina@yandex.ru, donghanglin@gmail.com, geidav.pg@gmail.com, melanieplageman@gmail.com, tomas.vondra@enterprisedb.com, dilipbalaut@gmail.com, pgsql-hackers@lists.postgresql.org, hlinnaka@iki.fi Content-Type: text/plain; charset="UTF-8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Mon, 8 Jul 2024 at 12:19, David Rowley wrote: > Notice the "Heap Blocks: exact=2250000000" is missing on Windows. > This is because it wrapped around to a negative value and > show_tidbitmap_info() only shows > 0 values. > > I feel this is a good enough justification to increase the width of > those counters to uint64, so I'll do that too. I pushed the widening of the types first as I saw some code in the EXPLAIN patch which assumed var == 0 is the negator of var > 0. I couldn't bring myself to commit that knowing it was wrong and also couldn't bring myself to write <= 0 knowing I was about to make that look like a weird thing to write for an unsigned type. David