max_insert_block_size effects when inserting via clickhouse-client

max_insert_block_size_sample.md

Default settings

create table xyz (number UInt64) Engine=MergeTree() ORDER BY number;

Inserting 100 mln numbers from CSV.

Each 'renaming' in log = one part created on the server.

root@2afa8d07f5da:/# clickhouse-local --query='SELECT * from numbers(100000000)' | clickhouse-client --query='insert into xyz format TSV' --send_logs_level='trace'
[2afa8d07f5da] 2019.05.24 12:27:42.639070 {22a41b10-aed9-4a01-b412-217e5e7d2c6a} [ 25 ] <Debug> executeQuery: (from 127.0.0.1:60030) insert into xyz format TSV
[2afa8d07f5da] 2019.05.24 12:27:42.803552 {22a41b10-aed9-4a01-b412-217e5e7d2c6a} [ 25 ] <Trace> default.xyz (Data): Renaming temporary part tmp_insert_all_21_21_0 to all_21_21_0.
[2afa8d07f5da] 2019.05.24 12:27:42.863285 {22a41b10-aed9-4a01-b412-217e5e7d2c6a} [ 25 ] <Trace> default.xyz (Data): Renaming temporary part tmp_insert_all_22_22_0 to all_22_22_0.
[2afa8d07f5da] 2019.05.24 12:27:42.917228 {22a41b10-aed9-4a01-b412-217e5e7d2c6a} [ 25 ] <Trace> default.xyz (Data): Renaming temporary part tmp_insert_all_23_23_0 to all_23_23_0.
[2afa8d07f5da] 2019.05.24 12:27:42.971274 {22a41b10-aed9-4a01-b412-217e5e7d2c6a} [ 25 ] <Trace> default.xyz (Data): Renaming temporary part tmp_insert_all_24_24_0 to all_24_24_0.
[2afa8d07f5da] 2019.05.24 12:27:43.033151 {22a41b10-aed9-4a01-b412-217e5e7d2c6a} [ 25 ] <Trace> default.xyz (Data): Renaming temporary part tmp_insert_all_25_25_0 to all_25_25_0.
[2afa8d07f5da] 2019.05.24 12:27:43.094098 {22a41b10-aed9-4a01-b412-217e5e7d2c6a} [ 25 ] <Trace> default.xyz (Data): Renaming temporary part tmp_insert_all_26_26_0 to all_26_26_0.
[2afa8d07f5da] 2019.05.24 12:27:43.156167 {22a41b10-aed9-4a01-b412-217e5e7d2c6a} [ 25 ] <Trace> default.xyz (Data): Renaming temporary part tmp_insert_all_27_27_0 to all_27_27_0.
[2afa8d07f5da] 2019.05.24 12:27:43.215559 {22a41b10-aed9-4a01-b412-217e5e7d2c6a} [ 25 ] <Trace> default.xyz (Data): Renaming temporary part tmp_insert_all_28_28_0 to all_28_28_0.
[2afa8d07f5da] 2019.05.24 12:27:43.275742 {22a41b10-aed9-4a01-b412-217e5e7d2c6a} [ 25 ] <Trace> default.xyz (Data): Renaming temporary part tmp_insert_all_29_29_0 to all_29_29_0.
[2afa8d07f5da] 2019.05.24 12:27:43.334983 {22a41b10-aed9-4a01-b412-217e5e7d2c6a} [ 25 ] <Trace> default.xyz (Data): Renaming temporary part tmp_insert_all_30_30_0 to all_30_30_0.
[2afa8d07f5da] 2019.05.24 12:27:43.390162 {22a41b10-aed9-4a01-b412-217e5e7d2c6a} [ 25 ] <Trace> default.xyz (Data): Renaming temporary part tmp_insert_all_31_31_0 to all_31_31_0.
[2afa8d07f5da] 2019.05.24 12:27:43.443443 {22a41b10-aed9-4a01-b412-217e5e7d2c6a} [ 25 ] <Trace> default.xyz (Data): Renaming temporary part tmp_insert_all_32_32_0 to all_32_32_0.
[2afa8d07f5da] 2019.05.24 12:27:43.503450 {22a41b10-aed9-4a01-b412-217e5e7d2c6a} [ 25 ] <Trace> default.xyz (Data): Renaming temporary part tmp_insert_all_33_33_0 to all_33_33_0.
[2afa8d07f5da] 2019.05.24 12:27:43.567915 {22a41b10-aed9-4a01-b412-217e5e7d2c6a} [ 25 ] <Trace> default.xyz (Data): Renaming temporary part tmp_insert_all_34_34_0 to all_34_34_0.
[2afa8d07f5da] 2019.05.24 12:27:43.627890 {22a41b10-aed9-4a01-b412-217e5e7d2c6a} [ 25 ] <Trace> default.xyz (Data): Renaming temporary part tmp_insert_all_35_35_0 to all_35_35_0.
[2afa8d07f5da] 2019.05.24 12:27:43.686433 {22a41b10-aed9-4a01-b412-217e5e7d2c6a} [ 25 ] <Trace> default.xyz (Data): Renaming temporary part tmp_insert_all_36_36_0 to all_36_36_0.
[2afa8d07f5da] 2019.05.24 12:27:43.748213 {22a41b10-aed9-4a01-b412-217e5e7d2c6a} [ 25 ] <Trace> default.xyz (Data): Renaming temporary part tmp_insert_all_37_37_0 to all_37_37_0.
[2afa8d07f5da] 2019.05.24 12:27:43.804197 {22a41b10-aed9-4a01-b412-217e5e7d2c6a} [ 25 ] <Trace> default.xyz (Data): Renaming temporary part tmp_insert_all_38_38_0 to all_38_38_0.
[2afa8d07f5da] 2019.05.24 12:27:43.967816 {22a41b10-aed9-4a01-b412-217e5e7d2c6a} [ 25 ] <Trace> default.xyz (Data): Renaming temporary part tmp_insert_all_39_39_0 to all_39_39_0.
[2afa8d07f5da] 2019.05.24 12:27:44.023599 {22a41b10-aed9-4a01-b412-217e5e7d2c6a} [ 25 ] <Trace> default.xyz (Data): Renaming temporary part tmp_insert_all_40_40_0 to all_40_40_0.
[2afa8d07f5da] 2019.05.24 12:27:44.097958 {22a41b10-aed9-4a01-b412-217e5e7d2c6a} [ 25 ] <Trace> default.xyz (Data): Renaming temporary part tmp_insert_all_41_41_0 to all_41_41_0.
[2afa8d07f5da] 2019.05.24 12:27:44.150528 {22a41b10-aed9-4a01-b412-217e5e7d2c6a} [ 25 ] <Trace> default.xyz (Data): Renaming temporary part tmp_insert_all_42_42_0 to all_42_42_0.
[2afa8d07f5da] 2019.05.24 12:27:44.209767 {22a41b10-aed9-4a01-b412-217e5e7d2c6a} [ 25 ] <Trace> default.xyz (Data): Renaming temporary part tmp_insert_all_43_43_0 to all_43_43_0.
[2afa8d07f5da] 2019.05.24 12:27:44.269443 {22a41b10-aed9-4a01-b412-217e5e7d2c6a} [ 25 ] <Trace> default.xyz (Data): Renaming temporary part tmp_insert_all_44_44_0 to all_44_44_0.
[2afa8d07f5da] 2019.05.24 12:27:44.319684 {22a41b10-aed9-4a01-b412-217e5e7d2c6a} [ 25 ] <Trace> default.xyz (Data): Renaming temporary part tmp_insert_all_45_45_0 to all_45_45_0.
[2afa8d07f5da] 2019.05.24 12:27:44.373982 {22a41b10-aed9-4a01-b412-217e5e7d2c6a} [ 25 ] <Trace> default.xyz (Data): Renaming temporary part tmp_insert_all_46_46_0 to all_46_46_0.
[2afa8d07f5da] 2019.05.24 12:27:44.433318 {22a41b10-aed9-4a01-b412-217e5e7d2c6a} [ 25 ] <Trace> default.xyz (Data): Renaming temporary part tmp_insert_all_47_47_0 to all_47_47_0.
[2afa8d07f5da] 2019.05.24 12:27:44.501382 {22a41b10-aed9-4a01-b412-217e5e7d2c6a} [ 25 ] <Trace> default.xyz (Data): Renaming temporary part tmp_insert_all_48_48_0 to all_48_48_0.
[2afa8d07f5da] 2019.05.24 12:27:44.564140 {22a41b10-aed9-4a01-b412-217e5e7d2c6a} [ 25 ] <Trace> default.xyz (Data): Renaming temporary part tmp_insert_all_49_49_0 to all_49_49_0.
[2afa8d07f5da] 2019.05.24 12:27:44.621421 {22a41b10-aed9-4a01-b412-217e5e7d2c6a} [ 25 ] <Trace> default.xyz (Data): Renaming temporary part tmp_insert_all_50_50_0 to all_50_50_0.
[2afa8d07f5da] 2019.05.24 12:27:44.680446 {22a41b10-aed9-4a01-b412-217e5e7d2c6a} [ 25 ] <Trace> default.xyz (Data): Renaming temporary part tmp_insert_all_51_51_0 to all_51_51_0.
[2afa8d07f5da] 2019.05.24 12:27:44.735572 {22a41b10-aed9-4a01-b412-217e5e7d2c6a} [ 25 ] <Trace> default.xyz (Data): Renaming temporary part tmp_insert_all_52_52_0 to all_52_52_0.
[2afa8d07f5da] 2019.05.24 12:27:44.800907 {22a41b10-aed9-4a01-b412-217e5e7d2c6a} [ 25 ] <Trace> default.xyz (Data): Renaming temporary part tmp_insert_all_53_53_0 to all_53_53_0.
[2afa8d07f5da] 2019.05.24 12:27:44.857867 {22a41b10-aed9-4a01-b412-217e5e7d2c6a} [ 25 ] <Trace> default.xyz (Data): Renaming temporary part tmp_insert_all_54_54_0 to all_54_54_0.
[2afa8d07f5da] 2019.05.24 12:27:44.983257 {22a41b10-aed9-4a01-b412-217e5e7d2c6a} [ 25 ] <Trace> default.xyz (Data): Renaming temporary part tmp_insert_all_55_55_0 to all_55_55_0.
[2afa8d07f5da] 2019.05.24 12:27:45.043064 {22a41b10-aed9-4a01-b412-217e5e7d2c6a} [ 25 ] <Trace> default.xyz (Data): Renaming temporary part tmp_insert_all_56_56_0 to all_56_56_0.
[2afa8d07f5da] 2019.05.24 12:27:45.106063 {22a41b10-aed9-4a01-b412-217e5e7d2c6a} [ 25 ] <Trace> default.xyz (Data): Renaming temporary part tmp_insert_all_57_57_0 to all_57_57_0.
[2afa8d07f5da] 2019.05.24 12:27:45.173832 {22a41b10-aed9-4a01-b412-217e5e7d2c6a} [ 25 ] <Trace> default.xyz (Data): Renaming temporary part tmp_insert_all_58_58_0 to all_58_58_0.
[2afa8d07f5da] 2019.05.24 12:27:45.240076 {22a41b10-aed9-4a01-b412-217e5e7d2c6a} [ 25 ] <Trace> default.xyz (Data): Renaming temporary part tmp_insert_all_59_59_0 to all_59_59_0.
[2afa8d07f5da] 2019.05.24 12:27:45.305202 {22a41b10-aed9-4a01-b412-217e5e7d2c6a} [ 25 ] <Trace> default.xyz (Data): Renaming temporary part tmp_insert_all_60_60_0 to all_60_60_0.
[2afa8d07f5da] 2019.05.24 12:27:45.368615 {22a41b10-aed9-4a01-b412-217e5e7d2c6a} [ 25 ] <Trace> default.xyz (Data): Renaming temporary part tmp_insert_all_61_61_0 to all_61_61_0.
[2afa8d07f5da] 2019.05.24 12:27:45.426768 {22a41b10-aed9-4a01-b412-217e5e7d2c6a} [ 25 ] <Trace> default.xyz (Data): Renaming temporary part tmp_insert_all_62_62_0 to all_62_62_0.
[2afa8d07f5da] 2019.05.24 12:27:45.487823 {22a41b10-aed9-4a01-b412-217e5e7d2c6a} [ 25 ] <Trace> default.xyz (Data): Renaming temporary part tmp_insert_all_63_63_0 to all_63_63_0.
[2afa8d07f5da] 2019.05.24 12:27:45.546826 {22a41b10-aed9-4a01-b412-217e5e7d2c6a} [ 25 ] <Trace> default.xyz (Data): Renaming temporary part tmp_insert_all_64_64_0 to all_64_64_0.
[2afa8d07f5da] 2019.05.24 12:27:45.602890 {22a41b10-aed9-4a01-b412-217e5e7d2c6a} [ 25 ] <Trace> default.xyz (Data): Renaming temporary part tmp_insert_all_65_65_0 to all_65_65_0.
[2afa8d07f5da] 2019.05.24 12:27:45.663199 {22a41b10-aed9-4a01-b412-217e5e7d2c6a} [ 25 ] <Trace> default.xyz (Data): Renaming temporary part tmp_insert_all_66_66_0 to all_66_66_0.
[2afa8d07f5da] 2019.05.24 12:27:45.724094 {22a41b10-aed9-4a01-b412-217e5e7d2c6a} [ 25 ] <Trace> default.xyz (Data): Renaming temporary part tmp_insert_all_67_67_0 to all_67_67_0.
[2afa8d07f5da] 2019.05.24 12:27:45.784591 {22a41b10-aed9-4a01-b412-217e5e7d2c6a} [ 25 ] <Trace> default.xyz (Data): Renaming temporary part tmp_insert_all_68_68_0 to all_68_68_0.
[2afa8d07f5da] 2019.05.24 12:27:45.844793 {22a41b10-aed9-4a01-b412-217e5e7d2c6a} [ 25 ] <Trace> default.xyz (Data): Renaming temporary part tmp_insert_all_69_69_0 to all_69_69_0.
[2afa8d07f5da] 2019.05.24 12:27:45.904834 {22a41b10-aed9-4a01-b412-217e5e7d2c6a} [ 25 ] <Trace> default.xyz (Data): Renaming temporary part tmp_insert_all_70_70_0 to all_70_70_0.
[2afa8d07f5da] 2019.05.24 12:27:45.964353 {22a41b10-aed9-4a01-b412-217e5e7d2c6a} [ 25 ] <Trace> default.xyz (Data): Renaming temporary part tmp_insert_all_71_71_0 to all_71_71_0.
[2afa8d07f5da] 2019.05.24 12:27:46.025121 {22a41b10-aed9-4a01-b412-217e5e7d2c6a} [ 25 ] <Trace> default.xyz (Data): Renaming temporary part tmp_insert_all_72_72_0 to all_72_72_0.
[2afa8d07f5da] 2019.05.24 12:27:46.085235 {22a41b10-aed9-4a01-b412-217e5e7d2c6a} [ 25 ] <Trace> default.xyz (Data): Renaming temporary part tmp_insert_all_73_73_0 to all_73_73_0.
[2afa8d07f5da] 2019.05.24 12:27:46.144326 {22a41b10-aed9-4a01-b412-217e5e7d2c6a} [ 25 ] <Trace> default.xyz (Data): Renaming temporary part tmp_insert_all_74_74_0 to all_74_74_0.
[2afa8d07f5da] 2019.05.24 12:27:46.203224 {22a41b10-aed9-4a01-b412-217e5e7d2c6a} [ 25 ] <Trace> default.xyz (Data): Renaming temporary part tmp_insert_all_75_75_0 to all_75_75_0.
[2afa8d07f5da] 2019.05.24 12:27:46.263370 {22a41b10-aed9-4a01-b412-217e5e7d2c6a} [ 25 ] <Trace> default.xyz (Data): Renaming temporary part tmp_insert_all_76_76_0 to all_76_76_0.
[2afa8d07f5da] 2019.05.24 12:27:46.325261 {22a41b10-aed9-4a01-b412-217e5e7d2c6a} [ 25 ] <Trace> default.xyz (Data): Renaming temporary part tmp_insert_all_77_77_0 to all_77_77_0.
[2afa8d07f5da] 2019.05.24 12:27:46.386032 {22a41b10-aed9-4a01-b412-217e5e7d2c6a} [ 25 ] <Trace> default.xyz (Data): Renaming temporary part tmp_insert_all_78_78_0 to all_78_78_0.
[2afa8d07f5da] 2019.05.24 12:27:46.448154 {22a41b10-aed9-4a01-b412-217e5e7d2c6a} [ 25 ] <Trace> default.xyz (Data): Renaming temporary part tmp_insert_all_79_79_0 to all_79_79_0.
[2afa8d07f5da] 2019.05.24 12:27:46.508279 {22a41b10-aed9-4a01-b412-217e5e7d2c6a} [ 25 ] <Trace> default.xyz (Data): Renaming temporary part tmp_insert_all_80_80_0 to all_80_80_0.
[2afa8d07f5da] 2019.05.24 12:27:46.572640 {22a41b10-aed9-4a01-b412-217e5e7d2c6a} [ 25 ] <Trace> default.xyz (Data): Renaming temporary part tmp_insert_all_81_81_0 to all_81_81_0.
[2afa8d07f5da] 2019.05.24 12:27:46.635409 {22a41b10-aed9-4a01-b412-217e5e7d2c6a} [ 25 ] <Trace> default.xyz (Data): Renaming temporary part tmp_insert_all_82_82_0 to all_82_82_0.
[2afa8d07f5da] 2019.05.24 12:27:46.694757 {22a41b10-aed9-4a01-b412-217e5e7d2c6a} [ 25 ] <Trace> default.xyz (Data): Renaming temporary part tmp_insert_all_83_83_0 to all_83_83_0.
[2afa8d07f5da] 2019.05.24 12:27:46.757213 {22a41b10-aed9-4a01-b412-217e5e7d2c6a} [ 25 ] <Trace> default.xyz (Data): Renaming temporary part tmp_insert_all_84_84_0 to all_84_84_0.
[2afa8d07f5da] 2019.05.24 12:27:46.823345 {22a41b10-aed9-4a01-b412-217e5e7d2c6a} [ 25 ] <Trace> default.xyz (Data): Renaming temporary part tmp_insert_all_85_85_0 to all_85_85_0.
[2afa8d07f5da] 2019.05.24 12:27:46.903697 {22a41b10-aed9-4a01-b412-217e5e7d2c6a} [ 25 ] <Trace> default.xyz (Data): Renaming temporary part tmp_insert_all_86_86_0 to all_86_86_0.
[2afa8d07f5da] 2019.05.24 12:27:46.991692 {22a41b10-aed9-4a01-b412-217e5e7d2c6a} [ 25 ] <Trace> default.xyz (Data): Renaming temporary part tmp_insert_all_87_87_0 to all_87_87_0.
[2afa8d07f5da] 2019.05.24 12:27:47.071393 {22a41b10-aed9-4a01-b412-217e5e7d2c6a} [ 25 ] <Trace> default.xyz (Data): Renaming temporary part tmp_insert_all_88_88_0 to all_88_88_0.
[2afa8d07f5da] 2019.05.24 12:27:47.137977 {22a41b10-aed9-4a01-b412-217e5e7d2c6a} [ 25 ] <Trace> default.xyz (Data): Renaming temporary part tmp_insert_all_89_89_0 to all_89_89_0.
[2afa8d07f5da] 2019.05.24 12:27:47.193160 {22a41b10-aed9-4a01-b412-217e5e7d2c6a} [ 25 ] <Trace> default.xyz (Data): Renaming temporary part tmp_insert_all_90_90_0 to all_90_90_0.
[2afa8d07f5da] 2019.05.24 12:27:47.270551 {22a41b10-aed9-4a01-b412-217e5e7d2c6a} [ 25 ] <Trace> default.xyz (Data): Renaming temporary part tmp_insert_all_91_91_0 to all_91_91_0.
[2afa8d07f5da] 2019.05.24 12:27:47.331194 {22a41b10-aed9-4a01-b412-217e5e7d2c6a} [ 25 ] <Trace> default.xyz (Data): Renaming temporary part tmp_insert_all_92_92_0 to all_92_92_0.
[2afa8d07f5da] 2019.05.24 12:27:47.411883 {22a41b10-aed9-4a01-b412-217e5e7d2c6a} [ 25 ] <Trace> default.xyz (Data): Renaming temporary part tmp_insert_all_93_93_0 to all_93_93_0.
[2afa8d07f5da] 2019.05.24 12:27:47.485523 {22a41b10-aed9-4a01-b412-217e5e7d2c6a} [ 25 ] <Trace> default.xyz (Data): Renaming temporary part tmp_insert_all_94_94_0 to all_94_94_0.
[2afa8d07f5da] 2019.05.24 12:27:47.540780 {22a41b10-aed9-4a01-b412-217e5e7d2c6a} [ 25 ] <Trace> default.xyz (Data): Renaming temporary part tmp_insert_all_95_95_0 to all_95_95_0.
[2afa8d07f5da] 2019.05.24 12:27:47.589615 {22a41b10-aed9-4a01-b412-217e5e7d2c6a} [ 25 ] <Trace> default.xyz (Data): Renaming temporary part tmp_insert_all_96_96_0 to all_96_96_0.
[2afa8d07f5da] 2019.05.24 12:27:47.642057 {22a41b10-aed9-4a01-b412-217e5e7d2c6a} [ 25 ] <Trace> default.xyz (Data): Renaming temporary part tmp_insert_all_97_97_0 to all_97_97_0.
[2afa8d07f5da] 2019.05.24 12:27:47.700300 {22a41b10-aed9-4a01-b412-217e5e7d2c6a} [ 25 ] <Trace> default.xyz (Data): Renaming temporary part tmp_insert_all_98_98_0 to all_98_98_0.
[2afa8d07f5da] 2019.05.24 12:27:47.763494 {22a41b10-aed9-4a01-b412-217e5e7d2c6a} [ 25 ] <Trace> default.xyz (Data): Renaming temporary part tmp_insert_all_99_99_0 to all_99_99_0.
[2afa8d07f5da] 2019.05.24 12:27:47.830758 {22a41b10-aed9-4a01-b412-217e5e7d2c6a} [ 25 ] <Trace> default.xyz (Data): Renaming temporary part tmp_insert_all_100_100_0 to all_100_100_0.
[2afa8d07f5da] 2019.05.24 12:27:47.895956 {22a41b10-aed9-4a01-b412-217e5e7d2c6a} [ 25 ] <Trace> default.xyz (Data): Renaming temporary part tmp_insert_all_101_101_0 to all_101_101_0.
[2afa8d07f5da] 2019.05.24 12:27:47.969562 {22a41b10-aed9-4a01-b412-217e5e7d2c6a} [ 25 ] <Trace> default.xyz (Data): Renaming temporary part tmp_insert_all_102_102_0 to all_102_102_0.
[2afa8d07f5da] 2019.05.24 12:27:48.029262 {22a41b10-aed9-4a01-b412-217e5e7d2c6a} [ 25 ] <Trace> default.xyz (Data): Renaming temporary part tmp_insert_all_103_103_0 to all_103_103_0.
[2afa8d07f5da] 2019.05.24 12:27:48.105663 {22a41b10-aed9-4a01-b412-217e5e7d2c6a} [ 25 ] <Trace> default.xyz (Data): Renaming temporary part tmp_insert_all_104_104_0 to all_104_104_0.
[2afa8d07f5da] 2019.05.24 12:27:48.165132 {22a41b10-aed9-4a01-b412-217e5e7d2c6a} [ 25 ] <Trace> default.xyz (Data): Renaming temporary part tmp_insert_all_105_105_0 to all_105_105_0.
[2afa8d07f5da] 2019.05.24 12:27:48.221943 {22a41b10-aed9-4a01-b412-217e5e7d2c6a} [ 25 ] <Trace> default.xyz (Data): Renaming temporary part tmp_insert_all_106_106_0 to all_106_106_0.
[2afa8d07f5da] 2019.05.24 12:27:48.284537 {22a41b10-aed9-4a01-b412-217e5e7d2c6a} [ 25 ] <Trace> default.xyz (Data): Renaming temporary part tmp_insert_all_107_107_0 to all_107_107_0.
[2afa8d07f5da] 2019.05.24 12:27:48.351422 {22a41b10-aed9-4a01-b412-217e5e7d2c6a} [ 25 ] <Trace> default.xyz (Data): Renaming temporary part tmp_insert_all_108_108_0 to all_108_108_0.
[2afa8d07f5da] 2019.05.24 12:27:48.441809 {22a41b10-aed9-4a01-b412-217e5e7d2c6a} [ 25 ] <Trace> default.xyz (Data): Renaming temporary part tmp_insert_all_109_109_0 to all_109_109_0.
[2afa8d07f5da] 2019.05.24 12:27:48.525801 {22a41b10-aed9-4a01-b412-217e5e7d2c6a} [ 25 ] <Trace> default.xyz (Data): Renaming temporary part tmp_insert_all_110_110_0 to all_110_110_0.
[2afa8d07f5da] 2019.05.24 12:27:48.587165 {22a41b10-aed9-4a01-b412-217e5e7d2c6a} [ 25 ] <Trace> default.xyz (Data): Renaming temporary part tmp_insert_all_111_111_0 to all_111_111_0.
[2afa8d07f5da] 2019.05.24 12:27:48.656276 {22a41b10-aed9-4a01-b412-217e5e7d2c6a} [ 25 ] <Trace> default.xyz (Data): Renaming temporary part tmp_insert_all_112_112_0 to all_112_112_0.
[2afa8d07f5da] 2019.05.24 12:27:48.716353 {22a41b10-aed9-4a01-b412-217e5e7d2c6a} [ 25 ] <Trace> default.xyz (Data): Renaming temporary part tmp_insert_all_113_113_0 to all_113_113_0.
[2afa8d07f5da] 2019.05.24 12:27:48.777166 {22a41b10-aed9-4a01-b412-217e5e7d2c6a} [ 25 ] <Trace> default.xyz (Data): Renaming temporary part tmp_insert_all_114_114_0 to all_114_114_0.
[2afa8d07f5da] 2019.05.24 12:27:48.829862 {22a41b10-aed9-4a01-b412-217e5e7d2c6a} [ 25 ] <Trace> default.xyz (Data): Renaming temporary part tmp_insert_all_115_115_0 to all_115_115_0.
[2afa8d07f5da] 2019.05.24 12:27:48.851701 {22a41b10-aed9-4a01-b412-217e5e7d2c6a} [ 25 ] <Trace> default.xyz (Data): Renaming temporary part tmp_insert_all_116_116_0 to all_116_116_0.
[2afa8d07f5da] 2019.05.24 12:27:48.851878 {22a41b10-aed9-4a01-b412-217e5e7d2c6a} [ 25 ] <Debug> MemoryTracker: Peak memory usage (for query): 38.14 MiB.

