Re: RFC: Allow EXPLAIN to Output Page Fault Information
torikoshia <torikoshia@oss.nttdata.com>
From: torikoshia <torikoshia@oss.nttdata.com>
To: Jelte Fennema-Nio <postgres@jeltef.nl>
Cc: pgsql-hackers@postgresql.org, andres@anarazel.de, tgl@sss.pgh.pa.us,
rjuju123@gmail.com, Bruce Momjian <bruce@momjian.us>
Date: 2026-01-28T14:59:20Z
Lists: pgsql-hackers
Attachments
- v9-0001-Add-storage-I-O-tracking-to-BUFFERS-option.patch (text/x-diff) patch v9-0001
On 2026-01-28 22:27, torikoshia wrote: > On 2026-01-25 23:35, Jelte Fennema-Nio wrote: > >> On Tue Oct 28, 2025 at 9:43 AM CET, torikoshia wrote: >>> Rebased the patch again. >> >> I took another look at this patch because I think it would be really >> useful to have. Below is my review: > > Thank you for the review! > >> 8. Now that worker is the default io_method the new explain fields are >> never >> present in the explain tests anymore. So explain_1.out is >> unnecessary and can be removed. That obviously also means that >> there's no coverage for this feature at all in the tests currently, >> which is clearly a problem. So I think it would be good to add some >> actual tests for the feature using some other io_method in a Perl >> TAP >> test. > > However, I noticed that there are test environments where io_method is > set to io_uring (for example, Linux Debian Trixie builds on Cirrus CI > using Meson), so it appears that explain_1.out is still needed. > Given this, adding the Perl TAP test might be somewhat redundant, but > for now I’m attaching a patch that includes both. > >> 9. The added docs about the kernel not being built with the correct >> options seems a bit too much detail. I'd say remove that sentence. >> And maybe shorten th > > Is this comment still a work in progress? > > I agree with the other comments. Attached an updated patch reflecting > them. Updated the patch to fix a regression test failure. > > > Regards, > > -- > Atsushi Torikoshi > Seconded from NTT DATA Japan Corporation to SRA OSS K.K
Commits
Same data as JSON:
GET /api/v1/messages/:b64id/commits
the thread's linked commits as JSON, with link sources.
API reference →
-
Avoid leaking system path from pg_available_extensions
- db5ed03217b9 19 (unreleased) cited
-
Enable BUFFERS with EXPLAIN ANALYZE by default
- c2a4078ebad7 18.0 cited