Statistics Import and Export

Edit
ID 4538
Title Statistics Import and Export
CI (CFBot) Summary
Stats (from CFBot) Patch count: 3, First patch: +4−2, All patches: +267−64
Topic Performance
Tags
Created 2023-08-31 19:21:04
Last modified 2025-04-03 06:29:28 (6 months ago)
Latest email 2025-05-22 21:29:29 (5 months ago)
Status
2025-03 (2025-03-01 – 2025-04-08): Committed
2025-01 (2025-01-01 – 2025-01-31): Moved to different CF
2024-11 (2024-11-01 – 2024-11-30): Moved to different CF
2024-09 (2024-09-01 – 2024-09-30): Moved to different CF
2024-07 (2024-07-01 – 2024-07-31): Moved to different CF
2024-03 (2024-03-01 – 2024-04-08): Moved to different CF
2024-01 (2024-01-01 – 2024-01-31): Moved to different CF
2023-11 (2023-11-01 – 2023-12-04): Moved to different CF
2023-09 (2023-09-01 – 2023-09-30): Moved to different CF
Target version
Authors Corey Huinker (coreyh)
Reviewers Nathan Bossart (bossartn), Bharath Rupireddy (bharathrupireddy)Become reviewer
Committer Jeff Davis (jdavis)
Links
Emails
Statistics Import and Export
First at 2023-08-31 06:47:31 by Corey Huinker <corey.huinker at gmail.com>
Latest at 2025-05-22 21:29:29 by Jeff Davis <pgsql at j-davis.com>
Latest attachment (v2-0001-Change-defaults-for-statistics-export.patch) at 2025-05-22 21:29:29 from Jeff Davis <pgsql at j-davis.com>
    Attachment (v2-0001-Change-defaults-for-statistics-export.patch) at 2025-05-22 21:29:29 from Jeff Davis <pgsql at j-davis.com> (Patch: Yes)
    Attachment (v1-0001-Change-defaults-for-statistics-export.patch) at 2025-05-22 18:52:21 from Jeff Davis <pgsql at j-davis.com> (Patch: Yes)
    Attachment (v3-0001-pg_dump-Adjust-reltuples-from-0-to-1-for-dumps-on.patch) at 2025-05-21 16:08:23 from Nathan Bossart <nathandbossart at gmail.com> (Patch: Yes)
    Attachment (0001-Stats-import-Fix-default-reltuples-on-versions-older.patch) at 2025-05-14 20:30:48 from Hari Krishna Sunder <hari.db.pg at gmail.com> (Patch: Yes)
    Attachment (0001-Stats-import-Fix-default-reltuples-on-versions-older.patch) at 2025-05-14 00:01:02 from Hari Krishna Sunder <hari.db.pg at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Fall-back-to-single-attribute-stat-fetching-for-v.patch) at 2025-04-04 23:32:48 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v12n6-0001-Skip-second-WriteToc-call-for-custom-format-du.patch) at 2025-04-04 02:19:51 from Nathan Bossart <nathandbossart at gmail.com> (Patch: Yes)
    Attachment (v12n5-0001-Skip-second-WriteToc-for-custom-format-dumps-w.patch) at 2025-04-03 02:26:32 from Nathan Bossart <nathandbossart at gmail.com> (Patch: Yes)
    Attachment (v12n4-0001-Skip-second-WriteToc-for-custom-format-dumps-w.patch) at 2025-04-02 03:21:44 from Nathan Bossart <nathandbossart at gmail.com> (Patch: Yes)
    Attachment (v12n3-0001-Skip-second-WriteToc-for-custom-format-dumps-w.patch) at 2025-04-01 18:44:14 from Nathan Bossart <nathandbossart at gmail.com> (Patch: Yes)
    Attachment (v12n2-0001-Skip-second-WriteToc-for-custom-format-dumps-w.patch) at 2025-04-01 18:20:30 from Nathan Bossart <nathandbossart at gmail.com> (Patch: Yes)
    Attachment (v12n-0001-Skip-second-WriteToc-for-custom-format-dumps-wi.patch) at 2025-04-01 02:33:15 from Nathan Bossart <nathandbossart at gmail.com> (Patch: Yes)
    Attachment (v12-0001-Introduce-CreateStmtPtr.patch) at 2025-03-31 15:11:47 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v11j-0001-Add-relallfrozen-to-pg_dump-statistics.patch) at 2025-03-29 05:29:16 from Jeff Davis <pgsql at j-davis.com> (Patch: Yes)
    Attachment (v11-0001-Add-relallfrozen-to-pg_dump-statistics.patch) at 2025-03-29 01:11:05 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v10-0002-Batching-getAttributeStats.patch) at 2025-03-26 01:41:25 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v9j-0001-Stats-use-schemaname-relname-instead-of-regclass.patch) at 2025-03-25 06:53:33 from Jeff Davis <pgsql at j-davis.com> (Patch: Yes)
    Attachment (v9-0005-Add-relallfrozen-to-pg_dump-statistics.patch) at 2025-03-16 01:37:51 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v8-0001-Split-relation-into-schemaname-and-relname.patch) at 2025-03-14 20:03:16 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v7-0001-Split-relation-into-schemaname-and-relname.patch) at 2025-03-08 07:56:18 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Add-pg_dump-with-X-options.patch) at 2025-03-07 01:42:30 from Jeff Davis <pgsql at j-davis.com> (Patch: Yes)
    Attachment (v6-0001-refactor-_tocEntryRequired-for-STATISTICS-DATA.patch) at 2025-03-06 04:04:29 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v5-0001-refactor-_tocEntryRequired-for-STATISTICS-DATA.patch) at 2025-03-05 08:08:55 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v2-0001-During-CREATE-INDEX-don-t-update-stats-if-autovac.patch) at 2025-02-28 20:10:37 from Jeff Davis <pgsql at j-davis.com> (Patch: Yes)
    Attachment (v2-0001-Organize-and-deduplicate-statistics-import-tests.patch) at 2025-02-28 04:34:40 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Do-not-update-stats-on-empty-table-when-building-.patch) at 2025-02-28 02:32:20 from Jeff Davis <pgsql at j-davis.com> (Patch: Yes)
    Attachment (vTestReorg-0001-Organize-and-deduplicate-statistics-impor.patch) at 2025-02-27 02:19:12 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (vViaDellaAttnums-0001-Add-ability-to-reference-columns-by.patch) at 2025-02-26 09:25:29 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v3j-0001-Avoid-unnecessary-relation-stats-query-in-pg_dum.patch) at 2025-02-26 02:00:12 from Jeff Davis <pgsql at j-davis.com> (Patch: Yes)
    Attachment (vAdios-Set-0001-Remove-redundant-pg_set_-_stats-variants.patch) at 2025-02-25 23:40:34 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Remove-redundant-pg_set_-_stats-variants.patch) at 2025-02-25 18:22:13 from Jeff Davis <pgsql at j-davis.com> (Patch: Yes)
    Attachment (pg-dump-setlocale.diff) at 2025-02-24 20:20:41 from Jeff Davis <pgsql at j-davis.com> (Patch: Yes)
    Attachment (allow-stats-att-name-or-number-wip.patch) at 2025-02-24 17:50:58 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)
    Attachment (v2-0001-Leverage-existing-functions-for-relation-stats.patch) at 2025-02-24 10:11:48 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v2j-0001-Avoid-unnecessary-relation-stats-query-in-pg_dum.patch) at 2025-02-24 00:21:59 from Jeff Davis <pgsql at j-davis.com> (Patch: Yes)
    Attachment (v1-0001-Leverage-existing-functions-for-relation-stats.patch) at 2025-02-22 05:00:39 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v48-0001-Enable-dumping-of-table-index-stats-in-pg_dump.patch) at 2025-02-11 19:02:21 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v47-0001-Lock-table-first-when-setting-index-relation-sta.patch) at 2025-02-10 03:00:18 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v46-0001-Lock-table-first-when-setting-index-relation-sta.patch) at 2025-02-06 09:35:28 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v45-0001-Lock-table-first-when-setting-index-relation-sta.patch) at 2025-02-06 04:01:13 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v43-0001-Lock-table-first-when-setting-index-relation-sta.patch) at 2025-01-22 03:21:51 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v42-0001-Lock-table-first-when-setting-index-relation-sta.patch) at 2025-01-21 19:50:33 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v41-0001-Lock-table-first-when-setting-index-relation-sta.patch) at 2025-01-21 06:43:17 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v40-0001-Lock-table-first-when-setting-index-relation-sta.patch) at 2025-01-21 02:25:14 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (regression.diffs) at 2025-01-20 21:26:02 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v38-0001-make-statistics-dumped-at-SECTION_POST_DATA.no-cfbot) at 2025-01-20 08:21:35 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v1-0001-misc-minor-refactoring.no-cfbot) at 2025-01-18 17:00:04 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (refactor_pg_dump_onlyoption.no-cfbot) at 2025-01-17 14:20:12 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v38-0001-Enable-dumping-of-table-index-stats-in-pg_dump.patch) at 2025-01-15 20:56:04 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v37-0004-Expose-attribute-statistics-functions-for-use-in.patch) at 2025-01-07 06:18:04 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v36j-0001-Dump-table-index-stats-in-pg_dump-and-transfer-.patch) at 2024-12-20 05:23:20 from Jeff Davis <pgsql at j-davis.com> (Patch: Yes)
    Attachment (v35-0004-Add-no-schema-option-to-pg_dump-etc.patch) at 2024-12-13 05:22:38 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v34-0002-Add-no-data-option.patch) at 2024-12-12 03:49:53 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v33j-0001-Use-in-place-updates-for-pg_restore_relation_st.patch) at 2024-12-07 00:44:10 from Jeff Davis <pgsql at j-davis.com> (Patch: Yes)
    Attachment (v33-0002-Add-no-data-option.patch) at 2024-11-27 05:08:26 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v32-0003-Enable-dumping-of-table-index-stats-in-pg_dump.patch) at 2024-11-19 01:29:10 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v31-0004-Enable-in-place-updates-for-pg_restore_relation_.patch) at 2024-11-08 18:25:21 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v30-0001-Add-derivative-flags-dumpSchema-dumpData.patch) at 2024-11-05 02:22:28 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (0001-Add-missing-CommandCounterIncrement-in-stats-import-.patch) at 2024-10-29 01:55:00 from Jeff Davis <pgsql at j-davis.com> (Patch: Yes)
    Attachment (pg_clear_attribute_stats_doc_v1.diff) at 2024-10-22 23:58:31 from "Shinoda, Noriyoshi (SXD Japan FSIP)" <noriyoshi.shinoda at hpe.com> (Patch: Yes)
    Attachment (pg_set_relation_stats_patch_v1.diff) at 2024-10-22 00:50:56 from "Shinoda, Noriyoshi (SXD Japan FSIP)" <noriyoshi.shinoda at hpe.com> (Patch: Yes)
    Attachment (v3-0001-Allow-relation_statistics_update-to-continue-afte.patch) at 2024-10-19 01:00:16 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v2-0001-Allow-pg_set_relation_stats-to-set-relpages-to-1.patch) at 2024-10-16 23:20:19 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Allow-pg_set_relation_stats-to-set-relpages-to-1.patch) at 2024-10-15 23:36:10 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (relpages_stat_update_v1.diff) at 2024-10-12 13:02:55 from "Shinoda, Noriyoshi (SXD Japan FSIP)" <noriyoshi.shinoda at hpe.com> (Patch: Yes)
    Attachment (v29-0003-Add-relkind-check-to-stats_lock_check_privileges.patch) at 2024-09-17 09:02:49 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v28-0001-minor-refactor-based-on-28j.no-cfbot) at 2024-09-08 02:02:00 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v28j-0001-Create-functions-pg_set_relation_stats-pg_clear.patch) at 2024-08-23 20:49:52 from Jeff Davis <pgsql at j-davis.com> (Patch: No)
    Attachment (v27j-0001-Create-function-pg_set_relation_stats.patch) at 2024-08-16 00:35:24 from Jeff Davis <pgsql at j-davis.com> (Patch: Yes)
    Attachment (v26j-0001-Create-function-pg_set_relation_stats.patch) at 2024-08-15 08:57:03 from Jeff Davis <pgsql at j-davis.com> (Patch: Yes)
    Attachment (v25j-0001-Create-function-pg_set_relation_stats.patch) at 2024-08-09 01:32:23 from Jeff Davis <pgsql at j-davis.com> (Patch: Yes)
    Attachment (v25-0001-Create-function-pg_set_relation_stats.patch) at 2024-07-28 01:08:44 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v24-0004-Add-derivative-flags-dumpSchema-dumpData.patch) at 2024-07-22 16:05:34 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v23-0001-Create-statistics-set-and-restore-functions.patch) at 2024-07-18 06:09:26 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v22-0001-Create-pg_set_relation_stats-pg_set_attribute_st.patch) at 2024-06-04 03:34:51 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v21-0001-Create-pg_set_relation_stats-pg_set_attribute_st.patch) at 2024-05-07 03:43:50 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v20-0001-Create-pg_set_relation_stats-pg_set_attribute_st.patch) at 2024-04-26 03:27:08 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v19-0001-Create-pg_set_relation_stats-pg_set_attribute_st.patch) at 2024-04-24 10:18:30 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v18-0001-Create-pg_set_relation_stats-pg_set_attribute_st.patch) at 2024-04-11 19:54:07 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v17-0001-Create-pg_set_relation_stats-pg_set_attribute_st.patch) at 2024-04-04 04:30:18 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v16-0001-Disable-updating-pg_class-for-CREATE-INDEX-durin.patch) at 2024-04-03 04:59:10 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Disable-updating-pg_class-for-CREATE-INDEX-during.patch) at 2024-04-02 09:38:53 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (stats_import_export_review.patch) at 2024-04-01 11:31:02 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: Yes)
    Attachment (v15-0001-Create-pg_set_relation_stats-pg_set_attribute_st.patch) at 2024-03-30 05:34:16 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v14-0001-Create-pg_set_relation_stats-pg_set_attribute_st.patch) at 2024-03-29 09:32:40 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (vjeff-0001-Enable-dumping-of-table-index-stats-in-pg_dump.patch) at 2024-03-29 06:25:38 from Jeff Davis <pgsql at j-davis.com> (Patch: Yes)
    Attachment (0001-Create-pg_set_relation_stats-pg_set_attribute_stats.patch) at 2024-03-25 23:16:48 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (v13-0001-Create-pg_set_relation_stats-pg_set_attribute_st.patch) at 2024-03-25 08:27:38 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v12-0001-Create-pg_set_relation_stats-pg_set_attribute_st.patch) at 2024-03-23 01:51:01 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v11-0001-Create-pg_set_relation_stats-pg_set_attribute_st.patch) at 2024-03-19 09:16:29 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v10-0001-Create-pg_set_relation_stats-pg_set_attribute_st.patch) at 2024-03-18 03:33:57 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v9-0001-Create-pg_set_relation_stats-pg_set_attribute_sta.patch) at 2024-03-15 07:55:13 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v8-0001-Create-pg_set_relation_stats-pg_set_attribute_sta.patch) at 2024-03-11 18:20:36 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v7-0001-Create-pg_set_relation_stats-pg_set_attribute_sta.patch) at 2024-03-08 06:35:40 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v6-0001-Create-pg_import_rel_stats.patch) at 2024-02-20 07:24:52 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v5-0001-Create-pg_import_rel_stats.patch) at 2024-02-15 09:09:41 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v4-0001-Create-pg_import_rel_stats.patch) at 2024-02-02 08:37:10 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v3-0002-Add-system-view-pg_statistic_export.patch) at 2023-12-13 10:26:04 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v2-0001-Additional-internal-jsonb-access-functions.patch) at 2023-10-31 07:25:17 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Introduce-the-system-view-pg_stats_export-and-the.patch) at 2023-08-31 06:47:31 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
History
When Who What
2025-04-03 06:29:28 Jeff Davis (jdavis) Closed in commitfest 2025-03 with status: Committed
2025-04-03 06:29:28 Jeff Davis (jdavis) Changed committer to jdavis
2025-04-01 18:21:39 Nathan Bossart (bossartn) Added bossartn as reviewer
2025-03-18 09:57:17 vigneshwaran C (vignesh.postgres) New status: Needs review
2025-03-14 20:35:39 CFbot Patch does not need rebase anymore
2025-03-11 04:13:47 vigneshwaran C (vignesh.postgres) New status: Waiting on Author
2025-03-10 13:35:45 CFbot Patch needs rebase
2025-02-22 05:31:52 CFbot Patch does not need rebase anymore
2025-02-21 21:31:46 CFbot Patch needs rebase
2025-02-05 22:38:50 Corey Huinker (coreyh) Closed in commitfest 2025-01 with status: Moved to next CF
2024-12-01 19:11:04 Dmitry Dolgov (erthalion) Closed in commitfest 2024-11 with status: Moved to next CF
2024-10-05 07:26:39 Bertrand Drouvot (bertranddrouvot.pg) Closed in commitfest 2024-09 with status: Moved to next CF
2024-08-01 06:13:04 Corey Huinker (coreyh) Closed in commitfest 2024-07 with status: Moved to next CF
2024-04-08 14:31:48 Andrey Borodin (x4m) Changed targetversion to None
2024-04-08 07:21:25 Andrey Borodin (x4m) Closed in commitfest 2024-03 with status: Moved to next CF
2024-04-08 07:21:21 Andrey Borodin (x4m) New status: Needs review
2024-03-11 12:21:46 Bharath Rupireddy (bharathrupireddy) New status: Waiting on Author
2024-03-11 02:30:26 Bharath Rupireddy (bharathrupireddy) Added bharathrupireddy as reviewer
2024-02-20 18:53:58 Corey Huinker (coreyh) New status: Needs review
2024-02-01 17:50:26 vigneshwaran C (vignesh.postgres) Closed in commitfest 2024-01 with status: Moved to next CF
2024-02-01 17:50:21 vigneshwaran C (vignesh.postgres) New status: Waiting on Author
2023-12-04 09:48:37 John Naylor (john.naylor) Closed in commitfest 2023-11 with status: Moved to next CF
2023-10-02 09:47:37 Peter Eisentraut (petere) Closed in commitfest 2023-09 with status: Moved to next CF
2023-08-31 19:41:08 Corey Huinker (coreyh) Changed authors to Corey Huinker (coreyh)
2023-08-31 19:21:16 Corey Huinker (coreyh) Changed targetversion to 17
2023-08-31 19:21:04 Corey Huinker (coreyh) Attached mail thread CADkLM=cB0rF3p_FuWRTMSV0983ihTRpsH+OCpNyiqE7Wk0vUWA@mail.gmail.com
2023-08-31 19:21:04 Corey Huinker (coreyh) Created patch record
Edit