max_insert_block_size=1000000000

root@2afa8d07f5da:/# clickhouse-local --query='SELECT * from numbers(100000000)' | clickhouse-client --query='insert into xyz format TSV' --max_insert_block_size=1000000000 --send_logs_level='trace'
[2afa8d07f5da] 2019.05.24 12:28:07.719924 {68c06c8a-b647-4a26-a57c-127b582d9e8f} [ 25 ] <Debug> executeQuery: (from 127.0.0.1:60032) insert into xyz format TSV
[2afa8d07f5da] 2019.05.24 12:28:11.469680 {68c06c8a-b647-4a26-a57c-127b582d9e8f} [ 25 ] <Debug> MemoryTracker: Current memory usage: 1.00 GiB.
[2afa8d07f5da] 2019.05.24 12:28:16.096100 {68c06c8a-b647-4a26-a57c-127b582d9e8f} [ 25 ] <Debug> MemoryTracker: Current memory usage: 2.00 GiB.
[2afa8d07f5da] 2019.05.24 12:28:22.281066 {68c06c8a-b647-4a26-a57c-127b582d9e8f} [ 25 ] <Trace> default.xyz (Data): Renaming temporary part tmp_insert_all_117_117_0 to all_117_117_0.
[2afa8d07f5da] 2019.05.24 12:28:22.488141 {68c06c8a-b647-4a26-a57c-127b582d9e8f} [ 25 ] <Debug> MemoryTracker: Peak memory usage (for query): 2.01 GiB.