Database Table side check

back

schema	table	live_tupple	dead_tupple	ratio_of_dead_to_each_live	percent_of_dead	last_vacuum_at	last_analyze_at
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	660	0	0.00	0.00
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	38	0	0.00	0.00
e202311	t_presence_history	0	0	0	0
e202311	t_sensor_history	0	0	0	0
e202312	a_proximity_sum	304581	0	0.00	0.00
e202312	a_stay_time	1076729	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	15158463	0	0.00	0.00
e202312	t_presence_history	3192957	708590015	221.00	99.00
e202312	t_sensor_history	685610	0	0.00	0.00
public	__digdag_status	0	74	0	100.00
public	a_proximity_sum	0	0	0	0
public	a_stay_time	0	0	0	0
public	b_attendance_group	11706	5674	0.00	32.00
public	b_attendance_hour	188924	77392	0.00	29.00
public	b_attendance_pot	0	0	0	0
public	b_attendance_pot_hour	0	0	0	0
public	b_check_in	75290	63999	0.00	45.00
public	b_check_in_hour	1231682	828781	0.00	40.00
public	b_proximity_group	1112382	847140	0.00	43.00
public	b_proximity_info	600464	12442	0.00	2.00
public	b_seat_reserve	24065	4800	0.00	16.00
public	b_seat_reserve_hour	427770	100800	0.00	19.00
public	b_usage	22421	9495	0.00	29.00
public	b_usage_hour	414466	157766	0.00	27.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	1	2	2.00	66.00
public	m_auth	0	0	0	0
public	m_category	0	0	0	0
public	m_exb	3	112	37.00	97.00
public	m_favorite	673	94	0.00	12.00
public	m_feature	0	0	0	0
public	m_group	2	0	0.00	0.00
public	m_holiday	0	0	0	0
public	m_lob	8	3	0.00	27.00
public	m_location	8	38	4.00	82.00
public	m_notify_template	0	0	0	0
public	m_outside	0	0	0	0
public	m_pot	69	4746	68.00	98.00
public	m_pot_profile	4	11	2.00	73.00
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	3644	0	100.00
public	m_setting_log	168	4014	23.00	95.00
public	m_site	0	0	0	0
public	m_tenant	0	0	0	0
public	m_tx	39	32426	831.00	99.00
public	m_user	5	2	0.00	28.00
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	2	74	37.00	97.00
public	r_pot_auth	0	0	0	0
public	r_pot_category	0	5	0	100.00
public	r_pot_group	6	201937	33656.00	99.00
public	r_pot_tx	17	55	3.00	76.00
public	r_pot_user	5	2	0.00	28.00
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	5	2	0.00	28.00
public	r_user_site	5	2	0.00	28.00
public	r_zone_category	0	0	0	0
public	t_attendance	9664	17832	1.00	64.00
public	t_general	1	0	0.00	0.00
public	t_mobile_device_history	2815	0	0.00	0.00
public	t_news	0	0	0	0
public	t_notify_history	9447	15052	1.00	61.00
public	t_operation_log	29563	47902	1.00	61.00
public	t_plan	46375	685443	14.00	93.00
public	t_plan_detail	60412	499490	8.00	89.00
public	t_plan_sync	50	34894	697.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	6326	1976744	312.00	99.00		2023-12-19 12:42:01.868445+00
public	t_sensor_history	0	0	0	0
public	t_terminal	688	13212	19.00	95.00
public	t_terminal_log	148036	0	0.00	0.00
public	w_arrival_notify	0	10	0	100.00
public	w_latest_position	33	2753010	83424.00	99.00
public	w_latest_presence	19011	30212748	1589.00	99.00	2023-12-19 12:42:46.47245+00	2023-12-19 12:42:46.533707+00
public	w_latest_sensor	0	33575	0	100.00
public	w_lock	17	0	0.00	0.00
public	w_master_update	0	202	0	100.00
public	w_plan_with_detail	46374	715873	15.00	93.00

back