SELECT
    table,
    count(),
    active,
    partition,
    formatReadableSize(sum(bytes_on_disk)) AS size
FROM system.parts
WHERE database = 'graphite'
GROUP BY
    table,
    partition,
    active
ORDER BY
    table ASC,
    partition ASC

┌─table─────────────────────┬─count()─┬─active─┬─partition─┬─size───────┐
│ data_deltadelta           │       1 │      1 │ 201906    │ 12.41 GiB  │
│ data_experiment_reference │       1 │      1 │ 201906    │ 21.53 GiB  │


SELECT *
FROM system.columns
WHERE (database = 'graphite') AND (table IN ('data_experiment_reference', 'data_deltadelta'))
ORDER BY
    name ASC,
    table ASC

Row 1:
──────
database:                graphite
table:                   data_deltadelta
name:                    date
type:                    Date
default_kind:
default_expression:
data_compressed_bytes:   23579646
data_uncompressed_bytes: 7639437004
marks_bytes:             89524680
comment:
is_in_partition_key:     1
is_in_sorting_key:       0
is_in_primary_key:       0
is_in_sampling_key:      0
compression_codec:       CODEC(Delta(2), ZSTD(3))

Row 2:
──────
database:                graphite
table:                   data_experiment_reference
name:                    date
type:                    Date
default_kind:
default_expression:
data_compressed_bytes:   60568233
data_uncompressed_bytes: 7639437004
marks_bytes:             89524680
comment:
is_in_partition_key:     1
is_in_sorting_key:       0
is_in_primary_key:       0
is_in_sampling_key:      0
compression_codec:

Row 3:
──────
database:                graphite
table:                   data_deltadelta
name:                    metric
type:                    String
default_kind:
default_expression:
data_compressed_bytes:   1113350153
data_uncompressed_bytes: 214716083159
marks_bytes:             89524680
comment:
is_in_partition_key:     0
is_in_sorting_key:       1
is_in_primary_key:       1
is_in_sampling_key:      0
compression_codec:

Row 4:
──────
database:                graphite
table:                   data_experiment_reference
name:                    metric
type:                    String
default_kind:
default_expression:
data_compressed_bytes:   1113350153
data_uncompressed_bytes: 214716083159
marks_bytes:             89524680
comment:
is_in_partition_key:     0
is_in_sorting_key:       1
is_in_primary_key:       1
is_in_sampling_key:      0
compression_codec:

Row 5:
──────
database:                graphite
table:                   data_deltadelta
name:                    timestamp
type:                    UInt32
default_kind:
default_expression:
data_compressed_bytes:   148197469
data_uncompressed_bytes: 15278874008
marks_bytes:             89524680
comment:
is_in_partition_key:     0
is_in_sorting_key:       1
is_in_primary_key:       1
is_in_sampling_key:      0
compression_codec:       CODEC(DoubleDelta, ZSTD(3))

Row 6:
──────
database:                graphite
table:                   data_experiment_reference
name:                    timestamp
type:                    UInt32
default_kind:
default_expression:
data_compressed_bytes:   5940686002
data_uncompressed_bytes: 15278874008
marks_bytes:             89524680
comment:
is_in_partition_key:     0
is_in_sorting_key:       1
is_in_primary_key:       1
is_in_sampling_key:      0
compression_codec:

Row 7:
──────
database:                graphite
table:                   data_deltadelta
name:                    updated
type:                    UInt32
default_kind:
default_expression:
data_compressed_bytes:   865308103
data_uncompressed_bytes: 15278874008
marks_bytes:             89524680
comment:
is_in_partition_key:     0
is_in_sorting_key:       0
is_in_primary_key:       0
is_in_sampling_key:      0
compression_codec:       CODEC(DoubleDelta, ZSTD(3))

Row 8:
──────
database:                graphite
table:                   data_experiment_reference
name:                    updated
type:                    UInt32
default_kind:
default_expression:
data_compressed_bytes:   6947465658
data_uncompressed_bytes: 15278874008
marks_bytes:             89524680
comment:
is_in_partition_key:     0
is_in_sorting_key:       0
is_in_primary_key:       0
is_in_sampling_key:      0
compression_codec:

Row 9:
───────
database:                graphite
table:                   data_deltadelta
name:                    value
type:                    Float64
default_kind:
default_expression:
data_compressed_bytes:   10504543964
data_uncompressed_bytes: 30557748016
marks_bytes:             89524680
comment:
is_in_partition_key:     0
is_in_sorting_key:       0
is_in_primary_key:       0
is_in_sampling_key:      0
compression_codec:       CODEC(Gorilla)

Row 10:
───────
database:                graphite
table:                   data_experiment_reference
name:                    value
type:                    Float64
default_kind:
default_expression:
data_compressed_bytes:   8387853514
data_uncompressed_bytes: 30557748016
marks_bytes:             89524680
comment:
is_in_partition_key:     0
is_in_sorting_key:       0
is_in_primary_key:       0
is_in_sampling_key:      0
compression_codec:

10 rows in set. Elapsed: 0.004 sec.