# MonetDB 5 server v11.52.0
# This is an unreleased version
# Serving database 'mTests_sql_benchmarks_tpcds', using 32 threads
# Compiled for x86_64-pc-linux-gnu/64bit with 128bit integers
# Found 7.741 GiB available main-memory of which we use 6.309 GiB
# Virtual memory usage limited to 8.000 GiB
# Copyright (c) 2024 MonetDB Foundation, all rights reserved
# Visit https://www.monetdb.org/ for further information
# MonetDB/GIS module loaded
# MonetDB/SQL module loaded
# Listening for connection requests on mapi:monetdb://lab01.da.cwi.nl:39407/
# Listening for UNIX domain connection requests on mapi:monetdb:///tmp/mtest-2439098/.s.monetdb.39407
#2024-11-15 20:27:59: client0043: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-11-15 20:27:59: client0043: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-11-15 20:27:59: client0043: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-15 20:27:59: client0043: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-15 20:27:59: client0043: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-15 20:27:59: client0043: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-15 20:27:59: client0043: SQLrun: INFO: Executing: call sys.setsessiontimeout(360)
#2024-11-15 20:27:59: client0043: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-15 20:27:59: client0043: SQLrun: INFO: Executing: select sys.debug(0)
#SIGUSR1 info start
#Virtual memory allocated: 1748083992, of which 13411608 with malloc
#gdk_vm_maxsize: 8589934592, gdk_mem_maxsize: 6774484049
#gdk_mmap_minsize_persistent 262144, gdk_mmap_minsize_transient 423405253
#Virtual size: 7100825600, anonymous RSS: 327483392, shared RSS: 1195646976 (together: 1523130368)
#BATs:
#fix, dirty, persistent, loaded, hot: 1 bats, 0 virtual, 0 malloc
#fix, dirty, transient, loaded, hot: 337 bats, 39112 virtual, 39112 malloc
#fix, clean, persistent, loaded, hot: 5 bats, 13312 virtual, 13312 malloc
#no fix, dirty, persistent, loaded, hot: 6 bats, 1536 virtual, 1536 malloc
#no fix, dirty, persistent, not loaded, hot: 111 bats, 0 virtual, 0 malloc
#no fix, dirty, transient, not loaded, cold: 49 bats, 0 virtual, 0 malloc
#no fix, clean, persistent, loaded, hot: 393 bats, 1589962859 virtual, 6154347 malloc
#no fix, clean, persistent, not loaded, cold: 315 bats, 0 virtual, 0 malloc
#3090 bats total, 1217 in use, 1122 free bats in common shared list
#Threads:
#client0043, tid 43, Thread 0x7f41faffe6c0, LWP 2440494, 0 free bats, waiting for nothing, working on exiting
#heartbeat, tid 40, Thread 0x7f41fb1ff6c0, LWP 2440490, 0 free bats, waiting for nothing, working on sleeping
#listenThread, tid 39, Thread 0x7f41fbf786c0, LWP 2440489, 0 free bats, waiting for nothing, working on nothing
#logmanager, tid 38, Thread 0x7f41fbd776c0, LWP 2440487, 10 free bats, waiting for nothing, working on sleeping
#DFLOWworker0035, tid 35, Thread 0x7f42091f96c0, LWP 2440484, 28 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0034, tid 34, Thread 0x7f42093fa6c0, LWP 2440483, 23 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0033, tid 33, Thread 0x7f42095fb6c0, LWP 2440482, 11 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0032, tid 32, Thread 0x7f42097fc6c0, LWP 2440481, 18 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0031, tid 31, Thread 0x7f42099fd6c0, LWP 2440480, 9 free bats, waiting for semaphore DFLOWsema0031, working on idle, waiting for new client
#DFLOWworker0030, tid 30, Thread 0x7f4209bfe6c0, LWP 2440479, 26 free bats, waiting for semaphore DFLOWsema0030, working on idle, waiting for new client
#DFLOWworker0029, tid 29, Thread 0x7f4209dff6c0, LWP 2440478, 22 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0028, tid 28, Thread 0x7f420a7fe6c0, LWP 2440477, 12 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0027, tid 27, Thread 0x7f420a9ff6c0, LWP 2440476, 25 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0026, tid 26, Thread 0x7f420b1ff6c0, LWP 2440475, 9 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0025, tid 25, Thread 0x7f420b7fe6c0, LWP 2440474, 45 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0024, tid 24, Thread 0x7f420bbff6c0, LWP 2440473, 21 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0023, tid 23, Thread 0x7f420c3ff6c0, LWP 2440472, 24 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0022, tid 22, Thread 0x7f420cbfe6c0, LWP 2440471, 45 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0021, tid 21, Thread 0x7f420cdff6c0, LWP 2440470, 6 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0020, tid 20, Thread 0x7f420d5ff6c0, LWP 2440469, 5 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0019, tid 19, Thread 0x7f420dbfe6c0, LWP 2440468, 16 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0018, tid 18, Thread 0x7f420ddff6c0, LWP 2440467, 30 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0017, tid 17, Thread 0x7f420e3fe6c0, LWP 2440466, 25 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0016, tid 16, Thread 0x7f420e9ff6c0, LWP 2440465, 12 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0015, tid 15, Thread 0x7f420efff6c0, LWP 2440464, 12 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0014, tid 14, Thread 0x7f420f5fe6c0, LWP 2440463, 37 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0013, tid 13, Thread 0x7f420fbff6c0, LWP 2440462, 9 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0012, tid 12, Thread 0x7f42103fe6c0, LWP 2440461, 26 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0011, tid 11, Thread 0x7f42105ff6c0, LWP 2440460, 11 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0010, tid 10, Thread 0x7f4210dff6c0, LWP 2440459, 35 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0009, tid 9, Thread 0x7f42113fe6c0, LWP 2440458, 44 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0008, tid 8, Thread 0x7f42117ff6c0, LWP 2440457, 21 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0007, tid 7, Thread 0x7f4211dfe6c0, LWP 2440456, 25 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0006, tid 6, Thread 0x7f42121ff6c0, LWP 2440455, 25 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0005, tid 5, Thread 0x7f42126fd6c0, LWP 2440454, 31 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0004, tid 4, Thread 0x7f42128fe6c0, LWP 2440453, 36 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0003, tid 3, Thread 0x7f4212aff6c0, LWP 2440452, 17 free bats, waiting for semaphore todo, working on waiting for work
#BBPmanager, tid 2, Thread 0x7f429d9ff6c0, LWP 2440451, 0 free bats, waiting for nothing, working on sleeping
#main thread, tid 1, Thread 0x7f42a0136180, LWP 2440450, 0 free bats, waiting for nothing, working on nothing
#Clients:
#0 active clients, 0 finishing clients, 0 blocked clients; max: 64
#WAL:
#SQL store oldest pending 284
#logger sql:
#current log file 7, last handled log file 6
#current transaction id 3, saved transaction id 2
#number of flushers: 0
#number of catalog entries 825, of which 0 deleted
#pending range 7: drops 362354481, last_ts 284, flushed_ts 284, refcount 1, file size 33884 (current)
#SIGUSR1 info end
# mserver5 exiting