Logo

ClickHouse MonitoringMonitoring

  • Overview

top usage tables

Most usage tables, ignore system tables, based on system.query_log (top 50). Click on table name to see top usage columns.

prodenv.`.stream_analytics.C2C_CAN_ghz`
1674800
prodenv.navigation_detail
269996
prodenv.`.device_shadow_latest`
57497
prodenv.ride_summary
52925
prodenv.stop
51244
prodenv.imu_sensor
41977
prodenv.ride_detail
23498
prodenv.C2C_CAN
21594
prodenv.action_result
16520
prodenv.vehicle_location
15700
prodenv.vehicle_state
15449
prodenv.sw_version_details
5270
prodenv.C2C_CAN_LATEST
3500
prodenv.app_tracker
3346
prodenv.notification_detail
2583
prodenv.user_preferences
1901
prodenv.action_status
1842
prodenv.ride_statistics
1683
prodenv.VIC_diagnostics
1679
prodenv.network_info
746
prodenv.feature_action_status
724
prodenv.vic_request
724
prodenv.uplink_network_stats
700
prodenv.C2C_CAN_ghz
364
prodenv.device_shadow
352
prodenv.imu_processed_data
340
prodenv.vic_state
83
prodenv.VIC_app_crash
17
prodenv.ride_mode_efficiency
11
prodenv.C2C_CAN_MV
10
prodenv.C2C_CAN_FILTERED
10
prodenv.uplink_system_stats
8
prodenv.ota_sw_update_status
7
prodenv.ota_package_queue
6
prodenv.uplink_stream_metrics
6
prodenv.uplink_processor_stats
6
prodenv.uplink_serializer_metrics
6
prodenv.uplink_mqtt_metrics
6
prodenv.uplink_serializer_stream_metrics
6
prodenv.`.pg_session_notifications`
6
prodenv.uplink_disk_stats
6
prodenv.mv_max_insert_timestamp_C2C_CAN
6
prodenv.BMS_pack_serial_number
5
prodenv.C2C_CAN_INVALID_TIMESTAMP
5
prodenv.can_parsed_dbc_base_v7
4
prodenv.can_parsed_dbc_base_v13
4
prodenv.cal_stats
4
prodenv.dbg_can_parsed_dbc_base_v9
4
prodenv.duplicate_ride_id
4
prodenv.can_parsed_dbc_base_v12
4
50 row(s) in 0.064 seconds.

Rows per page

Page 1 of 1