duet-ubuntu

::ffff:127.0.0.1

2025-01-10 18:29:58

[ "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": "16", "ReadBufferFromFileDescriptorReadBytes": "74579848", "ReadCompressedBytes": "71400814", "CompressedReadBufferBlocks": "995", "CompressedReadBufferBytes": "264589436", "OpenedFileCacheHits": "120", "OpenedFileCacheMisses": "16", "OpenedFileCacheMicroseconds": "139", "IOBufferAllocs": "270", "IOBufferAllocBytes": "24929206", "FunctionExecute": "954", "MarkCacheHits": "150", "QueryCacheMisses": "1", "CreatedReadBufferOrdinary": "136", "DiskReadElapsedMicroseconds": "9791", "GlobalThreadPoolLockWaitMicroseconds": "1", "GlobalThreadPoolJobs": "2", "LocalThreadPoolExpansions": "1", "LocalThreadPoolThreadCreationMicroseconds": "24", "LocalThreadPoolLockWaitMicroseconds": "2", "LocalThreadPoolJobs": "4", "SelectedParts": "26", "SelectedPartsTotal": "26", "SelectedRanges": "26", "SelectedMarks": "907", "SelectedMarksTotal": "907", "SelectedRows": "6874955", "SelectedBytes": "309689760", "RowsReadByMainReader": "398", "RowsReadByPrewhereReaders": "6874955", "WaitMarksLoadMicroseconds": "384", "ContextLock": "51", "ContextLockWaitMicroseconds": "57", "RWLockAcquiredReadLocks": "1", "PartsLockHoldMicroseconds": "15", "PartsLockWaitMicroseconds": "4", "RealTimeMicroseconds": "424978", "UserTimeMicroseconds": "186394", "SystemTimeMicroseconds": "32109", "SoftPageFaults": "5032", "OSCPUWaitMicroseconds": "41", "OSCPUVirtualTimeMicroseconds": "218463", "OSWriteBytes": "28672", "OSReadChars": "74579968", "OSWriteChars": "19456", "ThreadPoolReaderPageCacheHit": "663", "ThreadPoolReaderPageCacheHitBytes": "74579848", "ThreadPoolReaderPageCacheHitElapsedMicroseconds": "9791", "SynchronousReadWaitMicroseconds": "11679", "LogTrace": "59", "LogDebug": "4", "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": "300", "log_query_threads": "0", "enable_optimize_predicate_expression": "1", "use_query_cache": "1", "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" }

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

[ "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" ]