Рекомендации по освобождению пространства ecss_storekeeper_db
Функция автоочистки Аutovacuum - это фоновый механизм, который автоматически выполняет команды VACUUM и ANALYZE для обслуживания базы данных.
Autovacuum помечает место как свободное для повторного использования, но не возвращать его операционной системе. Аutovacuum не выполняет VACUUM FULL.
Планируйте VACUUM FULL на время минимальной нагрузки на базу данных.
VACUUM FULL обновляет статистику для планировщика запросов, и Аutovacuum делает это автоматически. В отличие от VACUUM FULL, команда ANALYZE (с флагом VERBOSE или без) не блокирует таблицы.
Команда ANALYZE VERBOSE собирает статистику по таблицам и выводит на экран подробные сообщения о ходе работы, включая имена обрабатываемых таблиц, число проанализированных строк и собранные статистические данные, флаг VERBOSE показывает сколько «активных» и «неактивных» строк насчитал планировщик, что помогает понять, насколько актуальна статистика и правильно ли он оценивает размер таблицы.
Ниже показаны примеры вывода команд.
выполнить на обоих нодах
psql ecss_storekeeper_db -U postgres -h localhost -p 5439 -c "VACUUM (FULL, VERBOSE);"
psql ecss_storekeeper_db -U postgres -h localhost -p 5439 -c "ANALYZE VERBOSE;"
(Password for user postgres: postgres1)
ecss_storekeeper_db=# VACUUM (FULL, VERBOSE); INFO: vacuuming "pg_catalog.pg_statistic" INFO: "pg_statistic": found 0 removable, 785 nonremovable row versions in 355 pages DETAIL: 0 dead row versions cannot be removed yet. CPU 0.00s/0.00u sec elapsed 0.01 sec. INFO: vacuuming "pg_catalog.pg_type" INFO: "pg_type": found 0 removable, 700 nonremovable row versions in 23 pages DETAIL: 3 dead row versions cannot be removed yet. CPU 0.00s/0.00u sec elapsed 0.00 sec. INFO: vacuuming "pg_catalog.pg_authid" INFO: "pg_authid": found 0 removable, 2 nonremovable row versions in 1 pages DETAIL: 0 dead row versions cannot be removed yet. CPU 0.00s/0.00u sec elapsed 0.00 sec. INFO: vacuuming "pg_catalog.pg_user_mapping" INFO: "pg_user_mapping": found 0 removable, 0 nonremovable row versions in 0 pages DETAIL: 0 dead row versions cannot be removed yet. CPU 0.00s/0.00u sec elapsed 0.00 sec. INFO: vacuuming "pg_catalog.pg_attribute" INFO: "pg_attribute": found 9 removable, 6399 nonremovable row versions in 135 pages DETAIL: 108 dead row versions cannot be removed yet. CPU 0.00s/0.00u sec elapsed 0.01 sec. INFO: vacuuming "pg_catalog.pg_proc" INFO: "pg_proc": found 1 removable, 2998 nonremovable row versions in 81 pages DETAIL: 0 dead row versions cannot be removed yet. CPU 0.00s/0.00u sec elapsed 0.01 sec. INFO: vacuuming "pg_catalog.pg_attrdef" INFO: "pg_attrdef": found 0 removable, 82 nonremovable row versions in 14 pages DETAIL: 0 dead row versions cannot be removed yet. CPU 0.00s/0.00u sec elapsed 0.00 sec. INFO: vacuuming "pg_catalog.pg_constraint" INFO: "pg_constraint": found 0 removable, 106 nonremovable row versions in 8 pages DETAIL: 0 dead row versions cannot be removed yet. CPU 0.00s/0.00u sec elapsed 0.00 sec. INFO: vacuuming "pg_catalog.pg_index" INFO: "pg_index": found 0 removable, 528 nonremovable row versions in 18 pages DETAIL: 4 dead row versions cannot be removed yet. CPU 0.00s/0.00u sec elapsed 0.00 sec.
ecss_storekeeper_db=# ANALYZE VERBOSE; INFO: analyzing "pg_catalog.pg_type" INFO: "pg_type": scanned 23 of 23 pages, containing 695 live rows and 19 dead rows; 695 rows in sample, 695 estimated total rows INFO: analyzing "pg_catalog.pg_authid" INFO: "pg_authid": scanned 1 of 1 pages, containing 2 live rows and 0 dead rows; 2 rows in sample, 2 estimated total rows INFO: analyzing "pg_catalog.pg_user_mapping" INFO: "pg_user_mapping": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows INFO: analyzing "pg_catalog.pg_attribute" INFO: "pg_attribute": scanned 132 of 132 pages, containing 6264 live rows and 193 dead rows; 6264 rows in sample, 6264 estimated total rows INFO: analyzing "pg_catalog.pg_proc" INFO: "pg_proc": scanned 81 of 81 pages, containing 2998 live rows and 13 dead rows; 2998 rows in sample, 2998 estimated total rows INFO: analyzing "pg_catalog.pg_attrdef" INFO: "pg_attrdef": scanned 14 of 14 pages, containing 82 live rows and 0 dead rows; 82 rows in sample, 82 estimated total rows INFO: analyzing "pg_catalog.pg_constraint" INFO: "pg_constraint": scanned 8 of 8 pages, containing 106 live rows and 6 dead rows; 106 rows in sample, 106 estimated total rows INFO: analyzing "pg_catalog.pg_index" INFO: "pg_index": scanned 18 of 18 pages, containing 524 live rows and 11 dead rows; 524 rows in sample, 524 estimated total rows INFO: analyzing "pg_catalog.pg_operator" INFO: "pg_operator": scanned 16 of 16 pages, containing 826 live rows and 25 dead rows; 826 rows in sample, 826 estimated total rows INFO: analyzing "pg_catalog.pg_opfamily" INFO: "pg_opfamily": scanned 2 of 2 pages, containing 111 live rows and 0 dead rows; 111 rows in sample, 111 estimated total rows INFO: analyzing "pg_catalog.pg_opclass" INFO: "pg_opclass": scanned 3 of 3 pages, containing 153 live rows and 0 dead rows; 153 rows in sample, 153 estimated total rows INFO: analyzing "pg_catalog.pg_am" INFO: "pg_am": scanned 1 of 1 pages, containing 5 live rows and 0 dead rows; 5 rows in sample, 5 estimated total rows INFO: analyzing "pg_catalog.pg_amop" INFO: "pg_amop": scanned 6 of 6 pages, containing 606 live rows and 0 dead rows; 606 rows in sample, 606 estimated total rows INFO: analyzing "pg_catalog.pg_amproc" INFO: "pg_amproc": scanned 4 of 4 pages, containing 525 live rows and 0 dead rows; 525 rows in sample, 525 estimated total rows INFO: analyzing "pg_catalog.pg_language" INFO: "pg_language": scanned 1 of 1 pages, containing 4 live rows and 0 dead rows; 4 rows in sample, 4 estimated total rows INFO: analyzing "pg_catalog.pg_largeobject_metadata" INFO: "pg_largeobject_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows INFO: analyzing "pg_catalog.pg_aggregate" INFO: "pg_aggregate": scanned 2 of 2 pages, containing 133 live rows and 0 dead rows; 133 rows in sample, 133 estimated total rows INFO: analyzing "pg_catalog.pg_rewrite" INFO: "pg_rewrite": scanned 12 of 12 pages, containing 118 live rows and 2 dead rows; 118 rows in sample, 118 estimated total rows INFO: analyzing "pg_catalog.pg_trigger" INFO: "pg_trigger": scanned 8 of 8 pages, containing 131 live rows and 0 dead rows; 131 rows in sample, 131 estimated total rows INFO: analyzing "pg_catalog.pg_event_trigger" INFO: "pg_event_trigger": scanned 1 of 1 pages, containing 3 live rows and 1 dead rows; 3 rows in sample, 3 estimated total rows INFO: analyzing "pg_catalog.pg_description" INFO: "pg_description": scanned 33 of 33 pages, containing 3771 live rows and 2 dead rows; 3771 rows in sample, 3771 estimated total rows INFO: analyzing "pg_catalog.pg_cast" INFO: "pg_cast": scanned 2 of 2 pages, containing 198 live rows and 0 dead rows; 198 rows in sample, 198 estimated total rows INFO: analyzing "pg_catalog.pg_enum" INFO: "pg_enum": scanned 1 of 1 pages, containing 18 live rows and 7 dead rows; 18 rows in sample, 18 estimated total rows INFO: analyzing "pg_catalog.pg_namespace" INFO: "pg_namespace": scanned 1 of 1 pages, containing 10 live rows and 2 dead rows; 10 rows in sample, 10 estimated total rows INFO: analyzing "pg_catalog.pg_database" INFO: "pg_database": scanned 1 of 1 pages, containing 7 live rows and 0 dead rows; 7 rows in sample, 7 estimated total rows INFO: analyzing "public.statistics_realtime_statistics_1" INFO: "statistics_realtime_statistics_1": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows INFO: analyzing "pg_catalog.pg_depend" INFO: "pg_depend": scanned 84 of 84 pages, containing 10225 live rows and 286 dead rows; 10225 rows in sample, 10225 estimated total rows INFO: analyzing "pg_catalog.pg_tablespace" INFO: "pg_tablespace": scanned 1 of 1 pages, containing 2 live rows and 0 dead rows; 2 rows in sample, 2 estimated total rows INFO: analyzing "pg_catalog.pg_pltemplate" INFO: "pg_pltemplate": scanned 1 of 1 pages, containing 8 live rows and 0 dead rows; 8 rows in sample, 8 estimated total rows INFO: analyzing "pg_catalog.pg_auth_members" INFO: "pg_auth_members": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows INFO: analyzing "pg_catalog.pg_seqam" INFO: "pg_seqam": scanned 1 of 1 pages, containing 2 live rows and 0 dead rows; 2 rows in sample, 2 estimated total rows INFO: analyzing "pg_catalog.pg_shdepend" INFO: "pg_shdepend": scanned 1 of 1 pages, containing 6 live rows and 0 dead rows; 6 rows in sample, 6 estimated total rows INFO: analyzing "pg_catalog.pg_shdescription" INFO: "pg_shdescription": scanned 1 of 1 pages, containing 3 live rows and 0 dead rows; 3 rows in sample, 3 estimated total rows INFO: analyzing "pg_catalog.pg_ts_config" INFO: "pg_ts_config": scanned 1 of 1 pages, containing 16 live rows and 0 dead rows; 16 rows in sample, 16 estimated total rows INFO: analyzing "pg_catalog.pg_ts_config_map" INFO: "pg_ts_config_map": scanned 2 of 2 pages, containing 304 live rows and 0 dead rows; 304 rows in sample, 304 estimated total rows INFO: analyzing "pg_catalog.pg_ts_dict" INFO: "pg_ts_dict": scanned 1 of 1 pages, containing 16 live rows and 0 dead rows; 16 rows in sample, 16 estimated total rows INFO: analyzing "pg_catalog.pg_ts_parser" INFO: "pg_ts_parser": scanned 1 of 1 pages, containing 1 live rows and 0 dead rows; 1 rows in sample, 1 estimated total rows INFO: analyzing "pg_catalog.pg_ts_template" INFO: "pg_ts_template": scanned 1 of 1 pages, containing 5 live rows and 0 dead rows; 5 rows in sample, 5 estimated total rows INFO: analyzing "pg_catalog.pg_extension" INFO: "pg_extension": scanned 1 of 1 pages, containing 6 live rows and 11 dead rows; 6 rows in sample, 6 estimated total rows INFO: analyzing "pg_catalog.pg_foreign_data_wrapper" INFO: "pg_foreign_data_wrapper": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows INFO: analyzing "pg_catalog.pg_foreign_server" INFO: "pg_foreign_server": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows INFO: analyzing "pg_catalog.pg_foreign_table" INFO: "pg_foreign_table": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows INFO: analyzing "pg_catalog.pg_replication_identifier" INFO: "pg_replication_identifier": scanned 1 of 1 pages, containing 1 live rows and 0 dead rows; 1 rows in sample, 1 estimated total rows INFO: analyzing "pg_catalog.pg_default_acl" INFO: "pg_default_acl": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows INFO: analyzing "pg_catalog.pg_seclabel" INFO: "pg_seclabel": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows INFO: analyzing "pg_catalog.pg_shseclabel" INFO: "pg_shseclabel": scanned 1 of 1 pages, containing 1 live rows and 0 dead rows; 1 rows in sample, 1 estimated total rows INFO: analyzing "pg_catalog.pg_collation" INFO: "pg_collation": scanned 1 of 1 pages, containing 7 live rows and 0 dead rows; 7 rows in sample, 7 estimated total rows INFO: analyzing "pg_catalog.pg_range" INFO: "pg_range": scanned 1 of 1 pages, containing 6 live rows and 0 dead rows; 6 rows in sample, 6 estimated total rows INFO: analyzing "information_schema.sql_features" INFO: "sql_features": scanned 7 of 7 pages, containing 672 live rows and 0 dead rows; 672 rows in sample, 672 estimated total rows INFO: analyzing "information_schema.sql_implementation_info" INFO: "sql_implementation_info": scanned 1 of 1 pages, containing 12 live rows and 0 dead rows; 12 rows in sample, 12 estimated total rows INFO: analyzing "bdr.bdr_sequence_elections" INFO: "bdr_sequence_elections": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows INFO: analyzing "information_schema.sql_packages" INFO: "sql_packages": scanned 1 of 1 pages, containing 10 live rows and 0 dead rows; 10 rows in sample, 10 estimated total rows INFO: analyzing "information_schema.sql_parts" INFO: "sql_parts": scanned 1 of 1 pages, containing 9 live rows and 0 dead rows; 9 rows in sample, 9 estimated total rows INFO: analyzing "information_schema.sql_sizing" INFO: "sql_sizing": scanned 1 of 1 pages, containing 23 live rows and 0 dead rows; 23 rows in sample, 23 estimated total rows INFO: analyzing "information_schema.sql_sizing_profiles" INFO: "sql_sizing_profiles": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows INFO: analyzing "bdr.bdr_sequence_values" INFO: "bdr_sequence_values": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows INFO: analyzing "pg_catalog.pg_class" INFO: "pg_class": scanned 27 of 27 pages, containing 943 live rows and 29 dead rows; 943 rows in sample, 943 estimated total rows INFO: analyzing "pg_catalog.pg_inherits" INFO: "pg_inherits": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows INFO: analyzing "pg_catalog.pg_conversion" INFO: "pg_conversion": scanned 3 of 3 pages, containing 132 live rows and 0 dead rows; 132 rows in sample, 132 estimated total rows INFO: analyzing "pg_catalog.pg_db_role_setting" INFO: "pg_db_role_setting": scanned 1 of 1 pages, containing 1 live rows and 0 dead rows; 1 rows in sample, 1 estimated total rows INFO: analyzing "pg_catalog.pg_largeobject" INFO: "pg_largeobject": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows INFO: analyzing "information_schema.sql_languages" INFO: "sql_languages": scanned 1 of 1 pages, containing 4 live rows and 0 dead rows; 4 rows in sample, 4 estimated total rows INFO: analyzing "public.statistics_realtime_statistics_2" INFO: "statistics_realtime_statistics_2": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows INFO: analyzing "bdr.bdr_global_locks" INFO: "bdr_global_locks": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows INFO: analyzing "bdr.bdr_queued_drops" INFO: "bdr_queued_drops": scanned 1 of 1 pages, containing 3 live rows and 0 dead rows; 3 rows in sample, 3 estimated total rows INFO: analyzing "bdr.bdr_replication_set_config" INFO: "bdr_replication_set_config": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows INFO: analyzing "public.statistics_historical_daily_statistics" INFO: "statistics_historical_daily_statistics": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows INFO: analyzing "bdr.bdr_votes" INFO: "bdr_votes": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows INFO: analyzing "public.statistics_realtime_statistics_3" INFO: "statistics_realtime_statistics_3": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows INFO: analyzing "bdr.bdr_connections" INFO: "bdr_connections": scanned 1 of 1 pages, containing 2 live rows and 0 dead rows; 2 rows in sample, 2 estimated total rows INFO: analyzing "bdr.bdr_conflict_handlers" INFO: "bdr_conflict_handlers": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows INFO: analyzing "public.statistics_realtime_statistics_template" INFO: "statistics_realtime_statistics_template": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows INFO: analyzing "bdr.bdr_queued_commands" INFO: "bdr_queued_commands": scanned 36 of 36 pages, containing 657 live rows and 0 dead rows; 657 rows in sample, 657 estimated total rows INFO: analyzing "bdr.bdr_nodes" INFO: "bdr_nodes": scanned 1 of 1 pages, containing 2 live rows and 2 dead rows; 2 rows in sample, 2 estimated total rows INFO: analyzing "bdr.bdr_conflict_history" INFO: "bdr_conflict_history": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows INFO: analyzing "public.schema_migrations" INFO: "schema_migrations": scanned 1 of 1 pages, containing 88 live rows and 0 dead rows; 88 rows in sample, 88 estimated total rows INFO: analyzing "public.tag_of_service" INFO: "tag_of_service": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows INFO: analyzing "public.bw_list" INFO: "bw_list": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows INFO: analyzing "public.statistics_realtime_statistics_4" INFO: "statistics_realtime_statistics_4": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows INFO: analyzing "public.numbers_plan" INFO: "numbers_plan": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows INFO: analyzing "public.system_numbers" INFO: "system_numbers": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows INFO: analyzing "public.marshrut_cadc" INFO: "marshrut_cadc": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows INFO: analyzing "public.statistics_realtime_statistics_7" INFO: "statistics_realtime_statistics_7": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows INFO: analyzing "public.marshrutisation_a" INFO: "marshrutisation_a": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows INFO: analyzing "public.statistics_realtime_statistics_5" INFO: "statistics_realtime_statistics_5": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows INFO: analyzing "public.statistics_realtime_statistics_8" INFO: "statistics_realtime_statistics_8": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows INFO: analyzing "public.statistics_realtime_statistics_11" INFO: "statistics_realtime_statistics_11": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows INFO: analyzing "public.marshrutisation_b" INFO: "marshrutisation_b": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows INFO: analyzing "public.address_book_source" INFO: "address_book_source": scanned 1 of 1 pages, containing 3 live rows and 2 dead rows; 3 rows in sample, 3 estimated total rows INFO: analyzing "public.audit_groups" INFO: "audit_groups": scanned 1 of 1 pages, containing 18 live rows and 3 dead rows; 18 rows in sample, 18 estimated total rows INFO: analyzing "public.calls_tree" INFO: "calls_tree": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows INFO: analyzing "public.statistics_realtime_statistics_6" INFO: "statistics_realtime_statistics_6": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows INFO: analyzing "public.address_book_email" INFO: "address_book_email": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows INFO: analyzing "public.address_book_external" INFO: "address_book_external": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows INFO: analyzing "public.calls_tolltickets" INFO: "calls_tolltickets": scanned 145 of 145 pages, containing 1306 live rows and 0 dead rows; 1306 rows in sample, 1306 estimated total rows INFO: analyzing "public.audit_users" INFO: "audit_users": scanned 1 of 1 pages, containing 4 live rows and 0 dead rows; 4 rows in sample, 4 estimated total rows INFO: analyzing "public.calls_ss" INFO: "calls_ss": scanned 67 of 67 pages, containing 503 live rows and 5 dead rows; 503 rows in sample, 503 estimated total rows INFO: analyzing "public.calls_cdr" INFO: "calls_cdr": scanned 205 of 205 pages, containing 1898 live rows and 296 dead rows; 1898 rows in sample, 1898 estimated total rows INFO: analyzing "public.audit_role_group" INFO: "audit_role_group": scanned 1 of 1 pages, containing 1 live rows and 0 dead rows; 1 rows in sample, 1 estimated total rows INFO: analyzing "public.statistics_realtime_statistics_9" INFO: "statistics_realtime_statistics_9": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows INFO: analyzing "public.calls_inodes" INFO: "calls_inodes": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows INFO: analyzing "public.calls_data" INFO: "calls_data": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows INFO: analyzing "public.calls_variables" INFO: "calls_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows INFO: analyzing "public.calls_counters" INFO: "calls_counters": scanned 1 of 1 pages, containing 2 live rows and 14 dead rows; 2 rows in sample, 2 estimated total rows INFO: analyzing "public.statistics_historical_hour_statistics" INFO: "statistics_historical_hour_statistics": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows INFO: analyzing "public.audit_users_settings2" INFO: "audit_users_settings2": scanned 6 of 6 pages, containing 7 live rows and 32 dead rows; 7 rows in sample, 7 estimated total rows INFO: analyzing "public.audit_restrictions" INFO: "audit_restrictions": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows INFO: analyzing "public.audit_groups_users" INFO: "audit_groups_users": scanned 1 of 1 pages, containing 16 live rows and 2 dead rows; 16 rows in sample, 16 estimated total rows INFO: analyzing "public.audit_roles" INFO: "audit_roles": scanned 1 of 1 pages, containing 3 live rows and 0 dead rows; 3 rows in sample, 3 estimated total rows INFO: analyzing "public.statistics_realtime_statistics" INFO: "statistics_realtime_statistics": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows INFO: analyzing "public.audit_sessions" INFO: "audit_sessions": scanned 633 of 633 pages, containing 18626 live rows and 2300 dead rows; 18626 rows in sample, 18626 estimated total rows INFO: analyzing "public.audit_roles_settings" INFO: "audit_roles_settings": scanned 1 of 1 pages, containing 9 live rows and 0 dead rows; 9 rows in sample, 9 estimated total rows INFO: analyzing "public.audit_commands" INFO: "audit_commands": scanned 30000 of 31532 pages, containing 1079407 live rows and 0 dead rows; 30000 rows in sample, 1133750 estimated total rows INFO: analyzing "public.statistics_realtime_statistics_0" INFO: "statistics_realtime_statistics_0": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows INFO: analyzing "public.statistics_realtime_statistics_10" INFO: "statistics_realtime_statistics_10": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows INFO: analyzing "public.statistics_historical_intrahour_statistics" INFO: "statistics_historical_intrahour_statistics": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows INFO: analyzing "public.statistics_historical_weekly_statistics" INFO: "statistics_historical_weekly_statistics": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows INFO: analyzing "public.statistics_historical_monthly_statistics" INFO: "statistics_historical_monthly_statistics": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows INFO: analyzing "public.subscribers_users" INFO: "subscribers_users": scanned 1 of 1 pages, containing 28 live rows and 36 dead rows; 28 rows in sample, 28 estimated total rows INFO: analyzing "public.system_versions" INFO: "system_versions": scanned 1 of 1 pages, containing 4 live rows and 0 dead rows; 4 rows in sample, 4 estimated total rows INFO: analyzing "public.address_book_changes" INFO: "address_book_changes": scanned 1 of 1 pages, containing 5 live rows and 24 dead rows; 5 rows in sample, 5 estimated total rows INFO: analyzing "public.address_book_label" INFO: "address_book_label": scanned 1 of 1 pages, containing 4 live rows and 0 dead rows; 4 rows in sample, 4 estimated total rows INFO: analyzing "public.dialer_campaigns" INFO: "dialer_campaigns": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows INFO: analyzing "public.address_book_phone" INFO: "address_book_phone": scanned 1 of 1 pages, containing 40 live rows and 20 dead rows; 40 rows in sample, 40 estimated total rows INFO: analyzing "public.statistics_week_votes" INFO: "statistics_week_votes": scanned 1 of 1 pages, containing 0 live rows and 20 dead rows; 0 rows in sample, 0 estimated total rows INFO: analyzing "public.history_members" INFO: "history_members": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows INFO: analyzing "public.address_book_contact" INFO: "address_book_contact": scanned 1 of 1 pages, containing 40 live rows and 47 dead rows; 40 rows in sample, 40 estimated total rows INFO: analyzing "public.statistics_five_votes" INFO: "statistics_five_votes": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows INFO: analyzing "public.statistics_hour_votes" INFO: "statistics_hour_votes": scanned 1 of 1 pages, containing 0 live rows and 30 dead rows; 0 rows in sample, 0 estimated total rows INFO: analyzing "public.statistics_day_votes" INFO: "statistics_day_votes": scanned 1 of 1 pages, containing 0 live rows and 20 dead rows; 0 rows in sample, 0 estimated total rows INFO: analyzing "public.statistics_month_votes" INFO: "statistics_month_votes": scanned 1 of 1 pages, containing 0 live rows and 4 dead rows; 0 rows in sample, 0 estimated total rows INFO: analyzing "public.meeting_expiration_period" INFO: "meeting_expiration_period": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows INFO: analyzing "public.meeting_event_history" INFO: "meeting_event_history": scanned 45 of 45 pages, containing 489 live rows and 0 dead rows; 489 rows in sample, 489 estimated total rows INFO: analyzing "public.meeting_history" INFO: "meeting_history": scanned 2 of 2 pages, containing 46 live rows and 46 dead rows; 46 rows in sample, 46 estimated total rows INFO: analyzing "public.dialer_campaign_calls" INFO: "dialer_campaign_calls": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows INFO: analyzing "public.subscribers_sessions" INFO: "subscribers_sessions": scanned 1 of 1 pages, containing 3 live rows and 9 dead rows; 3 rows in sample, 3 estimated total rows INFO: analyzing "public.key_value" INFO: "key_value": scanned 1 of 1 pages, containing 1 live rows and 0 dead rows; 1 rows in sample, 1 estimated total rows INFO: analyzing "public.sip_state" INFO: "sip_state": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows INFO: analyzing "public.history_meetings" INFO: "history_meetings": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows INFO: analyzing "public.trunk_manager_state" INFO: "trunk_manager_state": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows INFO: analyzing "public.call_state" INFO: "call_state": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows INFO: analyzing "public.megaco_ports" INFO: "megaco_ports": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows INFO: analyzing "public.calls_super_tree" INFO: "calls_super_tree": scanned 2811 of 2811 pages, containing 25864 live rows and 672 dead rows; 25864 rows in sample, 25864 estimated total rows ANALYZE