ClickHouse MonitoringMonitoring

Table: system.query_views_log


ProfileEvents	`Map(String, UInt64)`	32.30 MiB	321.04 MiB	9.94	399.50 thousand	842.62	ProfileEvents that measure different metrics. The description of them could be found in the table system.events.
initial_query_id	`String`	10.07 MiB	13.82 MiB	1.37	399.50 thousand	36.28	ID of the initial query (for distributed query execution).
event_time_microseconds	`DateTime64(6)`	1.88 MiB	2.99 MiB	1.59	399.50 thousand	7.84	The date and time when the view finished execution with microseconds precision.
written_bytes	`UInt64`	1.67 MiB	2.99 MiB	1.79	399.50 thousand	7.84	Number of written bytes.
read_bytes	`UInt64`	1.67 MiB	2.99 MiB	1.79	399.50 thousand	7.84	Number of read bytes.
written_rows	`UInt64`	1.28 MiB	2.99 MiB	2.33	399.50 thousand	7.84	Number of written rows.
read_rows	`UInt64`	1.13 MiB	2.99 MiB	2.65	399.50 thousand	7.84	Number of read rows.
view_duration_ms	`UInt64`	1.08 MiB	2.99 MiB	2.76	399.50 thousand	7.84	Duration of view execution (sum of its stages) in milliseconds.
peak_memory_usage	`Int64`	1.02 MiB	2.99 MiB	2.92	399.50 thousand	7.84	The maximum difference between the amount of allocated and freed memory in context of this view.
event_time	`DateTime`	549.55 KiB	1.49 MiB	2.78	399.50 thousand	3.92	The date and time when the view finished execution.
view_query	`String`	459.49 KiB	35.77 MiB	79.71	399.50 thousand	93.87	The query executed by the view.
view_target	`String`	456.96 KiB	16.26 MiB	36.44	399.50 thousand	42.68	The name of the view target table.
view_name	`String`	387.84 KiB	16.75 MiB	44.22	399.50 thousand	43.96	Name of the view.
view_uuid	`UUID`	313.73 KiB	5.98 MiB	19.51	399.50 thousand	15.69	UUID of the view.
event_date	`Date`	3.48 KiB	765.15 KiB	220.15	399.50 thousand	1.96	The date when the last event of the view happened.
hostname	`LowCardinality(String)`	2.61 KiB	383.79 KiB	147.25	399.50 thousand	0.98	Hostname of the server executing the query.
status	`Enum8('QueryStart' = 1, 'QueryFinish' = 2, 'ExceptionBeforeStart' = 3, 'ExceptionWhileProcessing' = 4)`	1.78 KiB	382.57 KiB	215.37	399.50 thousand	0.98	Status of the view. Values: 'QueryStart' = 1 — Successful start the view execution. Should not appear, 'QueryFinish' = 2 — Successful end of the view execution, 'ExceptionBeforeStart' = 3 — Exception before the start of the view execution., 'ExceptionWhileProcessing' = 4 — Exception during the view execution.
view_type	`Enum8('Default' = 1, 'Materialized' = 2, 'Live' = 3, 'Window' = 4)`	1.78 KiB	382.57 KiB	215.37	399.50 thousand	0.98	Type of the view. Values: 'Default' = 1 — Default views. Should not appear in this log, 'Materialized' = 2 — Materialized views, 'Live' = 3 — Live views.
exception_code	`Int32`	416.00 B	612.00 B	1.47	399.50 thousand	0	Code of an exception.
stack_trace	`String`	416.00 B	612.00 B	1.47	399.50 thousand	0	Stack trace. An empty string, if the query was completed successfully.
exception	`String`	416.00 B	612.00 B	1.47	399.50 thousand	0	Exception message.

0 of 21 row(s) selected.

Table: system.query_views_log


ProfileEvents	`Map(String, UInt64)`	32.30 MiB	321.04 MiB	9.94	399.50 thousand	842.62	ProfileEvents that measure different metrics. The description of them could be found in the table system.events.
initial_query_id	`String`	10.07 MiB	13.82 MiB	1.37	399.50 thousand	36.28	ID of the initial query (for distributed query execution).
event_time_microseconds	`DateTime64(6)`	1.88 MiB	2.99 MiB	1.59	399.50 thousand	7.84	The date and time when the view finished execution with microseconds precision.
written_bytes	`UInt64`	1.67 MiB	2.99 MiB	1.79	399.50 thousand	7.84	Number of written bytes.
read_bytes	`UInt64`	1.67 MiB	2.99 MiB	1.79	399.50 thousand	7.84	Number of read bytes.
written_rows	`UInt64`	1.28 MiB	2.99 MiB	2.33	399.50 thousand	7.84	Number of written rows.
read_rows	`UInt64`	1.13 MiB	2.99 MiB	2.65	399.50 thousand	7.84	Number of read rows.
view_duration_ms	`UInt64`	1.08 MiB	2.99 MiB	2.76	399.50 thousand	7.84	Duration of view execution (sum of its stages) in milliseconds.
peak_memory_usage	`Int64`	1.02 MiB	2.99 MiB	2.92	399.50 thousand	7.84	The maximum difference between the amount of allocated and freed memory in context of this view.
event_time	`DateTime`	549.55 KiB	1.49 MiB	2.78	399.50 thousand	3.92	The date and time when the view finished execution.
view_query	`String`	459.49 KiB	35.77 MiB	79.71	399.50 thousand	93.87	The query executed by the view.
view_target	`String`	456.96 KiB	16.26 MiB	36.44	399.50 thousand	42.68	The name of the view target table.
view_name	`String`	387.84 KiB	16.75 MiB	44.22	399.50 thousand	43.96	Name of the view.
view_uuid	`UUID`	313.73 KiB	5.98 MiB	19.51	399.50 thousand	15.69	UUID of the view.
event_date	`Date`	3.48 KiB	765.15 KiB	220.15	399.50 thousand	1.96	The date when the last event of the view happened.
hostname	`LowCardinality(String)`	2.61 KiB	383.79 KiB	147.25	399.50 thousand	0.98	Hostname of the server executing the query.
status	`Enum8('QueryStart' = 1, 'QueryFinish' = 2, 'ExceptionBeforeStart' = 3, 'ExceptionWhileProcessing' = 4)`	1.78 KiB	382.57 KiB	215.37	399.50 thousand	0.98	Status of the view. Values: 'QueryStart' = 1 — Successful start the view execution. Should not appear, 'QueryFinish' = 2 — Successful end of the view execution, 'ExceptionBeforeStart' = 3 — Exception before the start of the view execution., 'ExceptionWhileProcessing' = 4 — Exception during the view execution.
view_type	`Enum8('Default' = 1, 'Materialized' = 2, 'Live' = 3, 'Window' = 4)`	1.78 KiB	382.57 KiB	215.37	399.50 thousand	0.98	Type of the view. Values: 'Default' = 1 — Default views. Should not appear in this log, 'Materialized' = 2 — Materialized views, 'Live' = 3 — Live views.
exception_code	`Int32`	416.00 B	612.00 B	1.47	399.50 thousand	0	Code of an exception.
stack_trace	`String`	416.00 B	612.00 B	1.47	399.50 thousand	0	Stack trace. An empty string, if the query was completed successfully.
exception	`String`	416.00 B	612.00 B	1.47	399.50 thousand	0	Exception message.

0 of 21 row(s) selected.

ClickHouse MonitoringMonitoring

View Full Query Details

Table: system.query_views_log

View Full Query Details

Table: system.query_views_log