gistfile1.txt

Results from pg_stat_all_tables for Postgres 15.15

--- after update-inlist which precedes update-one

relid               | 16722
schemaname          | public
relname             | sbtest5
seq_scan            | 7
seq_tup_read        | 1500000000
idx_scan            | 24105834
idx_tup_fetch       | 44917425
n_tup_ins           | 250000000
n_tup_upd           | 6957026
n_tup_del           | 0
n_tup_hot_upd       | 1812309
n_live_tup          | 250000009
n_dead_tup          | 6521510
n_mod_since_analyze | 6957026
n_ins_since_vacuum  | 0
last_vacuum         | 2026-01-02 12:05:29.963878+00
last_autovacuum     | 2026-01-02 10:19:27.999877+00
last_analyze        | 2026-01-02 12:05:30.921113+00
last_autoanalyze    | 2026-01-02 10:18:26.662697+00
vacuum_count        | 1
autovacuum_count    | 55
analyze_count       | 1
autoanalyze_count   | 33

--- after update-zipf

relid               | 16722
schemaname          | public
relname             | sbtest5
seq_scan            | 7
seq_tup_read        | 1500000000
idx_scan            | 47853319
idx_tup_fetch       | 68664910
n_tup_ins           | 250000000
n_tup_upd           | 30704511
n_tup_del           | 0
n_tup_hot_upd       | 24038177
n_live_tup          | 249930433
n_dead_tup          | 9794943
n_mod_since_analyze | 5528849
n_ins_since_vacuum  | 0
last_vacuum         | 2026-01-02 12:05:29.963878+00
last_autovacuum     | 2026-01-02 10:19:27.999877+00
last_analyze        | 2026-01-02 12:05:30.921113+00
last_autoanalyze    | 2026-01-02 13:53:43.713117+00
vacuum_count        | 1
autovacuum_count    | 55
analyze_count       | 1
autoanalyze_count   | 34