Query Stages

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": "27", "ReadBufferFromFileDescriptorReadBytes": "74580739", "ReadCompressedBytes": "71401705", "CompressedReadBufferBlocks": "1000", "CompressedReadBufferBytes": "264599372", "OpenedFileCacheHits": "114", "OpenedFileCacheMisses": "27", "OpenedFileCacheMicroseconds": "166", "IOBufferAllocs": "280", "IOBufferAllocBytes": "24940663", "FunctionExecute": "954", "MarkCacheHits": "145", "MarkCacheMisses": "5", "CreatedReadBufferOrdinary": "141", "DiskReadElapsedMicroseconds": "10431", "GlobalThreadPoolLockWaitMicroseconds": "1", "GlobalThreadPoolJobs": "2", "LocalThreadPoolExpansions": "1", "LocalThreadPoolThreadCreationMicroseconds": "42", "LocalThreadPoolLockWaitMicroseconds": "3", "LocalThreadPoolJobs": "4", "SelectedParts": "26", "SelectedPartsTotal": "26", "SelectedRanges": "26", "SelectedMarks": "907", "SelectedMarksTotal": "907", "SelectedRows": "6874955", "SelectedBytes": "309689760", "RowsReadByMainReader": "398", "RowsReadByPrewhereReaders": "6874955", "WaitMarksLoadMicroseconds": "746", "LoadedMarksCount": "614", "LoadedMarksMemoryBytes": "1544", "ContextLock": "48", "ContextLockWaitMicroseconds": "43", "RWLockAcquiredReadLocks": "1", "PartsLockHoldMicroseconds": "22", "PartsLockWaitMicroseconds": "4", "RealTimeMicroseconds": "424981", "UserTimeMicroseconds": "191699", "SystemTimeMicroseconds": "26356", "SoftPageFaults": "5384", "OSCPUWaitMicroseconds": "41", "OSCPUVirtualTimeMicroseconds": "218066", "OSWriteBytes": "8192", "OSReadChars": "74579968", "OSWriteChars": "16384", "ThreadPoolReaderPageCacheHit": "668", "ThreadPoolReaderPageCacheHitBytes": "74580739", "ThreadPoolReaderPageCacheHitElapsedMicroseconds": "10431", "SynchronousReadWaitMicroseconds": "12332", "LogTrace": "58", "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": "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" }

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