# MonetDB 5 server v11.52.0
# This is an unreleased version
# Serving database 'mTests_sql_benchmarks_tpcds', using 8 threads
# Compiled for ppc64le-pc-linux-gnu/64bit
# Found 127.437 GiB available main-memory of which we use 103.861 GiB
# Virtual memory usage limited to 32.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://jewels11.scilens.private:37267/
# Listening for UNIX domain connection requests on mapi:monetdb:///tmp/mtest-2779140/.s.monetdb.37267
#2024-11-15 19:26:15: client0020: 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 19:26:15: client0020: 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 19:26:15: client0020: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-15 19:26:15: client0020: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-15 19:26:15: client0020: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-15 19:26:15: client0020: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-15 19:26:15: client0020: SQLrun: INFO: Executing: call sys.setsessiontimeout(360)
#2024-11-15 19:26:15: client0020: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-15 19:26:15: client0020: SQLrun: INFO: Executing: select sys.debug(0)
#SIGUSR1 info start
#Virtual memory allocated: 1916071688, of which 13627144 with malloc
#gdk_vm_maxsize: 34359738368, gdk_mem_maxsize: 111519755796
#gdk_mmap_minsize_persistent 262144, gdk_mmap_minsize_transient 4294967296
#Virtual size: 38419890176, anonymous RSS: 500367360, shared RSS: 1783955456 (together: 2284322816)
#BATs:
#fix, dirty, persistent, loaded, hot: 6 bats, 13312 virtual, 13312 malloc
#fix, dirty, transient, loaded, hot: 120 bats, 39112 virtual, 39112 malloc
#no fix, dirty, persistent, loaded, hot: 13 bats, 73216 virtual, 73216 malloc
#no fix, dirty, persistent, not loaded, hot: 122 bats, 87040 virtual, 87040 malloc
#no fix, dirty, transient, loaded, hot: 5 bats, 28835840 virtual, 0 malloc
#no fix, dirty, transient, not loaded, hot: 3 bats, 17301504 virtual, 0 malloc
#no fix, dirty, transient, not loaded, cold: 49 bats, 0 virtual, 0 malloc
#no fix, clean, persistent, loaded, hot: 325 bats, 907937622 virtual, 5965654 malloc
#no fix, clean, persistent, not loaded, cold: 263 bats, 0 virtual, 0 malloc
#no fix, clean, transient, loaded, hot: 38 bats, 534702080 virtual, 59392 malloc
#no fix, clean, transient, not loaded, hot: 11 bats, 123404288 virtual, 0 malloc
#no fix, clean, transient, not loaded, cold: 45 bats, 0 virtual, 0 malloc
#1660 bats total, 1000 in use, 413 free bats in common shared list
#Threads:
#client0020, tid 20, Thread 0x7ff785e0f120, LWP 2782810, 0 free bats, waiting for nothing, working on exiting
#heartbeat, tid 17, Thread 0x7ff78620f120, LWP 2782806, 0 free bats, waiting for nothing, working on sleeping
#listenThread, tid 16, Thread 0x7ff78040f120, LWP 2782805, 0 free bats, waiting for nothing, working on nothing
#logmanager, tid 15, Thread 0x7ff77560f120, LWP 2782804, 0 free bats, waiting for nothing, working on sleeping
#DFLOWworker0012, tid 12, Thread 0x7ff78660f120, LWP 2782787, 11 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0011, tid 11, Thread 0x7ff786a0f120, LWP 2782786, 32 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0010, tid 10, Thread 0x7ff786e0f120, LWP 2782785, 35 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0009, tid 9, Thread 0x7ff78720f120, LWP 2782784, 1 free bats, waiting for semaphore DFLOWsema0009, working on idle, waiting for new client
#DFLOWworker0008, tid 8, Thread 0x7ff78760f120, LWP 2782783, 39 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0007, tid 7, Thread 0x7ff787a0f120, LWP 2782782, 41 free bats, waiting for semaphore DFLOWsema0007, working on idle, waiting for new client
#DFLOWworker0006, tid 6, Thread 0x7ff787e0f120, LWP 2782781, 31 free bats, waiting for semaphore DFLOWsema0006, working on idle, waiting for new client
#DFLOWworker0005, tid 5, Thread 0x7ff78420f120, LWP 2782780, 15 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0004, tid 4, Thread 0x7ff78c60f120, LWP 2782779, 35 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0003, tid 3, Thread 0x7ff78ca0f120, LWP 2782778, 7 free bats, waiting for semaphore todo, working on waiting for work
#BBPmanager, tid 2, Thread 0x7fff9a60f120, LWP 2782777, 0 free bats, waiting for nothing, working on sleeping
#main thread, tid 1, Thread 0x7fffaa2f8aa0, LWP 2782776, 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 5
#current transaction id 3, saved transaction id 1
#number of flushers: 0
#number of catalog entries 825, of which 0 deleted
#pending range 6: drops 0, last_ts 43, flushed_ts 43, refcount 0
#pending range 7: drops 362354481, last_ts 284, flushed_ts 284, refcount 1, file size 33884 (current)
#SIGUSR1 info end
# mserver5 exiting