=============================================================================== [03:17:02] [8520] BEGIN Verarbeitung [03:17:02] [8520] ### executing VACUUM(FULL, ANALYZE, VERBOSE) rudderproperties; INFO: vacuuming "public.rudderproperties" INFO: "rudderproperties": found 0 removable, 1612 nonremovable row versions in 12 pages DETAIL: 1611 dead row versions cannot be removed yet. CPU 0.01s/0.00u sec elapsed 0.01 sec. INFO: analyzing "public.rudderproperties" INFO: "rudderproperties": scanned 12 of 12 pages, containing 1 live rows and 1611 dead rows; 1 rows in sample, 1 estimated total rows VACUUM [03:17:02] [8520] Returncode: 0 [03:17:02] [8520] ### executing VACUUM(FULL, ANALYZE, VERBOSE) statusupdate; INFO: vacuuming "public.statusupdate" INFO: "statusupdate": found 0 removable, 6603 nonremovable row versions in 49 pages DETAIL: 6602 dead row versions cannot be removed yet. CPU 0.00s/0.00u sec elapsed 0.01 sec. INFO: analyzing "public.statusupdate" INFO: "statusupdate": scanned 49 of 49 pages, containing 1 live rows and 6602 dead rows; 1 rows in sample, 1 estimated total rows VACUUM [03:17:02] [8520] Returncode: 0 [03:17:02] [8520] ### executing VACUUM(FULL, ANALYZE, VERBOSE) nodes_info; INFO: vacuuming "public.nodes_info" INFO: "nodes_info": found 0 removable, 5035 nonremovable row versions in 110 pages DETAIL: 4784 dead row versions cannot be removed yet. CPU 0.00s/0.01u sec elapsed 0.01 sec. INFO: analyzing "public.nodes_info" INFO: "nodes_info": scanned 111 of 111 pages, containing 251 live rows and 4784 dead rows; 251 rows in sample, 251 estimated total rows VACUUM [03:17:02] [8520] Returncode: 0 [03:17:02] [8520] ### executing VACUUM(FULL, ANALYZE, VERBOSE) archivednodeconfigurations; INFO: vacuuming "public.archivednodeconfigurations" INFO: "archivednodeconfigurations": 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: analyzing "public.archivednodeconfigurations" INFO: "archivednodeconfigurations": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows VACUUM [03:17:02] [8520] Returncode: 0 [03:17:02] [8520] ### executing VACUUM(FULL, ANALYZE, VERBOSE) nodeconfigurations; INFO: vacuuming "public.nodeconfigurations" INFO: "nodeconfigurations": found 0 removable, 732 nonremovable row versions in 12 pages DETAIL: 266 dead row versions cannot be removed yet. CPU 0.02s/0.02u sec elapsed 0.14 sec. INFO: analyzing "public.nodeconfigurations" INFO: "nodeconfigurations": scanned 12 of 12 pages, containing 466 live rows and 266 dead rows; 466 rows in sample, 466 estimated total rows VACUUM [03:17:02] [8520] Returncode: 0 [03:17:02] [8520] ### executing VACUUM(FULL, ANALYZE, VERBOSE) nodes; INFO: vacuuming "public.nodes" INFO: "nodes": found 0 removable, 2379128 nonremovable row versions in 33008 pages DETAIL: 8970 dead row versions cannot be removed yet. CPU 0.54s/0.94u sec elapsed 1.62 sec. INFO: analyzing "public.nodes" INFO: "nodes": scanned 30000 of 33007 pages, containing 2154234 live rows and 8188 dead rows; 30000 rows in sample, 2370977 estimated total rows VACUUM [03:17:19] [8520] Returncode: 0 [03:17:19] [8520] ### executing VACUUM(FULL, ANALYZE, VERBOSE) directives; INFO: vacuuming "public.directives" INFO: "directives": found 0 removable, 1048126 nonremovable row versions in 36440 pages DETAIL: 3404 dead row versions cannot be removed yet. CPU 0.60s/0.71u sec elapsed 1.58 sec. INFO: analyzing "public.directives" INFO: "directives": scanned 30000 of 36441 pages, containing 860204 live rows and 2794 dead rows; 30000 rows in sample, 1045462 estimated total rows VACUUM [03:17:25] [8520] Returncode: 0 [03:17:25] [8520] ### executing VACUUM(FULL, ANALYZE, VERBOSE) archivednodecompliance; INFO: vacuuming "public.archivednodecompliance" INFO: "archivednodecompliance": found 0 removable, 59960 nonremovable row versions in 2396 pages DETAIL: 40008 dead row versions cannot be removed yet. CPU 2.68s/3.69u sec elapsed 6.85 sec. INFO: analyzing "public.archivednodecompliance" INFO: "archivednodecompliance": scanned 2396 of 2396 pages, containing 19952 live rows and 40008 dead rows; 19952 rows in sample, 19952 estimated total rows VACUUM [03:17:33] [8520] Returncode: 0 [03:17:33] [8520] ### executing VACUUM(FULL, ANALYZE, VERBOSE) nodecompliance; INFO: vacuuming "public.nodecompliance" INFO: "nodecompliance": found 0 removable, 55987 nonremovable row versions in 2231 pages DETAIL: 39981 dead row versions cannot be removed yet. CPU 2.48s/3.31u sec elapsed 7.18 sec. INFO: analyzing "public.nodecompliance" INFO: "nodecompliance": scanned 2227 of 2227 pages, containing 16006 live rows and 39981 dead rows; 16006 rows in sample, 16006 estimated total rows VACUUM [03:17:40] [8520] Returncode: 0 [03:17:40] [8520] ### executing VACUUM(FULL, ANALYZE, VERBOSE) reportsexecution; INFO: vacuuming "public.reportsexecution" INFO: "reportsexecution": found 0 removable, 120361 nonremovable row versions in 1656 pages DETAIL: 59739 dead row versions cannot be removed yet. CPU 0.03s/0.06u sec elapsed 0.14 sec. INFO: analyzing "public.reportsexecution" INFO: "reportsexecution": scanned 1658 of 1658 pages, containing 60622 live rows and 59739 dead rows; 30000 rows in sample, 60622 estimated total rows VACUUM [03:17:41] [8520] Returncode: 0 [03:17:41] [8520] ### executing VACUUM(FULL, ANALYZE, VERBOSE) nodecompliancelevels; INFO: vacuuming "public.nodecompliancelevels" INFO: "nodecompliancelevels": found 0 removable, 3768972 nonremovable row versions in 98579 pages DETAIL: 1984697 dead row versions cannot be removed yet. CPU 1.27s/2.24u sec elapsed 5.18 sec. INFO: analyzing "public.nodecompliancelevels" INFO: "nodecompliancelevels": scanned 30000 of 98571 pages, containing 539158 live rows and 607844 dead rows; 30000 rows in sample, 3161047 estimated total rows VACUUM [03:18:49] [8520] Returncode: 0 [03:18:49] [8520] ### executing VACUUM(FULL, ANALYZE, VERBOSE) archivedruddersysevents; INFO: vacuuming "public.archivedruddersysevents" INFO: "archivedruddersysevents": found 0 removable, 18095297 nonremovable row versions in 649437 pages DETAIL: 12065825 dead row versions cannot be removed yet. CPU 8.11s/11.79u sec elapsed 34.59 sec. INFO: analyzing "public.archivedruddersysevents" INFO: "archivedruddersysevents": scanned 30000 of 649437 pages, containing 277302 live rows and 558662 dead rows; 30000 rows in sample, 17536706 estimated total rows VACUUM [03:20:41] [8520] Returncode: 0 [03:20:41] [8520] ### executing VACUUM(FULL, ANALYZE, VERBOSE) ruddersysevents; INFO: vacuuming "public.ruddersysevents" INFO: "ruddersysevents": found 0 removable, 24224344 nonremovable row versions in 892559 pages DETAIL: 12066705 dead row versions cannot be removed yet. CPU 10.91s/15.62u sec elapsed 47.07 sec. INFO: analyzing "public.ruddersysevents" INFO: "ruddersysevents": scanned 30000 of 892559 pages, containing 404886 live rows and 409645 dead rows; 30000 rows in sample, 23815020 estimated total rows VACUUM [03:33:21] [8520] Returncode: 0 [03:33:21] [8520] ### executing REINDEX DATABASE rudder; NOTICE: table "pg_catalog.pg_class" was reindexed NOTICE: table "pg_catalog.pg_enum" was reindexed NOTICE: table "pg_catalog.pg_constraint" was reindexed NOTICE: table "pg_catalog.pg_range" was reindexed NOTICE: table "pg_catalog.pg_largeobject" was reindexed NOTICE: table "pg_catalog.pg_type" was reindexed NOTICE: table "information_schema.sql_sizing" was reindexed NOTICE: table "information_schema.sql_sizing_profiles" was reindexed NOTICE: table "pg_catalog.pg_attrdef" was reindexed NOTICE: table "pg_catalog.pg_index" was reindexed NOTICE: table "pg_catalog.pg_cast" was reindexed NOTICE: table "pg_catalog.pg_foreign_table" was reindexed NOTICE: table "information_schema.sql_features" was reindexed NOTICE: table "public.rulesdirectivesjoin" was reindexed NOTICE: table "pg_catalog.pg_proc" was reindexed NOTICE: table "public.eventlog" was reindexed NOTICE: table "pg_catalog.pg_operator" was reindexed NOTICE: table "pg_catalog.pg_tablespace" was reindexed NOTICE: table "pg_catalog.pg_ts_parser" was reindexed NOTICE: table "information_schema.sql_languages" was reindexed NOTICE: table "pg_catalog.pg_attribute" was reindexed NOTICE: table "information_schema.sql_implementation_info" was reindexed NOTICE: table "pg_catalog.pg_statistic" was reindexed NOTICE: table "public.migrationeventlog" was reindexed NOTICE: table "public.gitcommit" was reindexed NOTICE: table "public.groups" was reindexed NOTICE: table "public.rules" was reindexed NOTICE: table "public.changerequest" was reindexed NOTICE: table "public.workflow" was reindexed NOTICE: table "public.groupsnodesjoin" was reindexed NOTICE: table "public.rulesgroupjoin" was reindexed NOTICE: table "pg_catalog.pg_authid" was reindexed NOTICE: table "information_schema.sql_packages" was reindexed NOTICE: table "pg_catalog.pg_inherits" was reindexed NOTICE: table "pg_catalog.pg_amop" was reindexed NOTICE: table "pg_catalog.pg_conversion" was reindexed NOTICE: table "pg_catalog.pg_user_mapping" was reindexed NOTICE: table "pg_catalog.pg_auth_members" was reindexed NOTICE: table "pg_catalog.pg_description" was reindexed NOTICE: table "pg_catalog.pg_depend" was reindexed NOTICE: table "pg_catalog.pg_namespace" was reindexed NOTICE: table "pg_catalog.pg_db_role_setting" was reindexed NOTICE: table "pg_catalog.pg_opclass" was reindexed NOTICE: table "pg_catalog.pg_opfamily" was reindexed NOTICE: table "pg_catalog.pg_ts_dict" was reindexed NOTICE: table "pg_catalog.pg_language" was reindexed NOTICE: table "pg_catalog.pg_largeobject_metadata" was reindexed NOTICE: table "pg_catalog.pg_aggregate" was reindexed NOTICE: table "pg_catalog.pg_extension" was reindexed NOTICE: table "information_schema.sql_parts" was reindexed NOTICE: table "pg_catalog.pg_collation" was reindexed NOTICE: table "public.globalschedule" was reindexed NOTICE: table "pg_catalog.pg_am" was reindexed NOTICE: table "pg_catalog.pg_amproc" was reindexed NOTICE: table "pg_catalog.pg_rewrite" was reindexed NOTICE: table "pg_catalog.pg_trigger" was reindexed NOTICE: table "pg_catalog.pg_database" was reindexed NOTICE: table "pg_catalog.pg_pltemplate" was reindexed NOTICE: table "pg_catalog.pg_shdepend" was reindexed NOTICE: table "pg_catalog.pg_shdescription" was reindexed NOTICE: table "pg_catalog.pg_ts_config" was reindexed NOTICE: table "pg_catalog.pg_ts_config_map" was reindexed NOTICE: table "pg_catalog.pg_ts_template" was reindexed NOTICE: table "pg_catalog.pg_foreign_data_wrapper" was reindexed NOTICE: table "pg_catalog.pg_foreign_server" was reindexed NOTICE: table "pg_catalog.pg_default_acl" was reindexed NOTICE: table "pg_catalog.pg_seclabel" was reindexed NOTICE: table "pg_catalog.pg_shseclabel" was reindexed NOTICE: table "public.archivedruddersysevents" was reindexed NOTICE: table "public.reportsexecution" was reindexed NOTICE: table "public.nodecompliancelevels" was reindexed NOTICE: table "public.nodeconfigurations" was reindexed NOTICE: table "public.nodes" was reindexed NOTICE: table "public.directives" was reindexed NOTICE: table "public.archivednodecompliance" was reindexed NOTICE: table "public.statusupdate" was reindexed NOTICE: table "public.archivednodeconfigurations" was reindexed NOTICE: table "public.nodes_info" was reindexed NOTICE: table "public.ruddersysevents" was reindexed NOTICE: table "public.nodecompliance" was reindexed NOTICE: table "public.rudderproperties" was reindexed REINDEX [03:47:19] [8520] Returncode: 0 [03:47:19] [8520] END Verarbeitung ===============================================================================