In bitmap scan explain node show how many relevant heap pages were not examined

Title

Topic

Monitoring & Control

Created

2020-02-09 22:51:52

Last modified

2020-03-31 02:45:11 (3 years, 8 months ago)

Latest email

2020-03-31 02:46:22 (3 years, 8 months ago)

Status

2020-03: Returned with feedback

Target version

Authors

Jeff Janes (jjanes)

Reviewers

James Coleman (jcole1989)Become reviewer

Committer

Links

Emails

improve transparency of bitmap-only heap scans: First at 2019-05-18 19:28:59 by Jeff Janes <jeff.janes at gmail.com>
Latest at 2020-03-31 02:46:22 by Amit Kapila <amit.kapila16 at gmail.com>
Latest attachment (v4-0001-Show-bitmap-only-unfetched-page-count-to-EXPLAIN.patch) at 2020-03-20 01:38:46 from James Coleman <jtc331 at gmail.com>
    Attachment (v4-0001-Show-bitmap-only-unfetched-page-count-to-EXPLAIN.patch) at 2020-03-20 01:38:46 from James Coleman <jtc331 at gmail.com> (Patch: Yes)
    Attachment (v3-0001-Show-bitmap-only-unfetched-page-count-to-EXPLAIN.patch) at 2020-03-16 13:08:36 from James Coleman <jtc331 at gmail.com> (Patch: Yes)
    Attachment (bitmap_only_avoided_v2.patch) at 2020-02-07 15:22:12 from Alexey Bashtanov <bashtanov at imap.cc> (Patch: Yes)
    Attachment (example_output.txt) at 2019-05-18 19:28:59 from Jeff Janes <jeff.janes at gmail.com> (Patch: No)

History

When	Who	What
2020-03-31 02:45:11	Amit Kapila (amitkapila)	Closed in commitfest 2020-03 with status: Returned with feedback
2020-03-20 08:03:53	Kaleya Porter (kaleyap)	Removed kaleyap from reviewers
2020-03-20 07:53:28	Kaleya Porter (kaleyap)	Added kaleyap as reviewer
2020-03-20 07:52:34	Kaleya Porter (kaleyap)	Removed kaleyap from reviewers
2020-03-20 07:52:11	Kaleya Porter (kaleyap)	Added kaleyap as reviewer
2020-03-20 00:04:10	James Coleman (jcole1989)	New status: Ready for Committer
2020-03-16 00:03:34	James Coleman (jcole1989)	Added jcole1989 as reviewer
2020-02-09 22:55:09	Alexey Bashtanov (bashtanov)	Changed authors to Jeff Janes (jjanes)
2020-02-09 22:55:09	Alexey Bashtanov (bashtanov)	Changed targetversion to 13
2020-02-09 22:51:52	Alexey Bashtanov (bashtanov)	Attached mail thread CAMkU=1xQcMJgMeNxatR60R+-Bv4TeeO1ZcWmrJS4McLvbBmoXg@mail.gmail.com
2020-02-09 22:51:52	Alexey Bashtanov (bashtanov)	Created patch record