[Proposal][WIP] Add option to log auto_explain output to separate logfile

From: Timofey <tim-shlyap(at)yandex-team(dot)ru>
To: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: [Proposal][WIP] Add option to log auto_explain output to separate logfile
Date: 2021-12-22 13:54:37
Message-ID: fc1b810b-6256-4a3c-0fe0-27aec63eee82@yandex-team.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hello, hackers!

Now, all of auto_explain output is directed to postgres's log and it is
not comfortably to extract on big highloaded systems.
My proposal is add option to auto_explain to log data to separate
logfile. In my patch I plan to (re)open file every time associated guc
variable is changing, included extension boot. In case of error or
unexpected situation file closes and output directed to common
postgres's log.
What do you think about this idea? Also i would be grateful about any
ideas how conveniently and suitable rotate that new log

Attachment Content-Type Size
Different_logfile_for_auto_explain_option.patch text/x-patch 5.7 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Amit Kapila 2021-12-22 13:55:12 Re: parallel vacuum comments
Previous Message Masahiko Sawada 2021-12-22 13:34:45 Re: Replication slot drop message is sent after pgstats shutdown.