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 <pgsql-bugs-owner+archive@lists.postgresql.org>)
	id 1shBB2-00E8VA-K7
	for pgsql-bugs@arkaria.postgresql.org; Thu, 22 Aug 2024 17:00:48 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-bugs-owner+archive@lists.postgresql.org>)
	id 1shBB0-0042w6-AX
	for pgsql-bugs@arkaria.postgresql.org; Thu, 22 Aug 2024 17:00:46 +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 <lepihov@gmail.com>)
	id 1shBB0-0042vy-10
	for pgsql-bugs@lists.postgresql.org; Thu, 22 Aug 2024 17:00:46 +0000
Received: from mail-wm1-x32a.google.com ([2a00:1450:4864:20::32a])
	by makus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256
	(Exim 4.94.2)
	(envelope-from <lepihov@gmail.com>)
	id 1shBAu-000veV-Ca
	for pgsql-bugs@lists.postgresql.org; Thu, 22 Aug 2024 17:00:45 +0000
Received: by mail-wm1-x32a.google.com with SMTP id
 5b1f17b1804b1-429ec9f2155so8057285e9.2
        for <pgsql-bugs@lists.postgresql.org>;
 Thu, 22 Aug 2024 10:00:40 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20230601; t=1724346039; x=1724950839;
 darn=lists.postgresql.org;
        h=content-transfer-encoding:in-reply-to:from:content-language
         :references:to:subject:user-agent:mime-version:date:message-id:from
         :to:cc:subject:date:message-id:reply-to;
        bh=nccfZxrDYo2B8qPn0ovcVXtWaVjh1bqDf4DmpsMvnwc=;
        b=cyt7psG7Rbx57NEUJYj5w5zjADIJxgZSMhGK0O9eOJFkrwEjkVxFCD41vCpOCzUCVd
         SsI3UCNefLZjuN7ZNy4zEMtZtqaIsJkkqcoXuBKvAb1wa3YCIZ1OWjL5OrjRVXxFTTZM
         atEAHu7gWoPgfGj6tW1fOtq0HtDQXS2rVubmAF6miow5wZrcBbLbW6/UKbBpzjzIrIVJ
         xiiBzch1aJKViBTU8YxTqqRsVoeHhCK1N81PBbut1M7RffrdSFKmX7F7cIVnlGtlK2P5
         col7fzGMtQ31q9czx4AFk0KX1IbFu3v6zrETa46erOb0hjNapMhSCYYERZKCY6wb0MYE
         UiOw==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20230601; t=1724346039; x=1724950839;
        h=content-transfer-encoding:in-reply-to:from:content-language
         :references:to:subject:user-agent:mime-version:date:message-id
         :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to;
        bh=nccfZxrDYo2B8qPn0ovcVXtWaVjh1bqDf4DmpsMvnwc=;
        b=pgL2Mr1qRLQjrec9TkAaKnRvEZ8sOQLpR6DmJl/nv9AT+qJBkkEvLu2uOQ0EUWDVUJ
         bw84/TcV04dWYcWj0rkfepbnoN7AJpPsBhlZyO7vYmWLlOVr+y5f9OgNLdpUlNUlpez5
         dj/Eo/AShUhl2HLalzzcwMgWpf8PsRrL5IhHwSOq5rBSRYsoV8g5qGtTmcfzoN0vgYj6
         pMFpPCV6iYAHFUNbrgVcuWkBb+JakYycayekRjhttgM5xNGuPmKBd3GpSejxzrbBNxLG
         1cmJVxX6MlxHlXwJtTCTXqaEkjW3szPg7FVCFplv0Y/RqFQky+nkIK5vl+f2zkT2QZ0c
         gwQA==
X-Gm-Message-State: AOJu0YyP3PWfyB3gBZi7V789Q3RpkfHuu43ChpL/XLZeHcexv5TfXjzV
	sS64j0IuLEOJubqxgCLd2G/SQCtg7j/QF747IVQxq/LGacc78TR5u2AZ6hV1CFHNFw==
X-Google-Smtp-Source: 
 AGHT+IGSjwH2uPFpnJHWSb+S+ZN0D7PLvpemIcs55DNzZAev5N2X2FXZwkU/CJ9qA8+w12QQW/Bf5w==
X-Received: by 2002:a05:600c:46cf:b0:426:647b:1bf7 with SMTP id
 5b1f17b1804b1-42abf0a9391mr47149865e9.32.1724346038443;
        Thu, 22 Aug 2024 10:00:38 -0700 (PDT)
Received: from ?IPV6:2a0c:5a83:4c09:9d00:e0ec:ccb3:c7cc:53a7?
 ([2a0c:5a83:4c09:9d00:e0ec:ccb3:c7cc:53a7])
        by smtp.gmail.com with ESMTPSA id
 5b1f17b1804b1-42ac5158f14sm30528875e9.16.2024.08.22.10.00.37
        for <pgsql-bugs@lists.postgresql.org>
        (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128);
        Thu, 22 Aug 2024 10:00:37 -0700 (PDT)
Message-ID: <59962b3b-4288-4759-a480-b60bcce3b388@gmail.com>
Date: Thu, 22 Aug 2024 19:00:37 +0200
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: BUG #18588: Cannot force/let database use parallel execution in
 simple case.
To: pgsql-bugs@lists.postgresql.org
References: <18588-204730f9394441a8@postgresql.org>
Content-Language: en-US
From: Andrei Lepikhov <lepihov@gmail.com>
In-Reply-To: <18588-204730f9394441a8@postgresql.org>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
List-Id: <pgsql-bugs.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-bugs@lists.postgresql.org>
List-Owner: <mailto:pgsql-bugs-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-bugs>
Archived-At: 
 <https://www.postgresql.org/message-id/59962b3b-4288-4759-a480-b60bcce3b388%40gmail.com>
Precedence: bulk

On 22/8/2024 14:58, PG Bug reporting form wrote:
>   Index Scan using negotiation_topic_archive_p005_employer_id_resume_id_idx
> on negotiation_topic_archive_p005 this_  (cost=0.11..2501972.13 rows=505757
> width=8) (actual time=0.020..699.322 rows=510040 loops=1)
>     Index Cond: (employer_id = 816144)
>   Planning Time: 0.132 ms
>   Execution Time: 717.005 ms
Can you disable IndexScan and Bitmapscan step-by-step and show explain 
analyze verbose with costs?

-- 
regards, Andrei Lepikhov