################################################################ ## ADAPTIVE OFF ################################################################ ### from config BASE_DIR=$HOME/test_adaptive_costdelay OLTP_TABLES=16 OLTP_ROWS_START=1000 OLTP_ROWS_MULTIPLIER=2 OLTP_MAX_ROWS=5000000 BATCH_TABLES=3 BATCH_SIZE=100000 BATCH_CONNECTIONS=5 OLTP_CONNECTIONS=200 TIMEOUT=1800 OLTP_RATE=15000 BATCH_SLEEP=5 BUCKETS=15 ### from summary_report.txt === Database Settings === name | setting ---------------------------------------+----------- autovacuum | on autovacuum_analyze_scale_factor | 0.1 autovacuum_analyze_threshold | 50 autovacuum_freeze_max_age | 200000000 autovacuum_max_workers | 6 autovacuum_multixact_freeze_max_age | 400000000 autovacuum_naptime | 10 autovacuum_vacuum_cost_delay | 2 autovacuum_vacuum_cost_limit | 200 autovacuum_vacuum_insert_scale_factor | 0.2 autovacuum_vacuum_insert_threshold | 1000 autovacuum_vacuum_max_threshold | 100000000 autovacuum_vacuum_scale_factor | 0.2 autovacuum_vacuum_threshold | 50 autovacuum_work_mem | -1 autovacuum_worker_slots | 16 debug_autovacuum_adaptive_cost_delay | off log_autovacuum_min_duration | 600000 max_connections | 1000 shared_buffers | 524288 (20 rows) === Total Activity === Expanded display is on. -[ RECORD 1 ]----------------+---------- total_n_dead_tup | 8275017 total_n_mod_since_analyze | 73270017 total_reltuples | 102595036 total_autovacuum_count | 596 total_autoanalyze_count | 626 total_n_tup_upd | 26976421 total_n_tup_hot_upd | 6 total_n_tup_newpage_upd | 4129161 total_n_tup_ins | 170998000 total_total_autovacuum_time | 6002559 total_total_autoanalyze_time | 737294 avg_autovacuum_time | 10071.41 avg_autoanalyze_time | 1177.79 table_count | 19 ### last snapshot from relstats_monitor.log ?column? | timestamp | relname | reltuples | n_dead_tup | av_count | aa_count | total_av_time | total_aa_time | n_tup_upd | n_tup_hot_upd | n_tup_ins | avg_av_time | avg_aa_time ----------+-------------------------------+------------------+-----------+------------+----------+----------+---------------+---------------+-----------+---------------+-----------+-------------+------------- TAB_DATA | 2025-11-13 18:19:13.859283+00 | table_batch_2 | 38100700 | 0 | 12 | 16 | 761121 | 44618 | 0 | 0 | 51600000 | 63426.75 | 2788.63 TAB_DATA | 2025-11-13 18:19:13.859283+00 | table_batch_3 | 34528300 | 0 | 13 | 16 | 566402 | 44034 | 0 | 0 | 58900000 | 43569.38 | 2752.13 TAB_DATA | 2025-11-13 18:19:13.859283+00 | table_batch_1 | 21774900 | 0 | 11 | 16 | 363639 | 42802 | 0 | 0 | 51700000 | 33058.09 | 2675.13 TAB_DATA | 2025-11-13 18:19:13.859283+00 | table_13_4096000 | 4094220 | 1663211 | 0 | 2 | 0 | 24094 | 1679826 | 0 | 4096000 | 0.00 | 12047.00 TAB_DATA | 2025-11-13 18:19:13.859283+00 | table_12_2048000 | 2045990 | 1202655 | 1 | 3 | 688704 | 32095 | 1677550 | 0 | 2048000 | 688704.00 | 10698.33 TAB_DATA | 2025-11-13 18:19:13.859283+00 | table_11_1024000 | 1023520 | 446236 | 3 | 5 | 1012818 | 88110 | 1679477 | 0 | 1024000 | 337606.00 | 17622.00 TAB_DATA | 2025-11-13 18:19:13.859283+00 | table_10_512000 | 510631 | 523053 | 6 | 9 | 831354 | 118808 | 1679972 | 0 | 512000 | 138559.00 | 13200.89 TAB_DATA | 2025-11-13 18:19:13.859283+00 | table_9_256000 | 253966 | 338711 | 11 | 13 | 595414 | 119077 | 1678826 | 0 | 256000 | 54128.55 | 9159.77 TAB_DATA | 2025-11-13 18:19:13.859283+00 | table_8_128000 | 127072 | 304428 | 20 | 23 | 342490 | 80691 | 1676978 | 0 | 128000 | 17124.50 | 3508.30 TAB_DATA | 2025-11-13 18:19:13.859283+00 | table_7_64000 | 63934 | 384090 | 31 | 37 | 137967 | 30872 | 1678386 | 0 | 64000 | 4450.55 | 834.38 TAB_DATA | 2025-11-13 18:19:13.859283+00 | table_6_32000 | 31999 | 397000 | 46 | 46 | 77761 | 20853 | 1679845 | 0 | 32000 | 1690.46 | 453.33 TAB_DATA | 2025-11-13 18:19:13.859283+00 | table_5_16000 | 16000 | 403389 | 53 | 53 | 54637 | 14975 | 1681087 | 0 | 16000 | 1030.89 | 282.55 TAB_DATA | 2025-11-13 18:19:13.859283+00 | table_4_8000 | 8000 | 408596 | 55 | 55 | 46578 | 12184 | 1678262 | 0 | 8000 | 846.87 | 221.53 TAB_DATA | 2025-11-13 18:19:13.859283+00 | table_3_4000 | 4000 | 413417 | 56 | 56 | 49377 | 12587 | 1679051 | 0 | 4000 | 881.73 | 224.77 TAB_DATA | 2025-11-13 18:19:13.859283+00 | table_16_4000 | 3998 | 424019 | 54 | 54 | 51626 | 10765 | 1680665 | 0 | 4000 | 956.04 | 199.35 TAB_DATA | 2025-11-13 18:19:13.859283+00 | table_2_2000 | 1996 | 433390 | 55 | 55 | 45625 | 11391 | 1680127 | 0 | 2000 | 829.55 | 207.11 TAB_DATA | 2025-11-13 18:19:13.859283+00 | table_15_2000 | 1988 | 429912 | 56 | 55 | 48642 | 11895 | 1679333 | 0 | 2000 | 868.61 | 216.27 TAB_DATA | 2025-11-13 18:19:13.859283+00 | table_14_1000 | 991 | 443569 | 55 | 55 | 47101 | 8219 | 1677776 | 1 | 1000 | 856.38 | 149.44 TAB_DATA | 2025-11-13 18:19:13.859283+00 | table_1_1000 | 986 | 438926 | 57 | 57 | 45355 | 9224 | 1678749 | 5 | 1000 | 795.70 | 161.82 (19 rows) ################################################################ ## ADAPTIVE ON ################################################################ ### from config BASE_DIR=/home/postgres/test_adaptive_costdelay OLTP_TABLES=16 OLTP_ROWS_START=1000 OLTP_ROWS_MULTIPLIER=2 OLTP_MAX_ROWS=5000000 BATCH_TABLES=3 BATCH_SIZE=100000 BATCH_CONNECTIONS=5 OLTP_CONNECTIONS=200 TIMEOUT=1800 OLTP_RATE=15000 BATCH_SLEEP=5 BUCKETS=15 ### from summary_report.txt === Database Settings === name | setting ---------------------------------------+----------- autovacuum | on autovacuum_analyze_scale_factor | 0.1 autovacuum_analyze_threshold | 50 autovacuum_freeze_max_age | 200000000 autovacuum_max_workers | 6 autovacuum_multixact_freeze_max_age | 400000000 autovacuum_naptime | 10 autovacuum_vacuum_cost_delay | 2 autovacuum_vacuum_cost_limit | 200 autovacuum_vacuum_insert_scale_factor | 0.2 autovacuum_vacuum_insert_threshold | 1000 autovacuum_vacuum_max_threshold | 100000000 autovacuum_vacuum_scale_factor | 0.2 autovacuum_vacuum_threshold | 50 autovacuum_work_mem | -1 autovacuum_worker_slots | 16 debug_autovacuum_adaptive_cost_delay | on <<<----------------- log_autovacuum_min_duration | 600000 max_connections | 1000 shared_buffers | 524288 (20 rows) === Total Activity === Expanded display is on. -[ RECORD 1 ]----------------+---------- total_n_dead_tup | 193646 total_n_mod_since_analyze | 3449748 total_reltuples | 167574791 total_autovacuum_count | 1884 total_autoanalyze_count | 2107 total_n_tup_upd | 26996175 total_n_tup_hot_upd | 1 total_n_tup_newpage_upd | 4376974 total_n_tup_ins | 170998000 total_total_autovacuum_time | 154293 total_total_autoanalyze_time | 194937 avg_autovacuum_time | 81.90 avg_autoanalyze_time | 92.52 table_count | 19 ### last snapshot from relstats_monitor.log ?column? | timestamp | relname | reltuples | n_dead_tup | av_count | aa_count | total_av_time | total_aa_time | n_tup_upd | n_tup_hot_upd | n_tup_ins | avg_av_time | avg_aa_time ----------+-------------------------------+------------------+-----------+------------+----------+----------+---------------+---------------+-----------+---------------+-----------+-------------+------------- TAB_DATA | 2025-11-13 17:44:12.059531+00 | table_batch_3 | 57988400 | 0 | 19 | 33 | 13527 | 7020 | 0 | 0 | 58400000 | 711.95 | 212.73 TAB_DATA | 2025-11-13 17:44:12.059531+00 | table_batch_2 | 51700100 | 0 | 20 | 33 | 10996 | 6705 | 0 | 0 | 52100000 | 549.80 | 203.18 TAB_DATA | 2025-11-13 17:44:12.059531+00 | table_batch_1 | 49688200 | 0 | 19 | 30 | 10917 | 6200 | 0 | 0 | 51400000 | 574.58 | 206.67 TAB_DATA | 2025-11-13 17:44:12.059531+00 | table_13_4096000 | 4096250 | 22439 | 2 | 5 | 19874 | 2003 | 1679450 | 0 | 4096000 | 9937.00 | 400.60 TAB_DATA | 2025-11-13 17:44:12.059531+00 | table_12_2048000 | 2048270 | 2506 | 4 | 8 | 19470 | 3000 | 1679833 | 0 | 2048000 | 4867.50 | 375.00 TAB_DATA | 2025-11-13 17:44:12.059531+00 | table_11_1024000 | 1023880 | 211596 | 7 | 16 | 16461 | 6228 | 1680559 | 0 | 1024000 | 2351.57 | 389.25 TAB_DATA | 2025-11-13 17:44:12.059531+00 | table_10_512000 | 512056 | 23575 | 15 | 30 | 15374 | 10561 | 1678857 | 0 | 512000 | 1024.93 | 352.03 TAB_DATA | 2025-11-13 17:44:12.059531+00 | table_9_256000 | 256011 | 42427 | 29 | 60 | 12449 | 18585 | 1679952 | 0 | 256000 | 429.28 | 309.75 TAB_DATA | 2025-11-13 17:44:12.059531+00 | table_8_128000 | 127992 | 11739 | 59 | 90 | 9886 | 23726 | 1679409 | 0 | 128000 | 167.56 | 263.62 TAB_DATA | 2025-11-13 17:44:12.059531+00 | table_7_64000 | 63998 | 15171 | 89 | 179 | 6187 | 39566 | 1678400 | 0 | 64000 | 69.52 | 221.04 TAB_DATA | 2025-11-13 17:44:12.059531+00 | table_6_32000 | 31998 | 5787 | 178 | 179 | 5864 | 34461 | 1681245 | 0 | 32000 | 32.94 | 192.52 TAB_DATA | 2025-11-13 17:44:12.059531+00 | table_5_16000 | 16000 | 6769 | 179 | 179 | 3242 | 16482 | 1677977 | 0 | 16000 | 18.11 | 92.08 TAB_DATA | 2025-11-13 17:44:12.059531+00 | table_4_8000 | 8000 | 6811 | 179 | 179 | 1861 | 7405 | 1678555 | 0 | 8000 | 10.40 | 41.37 TAB_DATA | 2025-11-13 17:44:12.059531+00 | table_3_4000 | 4000 | 7058 | 179 | 179 | 1145 | 3325 | 1679597 | 0 | 4000 | 6.40 | 18.58 TAB_DATA | 2025-11-13 17:44:12.059531+00 | table_16_4000 | 4000 | 6786 | 179 | 179 | 1131 | 3320 | 1678696 | 0 | 4000 | 6.32 | 18.55 TAB_DATA | 2025-11-13 17:44:12.059531+00 | table_15_2000 | 2000 | 6783 | 179 | 179 | 797 | 1598 | 1681553 | 0 | 2000 | 4.45 | 8.93 TAB_DATA | 2025-11-13 17:44:12.059531+00 | table_2_2000 | 2000 | 6936 | 179 | 179 | 820 | 1591 | 1681475 | 0 | 2000 | 4.58 | 8.89 TAB_DATA | 2025-11-13 17:44:12.059531+00 | table_1_1000 | 1000 | 6798 | 179 | 179 | 655 | 985 | 1679926 | 1 | 1000 | 3.66 | 5.50 TAB_DATA | 2025-11-13 17:44:12.059531+00 | table_14_1000 | 1000 | 6700 | 179 | 179 | 655 | 985 | 1681056 | 0 | 1000 | 3.66 | 5.50 (19 rows)