Proposal: add a debug message about using geqo

From: KAWAMOTO Masaya <kawamoto(at)sraoss(dot)co(dot)jp>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Proposal: add a debug message about using geqo
Date: 2022-05-10 01:05:48
Message-ID: 20220510100548.93be160a9fa88a11f0835c23@sraoss.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

During query tuning, users may want to check if GEQO is used or not
to generate a plan. However, users can not know it by simply counting
the number of tables that appear in SQL. I know we can know it by
enabling GEQO_DEBUG flag, but it needs recompiling, so I think it is
inconvenient.

So, I would like to propose to add a debug level message that shows
when PostgreSQL use GEQO. That enables users to easily see it by
just changing log_min_messages.

Use cases are as follows:
- When investigating about the result of planning, user can determine
whether the plan is chosen by the standard planning or GEQO.

- When tuning PostgreSQL, user can determine the suitable value of
geqo_threshold parameter.

Best regards.

--
KAWAMOTO Masaya <kawamoto(at)sraoss(dot)co(dot)jp>
SRA OSS, Inc. Japan

Attachment Content-Type Size
debugmessage_about_geqo.patch application/octet-stream 709 bytes

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andres Freund 2022-05-10 01:26:57 waiting for reload in tests
Previous Message Michael Paquier 2022-05-10 01:01:55 Re: [PATCH] Add native windows on arm64 support