Thread: BUG #18573: Analyze command consumes several GB of memory - more than analyzed table size
BUG #18573: Analyze command consumes several GB of memory - more than analyzed table size
From
PG Bug reporting form
Date:
The following bug has been logged on the website:
Bug reference: 18573
Logged by: Aleš Zelený
Email address: zeleny.ales@gmail.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@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@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@pgsql-powa-1 log]$ sysctl -q vm.nr_hugepages
vm.nr_hugepages = 0
[UAT][postgres@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@pgsql-powa-1 log]$ grep 66b2a2e8.13b46 postgresql.log >
analyze_mem_info_t3.log
[UAT][postgres@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
Re: BUG #18573: Analyze command consumes several GB of memory - more than analyzed table size
From
Tom Lane
Date:
PG Bug reporting form <noreply@postgresql.org> writes:
> Is there more I can do to identify why analyze uses that much memory?
What have you got default_statistics_target set to?
You might need to decrease the stats target for that composite-array
column. compute_array_stats is fairly aggressive about how much
data it will try to collect, and I can believe that that'd add up
when the array elements are of a wide composite type.
regards, tom lane
Re: BUG #18573: Analyze command consumes several GB of memory - more than analyzed table size
From
Aleš Zelený
Date:
Hello,
the default statistics target is:
powa=# show default_statistics_target ;
default_statistics_target
---------------------------
2500
(1 row)
default_statistics_target
---------------------------
2500
(1 row)
So I've changed it to the default:
powa=# ALTER TABLE testcase_t3 ALTER COLUMN records SET STATISTICS 100;
ALTER TABLE
ALTER TABLE
The memory consumption drops down to ~ 1.1GB
So you were right, thanks!
I thought it was a bug, but possibly it is only a space for an improvement for adding a potential limit for similar cases.
Kind regards Ales Zeleny
st 7. 8. 2024 v 16:46 odesílatel Tom Lane <tgl@sss.pgh.pa.us> napsal:
PG Bug reporting form <noreply@postgresql.org> writes:
> Is there more I can do to identify why analyze uses that much memory?
What have you got default_statistics_target set to?
You might need to decrease the stats target for that composite-array
column. compute_array_stats is fairly aggressive about how much
data it will try to collect, and I can believe that that'd add up
when the array elements are of a wide composite type.
regards, tom lane
Re: BUG #18573: Analyze command consumes several GB of memory - more than analyzed table size
From
Tom Lane
Date:
=?UTF-8?B?QWxlxaEgWmVsZW7DvQ==?= <zeleny.ales@gmail.com> writes:
> the default statistics target is:
> 2500
> So I've changed it to the default:
> powa=# ALTER TABLE testcase_t3 ALTER COLUMN records SET STATISTICS 100;
> The memory consumption drops down to ~ 1.1GB
> So you were right, thanks!
Yeah, the array statistics collection code is a bit of a memory hog
compared to most other data types. I'm not sure that's a bug exactly;
there are more kinds of stats that we want to collect for arrays, such
as per-element stats.
regards, tom lane
Re: BUG #18573: Analyze command consumes several GB of memory - more than analyzed table size
From
Muhammad Waqas
Date:
what is the size of table?
2024년 8월 8일 (목) 오후 1:31, Aleš Zelený <zeleny.ales@gmail.com>님이 작성:
Hello,the default statistics target is:powa=# show default_statistics_target ;
default_statistics_target
---------------------------
2500
(1 row)So I've changed it to the default:powa=# ALTER TABLE testcase_t3 ALTER COLUMN records SET STATISTICS 100;
ALTER TABLEThe memory consumption drops down to ~ 1.1GBSo you were right, thanks!I thought it was a bug, but possibly it is only a space for an improvement for adding a potential limit for similar cases.Kind regards Ales Zelenyst 7. 8. 2024 v 16:46 odesílatel Tom Lane <tgl@sss.pgh.pa.us> napsal:PG Bug reporting form <noreply@postgresql.org> writes:
> Is there more I can do to identify why analyze uses that much memory?
What have you got default_statistics_target set to?
You might need to decrease the stats target for that composite-array
column. compute_array_stats is fairly aggressive about how much
data it will try to collect, and I can believe that that'd add up
when the array elements are of a wide composite type.
regards, tom lane
Muhammad Waqas
Senior Technical Support Engineer - Tech Support Center (Karachi)
Mobile: +92-322-2844150
Email: waqas.m@bitnine.net
1st floor, suit no F-04, COLABS Karachi, 8-C Khayaban-e-Tanzeem,
DHA Phase 5 Tauheed Commercial Area,
Defense V Defense Housing Authority, Karachi, Karachi City, Sindh,
75500 Pakistan.
Re: BUG #18573: Analyze command consumes several GB of memory - more than analyzed table size
From
Aleš Zelený
Date:
Hello,
the table size is 1681 MB. (it was in the bug report, but it has to be clearer on top of the message).
Kind regards Ales Zeleny
pá 9. 8. 2024 v 6:45 odesílatel Muhammad Waqas <waqas.m@bitnine.net> napsal:
what is the size of table?2024년 8월 8일 (목) 오후 1:31, Aleš Zelený <zeleny.ales@gmail.com>님이 작성:Hello,the default statistics target is:powa=# show default_statistics_target ;
default_statistics_target
---------------------------
2500
(1 row)So I've changed it to the default:powa=# ALTER TABLE testcase_t3 ALTER COLUMN records SET STATISTICS 100;
ALTER TABLEThe memory consumption drops down to ~ 1.1GBSo you were right, thanks!I thought it was a bug, but possibly it is only a space for an improvement for adding a potential limit for similar cases.Kind regards Ales Zelenyst 7. 8. 2024 v 16:46 odesílatel Tom Lane <tgl@sss.pgh.pa.us> napsal:PG Bug reporting form <noreply@postgresql.org> writes:
> Is there more I can do to identify why analyze uses that much memory?
What have you got default_statistics_target set to?
You might need to decrease the stats target for that composite-array
column. compute_array_stats is fairly aggressive about how much
data it will try to collect, and I can believe that that'd add up
when the array elements are of a wide composite type.
regards, tom lane--Muhammad WaqasSenior Technical Support Engineer - Tech Support Center (Karachi)Mobile: +92-322-2844150Email: waqas.m@bitnine.net1st floor, suit no F-04, COLABS Karachi, 8-C Khayaban-e-Tanzeem,DHA Phase 5 Tauheed Commercial Area,Defense V Defense Housing Authority, Karachi, Karachi City, Sindh,75500 Pakistan.