Skip to content

Instantly share code, notes, and snippets.

@filimonov
Created June 23, 2022 07:52
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save filimonov/c83fdf988398c062f6fe5b3344c35e80 to your computer and use it in GitHub Desktop.
Save filimonov/c83fdf988398c062f6fe5b3344c35e80 to your computer and use it in GitHub Desktop.
create table N (s String) Engine=MergeTree ORDER BY tuple();
create materialized view nv_mv1 Engine=MergeTree ORDER BY tuple() as select * from N;
create materialized view nv_mv2 Engine=MergeTree ORDER BY tuple() as select * from N;
==== 22.3
select * from system.query_log where query like '%INSERT%'\G
query_duration_ms: 3
read_rows: 2
read_bytes: 20
written_rows: 3
written_bytes: 30
result_rows: 3
result_bytes: 3
select * from query_views_log
view_name: default.nv_mv1
read_rows: 1
read_bytes: 10
written_rows: 1
written_bytes: 10
view_name: default.nv_mv2
read_rows: 1
read_bytes: 10
written_rows: 1
written_bytes: 10
==== 21.8.6
select * from system.query_log where query like '%INSERT%'\G
query_duration_ms: 3
read_rows: 0
read_bytes: 0
written_rows: 3
written_bytes: 30
result_rows: 1
result_bytes: 10
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment