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 (4 years, 7 months ago)

Latest email

2020-03-31 02:46:22 (4 years, 7 months ago)

Status

2020-03: Returned with feedback

Target version

Authors

Jeff Janes (jjanes)

Reviewers

James Coleman (jcole1989)Become reviewer

Committer

Links

Checkout latest CFbot patchset

Go to your local checkout of the PostgreSQL repository and run:

git remote add commitfest https://github.com/postgresql-cfbot/postgresql.git
git fetch commitfest cf/2443
git checkout commitfest/cf/2443

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