表信息

[zjp-CN]

截止 2022-10-21

# src: https://gist.github.com/sanchezzzhak/511fd140e8809857f8f1d84ddb937015?permalink_comment_id=3159885#gistcomment-3159885
select concat(database, '.', table)                         as table,
       formatReadableSize(sum(bytes))                       as size,
       sum(rows)                                            as rows,
       max(modification_time)                               as latest_modification,
       sum(bytes)                                           as bytes_size,
       any(engine)                                          as engine,
       formatReadableSize(sum(primary_key_bytes_in_memory)) as primary_keys_size
from system.parts
where active
group by database, table
order by bytes_size desc;
┌─table──────────────────────────┬─size───────┬───────rows─┬─latest_modification─┬─bytes_size─┬─engine─────────────┬─primary_keys_size─┐ 
│ system.asynchronous_metric_log │ 4.25 GiB   │ 2444179502 │ 2023-02-13 20:18:27 │ 4560588878 │ MergeTree          │ 1.71 MiB          │ 
│ system.trace_log               │ 2.71 GiB   │  171533559 │ 2023-02-13 20:18:23 │ 2904611566 │ MergeTree          │ 123.02 KiB        │ 
│ system.metric_log_0            │ 783.74 MiB │   10896368 │ 2022-08-21 02:03:52 │  821812419 │ MergeTree          │ 16.40 KiB         │ 
│ rustdx.factor                  │ 443.94 MiB │   12455268 │ 2023-02-13 20:07:09 │  465499910 │ ReplacingMergeTree │ 11.92 KiB         │ 
│ system.metric_log              │ 438.22 MiB │    5927026 │ 2023-02-13 20:18:25 │  459510233 │ MergeTree          │ 9.96 KiB          │ 
│ rustdx.qfq                     │ 390.67 MiB │   12455268 │ 2022-10-21 15:16:01 │  409646375 │ MergeTree          │ 11.91 KiB         │ 
│ system.query_log_0             │ 471.58 KiB │       3410 │ 2022-08-16 15:35:54 │     482903 │ MergeTree          │ 48.00 B           │ 
│ system.query_thread_log_0      │ 470.06 KiB │       2629 │ 2022-08-16 15:34:05 │     481338 │ MergeTree          │ 48.00 B           │ 
│ system.query_log               │ 216.86 KiB │       1348 │ 2023-02-13 20:18:21 │     222065 │ MergeTree          │ 48.00 B           │ 
│ system.query_thread_log        │ 207.60 KiB │       1044 │ 2023-02-13 20:18:22 │     212579 │ MergeTree          │ 48.00 B           │ 
│ system.part_log                │ 142.46 KiB │       3902 │ 2023-02-13 20:16:16 │     145874 │ MergeTree          │ 120.00 B          │ 
│ rustdx.qfq_x                   │ 57.06 KiB  │       4831 │ 2022-10-21 15:15:36 │      58433 │ MergeTree          │ 20.00 B           │ 
│ system.session_log             │ 31.49 KiB  │       1186 │ 2022-08-16 15:35:52 │      32248 │ MergeTree          │ 48.00 B           │ 
│ rustdx.daily                   │ 1.48 KiB   │        218 │ 2022-10-21 16:06:04 │       1519 │ ReplacingMergeTree │ 20.00 B           │ 
│ rustdx.daily_tmp               │ 579.00 B   │         96 │ 2022-10-21 15:16:02 │        579 │ ReplacingMergeTree │ 20.00 B           │ 
│ rustdx.daily_prepare           │ 221.00 B   │          1 │ 2022-10-21 15:16:02 │        221 │ ReplacingMergeTree │ 20.00 B           │ 
│ default.test_insert            │ 99.00 B    │          1 │ 2022-07-02 23:31:35 │         99 │ ReplacingMergeTree │ 16.00 B           │ 
└────────────────────────────────┴────────────┴────────────┴─────────────────────┴────────────┴────────────────────┴───────────────────┘ 

select * from rustdx.factor ORDER BY date DESC LIMIT 3;
┌───────date─┬─code───┬───open─┬───high─┬───low─┬──close─┬────amount─┬───vol─┬─preclose─┬─────────────factor─┐
│ 2022-10-21 │ 688275 │ 206.64 │ 214.96 │ 206.6 │ 213.64 │ 378648500 │ 17857 │   206.67 │ 0.7197261851324536 │
│ 2022-10-21 │ 688273 │     36 │  36.75 │ 35.18 │   35.3 │  52705104 │ 14733 │    36.22 │  0.883215281359019 │
│ 2022-10-21 │ 688272 │  22.29 │  22.82 │ 21.77 │  22.27 │   8030155 │  3591 │    22.21 │  0.493877325837467 │
└────────────┴────────┴────────┴────────┴───────┴────────┴───────────┴───────┴──────────┴────────────────────┘