Re: Feature: add sync message logging to log_per_node_statement and notice_per_node_statement

From: Tatsuo Ishii <ishii(at)postgresql(dot)org>
To: pgpool-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: Feature: add sync message logging to log_per_node_statement and notice_per_node_statement
Date: 2025-12-15 00:18:51
Message-ID: 20251215.091851.1058501454610792105.ishii@postgresql.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgpool-hackers

> Currently pgpool does not emit logs for a "sync" message when
> log_per_node_statement/notice_per_node_statement enabled. Although
> "sync" is not a query statement, I think a sync message plays
> important role in extended query protocol since it indicates the
> completion of series of extended query protocol messages, and logging
> a sync message is important in a trouble shooting (I myself often
> enable debug message just to know whether a sync message is sent to
> backend or not, but enabling debug message creates lots of noise). So
> I propose to add logging for a sync message for upcoming Pgpool-II
> 4.8.
>
> Comments or suggestions are welcome.

Patch attached.
--
Tatsuo Ishii
SRA OSS K.K.
English: http://www.sraoss.co.jp/index_en/
Japanese:http://www.sraoss.co.jp

Attachment Content-Type Size
log_sync_message.patch text/x-patch 647 bytes

In response to

Responses

Browse pgpool-hackers by date

  From Date Subject
Next Message Tatsuo Ishii 2025-12-17 02:24:53 Re: Feature: add sync message logging to log_per_node_statement and notice_per_node_statement
Previous Message Tatsuo Ishii 2025-12-14 13:02:31 Feature: add sync message logging to log_per_node_statement and notice_per_node_statement