DC
Size: a a a
DC
AK
DC
K
select formatReadableSize(sum(bytes_allocated)) from system.dictionaries;
SELECT
database,
name,
formatReadableSize(total_bytes)
FROM system.tables
WHERE engine = 'Memory'
select formatReadableSize(sum(memory_usage)) from system.merges;
select formatReadableSize(sum(memory_usage)) from system.processes;
SELECT
initial_query_id,
formatReadableSize(memory_usage),
formatReadableSize(peak_memory_usage),
query
FROM system.processes
ORDER BY peak_memory_usage DESC
LIMIT 10
SELECT
initial_query_id,
formatReadableSize(memory_usage),
query
FROM system.query_log
WHERE (event_date >= today()) AND (event_time >= (now() - 7200))
ORDER BY memory_usage DESC
LIMIT 10
database,
name,
formatReadableSize(total_bytes)
FROM system.tables
WHERE engine
= 'Join'
┌─
database─┬─
name───────────────┬─
formatReadableSize(total_bytes)─┐
│
database │ attribution_source │ ᴺᵁᴸᴸ │
DC
database,
name,
formatReadableSize(total_bytes)
FROM system.tables
WHERE engine
= 'Join'
┌─
database─┬─
name───────────────┬─
formatReadableSize(total_bytes)─┐
│
database │ attribution_source │ ᴺᵁᴸᴸ │
create table j(A Int64, S String) Engine=Join( any,left, A) ;
insert into j select number, '' from numbers(1000000);
SELECT
database,
name,
formatReadableSize(total_bytes)
FROM system.tables
WHERE engine = 'Join'
┌─database─┬─name─┬─formatReadableSize(total_bytes)─┐
│ dw │ j │ 96.00 MiB │
└──────────┴──────┴─────────────────────────────────┘
K
create table j(A Int64, S String) Engine=Join( any,left, A) ;
insert into j select number, '' from numbers(1000000);
SELECT
database,
name,
formatReadableSize(total_bytes)
FROM system.tables
WHERE engine = 'Join'
┌─database─┬─name─┬─formatReadableSize(total_bytes)─┐
│ dw │ j │ 96.00 MiB │
└──────────┴──────┴─────────────────────────────────┘
ClickHouse server version 20.8.9 revision 54438
DC
ClickHouse server version 20.8.9 revision 54438
K
DC
K
DC
ВВ
DC
GA
AK
GA
AS
Ok.
0 rows in set. Elapsed 0.053 sec.
S
Ok.
0 rows in set. Elapsed 0.053 sec.