BUG #18573: Analyze command consumes several GB of memory - more than analyzed table size

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: zeleny(dot)ales(at)gmail(dot)com
Subject: BUG #18573: Analyze command consumes several GB of memory - more than analyzed table size
Date: 2024-08-06 23:22:22
Message-ID: 18573-4bd97c0c25e99339@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 18573
Logged by: Aleš Zelený
Email address: zeleny(dot)ales(at)gmail(dot)com
PostgreSQL version: 15.5
Operating system: AlmaLinux release 9.3 (Shamrock Pampas Cat)
Description:

Autovacuum frequently fails with out of memory error, like:

[autovacuum worker], [0], ERROR: out of memory

OS information:
[UAT][postgres(at)pgsql-powa-1 log]$ free -h
total used free shared buff/cache
available
Mem: 15Gi 3.8Gi 6.1Gi 3.1Gi 8.7Gi
11Gi
Swap: 0B 0B 0B

[UAT][postgres(at)pgsql-powa-1 log]$ uname -a
Linux pgsql-powa-1 5.14.0-362.13.1.el9_3.x86_64 #1 SMP PREEMPT_DYNAMIC Thu
Dec 21 07:12:43 EST 2023 x86_64 x86_64 x86_64 GNU/Linux

[UAT][postgres(at)pgsql-powa-1 log]$ sysctl -q vm.nr_hugepages
vm.nr_hugepages = 0
[UAT][postgres(at)pgsql-powa-1 log]$ sysctl -q vm.overcommit_memory
vm.overcommit_memory = 2

PostgreSQL instance:
postgres=# select version();
version

----------------------------------------------------------------------------------------------------------
PostgreSQL 15.5 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 11.4.1
20230605 (Red Hat 11.4.1-2), 64-bit
(1 row)

powa=# show shared_buffers;
shared_buffers
----------------
7680MB
(1 row)

postgres=# show work_mem;
work_mem
----------
4MB
(1 row)

postgres=# show temp_buffers;
temp_buffers
--------------
16MB
(1 row)

postgres=# show maintenance_work_mem;
maintenance_work_mem
----------------------
256MB
(1 row)

postgres=# show max_parallel_maintenance_workers;
max_parallel_maintenance_workers
----------------------------------
0
(1 row)

