duet-ubuntu

::ffff:127.0.0.1

2025-01-10 18:26:03

[ "system.query_log.ProfileEvents", "system.query_log.Settings", "system.query_log.`thread_ids.size0`", "system.query_log.client_hostname", "system.query_log.client_name", "system.query_log.client_revision", "system.query_log.columns", "system.query_log.databases", "system.query_log.distributed_depth", "system.query_log.event_time", "system.query_log.event_time_microseconds", "system.query_log.exception", "system.query_log.exception_code", "system.query_log.formatted_query", "system.query_log.forwarded_for", "system.query_log.hostname", "system.query_log.http_method", "system.query_log.http_referer", "system.query_log.http_user_agent", "system.query_log.initial_address", "system.query_log.initial_port", "system.query_log.initial_query_id", "system.query_log.initial_query_start_time", "system.query_log.initial_user", "system.query_log.interface", "system.query_log.is_initial_query", "system.query_log.log_comment", "system.query_log.memory_usage", "system.query_log.missing_privileges", "system.query_log.partitions", "system.query_log.peak_threads_usage", "system.query_log.projections", "system.query_log.query", "system.query_log.query_cache_usage", "system.query_log.query_duration_ms", "system.query_log.query_id", "system.query_log.query_kind", "system.query_log.query_start_time", "system.query_log.query_start_time_microseconds", "system.query_log.quota_key", "system.query_log.read_rows", "system.query_log.result_rows", "system.query_log.revision", "system.query_log.stack_trace", "system.query_log.tables", "system.query_log.transaction_id", "system.query_log.type", "system.query_log.used_aggregate_function_combinators", "system.query_log.used_aggregate_functions", "system.query_log.used_data_type_families", "system.query_log.used_database_engines", "system.query_log.used_dictionaries", "system.query_log.used_formats", "system.query_log.used_functions", "system.query_log.used_privileges", "system.query_log.used_row_policies", "system.query_log.used_storages", "system.query_log.used_table_functions", "system.query_log.user", "system.query_log.views", "system.query_log.written_rows" ]

[ "system.query_log.202407", "system.query_log.202408", "system.query_log.202409", "system.query_log.202410", "system.query_log.202411", "system.query_log.202412", "system.query_log.202501" ]

clickhouse-js/0.3.1 (lv:nodejs/v20.18.0; os:linux)

3.82.100.37

0

{ "Query": "1", "SelectQuery": "1", "InitialQuery": "1", "QueriesWithSubqueries": "1", "SelectQueriesWithSubqueries": "1", "FileOpen": "21", "ReadBufferFromFileDescriptorReadBytes": "76143643", "ReadCompressedBytes": "71466666", "CompressedReadBufferBlocks": "997", "CompressedReadBufferBytes": "267528551", "OpenedFileCacheHits": "116", "OpenedFileCacheMisses": "21", "OpenedFileCacheMicroseconds": "157", "IOBufferAllocs": "272", "IOBufferAllocBytes": "27763730", "FunctionExecute": "956", "MarkCacheHits": "151", "CreatedReadBufferOrdinary": "137", "DiskReadElapsedMicroseconds": "12210", "NetworkReceiveElapsedMicroseconds": "10", "NetworkReceiveBytes": "5", "GlobalThreadPoolLockWaitMicroseconds": "1", "GlobalThreadPoolJobs": "2", "LocalThreadPoolExpansions": "1", "LocalThreadPoolThreadCreationMicroseconds": "32", "LocalThreadPoolLockWaitMicroseconds": "3", "LocalThreadPoolJobs": "4", "SelectedParts": "27", "SelectedPartsTotal": "27", "SelectedRanges": "27", "SelectedMarks": "908", "SelectedMarksTotal": "908", "SelectedRows": "6874843", "SelectedBytes": "311103537", "RowsReadByMainReader": "1878", "RowsReadByPrewhereReaders": "6874843", "WaitMarksLoadMicroseconds": "460", "ContextLock": "48", "ContextLockWaitMicroseconds": "35", "RWLockAcquiredReadLocks": "1", "PartsLockHoldMicroseconds": "19", "PartsLockWaitMicroseconds": "4", "RealTimeMicroseconds": "433436", "UserTimeMicroseconds": "193968", "SystemTimeMicroseconds": "26821", "SoftPageFaults": "6698", "OSCPUWaitMicroseconds": "9", "OSCPUVirtualTimeMicroseconds": "220779", "OSWriteBytes": "20480", "OSReadChars": "76143616", "OSWriteChars": "16384", "ThreadPoolReaderPageCacheHit": "662", "ThreadPoolReaderPageCacheHitBytes": "76143643", "ThreadPoolReaderPageCacheHitElapsedMicroseconds": "12210", "SynchronousReadWaitMicroseconds": "14069", "LogTrace": "60", "LogDebug": "4", "InterfaceHTTPReceiveBytes": "5", "ConcurrencyControlSlotsGranted": "1", "ConcurrencyControlSlotsAcquired": "1" }

{ "max_insert_threads": "4", "max_threads": "1", "merge_tree_max_rows_to_use_cache": "10485760", "merge_tree_max_bytes_to_use_cache": "20132659200", "do_not_merge_across_partitions_select_final": "1", "enable_http_compression": "1", "http_connection_timeout": "10", "http_send_timeout": "3600", "http_receive_timeout": "300", "result_overflow_mode": "throw", "max_execution_time": "60", "log_query_threads": "0", "enable_optimize_predicate_expression": "1", "use_query_cache": "0", "query_cache_nondeterministic_function_handling": "ignore", "query_cache_system_table_handling": "save", "query_cache_max_entries": "0", "query_cache_ttl": "120", "async_insert": "1", "wait_for_async_insert": "1", "async_insert_use_adaptive_busy_timeout": "1", "allow_experimental_analyzer": "1", "allow_experimental_join_condition": "1" }

[ "LowCardinality", "String", "Array" ]

[ "SELECT(type, query_id, query_kind, query_cache_usage, query_duration_ms, event_time_microseconds, query_start_time_microseconds, query_start_time, event_time, query, is_initial_query, formatted_query, user, read_rows, written_rows, result_rows, memory_usage, `thread_ids.size0`, peak_threads_usage, interface, hostname, client_hostname, client_name, client_revision, initial_user, initial_query_id, initial_address, initial_port, initial_query_start_time, databases, tables, columns, partitions, projections, views, exception_code, exception, stack_trace, http_method, http_user_agent, http_referer, forwarded_for, quota_key, distributed_depth, revision, log_comment, ProfileEvents, Settings, used_aggregate_functions, used_aggregate_function_combinators, used_database_engines, used_data_type_families, used_dictionaries, used_formats, used_functions, used_storages, used_table_functions, used_row_policies, used_privileges, missing_privileges, transaction_id) ON system.query_log" ]