re-add redundant filter clause to stats query

Edit
ID 7222
Title re-add redundant filter clause to stats query
CI (CFBot) Summary
Stats (from CFBot) Patch version: v1, Patch count: 1, First patch: +7−5, All patches: +7−5
Tags Performance
Created 2026-08-30 14:27:16
Last modified 2026-09-01 21:29:17 (2 weeks ago)
Latest email 2026-09-01 21:29:08 (2 weeks ago)
Status
PG20-2 (2026-09-01 – 2026-09-30): Committed
Target version stable
Authors Nathan Bossart (bossartn)
Reviewers Become reviewer
Committer Nathan Bossart (bossartn)
Links
Emails
Add starelid, attnum to pg_stats and leverage this in pg_dump
First at 2026-02-25 21:22:06 by Corey Huinker <corey.huinker at gmail.com>
Latest at 2026-09-01 21:29:08 by Nathan Bossart <nathandbossart at gmail.com>
Latest attachment (v1-0001-pg_dump-Avoid-full-scans-of-pg_stats.patch) at 2026-08-30 14:26:38 from Nathan Bossart <nathandbossart at gmail.com>
    Attachment (v1-0001-pg_dump-Avoid-full-scans-of-pg_stats.patch) at 2026-08-30 14:26:38 from Nathan Bossart <nathandbossart at gmail.com> (Patch: No)
    Attachment (v10-0001-pg_dump-Simplify-query-in-getAttributeStats.patch) at 2026-03-17 15:01:42 from Nathan Bossart <nathandbossart at gmail.com> (Patch: Yes)
    Attachment (v9-0001-Add-OIDs-and-attribute-numbers-to-pg_stats-and-fr.patch) at 2026-03-16 19:19:07 from Nathan Bossart <nathandbossart at gmail.com> (Patch: Yes)
    Attachment (v8-0001-Add-tableid-statid-attnum-expr_attnum-columns-to-.patch) at 2026-03-14 21:13:19 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v7-0001-Add-test-view-pg_stats_check.patch) at 2026-03-13 15:38:42 from Sami Imseih <samimseih at gmail.com> (Patch: Yes)
    Attachment (v6-0001-Add-test-view-pg_stats_check.patch) at 2026-03-12 23:54:17 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v5-0001-Add-test-view-pg_stats_check.patch) at 2026-03-12 20:16:31 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v4-0001-Add-tableid-and-attnum-columns-to-pg_stats.patch) at 2026-03-09 22:42:46 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v3-0002-pg_dump-Use-tableid-in-getAttributeStats.patch) at 2026-03-09 18:56:19 from Sami Imseih <samimseih at gmail.com> (Patch: Yes)
    Attachment (v2-0001-Add-tableid-and-attnum-columns-to-pg_stats.patch) at 2026-03-02 05:18:36 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Add-attnum-and-starelid-columns-to-pg_stats.patch) at 2026-02-25 21:22:06 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
History
When Who What
2026-09-01 21:29:17 Nathan Bossart (bossartn) Closed in commitfest PG20-2 with status: Committed
2026-08-30 14:27:21 Nathan Bossart (bossartn) New status: Ready for Committer
2026-08-30 14:27:19 Nathan Bossart (bossartn) Added bossartn as committer
2026-08-30 14:27:16 Nathan Bossart (bossartn) Attached mail thread CADkLM=coCVy92QkVUUTLdo5eO2bMDtwMrzRn_8miAhX+uPaqXg@mail.gmail.com
2026-08-30 14:27:16 Nathan Bossart (bossartn) Created patch record
Edit