The server is a dedicated POWA (https://powa.readthedocs.io/) server, DB
instance for POWA database, powa-web, powa-collector runs there. The issue
is reproducible even with all the components stopped (except the PG
instance).

During the test, I found a reproducible test case to demonstrate how much
memory was used by the analyze command.

Failures are frequent on table public.powa_statements_history.

During subsequent tests, I created a copy of this table and the problem is
reproducible there.
Finally, a single-column table is sufficient for reproducing the memory
usage issue by analyze command.

Test case table information:

powa=# \dt+ public.testcase_t3
List of relations
Schema | Name | Type | Owner | Persistence | Access method |
Size | Description
--------+-------------+-------+----------+-------------+---------------+---------+-------------
public | testcase_t3 | table | postgres | permanent | heap |
1681 MB |
(1 row)

powa=# \d public.testcase_t3
Table "public.testcase_t3"
Column | Type | Collation | Nullable | Default

---------+----------------------------------+-----------+----------+---------
records | powa_statements_history_record[] | | |

powa=# \d public.powa_statements_history_record
Composite type "public.powa_statements_history_record"
Column | Type | Collation | Nullable |
Default
---------------------+--------------------------+-----------+----------+---------
ts | timestamp with time zone | | |
calls | bigint | | |
total_exec_time | double precision | | |
rows | bigint | | |
shared_blks_hit | bigint | | |
shared_blks_read | bigint | | |
shared_blks_dirtied | bigint | | |
shared_blks_written | bigint | | |
local_blks_hit | bigint | | |
local_blks_read | bigint | | |
local_blks_dirtied | bigint | | |
local_blks_written | bigint | | |
temp_blks_read | bigint | | |
temp_blks_written | bigint | | |
blk_read_time | double precision | | |
blk_write_time | double precision | | |
plans | bigint | | |
total_plan_time | double precision | | |
wal_records | bigint | | |
wal_fpi | bigint | | |
wal_bytes | numeric | | |

WITH q1 AS (
SELECT
cardinality(records)
, ntile(10) OVER (ORDER BY cardinality(records))
FROM public.testcase_t3
)
SELECT
ntile
, count(*)
, min(cardinality)
, round(avg(cardinality)) AS avg
, max(cardinality)
FROM q1
GROUP BY ntile
ORDER BY ntile;

ntile | count | min | avg | max
-------+--------+-----+-----+-----
1 | 221080 | 1 | 1 | 1
2 | 221080 | 1 | 2 | 5
3 | 221080 | 5 | 15 | 25
4 | 221080 | 25 | 29 | 31
5 | 221080 | 31 | 49 | 87
6 | 221079 | 87 | 97 | 100
7 | 221079 | 100 | 100 | 100
8 | 221079 | 100 | 100 | 100
9 | 221079 | 100 | 101 | 102
10 | 221079 | 102 | 126 | 410
(10 rows)

For memory allocation tracking another session was used to execute
pg_log_backend_memory_contexts() every 2 seconds. A summary was extracted
from the logs.

Grand total: 4368292528 bytes (peak) seems to be a lot of memory compared to
table size 1681 MB.

Memory allocation over time:

[UAT][postgres(at)pgsql-powa-1 log]$ grep 66b2a2e8.13b46 postgresql.log >
analyze_mem_info_t3.log
[UAT][postgres(at)pgsql-powa-1 log]$ grep -e TopMemoryContext -e
CacheMemoryContext -e Analyze -e "Grand total" analyze_mem_info_t3.log | awk
-F, '{print $1, $14, $15}'
2024-08-07 00:26:51.682 CEST [idle] LOG: level: 0; TopMemoryContext:
103312 total in 5 blocks; 6104 free (16 chunks); 97208 used
2024-08-07 00:26:51.682 CEST [idle] LOG: level: 1; CacheMemoryContext:
524288 total in 7 blocks; 109688 free (0 chunks); 414600 used
2024-08-07 00:26:51.684 CEST [idle] LOG: Grand total: 1156768 bytes in
184 blocks; 286392 free (135 chunks); 870376 used
2024-08-07 00:27:24.365 CEST [idle] LOG: level: 0; TopMemoryContext:
103312 total in 5 blocks; 6104 free (25 chunks); 97208 used
2024-08-07 00:27:24.366 CEST [idle] LOG: level: 1; CacheMemoryContext:
524288 total in 7 blocks; 26312 free (0 chunks); 497976 used
2024-08-07 00:27:24.367 CEST [idle] LOG: Grand total: 1258968 bytes in
205 blocks; 241224 free (173 chunks); 1017744 used
2024-08-07 00:27:26.365 CEST [idle] LOG: level: 0; TopMemoryContext:
103312 total in 5 blocks; 6104 free (25 chunks); 97208 used
2024-08-07 00:27:26.366 CEST [idle] LOG: level: 1; CacheMemoryContext:
524288 total in 7 blocks; 26312 free (0 chunks); 497976 used
2024-08-07 00:27:26.367 CEST [idle] LOG: Grand total: 1258968 bytes in
205 blocks; 241224 free (173 chunks); 1017744 used
2024-08-07 00:27:28.365 CEST [ANALYZE] LOG: level: 0; TopMemoryContext:
103312 total in 5 blocks; 3160 free (17 chunks); 100152 used
2024-08-07 00:27:28.366 CEST [ANALYZE] LOG: level: 3; Analyze: 584814008
total in 80 blocks; 3135952 free (108 chunks); 581678056 used
2024-08-07 00:27:28.366 CEST [ANALYZE] LOG: level: 1; CacheMemoryContext:
1048576 total in 8 blocks; 502976 free (2 chunks); 545600 used
2024-08-07 00:27:28.366 CEST [ANALYZE] LOG: Grand total: 586617744 bytes
in 291 blocks; 3862688 free (267 chunks); 582755056 used
2024-08-07 00:27:30.365 CEST [ANALYZE] LOG: level: 0; TopMemoryContext:
103312 total in 5 blocks; 3016 free (16 chunks); 100296 used
2024-08-07 00:27:30.388 CEST [ANALYZE] LOG: level: 3; Analyze: 719031736
total in 96 blocks; 66864784 free (73392 chunks); 652166952 used
2024-08-07 00:27:30.388 CEST [ANALYZE] LOG: level: 4; Analyze Column:
15028360 total in 4 blocks; 7704 free (10 chunks); 15020656 used
2024-08-07 00:27:30.388 CEST [ANALYZE] LOG: level: 1; CacheMemoryContext:
1048576 total in 8 blocks; 501872 free (2 chunks); 546704 used
2024-08-07 00:27:30.389 CEST [ANALYZE] LOG: Grand total: 735863832 bytes
in 311 blocks; 67597832 free (73560 chunks); 668266000 used
2024-08-07 00:27:32.365 CEST [ANALYZE] LOG: level: 0; TopMemoryContext:
103312 total in 5 blocks; 3016 free (16 chunks); 100296 used
2024-08-07 00:27:32.386 CEST [ANALYZE] LOG: level: 3; Analyze: 719051800
total in 97 blocks; 65893672 free (72921 chunks); 653158128 used
2024-08-07 00:27:32.386 CEST [ANALYZE] LOG: level: 4; Analyze Column:
107294856 total in 24 blocks; 3075288 free (37 chunks); 104219568 used
2024-08-07 00:27:32.386 CEST [ANALYZE] LOG: level: 5; Analyzed elements
table: 16793656 total in 13 blocks; 2255088 free (42 chunks); 14538568
used
2024-08-07 00:27:32.386 CEST [ANALYZE] LOG: level: 1; CacheMemoryContext:
1048576 total in 8 blocks; 497776 free (1 chunks); 550800 used
2024-08-07 00:27:32.387 CEST [ANALYZE] LOG: Grand total: 844954288 bytes
in 348 blocks; 71945496 free (73154 chunks); 773008792 used
2024-08-07 00:27:34.365 CEST [ANALYZE] LOG: level: 0; TopMemoryContext:
103312 total in 5 blocks; 3016 free (16 chunks); 100296 used
2024-08-07 00:27:34.386 CEST [ANALYZE] LOG: level: 3; Analyze: 719051800
total in 97 blocks; 65893672 free (72921 chunks); 653158128 used
2024-08-07 00:27:34.386 CEST [ANALYZE] LOG: level: 4; Analyze Column:
451227784 total in 65 blocks; 5446912 free (74 chunks); 445780872 used
2024-08-07 00:27:34.386 CEST [ANALYZE] LOG: level: 5; Analyzed elements
table: 75563064 total in 20 blocks; 5659864 free (63 chunks); 69903200
used
2024-08-07 00:27:34.386 CEST [ANALYZE] LOG: level: 1; CacheMemoryContext:
1048576 total in 8 blocks; 497776 free (1 chunks); 550800 used
2024-08-07 00:27:34.387 CEST [ANALYZE] LOG: Grand total: 1247664816 bytes
in 397 blocks; 77726928 free (73215 chunks); 1169937888 used
2024-08-07 00:27:36.365 CEST [ANALYZE] LOG: level: 0; TopMemoryContext:
103312 total in 5 blocks; 3016 free (16 chunks); 100296 used
2024-08-07 00:27:36.386 CEST [ANALYZE] LOG: level: 3; Analyze: 719051800
total in 97 blocks; 65893672 free (72921 chunks); 653158128 used
2024-08-07 00:27:36.386 CEST [ANALYZE] LOG: level: 4; Analyze Column:
753217672 total in 101 blocks; 2203456 free (104 chunks); 751014216 used
2024-08-07 00:27:36.386 CEST [ANALYZE] LOG: level: 5; Analyzed elements
table: 125960248 total in 26 blocks; 6678184 free (81 chunks); 119282064
used
2024-08-07 00:27:36.386 CEST [ANALYZE] LOG: level: 1; CacheMemoryContext:
1048576 total in 8 blocks; 497776 free (1 chunks); 550800 used
2024-08-07 00:27:36.387 CEST [ANALYZE] LOG: Grand total: 1600051888 bytes
in 439 blocks; 75501792 free (73263 chunks); 1524550096 used
2024-08-07 00:27:38.365 CEST [ANALYZE] LOG: level: 0; TopMemoryContext:
103312 total in 5 blocks; 3016 free (16 chunks); 100296 used
2024-08-07 00:27:38.386 CEST [ANALYZE] LOG: level: 3; Analyze: 719051800
total in 97 blocks; 65893672 free (72921 chunks); 653158128 used
2024-08-07 00:27:38.386 CEST [ANALYZE] LOG: level: 4; Analyze Column:
1046818952 total in 136 blocks; 3869224 free (145 chunks); 1042949728 used
2024-08-07 00:27:38.386 CEST [ANALYZE] LOG: level: 5; Analyzed elements
table: 167903288 total in 31 blocks; 940560 free (96 chunks); 166962728
used
2024-08-07 00:27:38.387 CEST [ANALYZE] LOG: level: 1; CacheMemoryContext:
1048576 total in 8 blocks; 497776 free (1 chunks); 550800 used
2024-08-07 00:27:38.387 CEST [ANALYZE] LOG: Grand total: 1935596208 bytes
in 479 blocks; 71429936 free (73319 chunks); 1864166272 used
2024-08-07 00:27:45.086 CEST [ANALYZE] LOG: level: 0; TopMemoryContext:
103312 total in 5 blocks; 3016 free (16 chunks); 100296 used
2024-08-07 00:27:45.107 CEST [ANALYZE] LOG: level: 3; Analyze: 719051800
total in 97 blocks; 65893672 free (72921 chunks); 653158128 used
2024-08-07 00:27:46.178 CEST [ANALYZE] LOG: level: 4; Analyze Column:
1181036680 total in 152 blocks; 972875432 free (3565573 chunks); 208161248
used
2024-08-07 00:27:46.178 CEST [ANALYZE] LOG: level: 5; Analyzed elements
table: 176291896 total in 32 blocks; 2967880 free (99 chunks); 173324016
used
2024-08-07 00:27:46.178 CEST [ANALYZE] LOG: level: 1; CacheMemoryContext:
1048576 total in 8 blocks; 497776 free (1 chunks); 550800 used
2024-08-07 00:27:46.179 CEST [ANALYZE] LOG: Grand total: 2078202544 bytes
in 496 blocks; 1042463464 free (3638750 chunks); 1035739080 used
2024-08-07 00:27:46.365 CEST [ANALYZE] LOG: level: 0; TopMemoryContext:
103312 total in 5 blocks; 3016 free (16 chunks); 100296 used
2024-08-07 00:27:46.386 CEST [ANALYZE] LOG: level: 3; Analyze: 719051800
total in 97 blocks; 65893672 free (72921 chunks); 653158128 used
2024-08-07 00:27:47.391 CEST [ANALYZE] LOG: level: 4; Analyze Column:
1189425288 total in 153 blocks; 935981952 free (3413097 chunks); 253443336
used
2024-08-07 00:27:47.391 CEST [ANALYZE] LOG: level: 5; Analyzed elements
table: 176291896 total in 32 blocks; 2967880 free (99 chunks); 173324016
used
2024-08-07 00:27:47.391 CEST [ANALYZE] LOG: level: 1; CacheMemoryContext:
1048576 total in 8 blocks; 497776 free (1 chunks); 550800 used
2024-08-07 00:27:47.392 CEST [ANALYZE] LOG: Grand total: 2086591152 bytes
in 497 blocks; 1005569984 free (3486274 chunks); 1081021168 used
2024-08-07 00:27:48.365 CEST [ANALYZE] LOG: level: 0; TopMemoryContext:
103312 total in 5 blocks; 3016 free (16 chunks); 100296 used
2024-08-07 00:27:48.387 CEST [ANALYZE] LOG: level: 3; Analyze: 719051800
total in 97 blocks; 65893672 free (72921 chunks); 653158128 used
2024-08-07 00:27:49.178 CEST [ANALYZE] LOG: level: 4; Analyze Column:
1206202504 total in 155 blocks; 729411760 free (2662895 chunks); 476790744
used
2024-08-07 00:27:49.178 CEST [ANALYZE] LOG: level: 5; Analyzed elements
table: 176291896 total in 32 blocks; 2967880 free (99 chunks); 173324016
used
2024-08-07 00:27:49.178 CEST [ANALYZE] LOG: level: 1; CacheMemoryContext:
1048576 total in 8 blocks; 497776 free (1 chunks); 550800 used
2024-08-07 00:27:49.178 CEST [ANALYZE] LOG: Grand total: 2103368368 bytes
in 499 blocks; 798999792 free (2736072 chunks); 1304368576 used
2024-08-07 00:27:50.365 CEST [ANALYZE] LOG: level: 0; TopMemoryContext:
103312 total in 5 blocks; 3016 free (16 chunks); 100296 used
2024-08-07 00:27:50.387 CEST [ANALYZE] LOG: level: 3; Analyze: 719051800
total in 97 blocks; 65893672 free (72921 chunks); 653158128 used
2024-08-07 00:27:50.917 CEST [ANALYZE] LOG: level: 4; Analyze Column:
1231368328 total in 158 blocks; 486785608 free (1764500 chunks); 744582720
used
2024-08-07 00:27:50.917 CEST [ANALYZE] LOG: level: 5; Analyzed elements
table: 176291896 total in 32 blocks; 2967880 free (99 chunks); 173324016
used
2024-08-07 00:27:50.917 CEST [ANALYZE] LOG: level: 1; CacheMemoryContext:
1048576 total in 8 blocks; 497776 free (1 chunks); 550800 used
2024-08-07 00:27:50.918 CEST [ANALYZE] LOG: Grand total: 2128534192 bytes
in 502 blocks; 556373640 free (1837677 chunks); 1572160552 used
2024-08-07 00:27:52.365 CEST [ANALYZE] LOG: level: 0; TopMemoryContext:
103312 total in 5 blocks; 3016 free (16 chunks); 100296 used
2024-08-07 00:27:52.386 CEST [ANALYZE] LOG: level: 3; Analyze: 719051800
total in 97 blocks; 65893672 free (72921 chunks); 653158128 used
2024-08-07 00:27:52.614 CEST [ANALYZE] LOG: level: 4; Analyze Column:
1256534152 total in 161 blocks; 204825088 free (738322 chunks); 1051709064
used
2024-08-07 00:27:52.614 CEST [ANALYZE] LOG: level: 5; Analyzed elements
table: 176291896 total in 32 blocks; 2967880 free (99 chunks); 173324016
used
2024-08-07 00:27:52.614 CEST [ANALYZE] LOG: level: 1; CacheMemoryContext:
1048576 total in 8 blocks; 497776 free (1 chunks); 550800 used
2024-08-07 00:27:52.615 CEST [ANALYZE] LOG: Grand total: 2153700016 bytes
in 505 blocks; 274413120 free (811499 chunks); 1879286896 used
2024-08-07 00:28:00.103 CEST [ANALYZE] LOG: level: 0; TopMemoryContext:
103312 total in 5 blocks; 3016 free (16 chunks); 100296 used
2024-08-07 00:28:00.124 CEST [ANALYZE] LOG: level: 3; Analyze: 719051800
total in 97 blocks; 65893672 free (72921 chunks); 653158128 used
2024-08-07 00:28:01.194 CEST [ANALYZE] LOG: level: 4; Analyze Column:
1373974664 total in 175 blocks; 978758072 free (3569147 chunks); 395216592
used
2024-08-07 00:28:01.194 CEST [ANALYZE] LOG: level: 0; TopMemoryContext:
103312 total in 5 blocks; 3016 free (16 chunks); 100296 used
2024-08-07 00:28:01.214 CEST [ANALYZE] LOG: level: 3; Analyze: 719051800
total in 97 blocks; 65893672 free (72921 chunks); 653158128 used
2024-08-07 00:28:02.283 CEST [ANALYZE] LOG: level: 4; Analyze Column:
1373974664 total in 175 blocks; 978758072 free (3569147 chunks); 395216592
used
2024-08-07 00:28:02.283 CEST [ANALYZE] LOG: level: 5; Analyzed elements
table: 176291896 total in 32 blocks; 2808952 free (99 chunks); 173482944
used
2024-08-07 00:28:02.283 CEST [ANALYZE] LOG: level: 1; CacheMemoryContext:
1048576 total in 8 blocks; 497776 free (1 chunks); 550800 used
2024-08-07 00:28:02.284 CEST [ANALYZE] LOG: Grand total: 2271140528 bytes
in 519 blocks; 1048187176 free (3642324 chunks); 1222953352 used
2024-08-07 00:28:02.284 CEST [ANALYZE] LOG: level: 5; Analyzed elements
table: 176291896 total in 32 blocks; 2808952 free (99 chunks); 173482944
used
2024-08-07 00:28:02.284 CEST [ANALYZE] LOG: level: 1; CacheMemoryContext:
1048576 total in 8 blocks; 497776 free (1 chunks); 550800 used
2024-08-07 00:28:02.285 CEST [ANALYZE] LOG: Grand total: 2271140528 bytes
in 519 blocks; 1048187176 free (3642324 chunks); 1222953352 used
2024-08-07 00:28:02.365 CEST [ANALYZE] LOG: level: 0; TopMemoryContext:
103312 total in 5 blocks; 3016 free (16 chunks); 100296 used
2024-08-07 00:28:02.387 CEST [ANALYZE] LOG: level: 3; Analyze: 719051800
total in 97 blocks; 65893672 free (72921 chunks); 653158128 used
2024-08-07 00:28:03.434 CEST [ANALYZE] LOG: level: 4; Analyze Column:
1373974664 total in 175 blocks; 959725592 free (3505287 chunks); 414249072
used
2024-08-07 00:28:03.434 CEST [ANALYZE] LOG: level: 5; Analyzed elements
table: 176291896 total in 32 blocks; 2808952 free (99 chunks); 173482944
used
2024-08-07 00:28:03.434 CEST [ANALYZE] LOG: level: 1; CacheMemoryContext:
1048576 total in 8 blocks; 497776 free (1 chunks); 550800 used
2024-08-07 00:28:03.434 CEST [ANALYZE] LOG: Grand total: 2271140528 bytes
in 519 blocks; 1029154696 free (3578464 chunks); 1241985832 used
2024-08-07 00:28:04.365 CEST [ANALYZE] LOG: level: 0; TopMemoryContext:
103312 total in 5 blocks; 3016 free (16 chunks); 100296 used
2024-08-07 00:28:04.386 CEST [ANALYZE] LOG: level: 3; Analyze: 719051800
total in 97 blocks; 65893672 free (72921 chunks); 653158128 used
2024-08-07 00:28:05.206 CEST [ANALYZE] LOG: level: 4; Analyze Column:
1390751880 total in 177 blocks; 758141848 free (2777606 chunks); 632610032
used
2024-08-07 00:28:05.206 CEST [ANALYZE] LOG: level: 5; Analyzed elements
table: 176291896 total in 32 blocks; 2808952 free (99 chunks); 173482944
used
2024-08-07 00:28:05.206 CEST [ANALYZE] LOG: level: 1; CacheMemoryContext:
1048576 total in 8 blocks; 497776 free (1 chunks); 550800 used
2024-08-07 00:28:05.207 CEST [ANALYZE] LOG: Grand total: 2287917744 bytes
in 521 blocks; 827570952 free (2850783 chunks); 1460346792 used
2024-08-07 00:28:06.365 CEST [ANALYZE] LOG: level: 0; TopMemoryContext:
103312 total in 5 blocks; 3016 free (16 chunks); 100296 used
2024-08-07 00:28:06.386 CEST [ANALYZE] LOG: level: 3; Analyze: 719051800
total in 97 blocks; 65893672 free (72921 chunks); 653158128 used
2024-08-07 00:28:06.955 CEST [ANALYZE] LOG: level: 4; Analyze Column:
1415917704 total in 180 blocks; 519454696 free (1901439 chunks); 896463008
used
2024-08-07 00:28:06.955 CEST [ANALYZE] LOG: level: 5; Analyzed elements
table: 176291896 total in 32 blocks; 2808952 free (99 chunks); 173482944
used
2024-08-07 00:28:06.955 CEST [ANALYZE] LOG: level: 1; CacheMemoryContext:
1048576 total in 8 blocks; 497776 free (1 chunks); 550800 used
2024-08-07 00:28:06.955 CEST [ANALYZE] LOG: Grand total: 2313083568 bytes
in 524 blocks; 588883800 free (1974616 chunks); 1724199768 used
2024-08-07 00:28:08.365 CEST [ANALYZE] LOG: level: 0; TopMemoryContext:
103312 total in 5 blocks; 3016 free (16 chunks); 100296 used
2024-08-07 00:28:08.386 CEST [ANALYZE] LOG: level: 3; Analyze: 719051800
total in 97 blocks; 65893672 free (72921 chunks); 653158128 used
2024-08-07 00:28:08.654 CEST [ANALYZE] LOG: level: 4; Analyze Column:
1441083528 total in 183 blocks; 243553760 free (888030 chunks); 1197529768
used
2024-08-07 00:28:08.654 CEST [ANALYZE] LOG: level: 5; Analyzed elements
table: 176291896 total in 32 blocks; 2808952 free (99 chunks); 173482944
used
2024-08-07 00:28:08.654 CEST [ANALYZE] LOG: level: 1; CacheMemoryContext:
1048576 total in 8 blocks; 497776 free (1 chunks); 550800 used
2024-08-07 00:28:08.655 CEST [ANALYZE] LOG: Grand total: 2338249392 bytes
in 527 blocks; 312982864 free (961207 chunks); 2025266528 used
2024-08-07 00:28:16.300 CEST [ANALYZE] LOG: level: 0; TopMemoryContext:
103312 total in 5 blocks; 3016 free (16 chunks); 100296 used
2024-08-07 00:28:16.320 CEST [ANALYZE] LOG: level: 3; Analyze: 719051800
total in 97 blocks; 65893672 free (72921 chunks); 653158128 used
2024-08-07 00:28:17.357 CEST [ANALYZE] LOG: level: 4; Analyze Column:
1558524040 total in 197 blocks; 971536464 free (3568112 chunks); 586987576
used
2024-08-07 00:28:17.357 CEST [ANALYZE] LOG: level: 0; TopMemoryContext:
103312 total in 5 blocks; 3016 free (16 chunks); 100296 used
2024-08-07 00:28:17.377 CEST [ANALYZE] LOG: level: 3; Analyze: 719051800
total in 97 blocks; 65893672 free (72921 chunks); 653158128 used
2024-08-07 00:28:18.440 CEST [ANALYZE] LOG: level: 4; Analyze Column:
1558524040 total in 197 blocks; 971536464 free (3568112 chunks); 586987576
used
2024-08-07 00:28:18.440 CEST [ANALYZE] LOG: level: 0; TopMemoryContext:
103312 total in 5 blocks; 3016 free (16 chunks); 100296 used
2024-08-07 00:28:18.461 CEST [ANALYZE] LOG: level: 3; Analyze: 719051800
total in 97 blocks; 65893672 free (72921 chunks); 653158128 used
2024-08-07 00:28:19.529 CEST [ANALYZE] LOG: level: 4; Analyze Column:
1558524040 total in 197 blocks; 971536464 free (3568112 chunks); 586987576
used
2024-08-07 00:28:19.530 CEST [ANALYZE] LOG: level: 5; Analyzed elements
table: 176291896 total in 32 blocks; 2808952 free (99 chunks); 173482944
used
2024-08-07 00:28:19.530 CEST [ANALYZE] LOG: level: 1; CacheMemoryContext:
1048576 total in 8 blocks; 497776 free (1 chunks); 550800 used
2024-08-07 00:28:19.531 CEST [ANALYZE] LOG: Grand total: 2455689904 bytes
in 541 blocks; 1040965568 free (3641289 chunks); 1414724336 used
2024-08-07 00:28:19.531 CEST [ANALYZE] LOG: level: 5; Analyzed elements
table: 176291896 total in 32 blocks; 2808952 free (99 chunks); 173482944
used
2024-08-07 00:28:19.531 CEST [ANALYZE] LOG: level: 1; CacheMemoryContext:
1048576 total in 8 blocks; 497776 free (1 chunks); 550800 used
2024-08-07 00:28:19.532 CEST [ANALYZE] LOG: Grand total: 2455689904 bytes
in 541 blocks; 1040965568 free (3641289 chunks); 1414724336 used
2024-08-07 00:28:19.532 CEST [ANALYZE] LOG: level: 5; Analyzed elements
table: 176291896 total in 32 blocks; 2808952 free (99 chunks); 173482944
used
2024-08-07 00:28:19.532 CEST [ANALYZE] LOG: level: 1; CacheMemoryContext:
1048576 total in 8 blocks; 497776 free (1 chunks); 550800 used
2024-08-07 00:28:19.534 CEST [ANALYZE] LOG: Grand total: 2455689904 bytes
in 541 blocks; 1040965568 free (3641289 chunks); 1414724336 used
2024-08-07 00:28:20.365 CEST [ANALYZE] LOG: level: 0; TopMemoryContext:
103312 total in 5 blocks; 3016 free (16 chunks); 100296 used
2024-08-07 00:28:20.386 CEST [ANALYZE] LOG: level: 3; Analyze: 719051800
total in 97 blocks; 65893672 free (72921 chunks); 653158128 used
2024-08-07 00:28:21.255 CEST [ANALYZE] LOG: level: 4; Analyze Column:
1575301256 total in 199 blocks; 791768536 free (2909842 chunks); 783532720
used
2024-08-07 00:28:21.255 CEST [ANALYZE] LOG: level: 5; Analyzed elements
table: 176291896 total in 32 blocks; 2808952 free (99 chunks); 173482944
used
2024-08-07 00:28:21.255 CEST [ANALYZE] LOG: level: 1; CacheMemoryContext:
1048576 total in 8 blocks; 497776 free (1 chunks); 550800 used
2024-08-07 00:28:21.256 CEST [ANALYZE] LOG: Grand total: 2472467120 bytes
in 543 blocks; 861197640 free (2983019 chunks); 1611269480 used
2024-08-07 00:28:22.365 CEST [ANALYZE] LOG: level: 0; TopMemoryContext:
103312 total in 5 blocks; 3016 free (16 chunks); 100296 used
2024-08-07 00:28:22.386 CEST [ANALYZE] LOG: level: 3; Analyze: 719051800
total in 97 blocks; 65893672 free (72921 chunks); 653158128 used
2024-08-07 00:28:23.002 CEST [ANALYZE] LOG: level: 4; Analyze Column:
1600467080 total in 202 blocks; 567521832 free (2074571 chunks); 1032945248
used
2024-08-07 00:28:23.002 CEST [ANALYZE] LOG: level: 5; Analyzed elements
table: 176291896 total in 32 blocks; 2808952 free (99 chunks); 173482944
used
2024-08-07 00:28:23.002 CEST [ANALYZE] LOG: level: 1; CacheMemoryContext:
1048576 total in 8 blocks; 497776 free (1 chunks); 550800 used
2024-08-07 00:28:23.003 CEST [ANALYZE] LOG: Grand total: 2497632944 bytes
in 546 blocks; 636950936 free (2147748 chunks); 1860682008 used
2024-08-07 00:28:24.365 CEST [ANALYZE] LOG: level: 0; TopMemoryContext:
103312 total in 5 blocks; 3016 free (16 chunks); 100296 used
2024-08-07 00:28:24.386 CEST [ANALYZE] LOG: level: 3; Analyze: 719051800
total in 97 blocks; 65893672 free (72921 chunks); 653158128 used
2024-08-07 00:28:24.712 CEST [ANALYZE] LOG: level: 4; Analyze Column:
1625632904 total in 205 blocks; 302042880 free (1103150 chunks); 1323590024
used
2024-08-07 00:28:24.712 CEST [ANALYZE] LOG: level: 5; Analyzed elements
table: 176291896 total in 32 blocks; 2808952 free (99 chunks); 173482944
used
2024-08-07 00:28:24.712 CEST [ANALYZE] LOG: level: 1; CacheMemoryContext:
1048576 total in 8 blocks; 497776 free (1 chunks); 550800 used
2024-08-07 00:28:24.713 CEST [ANALYZE] LOG: Grand total: 2522798768 bytes
in 549 blocks; 371471984 free (1176327 chunks); 2151326784 used
2024-08-07 00:28:32.754 CEST [ANALYZE] LOG: level: 0; TopMemoryContext:
103312 total in 5 blocks; 3016 free (16 chunks); 100296 used
2024-08-07 00:28:32.777 CEST [ANALYZE] LOG: level: 3; Analyze: 719051800
total in 97 blocks; 65893672 free (72921 chunks); 653158128 used
2024-08-07 00:28:33.842 CEST [ANALYZE] LOG: level: 4; Analyze Column:
1751462024 total in 220 blocks; 975598296 free (3569536 chunks); 775863728
used
2024-08-07 00:28:33.842 CEST [ANALYZE] LOG: level: 5; Analyzed elements
table: 176291896 total in 32 blocks; 2786248 free (99 chunks); 173505648
used
2024-08-07 00:28:33.842 CEST [ANALYZE] LOG: level: 1; CacheMemoryContext:
1048576 total in 8 blocks; 497776 free (1 chunks); 550800 used
2024-08-07 00:28:33.843 CEST [ANALYZE] LOG: Grand total: 2648627888 bytes
in 564 blocks; 1045004696 free (3642713 chunks); 1603623192 used
2024-08-07 00:28:34.365 CEST [ANALYZE] LOG: level: 0; TopMemoryContext:
103312 total in 5 blocks; 3016 free (16 chunks); 100296 used
2024-08-07 00:28:34.386 CEST [ANALYZE] LOG: level: 3; Analyze: 719051800
total in 97 blocks; 65893672 free (72921 chunks); 653158128 used
2024-08-07 00:28:35.319 CEST [ANALYZE] LOG: level: 4; Analyze Column:
1759850632 total in 221 blocks; 864184856 free (3167040 chunks); 895665776
used
2024-08-07 00:28:35.319 CEST [ANALYZE] LOG: level: 5; Analyzed elements
table: 176291896 total in 32 blocks; 2786248 free (99 chunks); 173505648
used
2024-08-07 00:28:35.319 CEST [ANALYZE] LOG: level: 1; CacheMemoryContext:
1048576 total in 8 blocks; 497776 free (1 chunks); 550800 used
2024-08-07 00:28:35.320 CEST [ANALYZE] LOG: Grand total: 2657016496 bytes
in 565 blocks; 933591256 free (3240217 chunks); 1723425240 used
2024-08-07 00:28:36.366 CEST [ANALYZE] LOG: level: 0; TopMemoryContext:
103312 total in 5 blocks; 3016 free (16 chunks); 100296 used
2024-08-07 00:28:36.386 CEST [ANALYZE] LOG: level: 3; Analyze: 719051800
total in 97 blocks; 65893672 free (72921 chunks); 653158128 used
2024-08-07 00:28:37.095 CEST [ANALYZE] LOG: level: 4; Analyze Column:
1785016456 total in 224 blocks; 661717392 free (2408800 chunks); 1123299064
used
2024-08-07 00:28:37.095 CEST [ANALYZE] LOG: level: 5; Analyzed elements
table: 176291896 total in 32 blocks; 2786248 free (99 chunks); 173505648
used
2024-08-07 00:28:37.095 CEST [ANALYZE] LOG: level: 1; CacheMemoryContext:
1048576 total in 8 blocks; 497776 free (1 chunks); 550800 used
2024-08-07 00:28:37.096 CEST [ANALYZE] LOG: Grand total: 2682182320 bytes
in 568 blocks; 731123792 free (2481977 chunks); 1951058528 used
2024-08-07 00:28:38.365 CEST [ANALYZE] LOG: level: 0; TopMemoryContext:
103312 total in 5 blocks; 3016 free (16 chunks); 100296 used
2024-08-07 00:28:38.388 CEST [ANALYZE] LOG: level: 3; Analyze: 719051800
total in 97 blocks; 65893672 free (72921 chunks); 653158128 used
2024-08-07 00:28:38.848 CEST [ANALYZE] LOG: level: 4; Analyze Column:
1810182280 total in 227 blocks; 412349240 free (1485968 chunks); 1397833040
used
2024-08-07 00:28:38.848 CEST [ANALYZE] LOG: level: 5; Analyzed elements
table: 176291896 total in 32 blocks; 2786248 free (99 chunks); 173505648
used
2024-08-07 00:28:38.848 CEST [ANALYZE] LOG: level: 1; CacheMemoryContext:
1048576 total in 8 blocks; 497776 free (1 chunks); 550800 used
2024-08-07 00:28:38.849 CEST [ANALYZE] LOG: Grand total: 2707348144 bytes
in 571 blocks; 481755640 free (1559145 chunks); 2225592504 used
2024-08-07 00:28:40.365 CEST [ANALYZE] LOG: level: 0; TopMemoryContext:
103312 total in 5 blocks; 3016 free (16 chunks); 100296 used
2024-08-07 00:28:40.388 CEST [ANALYZE] LOG: level: 3; Analyze: 719051800
total in 97 blocks; 65893672 free (72921 chunks); 653158128 used
2024-08-07 00:28:40.538 CEST [ANALYZE] LOG: level: 4; Analyze Column:
1835348104 total in 230 blocks; 138301072 free (485133 chunks); 1697047032
used
2024-08-07 00:28:40.538 CEST [ANALYZE] LOG: level: 5; Analyzed elements
table: 176291896 total in 32 blocks; 2786248 free (99 chunks); 173505648
used
2024-08-07 00:28:40.538 CEST [ANALYZE] LOG: level: 1; CacheMemoryContext:
1048576 total in 8 blocks; 497776 free (1 chunks); 550800 used
2024-08-07 00:28:40.540 CEST [ANALYZE] LOG: Grand total: 2732513968 bytes
in 574 blocks; 207707472 free (558310 chunks); 2524806496 used
2024-08-07 00:28:47.751 CEST [ANALYZE] LOG: level: 0; TopMemoryContext:
103312 total in 5 blocks; 3016 free (16 chunks); 100296 used
2024-08-07 00:28:47.772 CEST [ANALYZE] LOG: level: 3; Analyze: 719051800
total in 97 blocks; 65893672 free (72921 chunks); 653158128 used
2024-08-07 00:28:48.855 CEST [ANALYZE] LOG: level: 4; Analyze Column:
1944400008 total in 243 blocks; 978894312 free (3569081 chunks); 965505696
used
2024-08-07 00:28:48.855 CEST [ANALYZE] LOG: level: 0; TopMemoryContext:
103312 total in 5 blocks; 3016 free (16 chunks); 100296 used
2024-08-07 00:28:48.875 CEST [ANALYZE] LOG: level: 3; Analyze: 719051800
total in 97 blocks; 65893672 free (72921 chunks); 653158128 used
2024-08-07 00:28:49.952 CEST [ANALYZE] LOG: level: 4; Analyze Column:
1944400008 total in 243 blocks; 978894312 free (3569081 chunks); 965505696
used
2024-08-07 00:28:49.952 CEST [ANALYZE] LOG: level: 5; Analyzed elements
table: 176291896 total in 32 blocks; 2786248 free (99 chunks); 173505648
used
2024-08-07 00:28:49.952 CEST [ANALYZE] LOG: level: 1; CacheMemoryContext:
1048576 total in 8 blocks; 497776 free (1 chunks); 550800 used
2024-08-07 00:28:49.953 CEST [ANALYZE] LOG: Grand total: 2841565872 bytes
in 587 blocks; 1048300712 free (3642258 chunks); 1793265160 used
2024-08-07 00:28:49.953 CEST [ANALYZE] LOG: level: 5; Analyzed elements
table: 176291896 total in 32 blocks; 2786248 free (99 chunks); 173505648
used
2024-08-07 00:28:49.953 CEST [ANALYZE] LOG: level: 1; CacheMemoryContext:
1048576 total in 8 blocks; 497776 free (1 chunks); 550800 used
2024-08-07 00:28:49.953 CEST [ANALYZE] LOG: Grand total: 2841565872 bytes
in 587 blocks; 1048300712 free (3642258 chunks); 1793265160 used
2024-08-07 00:28:50.365 CEST [ANALYZE] LOG: level: 0; TopMemoryContext:
103312 total in 5 blocks; 3016 free (16 chunks); 100296 used
2024-08-07 00:28:50.387 CEST [ANALYZE] LOG: level: 3; Analyze: 719051800
total in 97 blocks; 65893672 free (72921 chunks); 653158128 used
2024-08-07 00:28:51.384 CEST [ANALYZE] LOG: level: 4; Analyze Column:
1952788616 total in 244 blocks; 891020424 free (3245537 chunks); 1061768192
used
2024-08-07 00:28:51.384 CEST [ANALYZE] LOG: level: 5; Analyzed elements
table: 176291896 total in 32 blocks; 2786248 free (99 chunks); 173505648
used
2024-08-07 00:28:51.384 CEST [ANALYZE] LOG: level: 1; CacheMemoryContext:
1048576 total in 8 blocks; 497776 free (1 chunks); 550800 used
2024-08-07 00:28:51.385 CEST [ANALYZE] LOG: Grand total: 2849954480 bytes
in 588 blocks; 960426824 free (3318714 chunks); 1889527656 used
2024-08-07 00:28:52.365 CEST [ANALYZE] LOG: level: 0; TopMemoryContext:
103312 total in 5 blocks; 3016 free (16 chunks); 100296 used
2024-08-07 00:28:52.387 CEST [ANALYZE] LOG: level: 3; Analyze: 719051800
total in 97 blocks; 65893672 free (72921 chunks); 653158128 used
2024-08-07 00:28:53.155 CEST [ANALYZE] LOG: level: 4; Analyze Column:
1969565832 total in 246 blocks; 687187176 free (2514069 chunks); 1282378656
used
2024-08-07 00:28:53.155 CEST [ANALYZE] LOG: level: 5; Analyzed elements
table: 176291896 total in 32 blocks; 2786248 free (99 chunks); 173505648
used
2024-08-07 00:28:53.155 CEST [ANALYZE] LOG: level: 1; CacheMemoryContext:
1048576 total in 8 blocks; 497776 free (1 chunks); 550800 used
2024-08-07 00:28:53.156 CEST [ANALYZE] LOG: Grand total: 2866731696 bytes
in 590 blocks; 756593576 free (2587246 chunks); 2110138120 used
2024-08-07 00:28:54.365 CEST [ANALYZE] LOG: level: 0; TopMemoryContext:
103312 total in 5 blocks; 3016 free (16 chunks); 100296 used
2024-08-07 00:28:54.387 CEST [ANALYZE] LOG: level: 3; Analyze: 719051800
total in 97 blocks; 65893672 free (72921 chunks); 653158128 used
2024-08-07 00:28:54.894 CEST [ANALYZE] LOG: level: 4; Analyze Column:
1994731656 total in 249 blocks; 454913048 free (1651744 chunks); 1539818608
used
2024-08-07 00:28:54.894 CEST [ANALYZE] LOG: level: 5; Analyzed elements
table: 176291896 total in 32 blocks; 2786248 free (99 chunks); 173505648
used
2024-08-07 00:28:54.894 CEST [ANALYZE] LOG: level: 1; CacheMemoryContext:
1048576 total in 8 blocks; 497776 free (1 chunks); 550800 used
2024-08-07 00:28:54.895 CEST [ANALYZE] LOG: Grand total: 2891897520 bytes
in 593 blocks; 524319448 free (1724921 chunks); 2367578072 used
2024-08-07 00:28:56.366 CEST [ANALYZE] LOG: level: 0; TopMemoryContext:
103312 total in 5 blocks; 3016 free (16 chunks); 100296 used
2024-08-07 00:28:56.388 CEST [ANALYZE] LOG: level: 3; Analyze: 719051800
total in 97 blocks; 65893672 free (72921 chunks); 653158128 used
2024-08-07 00:28:56.591 CEST [ANALYZE] LOG: level: 4; Analyze Column:
2019897480 total in 252 blocks; 186244736 free (671083 chunks); 1833652744
used
2024-08-07 00:28:56.591 CEST [ANALYZE] LOG: level: 5; Analyzed elements
table: 176291896 total in 32 blocks; 2786248 free (99 chunks); 173505648
used
2024-08-07 00:28:56.591 CEST [ANALYZE] LOG: level: 1; CacheMemoryContext:
1048576 total in 8 blocks; 497776 free (1 chunks); 550800 used
2024-08-07 00:28:56.593 CEST [ANALYZE] LOG: Grand total: 2917063344 bytes
in 596 blocks; 255651136 free (744260 chunks); 2661412208 used
2024-08-07 00:29:04.656 CEST [ANALYZE] LOG: level: 0; TopMemoryContext:
103312 total in 5 blocks; 3016 free (16 chunks); 100296 used
2024-08-07 00:29:04.679 CEST [ANALYZE] LOG: level: 3; Analyze: 719051800
total in 97 blocks; 65893672 free (72921 chunks); 653158128 used
2024-08-07 00:29:05.733 CEST [ANALYZE] LOG: level: 4; Analyze Column:
2137337992 total in 266 blocks; 977359024 free (3571532 chunks); 1159978968
used
2024-08-07 00:29:05.733 CEST [ANALYZE] LOG: level: 5; Analyzed elements
table: 176291896 total in 32 blocks; 2744968 free (99 chunks); 173546928
used
2024-08-07 00:29:05.733 CEST [ANALYZE] LOG: level: 1; CacheMemoryContext:
1048576 total in 8 blocks; 497776 free (1 chunks); 550800 used
2024-08-07 00:29:05.734 CEST [ANALYZE] LOG: Grand total: 3034503856 bytes
in 610 blocks; 1046724144 free (3644709 chunks); 1987779712 used
2024-08-07 00:29:06.365 CEST [ANALYZE] LOG: level: 0; TopMemoryContext:
103312 total in 5 blocks; 3016 free (16 chunks); 100296 used
2024-08-07 00:29:06.386 CEST [ANALYZE] LOG: level: 3; Analyze: 719051800
total in 97 blocks; 65893672 free (72921 chunks); 653158128 used
2024-08-07 00:29:07.283 CEST [ANALYZE] LOG: level: 4; Analyze Column:
2145726600 total in 267 blocks; 832308592 free (3055777 chunks); 1313418008
used
2024-08-07 00:29:07.283 CEST [ANALYZE] LOG: level: 5; Analyzed elements
table: 176291896 total in 32 blocks; 2744968 free (99 chunks); 173546928
used
2024-08-07 00:29:07.283 CEST [ANALYZE] LOG: level: 1; CacheMemoryContext:
1048576 total in 8 blocks; 497776 free (1 chunks); 550800 used
2024-08-07 00:29:07.285 CEST [ANALYZE] LOG: Grand total: 3042892464 bytes
in 611 blocks; 901673712 free (3128954 chunks); 2141218752 used
2024-08-07 00:29:08.365 CEST [ANALYZE] LOG: level: 0; TopMemoryContext:
103312 total in 5 blocks; 3016 free (16 chunks); 100296 used
2024-08-07 00:29:08.386 CEST [ANALYZE] LOG: level: 3; Analyze: 719051800
total in 97 blocks; 65893672 free (72921 chunks); 653158128 used
2024-08-07 00:29:09.066 CEST [ANALYZE] LOG: level: 4; Analyze Column:
2170892424 total in 270 blocks; 610923000 free (2228193 chunks); 1559969424
used
2024-08-07 00:29:09.066 CEST [ANALYZE] LOG: level: 5; Analyzed elements
table: 176291896 total in 32 blocks; 2744968 free (99 chunks); 173546928
used
2024-08-07 00:29:09.066 CEST [ANALYZE] LOG: level: 1; CacheMemoryContext:
1048576 total in 8 blocks; 497776 free (1 chunks); 550800 used
2024-08-07 00:29:09.067 CEST [ANALYZE] LOG: Grand total: 3068058288 bytes
in 614 blocks; 680288120 free (2301370 chunks); 2387770168 used
2024-08-07 00:29:10.365 CEST [ANALYZE] LOG: level: 0; TopMemoryContext:
103312 total in 5 blocks; 3016 free (16 chunks); 100296 used
2024-08-07 00:29:10.387 CEST [ANALYZE] LOG: level: 3; Analyze: 719051800
total in 97 blocks; 65893672 free (72921 chunks); 653158128 used
2024-08-07 00:29:10.798 CEST [ANALYZE] LOG: level: 4; Analyze Column:
2196058248 total in 273 blocks; 367011072 free (1329920 chunks); 1829047176
used
2024-08-07 00:29:10.799 CEST [ANALYZE] LOG: level: 5; Analyzed elements
table: 176291896 total in 32 blocks; 2744968 free (99 chunks); 173546928
used
2024-08-07 00:29:10.799 CEST [ANALYZE] LOG: level: 1; CacheMemoryContext:
1048576 total in 8 blocks; 497776 free (1 chunks); 550800 used
2024-08-07 00:29:10.799 CEST [ANALYZE] LOG: Grand total: 3093224112 bytes
in 617 blocks; 436376192 free (1403097 chunks); 2656847920 used
2024-08-07 00:29:12.365 CEST [ANALYZE] LOG: level: 0; TopMemoryContext:
103312 total in 5 blocks; 3016 free (16 chunks); 100296 used
2024-08-07 00:29:12.387 CEST [ANALYZE] LOG: level: 3; Analyze: 719051800
total in 97 blocks; 65893672 free (72921 chunks); 653158128 used
2024-08-07 00:29:12.475 CEST [ANALYZE] LOG: level: 4; Analyze Column:
2221224072 total in 276 blocks; 80337600 free (283790 chunks); 2140886472
used
2024-08-07 00:29:12.475 CEST [ANALYZE] LOG: level: 5; Analyzed elements
table: 176291896 total in 32 blocks; 2744968 free (99 chunks); 173546928
used
2024-08-07 00:29:12.475 CEST [ANALYZE] LOG: level: 1; CacheMemoryContext:
1048576 total in 8 blocks; 497776 free (1 chunks); 550800 used
2024-08-07 00:29:12.476 CEST [ANALYZE] LOG: Grand total: 3118389936 bytes
in 620 blocks; 149702720 free (356967 chunks); 2968687216 used
2024-08-07 00:29:19.711 CEST [ANALYZE] LOG: level: 0; TopMemoryContext:
103312 total in 5 blocks; 3016 free (16 chunks); 100296 used
2024-08-07 00:29:19.735 CEST [ANALYZE] LOG: level: 3; Analyze: 719051800
total in 97 blocks; 65893672 free (72921 chunks); 653158128 used
2024-08-07 00:29:20.890 CEST [ANALYZE] LOG: level: 4; Analyze Column:
2321887368 total in 288 blocks; 972382344 free (3569640 chunks); 1349505024
used
2024-08-07 00:29:20.890 CEST [ANALYZE] LOG: level: 0; TopMemoryContext:
103312 total in 5 blocks; 3016 free (16 chunks); 100296 used
2024-08-07 00:29:20.912 CEST [ANALYZE] LOG: level: 3; Analyze: 719051800
total in 97 blocks; 65893672 free (72921 chunks); 653158128 used
2024-08-07 00:29:22.024 CEST [ANALYZE] LOG: level: 4; Analyze Column:
2321887368 total in 288 blocks; 972382344 free (3569640 chunks); 1349505024
used
2024-08-07 00:29:22.024 CEST [ANALYZE] LOG: level: 5; Analyzed elements
table: 176291896 total in 32 blocks; 2744968 free (99 chunks); 173546928
used
2024-08-07 00:29:22.025 CEST [ANALYZE] LOG: level: 1; CacheMemoryContext:
1048576 total in 8 blocks; 497776 free (1 chunks); 550800 used
2024-08-07 00:29:22.026 CEST [ANALYZE] LOG: Grand total: 3219053232 bytes
in 632 blocks; 1041747464 free (3642817 chunks); 2177305768 used
2024-08-07 00:29:22.026 CEST [ANALYZE] LOG: level: 5; Analyzed elements
table: 176291896 total in 32 blocks; 2744968 free (99 chunks); 173546928
used
2024-08-07 00:29:22.026 CEST [ANALYZE] LOG: level: 1; CacheMemoryContext:
1048576 total in 8 blocks; 497776 free (1 chunks); 550800 used
2024-08-07 00:29:22.027 CEST [ANALYZE] LOG: Grand total: 3219053232 bytes
in 632 blocks; 1041747464 free (3642817 chunks); 2177305768 used
2024-08-07 00:29:22.365 CEST [ANALYZE] LOG: level: 0; TopMemoryContext:
103312 total in 5 blocks; 3016 free (16 chunks); 100296 used
2024-08-07 00:29:22.387 CEST [ANALYZE] LOG: level: 3; Analyze: 719051800
total in 97 blocks; 65893672 free (72921 chunks); 653158128 used
2024-08-07 00:29:23.431 CEST [ANALYZE] LOG: level: 4; Analyze Column:
2330275976 total in 289 blocks; 913254824 free (3345715 chunks); 1417021152
used
2024-08-07 00:29:23.431 CEST [ANALYZE] LOG: level: 5; Analyzed elements
table: 176291896 total in 32 blocks; 2744968 free (99 chunks); 173546928
used
2024-08-07 00:29:23.431 CEST [ANALYZE] LOG: level: 1; CacheMemoryContext:
1048576 total in 8 blocks; 497776 free (1 chunks); 550800 used
2024-08-07 00:29:23.432 CEST [ANALYZE] LOG: Grand total: 3227441840 bytes
in 633 blocks; 982619944 free (3418892 chunks); 2244821896 used
2024-08-07 00:29:24.365 CEST [ANALYZE] LOG: level: 0; TopMemoryContext:
103312 total in 5 blocks; 3016 free (16 chunks); 100296 used
2024-08-07 00:29:24.385 CEST [ANALYZE] LOG: level: 3; Analyze: 719051800
total in 97 blocks; 65893672 free (72921 chunks); 653158128 used
2024-08-07 00:29:25.243 CEST [ANALYZE] LOG: level: 4; Analyze Column:
2347053192 total in 291 blocks; 734302328 free (2690776 chunks); 1612750864
used
2024-08-07 00:29:25.244 CEST [ANALYZE] LOG: level: 5; Analyzed elements
table: 176291896 total in 32 blocks; 2744968 free (99 chunks); 173546928
used
2024-08-07 00:29:25.244 CEST [ANALYZE] LOG: level: 1; CacheMemoryContext:
1048576 total in 8 blocks; 497776 free (1 chunks); 550800 used
2024-08-07 00:29:25.245 CEST [ANALYZE] LOG: Grand total: 3244219056 bytes
in 635 blocks; 803667448 free (2763953 chunks); 2440551608 used
2024-08-07 00:29:26.365 CEST [ANALYZE] LOG: level: 0; TopMemoryContext:
103312 total in 5 blocks; 3016 free (16 chunks); 100296 used
2024-08-07 00:29:26.386 CEST [ANALYZE] LOG: level: 3; Analyze: 719051800
total in 97 blocks; 65893672 free (72921 chunks); 653158128 used
2024-08-07 00:29:26.989 CEST [ANALYZE] LOG: level: 4; Analyze Column:
2372219016 total in 294 blocks; 533507400 free (1937250 chunks); 1838711616
used
2024-08-07 00:29:26.989 CEST [ANALYZE] LOG: level: 5; Analyzed elements
table: 176291896 total in 32 blocks; 2744968 free (99 chunks); 173546928
used
2024-08-07 00:29:26.990 CEST [ANALYZE] LOG: level: 1; CacheMemoryContext:
1048576 total in 8 blocks; 497776 free (1 chunks); 550800 used
2024-08-07 00:29:26.991 CEST [ANALYZE] LOG: Grand total: 3269384880 bytes
in 638 blocks; 602872520 free (2010427 chunks); 2666512360 used
2024-08-07 00:29:28.365 CEST [ANALYZE] LOG: level: 0; TopMemoryContext:
103312 total in 5 blocks; 3016 free (16 chunks); 100296 used
2024-08-07 00:29:28.390 CEST [ANALYZE] LOG: level: 3; Analyze: 719051800
total in 97 blocks; 65893672 free (72921 chunks); 653158128 used
2024-08-07 00:29:28.746 CEST [ANALYZE] LOG: level: 4; Analyze Column:
2388996232 total in 296 blocks; 308384664 free (1130367 chunks); 2080611568
used
2024-08-07 00:29:28.746 CEST [ANALYZE] LOG: level: 5; Analyzed elements
table: 176291896 total in 32 blocks; 2744968 free (99 chunks); 173546928
used
2024-08-07 00:29:28.746 CEST [ANALYZE] LOG: level: 1; CacheMemoryContext:
1048576 total in 8 blocks; 497776 free (1 chunks); 550800 used
2024-08-07 00:29:28.747 CEST [ANALYZE] LOG: Grand total: 3286162096 bytes
in 640 blocks; 377749784 free (1203544 chunks); 2908412312 used
2024-08-07 00:29:30.365 CEST [ANALYZE] LOG: level: 0; TopMemoryContext:
103312 total in 5 blocks; 3016 free (16 chunks); 100296 used
2024-08-07 00:29:30.388 CEST [ANALYZE] LOG: level: 3; Analyze: 719051800
total in 97 blocks; 65893672 free (72921 chunks); 653158128 used
2024-08-07 00:29:30.398 CEST [ANALYZE] LOG: level: 4; Analyze Column:
2422550664 total in 300 blocks; 15312832 free (33605 chunks); 2407237832
used
2024-08-07 00:29:30.398 CEST [ANALYZE] LOG: level: 5; Analyzed elements
table: 176291896 total in 32 blocks; 2744968 free (99 chunks); 173546928
used
2024-08-07 00:29:30.398 CEST [ANALYZE] LOG: level: 1; CacheMemoryContext:
1048576 total in 8 blocks; 497776 free (1 chunks); 550800 used
2024-08-07 00:29:30.400 CEST [ANALYZE] LOG: Grand total: 3319716528 bytes
in 644 blocks; 84677952 free (106782 chunks); 3235038576 used
2024-08-07 00:29:37.114 CEST [ANALYZE] LOG: level: 0; TopMemoryContext:
103312 total in 5 blocks; 3016 free (16 chunks); 100296 used
2024-08-07 00:29:37.135 CEST [ANALYZE] LOG: level: 3; Analyze: 719051800
total in 97 blocks; 65893672 free (72921 chunks); 653158128 used
2024-08-07 00:29:38.240 CEST [ANALYZE] LOG: level: 4; Analyze Column:
2514825352 total in 311 blocks; 971944296 free (3569593 chunks); 1542881056
used
2024-08-07 00:29:38.240 CEST [ANALYZE] LOG: level: 5; Analyzed elements
table: 176291896 total in 32 blocks; 2744968 free (99 chunks); 173546928
used
2024-08-07 00:29:38.240 CEST [ANALYZE] LOG: level: 1; CacheMemoryContext:
1048576 total in 8 blocks; 497776 free (1 chunks); 550800 used
2024-08-07 00:29:38.241 CEST [ANALYZE] LOG: Grand total: 3411991216 bytes
in 655 blocks; 1041309416 free (3642770 chunks); 2370681800 used
2024-08-07 00:29:38.365 CEST [ANALYZE] LOG: level: 0; TopMemoryContext:
103312 total in 5 blocks; 3016 free (16 chunks); 100296 used
2024-08-07 00:29:38.387 CEST [ANALYZE] LOG: level: 3; Analyze: 719051800
total in 97 blocks; 65893672 free (72921 chunks); 653158128 used
2024-08-07 00:29:39.445 CEST [ANALYZE] LOG: level: 4; Analyze Column:
2523213960 total in 312 blocks; 951048440 free (3470998 chunks); 1572165520
used
2024-08-07 00:29:39.445 CEST [ANALYZE] LOG: level: 5; Analyzed elements
table: 176291896 total in 32 blocks; 2744968 free (99 chunks); 173546928
used
2024-08-07 00:29:39.445 CEST [ANALYZE] LOG: level: 1; CacheMemoryContext:
1048576 total in 8 blocks; 497776 free (1 chunks); 550800 used
2024-08-07 00:29:39.447 CEST [ANALYZE] LOG: Grand total: 3420379824 bytes
in 656 blocks; 1020413560 free (3544175 chunks); 2399966264 used
2024-08-07 00:29:40.366 CEST [ANALYZE] LOG: level: 0; TopMemoryContext:
103312 total in 5 blocks; 3016 free (16 chunks); 100296 used
2024-08-07 00:29:40.386 CEST [ANALYZE] LOG: level: 3; Analyze: 719051800
total in 97 blocks; 65893672 free (72921 chunks); 653158128 used
2024-08-07 00:29:41.202 CEST [ANALYZE] LOG: level: 4; Analyze Column:
2539991176 total in 314 blocks; 748817776 free (2737184 chunks); 1791173400
used
2024-08-07 00:29:41.202 CEST [ANALYZE] LOG: level: 5; Analyzed elements
table: 176291896 total in 32 blocks; 2744968 free (99 chunks); 173546928
used
2024-08-07 00:29:41.202 CEST [ANALYZE] LOG: level: 1; CacheMemoryContext:
1048576 total in 8 blocks; 497776 free (1 chunks); 550800 used
2024-08-07 00:29:41.203 CEST [ANALYZE] LOG: Grand total: 3437157040 bytes
in 658 blocks; 818182896 free (2810361 chunks); 2618974144 used
2024-08-07 00:29:42.365 CEST [ANALYZE] LOG: level: 0; TopMemoryContext:
103312 total in 5 blocks; 3016 free (16 chunks); 100296 used
2024-08-07 00:29:42.386 CEST [ANALYZE] LOG: level: 3; Analyze: 719051800
total in 97 blocks; 65893672 free (72921 chunks); 653158128 used
2024-08-07 00:29:42.931 CEST [ANALYZE] LOG: level: 4; Analyze Column:
2565157000 total in 317 blocks; 500130936 free (1816002 chunks); 2065026064
used
2024-08-07 00:29:42.931 CEST [ANALYZE] LOG: level: 5; Analyzed elements
table: 176291896 total in 32 blocks; 2744968 free (99 chunks); 173546928
used
2024-08-07 00:29:42.931 CEST [ANALYZE] LOG: level: 1; CacheMemoryContext:
1048576 total in 8 blocks; 497776 free (1 chunks); 550800 used
2024-08-07 00:29:42.932 CEST [ANALYZE] LOG: Grand total: 3462322864 bytes
in 661 blocks; 569496056 free (1889179 chunks); 2892826808 used
2024-08-07 00:29:44.365 CEST [ANALYZE] LOG: level: 0; TopMemoryContext:
103312 total in 5 blocks; 3016 free (16 chunks); 100296 used
2024-08-07 00:29:44.386 CEST [ANALYZE] LOG: level: 3; Analyze: 719051800
total in 97 blocks; 65893672 free (72921 chunks); 653158128 used
2024-08-07 00:29:44.620 CEST [ANALYZE] LOG: level: 4; Analyze Column:
2590322824 total in 320 blocks; 213820960 free (776935 chunks); 2376501864
used
2024-08-07 00:29:44.620 CEST [ANALYZE] LOG: level: 5; Analyzed elements
table: 176291896 total in 32 blocks; 2744968 free (99 chunks); 173546928
used
2024-08-07 00:29:44.620 CEST [ANALYZE] LOG: level: 1; CacheMemoryContext:
1048576 total in 8 blocks; 497776 free (1 chunks); 550800 used
2024-08-07 00:29:44.621 CEST [ANALYZE] LOG: Grand total: 3487488688 bytes
in 664 blocks; 283186080 free (850112 chunks); 3204302608 used
2024-08-07 00:29:55.930 CEST [ANALYZE] LOG: level: 0; TopMemoryContext:
103312 total in 5 blocks; 3016 free (16 chunks); 100296 used
2024-08-07 00:29:55.950 CEST [ANALYZE] LOG: level: 3; Analyze: 719051800
total in 97 blocks; 65893672 free (72921 chunks); 653158128 used
2024-08-07 00:29:57.026 CEST [ANALYZE] LOG: level: 4; Analyze Column:
2707763336 total in 334 blocks; 976822904 free (3570508 chunks); 1730940432
used
2024-08-07 00:29:57.026 CEST [ANALYZE] LOG: level: 0; TopMemoryContext:
103312 total in 5 blocks; 3016 free (16 chunks); 100296 used
2024-08-07 00:29:57.047 CEST [ANALYZE] LOG: level: 3; Analyze: 719051800
total in 97 blocks; 65893672 free (72921 chunks); 653158128 used
2024-08-07 00:29:58.103 CEST [ANALYZE] LOG: level: 4; Analyze Column:
2707763336 total in 334 blocks; 976822904 free (3570508 chunks); 1730940432
used
2024-08-07 00:29:58.103 CEST [ANALYZE] LOG: level: 5; Analyzed elements
table: 176291896 total in 32 blocks; 2744968 free (99 chunks); 173546928
used
2024-08-07 00:29:58.103 CEST [ANALYZE] LOG: level: 1; CacheMemoryContext:
1048576 total in 8 blocks; 497776 free (1 chunks); 550800 used
2024-08-07 00:29:58.104 CEST [ANALYZE] LOG: Grand total: 3604929200 bytes
in 678 blocks; 1046188024 free (3643685 chunks); 2558741176 used
2024-08-07 00:29:58.104 CEST [ANALYZE] LOG: level: 5; Analyzed elements
table: 176291896 total in 32 blocks; 2744968 free (99 chunks); 173546928
used
2024-08-07 00:29:58.104 CEST [ANALYZE] LOG: level: 1; CacheMemoryContext:
1048576 total in 8 blocks; 497776 free (1 chunks); 550800 used
2024-08-07 00:29:58.105 CEST [ANALYZE] LOG: Grand total: 3604929200 bytes
in 678 blocks; 1046188024 free (3643685 chunks); 2558741176 used
2024-08-07 00:29:58.365 CEST [ANALYZE] LOG: level: 0; TopMemoryContext:
103312 total in 5 blocks; 3016 free (16 chunks); 100296 used
2024-08-07 00:29:58.386 CEST [ANALYZE] LOG: level: 3; Analyze: 719051800
total in 97 blocks; 65893672 free (72921 chunks); 653158128 used
2024-08-07 00:29:59.392 CEST [ANALYZE] LOG: level: 4; Analyze Column:
2716151944 total in 335 blocks; 923832088 free (3367875 chunks); 1792319856
used
2024-08-07 00:29:59.392 CEST [ANALYZE] LOG: level: 5; Analyzed elements
table: 176291896 total in 32 blocks; 2744968 free (99 chunks); 173546928
used
2024-08-07 00:29:59.392 CEST [ANALYZE] LOG: level: 1; CacheMemoryContext:
1048576 total in 8 blocks; 497776 free (1 chunks); 550800 used
2024-08-07 00:29:59.393 CEST [ANALYZE] LOG: Grand total: 3613317808 bytes
in 679 blocks; 993197208 free (3441052 chunks); 2620120600 used
2024-08-07 00:30:00.366 CEST [ANALYZE] LOG: level: 0; TopMemoryContext:
103312 total in 5 blocks; 3016 free (16 chunks); 100296 used
2024-08-07 00:30:00.389 CEST [ANALYZE] LOG: level: 3; Analyze: 719051800
total in 97 blocks; 65893672 free (72921 chunks); 653158128 used
2024-08-07 00:30:01.232 CEST [ANALYZE] LOG: level: 4; Analyze Column:
2732929160 total in 337 blocks; 718808000 free (2624988 chunks); 2014121160
used
2024-08-07 00:30:01.233 CEST [ANALYZE] LOG: level: 5; Analyzed elements
table: 176291896 total in 32 blocks; 2744968 free (99 chunks); 173546928
used
2024-08-07 00:30:01.233 CEST [ANALYZE] LOG: level: 1; CacheMemoryContext:
1048576 total in 8 blocks; 497776 free (1 chunks); 550800 used
2024-08-07 00:30:01.233 CEST [ANALYZE] LOG: Grand total: 3630095024 bytes
in 681 blocks; 788173120 free (2698165 chunks); 2841921904 used
2024-08-07 00:30:02.365 CEST [ANALYZE] LOG: level: 0; TopMemoryContext:
103312 total in 5 blocks; 3016 free (16 chunks); 100296 used
2024-08-07 00:30:02.387 CEST [ANALYZE] LOG: level: 3; Analyze: 719051800
total in 97 blocks; 65893672 free (72921 chunks); 653158128 used
2024-08-07 00:30:02.933 CEST [ANALYZE] LOG: level: 4; Analyze Column:
2749706376 total in 339 blocks; 492398968 free (1806761 chunks); 2257307408
used
2024-08-07 00:30:02.933 CEST [ANALYZE] LOG: level: 5; Analyzed elements
table: 176291896 total in 32 blocks; 2744968 free (99 chunks); 173546928
used
2024-08-07 00:30:02.933 CEST [ANALYZE] LOG: level: 1; CacheMemoryContext:
1048576 total in 8 blocks; 497776 free (1 chunks); 550800 used
2024-08-07 00:30:02.934 CEST [ANALYZE] LOG: Grand total: 3646872240 bytes
in 683 blocks; 561764088 free (1879938 chunks); 3085108152 used
2024-08-07 00:30:04.365 CEST [ANALYZE] LOG: level: 0; TopMemoryContext:
103312 total in 5 blocks; 3016 free (16 chunks); 100296 used
2024-08-07 00:30:04.387 CEST [ANALYZE] LOG: level: 3; Analyze: 719051800
total in 97 blocks; 65893672 free (72921 chunks); 653158128 used
2024-08-07 00:30:04.640 CEST [ANALYZE] LOG: level: 4; Analyze Column:
2783260808 total in 343 blocks; 235812832 free (839113 chunks); 2547447976
used
2024-08-07 00:30:04.641 CEST [ANALYZE] LOG: level: 5; Analyzed elements
table: 176291896 total in 32 blocks; 2744968 free (99 chunks); 173546928
used
2024-08-07 00:30:04.641 CEST [ANALYZE] LOG: level: 1; CacheMemoryContext:
1048576 total in 8 blocks; 497776 free (1 chunks); 550800 used
2024-08-07 00:30:04.641 CEST [ANALYZE] LOG: Grand total: 3680426672 bytes
in 687 blocks; 305177952 free (912290 chunks); 3375248720 used
2024-08-07 00:30:12.479 CEST [ANALYZE] LOG: level: 0; TopMemoryContext:
103312 total in 5 blocks; 3016 free (16 chunks); 100296 used
2024-08-07 00:30:12.500 CEST [ANALYZE] LOG: level: 3; Analyze: 719051800
total in 97 blocks; 65893672 free (72921 chunks); 653158128 used
2024-08-07 00:30:13.582 CEST [ANALYZE] LOG: level: 4; Analyze Column:
2900701320 total in 357 blocks; 979114264 free (3569308 chunks); 1921587056
used
2024-08-07 00:30:13.582 CEST [ANALYZE] LOG: level: 5; Analyzed elements
table: 176291896 total in 32 blocks; 2744968 free (99 chunks); 173546928
used
2024-08-07 00:30:13.582 CEST [ANALYZE] LOG: level: 1; CacheMemoryContext:
1048576 total in 8 blocks; 497776 free (1 chunks); 550800 used
2024-08-07 00:30:13.584 CEST [ANALYZE] LOG: Grand total: 3797867184 bytes
in 701 blocks; 1048479384 free (3642485 chunks); 2749387800 used
2024-08-07 00:30:14.365 CEST [ANALYZE] LOG: level: 0; TopMemoryContext:
103312 total in 5 blocks; 3016 free (16 chunks); 100296 used
2024-08-07 00:30:14.386 CEST [ANALYZE] LOG: level: 3; Analyze: 719051800
total in 97 blocks; 65893672 free (72921 chunks); 653158128 used
2024-08-07 00:30:15.269 CEST [ANALYZE] LOG: level: 4; Analyze Column:
2909089928 total in 358 blocks; 807934728 free (2969655 chunks); 2101155200
used
2024-08-07 00:30:15.269 CEST [ANALYZE] LOG: level: 5; Analyzed elements
table: 176291896 total in 32 blocks; 2744968 free (99 chunks); 173546928
used
2024-08-07 00:30:15.269 CEST [ANALYZE] LOG: level: 1; CacheMemoryContext:
1048576 total in 8 blocks; 497776 free (1 chunks); 550800 used
2024-08-07 00:30:15.270 CEST [ANALYZE] LOG: Grand total: 3806255792 bytes
in 702 blocks; 877299848 free (3042832 chunks); 2928955944 used
2024-08-07 00:30:16.365 CEST [ANALYZE] LOG: level: 0; TopMemoryContext:
103312 total in 5 blocks; 3016 free (16 chunks); 100296 used
2024-08-07 00:30:16.387 CEST [ANALYZE] LOG: level: 3; Analyze: 719051800
total in 97 blocks; 65893672 free (72921 chunks); 653158128 used
2024-08-07 00:30:17.024 CEST [ANALYZE] LOG: level: 4; Analyze Column:
2934255752 total in 361 blocks; 595141584 free (2172688 chunks); 2339114168
used
2024-08-07 00:30:17.024 CEST [ANALYZE] LOG: level: 5; Analyzed elements
table: 176291896 total in 32 blocks; 2744968 free (99 chunks); 173546928
used
2024-08-07 00:30:17.024 CEST [ANALYZE] LOG: level: 1; CacheMemoryContext:
1048576 total in 8 blocks; 497776 free (1 chunks); 550800 used
2024-08-07 00:30:17.025 CEST [ANALYZE] LOG: Grand total: 3831421616 bytes
in 705 blocks; 664506704 free (2245865 chunks); 3166914912 used
2024-08-07 00:30:18.365 CEST [ANALYZE] LOG: level: 0; TopMemoryContext:
103312 total in 5 blocks; 3016 free (16 chunks); 100296 used
2024-08-07 00:30:18.386 CEST [ANALYZE] LOG: level: 3; Analyze: 719051800
total in 97 blocks; 65893672 free (72921 chunks); 653158128 used
2024-08-07 00:30:18.753 CEST [ANALYZE] LOG: level: 4; Analyze Column:
2959421576 total in 364 blocks; 337129848 free (1227165 chunks); 2622291728
used
2024-08-07 00:30:18.753 CEST [ANALYZE] LOG: level: 5; Analyzed elements
table: 176291896 total in 32 blocks; 2744968 free (99 chunks); 173546928
used
2024-08-07 00:30:18.753 CEST [ANALYZE] LOG: level: 1; CacheMemoryContext:
1048576 total in 8 blocks; 497776 free (1 chunks); 550800 used
2024-08-07 00:30:18.753 CEST [ANALYZE] LOG: Grand total: 3856587440 bytes
in 708 blocks; 406494968 free (1300342 chunks); 3450092472 used
2024-08-07 00:30:20.365 CEST [ANALYZE] LOG: level: 0; TopMemoryContext:
103312 total in 5 blocks; 3016 free (16 chunks); 100296 used
2024-08-07 00:30:20.386 CEST [ANALYZE] LOG: level: 3; Analyze: 719051800
total in 97 blocks; 65893672 free (72921 chunks); 653158128 used
2024-08-07 00:30:20.426 CEST [ANALYZE] LOG: level: 4; Analyze Column:
2984587400 total in 367 blocks; 37881960 free (138800 chunks); 2946705440
used
2024-08-07 00:30:20.427 CEST [ANALYZE] LOG: level: 5; Analyzed elements
table: 176291896 total in 32 blocks; 2744968 free (99 chunks); 173546928
used
2024-08-07 00:30:20.427 CEST [ANALYZE] LOG: level: 1; CacheMemoryContext:
1048576 total in 8 blocks; 497776 free (1 chunks); 550800 used
2024-08-07 00:30:20.428 CEST [ANALYZE] LOG: Grand total: 3881753264 bytes
in 711 blocks; 107247080 free (211977 chunks); 3774506184 used
2024-08-07 00:30:27.056 CEST [ANALYZE] LOG: level: 0; TopMemoryContext:
103312 total in 5 blocks; 3016 free (16 chunks); 100296 used
2024-08-07 00:30:27.076 CEST [ANALYZE] LOG: level: 3; Analyze: 719051800
total in 97 blocks; 65893672 free (72921 chunks); 653158128 used
2024-08-07 00:30:28.143 CEST [ANALYZE] LOG: level: 4; Analyze Column:
3085250696 total in 379 blocks; 972706424 free (3570591 chunks); 2112544272
used
2024-08-07 00:30:28.143 CEST [ANALYZE] LOG: level: 5; Analyzed elements
table: 176291896 total in 32 blocks; 2744968 free (99 chunks); 173546928
used
2024-08-07 00:30:28.143 CEST [ANALYZE] LOG: level: 1; CacheMemoryContext:
1048576 total in 8 blocks; 497776 free (1 chunks); 550800 used
2024-08-07 00:30:28.144 CEST [ANALYZE] LOG: Grand total: 3982416560 bytes
in 723 blocks; 1042071544 free (3643768 chunks); 2940345016 used
2024-08-07 00:30:28.365 CEST [ANALYZE] LOG: level: 0; TopMemoryContext:
103312 total in 5 blocks; 3016 free (16 chunks); 100296 used
2024-08-07 00:30:28.386 CEST [ANALYZE] LOG: level: 3; Analyze: 719051800
total in 97 blocks; 65893672 free (72921 chunks); 653158128 used
2024-08-07 00:30:29.393 CEST [ANALYZE] LOG: level: 4; Analyze Column:
3093639304 total in 380 blocks; 930016848 free (3399412 chunks); 2163622456
used
2024-08-07 00:30:29.393 CEST [ANALYZE] LOG: level: 5; Analyzed elements
table: 176291896 total in 32 blocks; 2744968 free (99 chunks); 173546928
used
2024-08-07 00:30:29.393 CEST [ANALYZE] LOG: level: 1; CacheMemoryContext:
1048576 total in 8 blocks; 497776 free (1 chunks); 550800 used
2024-08-07 00:30:29.394 CEST [ANALYZE] LOG: Grand total: 3990805168 bytes
in 724 blocks; 999381968 free (3472589 chunks); 2991423200 used
2024-08-07 00:30:30.366 CEST [ANALYZE] LOG: level: 0; TopMemoryContext:
103312 total in 5 blocks; 3016 free (16 chunks); 100296 used
2024-08-07 00:30:30.390 CEST [ANALYZE] LOG: level: 3; Analyze: 719051800
total in 97 blocks; 65893672 free (72921 chunks); 653158128 used
2024-08-07 00:30:31.178 CEST [ANALYZE] LOG: level: 4; Analyze Column:
3110416520 total in 382 blocks; 715755928 free (2622513 chunks); 2394660592
used
2024-08-07 00:30:31.178 CEST [ANALYZE] LOG: level: 5; Analyzed elements
table: 176291896 total in 32 blocks; 2744968 free (99 chunks); 173546928
used
2024-08-07 00:30:31.179 CEST [ANALYZE] LOG: level: 1; CacheMemoryContext:
1048576 total in 8 blocks; 497776 free (1 chunks); 550800 used
2024-08-07 00:30:31.180 CEST [ANALYZE] LOG: Grand total: 4007582384 bytes
in 726 blocks; 785121048 free (2695690 chunks); 3222461336 used
2024-08-07 00:30:32.366 CEST [ANALYZE] LOG: level: 0; TopMemoryContext:
103312 total in 5 blocks; 3016 free (16 chunks); 100296 used
2024-08-07 00:30:32.386 CEST [ANALYZE] LOG: level: 3; Analyze: 719051800
total in 97 blocks; 65893672 free (72921 chunks); 653158128 used
2024-08-07 00:30:32.903 CEST [ANALYZE] LOG: level: 4; Analyze Column:
3135582344 total in 385 blocks; 473839648 free (1725329 chunks); 2661742696
used
2024-08-07 00:30:32.903 CEST [ANALYZE] LOG: level: 5; Analyzed elements
table: 176291896 total in 32 blocks; 2744968 free (99 chunks); 173546928
used
2024-08-07 00:30:32.903 CEST [ANALYZE] LOG: level: 1; CacheMemoryContext:
1048576 total in 8 blocks; 497776 free (1 chunks); 550800 used
2024-08-07 00:30:32.905 CEST [ANALYZE] LOG: Grand total: 4032748208 bytes
in 729 blocks; 543204768 free (1798506 chunks); 3489543440 used
2024-08-07 00:30:34.365 CEST [ANALYZE] LOG: level: 0; TopMemoryContext:
103312 total in 5 blocks; 3016 free (16 chunks); 100296 used
2024-08-07 00:30:34.387 CEST [ANALYZE] LOG: level: 3; Analyze: 719051800
total in 97 blocks; 65893672 free (72921 chunks); 653158128 used
2024-08-07 00:30:34.607 CEST [ANALYZE] LOG: level: 4; Analyze Column:
3160748168 total in 388 blocks; 200644920 free (731299 chunks); 2960103248
used
2024-08-07 00:30:34.607 CEST [ANALYZE] LOG: level: 5; Analyzed elements
table: 176291896 total in 32 blocks; 2744968 free (99 chunks); 173546928
used
2024-08-07 00:30:34.607 CEST [ANALYZE] LOG: level: 1; CacheMemoryContext:
1048576 total in 8 blocks; 497776 free (1 chunks); 550800 used
2024-08-07 00:30:34.608 CEST [ANALYZE] LOG: Grand total: 4057914032 bytes
in 732 blocks; 270010040 free (804476 chunks); 3787903992 used
2024-08-07 00:30:42.372 CEST [ANALYZE] LOG: level: 0; TopMemoryContext:
103312 total in 5 blocks; 3016 free (16 chunks); 100296 used
2024-08-07 00:30:42.394 CEST [ANALYZE] LOG: level: 3; Analyze: 719051800
total in 97 blocks; 65893672 free (72921 chunks); 653158128 used
2024-08-07 00:30:43.482 CEST [ANALYZE] LOG: level: 4; Analyze Column:
3278188680 total in 402 blocks; 976447592 free (3569332 chunks); 2301741088
used
2024-08-07 00:30:43.483 CEST [ANALYZE] LOG: level: 5; Analyzed elements
table: 176291896 total in 32 blocks; 2744968 free (99 chunks); 173546928
used
2024-08-07 00:30:43.483 CEST [ANALYZE] LOG: level: 1; CacheMemoryContext:
1048576 total in 8 blocks; 497776 free (1 chunks); 550800 used
2024-08-07 00:30:43.484 CEST [ANALYZE] LOG: Grand total: 4175354544 bytes
in 746 blocks; 1045812712 free (3642509 chunks); 3129541832 used
2024-08-07 00:30:44.365 CEST [ANALYZE] LOG: level: 0; TopMemoryContext:
103312 total in 5 blocks; 3016 free (16 chunks); 100296 used
2024-08-07 00:30:44.386 CEST [ANALYZE] LOG: level: 3; Analyze: 719051800
total in 97 blocks; 65893672 free (72921 chunks); 653158128 used
2024-08-07 00:30:45.256 CEST [ANALYZE] LOG: level: 4; Analyze Column:
3294965896 total in 404 blocks; 789028624 free (2885313 chunks); 2505937272
used
2024-08-07 00:30:45.256 CEST [ANALYZE] LOG: level: 5; Analyzed elements
table: 176291896 total in 32 blocks; 2744968 free (99 chunks); 173546928
used
2024-08-07 00:30:45.256 CEST [ANALYZE] LOG: level: 1; CacheMemoryContext:
1048576 total in 8 blocks; 497776 free (1 chunks); 550800 used
2024-08-07 00:30:45.256 CEST [ANALYZE] LOG: Grand total: 4192131760 bytes
in 748 blocks; 858393744 free (2958490 chunks); 3333738016 used
2024-08-07 00:30:46.365 CEST [ANALYZE] LOG: level: 0; TopMemoryContext:
103312 total in 5 blocks; 3016 free (16 chunks); 100296 used
2024-08-07 00:30:46.387 CEST [ANALYZE] LOG: level: 3; Analyze: 719051800
total in 97 blocks; 65893672 free (72921 chunks); 653158128 used
2024-08-07 00:30:47.015 CEST [ANALYZE] LOG: level: 4; Analyze Column:
3320131720 total in 407 blocks; 570659568 free (2070760 chunks); 2749472152
used
2024-08-07 00:30:47.015 CEST [ANALYZE] LOG: level: 5; Analyzed elements
table: 176291896 total in 32 blocks; 2744968 free (99 chunks); 173546928
used
2024-08-07 00:30:47.015 CEST [ANALYZE] LOG: level: 1; CacheMemoryContext:
1048576 total in 8 blocks; 497776 free (1 chunks); 550800 used
2024-08-07 00:30:47.016 CEST [ANALYZE] LOG: Grand total: 4217297584 bytes
in 751 blocks; 640024688 free (2143937 chunks); 3577272896 used
2024-08-07 00:30:48.365 CEST [ANALYZE] LOG: level: 0; TopMemoryContext:
103312 total in 5 blocks; 3016 free (16 chunks); 100296 used
2024-08-07 00:30:48.387 CEST [ANALYZE] LOG: level: 3; Analyze: 719051800
total in 97 blocks; 65893672 free (72921 chunks); 653158128 used
2024-08-07 00:30:48.732 CEST [ANALYZE] LOG: level: 4; Analyze Column:
3345297544 total in 410 blocks; 316240248 free (1134230 chunks); 3029057296
used
2024-08-07 00:30:48.732 CEST [ANALYZE] LOG: level: 5; Analyzed elements
table: 176291896 total in 32 blocks; 2744968 free (99 chunks); 173546928
used
2024-08-07 00:30:48.732 CEST [ANALYZE] LOG: level: 1; CacheMemoryContext:
1048576 total in 8 blocks; 497776 free (1 chunks); 550800 used
2024-08-07 00:30:48.733 CEST [ANALYZE] LOG: Grand total: 4242463408 bytes
in 754 blocks; 385605368 free (1207407 chunks); 3856858040 used
2024-08-07 00:30:50.365 CEST [ANALYZE] LOG: level: 0; TopMemoryContext:
103312 total in 5 blocks; 3016 free (16 chunks); 100296 used
2024-08-07 00:30:50.387 CEST [ANALYZE] LOG: level: 3; Analyze: 719051800
total in 97 blocks; 65893672 free (72921 chunks); 653158128 used
2024-08-07 00:30:50.397 CEST [ANALYZE] LOG: level: 4; Analyze Column:
3370463368 total in 413 blocks; 11253688 free (29310 chunks); 3359209680
used
2024-08-07 00:30:50.397 CEST [ANALYZE] LOG: level: 5; Analyzed elements
table: 176291896 total in 32 blocks; 2744968 free (99 chunks); 173546928
used
2024-08-07 00:30:50.397 CEST [ANALYZE] LOG: level: 1; CacheMemoryContext:
1048576 total in 8 blocks; 497776 free (1 chunks); 550800 used
2024-08-07 00:30:50.398 CEST [ANALYZE] LOG: Grand total: 4267629232 bytes
in 757 blocks; 80618808 free (102487 chunks); 4187010424 used
2024-08-07 00:30:56.887 CEST [ANALYZE] LOG: level: 0; TopMemoryContext:
103312 total in 5 blocks; 3016 free (16 chunks); 100296 used
2024-08-07 00:30:56.908 CEST [ANALYZE] LOG: level: 3; Analyze: 719051800
total in 97 blocks; 65893672 free (72921 chunks); 653158128 used
2024-08-07 00:30:57.970 CEST [ANALYZE] LOG: level: 4; Analyze Column:
3471126664 total in 425 blocks; 978627808 free (3569590 chunks); 2492498856
used
2024-08-07 00:30:57.970 CEST [ANALYZE] LOG: level: 5; Analyzed elements
table: 176291896 total in 32 blocks; 2744968 free (99 chunks); 173546928
used
2024-08-07 00:30:57.970 CEST [ANALYZE] LOG: level: 1; CacheMemoryContext:
1048576 total in 8 blocks; 497776 free (1 chunks); 550800 used
2024-08-07 00:30:57.971 CEST [ANALYZE] LOG: Grand total: 4368292528 bytes
in 769 blocks; 1047992928 free (3642767 chunks); 3320299600 used
2024-08-07 00:30:58.410 CEST [ANALYZE] LOG: level: 0; TopMemoryContext:
103312 total in 5 blocks; 6104 free (25 chunks); 97208 used
2024-08-07 00:30:58.411 CEST [ANALYZE] LOG: level: 1; CacheMemoryContext:
1048576 total in 8 blocks; 497328 free (1 chunks); 551248 used
2024-08-07 00:30:58.411 CEST [ANALYZE] LOG: Grand total: 1793496 bytes in
209 blocks; 706304 free (145 chunks); 1087192 used
2024-08-07 00:31:00.365 CEST [idle] LOG: level: 0; TopMemoryContext:
103312 total in 5 blocks; 6104 free (25 chunks); 97208 used
2024-08-07 00:31:00.366 CEST [idle] LOG: level: 1; CacheMemoryContext:
1048576 total in 8 blocks; 497328 free (1 chunks); 551248 used
2024-08-07 00:31:00.366 CEST [idle] LOG: Grand total: 1793496 bytes in
209 blocks; 713840 free (177 chunks); 1079656 used
2024-08-07 00:31:02.365 CEST [idle] LOG: level: 0; TopMemoryContext:
103312 total in 5 blocks; 6104 free (25 chunks); 97208 used
2024-08-07 00:31:02.366 CEST [idle] LOG: level: 1; CacheMemoryContext:
1048576 total in 8 blocks; 497328 free (1 chunks); 551248 used
2024-08-07 00:31:02.367 CEST [idle] LOG: Grand total: 1793496 bytes in
209 blocks; 713840 free (177 chunks); 1079656 used

Is there more I can do to identify why analyze uses that much memory?

Kind regards Ales Zeleny

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tender Wang 2024-08-07 04:01:35 Re: BUG #18568: BUG: Result wrong when do group by on partition table!
Previous Message Tom Lane 2024-08-06 20:55:15 Re: BUG #18571: A CTE with a DELETE auxiliary statement only deletes when the DELETE results are referenced later