Database Table side check

back

schema	table	live_tupple	dead_tupple	ratio_of_dead_to_each_live	percent_of_dead
e202310	a_proximity_sum	0	0	0	0
e202310	a_stay_time	0	0	0	0
e202310	l_position_history	0	0	0	0
e202310	l_proximity_sum	0	0	0	0
e202310	l_stay_time	0	0	0	0
e202310	t_position_history	0	0	0	0
e202310	t_presence_history	0	0	0	0
e202310	t_sensor_history	0	0	0	0
e202311	a_proximity_sum	0	0	0	0
e202311	a_stay_time	0	0	0	0
e202311	l_position_history	0	0	0	0
e202311	l_proximity_sum	0	0	0	0
e202311	l_stay_time	0	0	0	0
e202311	t_position_history	0	0	0	0
e202311	t_presence_history	0	0	0	0
e202311	t_sensor_history	0	0	0	0
e202312	a_proximity_sum	26891	0	0.00	0.00
e202312	a_stay_time	50036	0	0.00	0.00
e202312	l_position_history	0	0	0	0
e202312	l_proximity_sum	0	0	0	0
e202312	l_stay_time	0	0	0	0
e202312	t_position_history	392038	0	0.00	0.00
e202312	t_presence_history	77016	15978724	207.00	99.00
e202312	t_sensor_history	18379	0	0.00	0.00
public	__digdag_status	0	7	0	100.00
public	a_proximity_sum	0	0	0	0
public	a_stay_time	0	0	0	0
public	b_attendance_group	834	314	0.00	27.00
public	b_attendance_hour	17534	0	0.00	0.00
public	b_attendance_pot	0	0	0	0
public	b_attendance_pot_hour	0	0	0	0
public	b_check_in	7682	1565	0.00	16.00
public	b_check_in_hour	136561	0	0.00	0.00
public	b_proximity_group	81719	48828	0.00	37.00
public	b_proximity_info	73862	0	0.00	0.00
public	b_seat_reserve	1915	0	0.00	0.00
public	b_seat_reserve_hour	35042	0	0.00	0.00
public	b_usage	1805	313	0.00	14.00
public	b_usage_hour	37948	0	0.00	0.00
public	l_position_history	0	0	0	0
public	l_proximity_sum	0	0	0	0
public	l_stay_time	0	0	0	0
public	m_area	0	0	0	0
public	m_auth	0	0	0	0
public	m_category	0	0	0	0
public	m_exb	0	0	0	0
public	m_favorite	47	1	0.00	2.00
public	m_feature	0	0	0	0
public	m_group	0	0	0	0
public	m_holiday	0	0	0	0
public	m_lob	0	0	0	0
public	m_location	0	0	0	0
public	m_notify_template	0	0	0	0
public	m_outside	0	0	0	0
public	m_pot	2	1975	987.00	99.00
public	m_pot_profile	0	0	0	0
public	m_provider_user	0	0	0	0
public	m_region	0	0	0	0
public	m_role	0	0	0	0
public	m_sensor	0	0	0	0
public	m_setting	0	100	0	100.00
public	m_setting_log	100	0	0.00	0.00
public	m_site	0	0	0	0
public	m_tenant	0	0	0	0
public	m_tx	1	0	0.00	0.00
public	m_user	0	0	0	0
public	m_zone	0	0	0	0
public	r_auth_group	0	0	0	0
public	r_auth_zone	0	0	0	0
public	r_exb_sensor	0	0	0	0
public	r_group_auth	0	0	0	0
public	r_location_zone	0	0	0	0
public	r_pot_auth	0	0	0	0
public	r_pot_category	0	0	0	0
public	r_pot_group	1	8822	8822.00	99.00
public	r_pot_tx	1	0	0.00	0.00
public	r_pot_user	0	0	0	0
public	r_role_feature	0	0	0	0
public	r_tenant_feature	0	0	0	0
public	r_tx_sensor	0	0	0	0
public	r_user_region	0	0	0	0
public	r_user_site	0	0	0	0
public	r_zone_category	0	0	0	0
public	t_attendance	538	511	0.00	48.00
public	t_general	0	0	0	0
public	t_mobile_device_history	53	0	0.00	0.00
public	t_news	0	0	0	0
public	t_notify_history	747	1134	1.00	60.00
public	t_operation_log	2605	4381	1.00	62.00
public	t_plan	3499	5294	1.00	60.00
public	t_plan_detail	3823	3355	0.00	46.00
public	t_plan_sync	2	2330	1165.00	99.00
public	t_position_history	0	0	0	0
public	t_presence_history	0	0	0	0
public	t_proximity	0	0	0	0
public	t_recv_position_history	861	1578534	1833.00	99.00
public	t_sensor_history	0	0	0	0
public	t_terminal	15	106	7.00	87.00
public	t_terminal_log	4062	0	0.00	0.00
public	w_arrival_notify	0	1	0	100.00
public	w_latest_position	1	19090	19090.00	99.00
public	w_latest_presence	2	16462629	8231314.00	99.00
public	w_latest_sensor	0	301	0	100.00
public	w_lock	0	0	0	0
public	w_master_update	0	12	0	100.00
public	w_plan_with_detail	3499	5408	1.00	60.00

back