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
e202307	a_proximity_sum	0	0	0	0
e202307	a_stay_time	0	0	0	0
e202307	l_position_history	0	0	0	0
e202307	l_proximity_sum	0	0	0	0
e202307	l_stay_time	0	0	0	0
e202307	t_position_history	1	0	0.00	0.00
e202307	t_presence_history	0	0	0	0
e202307	t_sensor_history	0	0	0	0
e202308	a_proximity_sum	57135	0	0.00	0.00
e202308	a_stay_time	221592	0	0.00	0.00
e202308	l_position_history	0	0	0	0
e202308	l_proximity_sum	0	0	0	0
e202308	l_stay_time	0	0	0	0
e202308	t_position_history	3071184	0	0.00	0.00
e202308	t_presence_history	596525	90641854	151.00	99.00
e202308	t_sensor_history	175742	0	0.00	0.00
e202309	a_proximity_sum	346522	0	0.00	0.00
e202309	a_stay_time	1606832	0	0.00	0.00
e202309	l_position_history	0	0	0	0
e202309	l_proximity_sum	0	0	0	0
e202309	l_stay_time	0	0	0	0
e202309	t_position_history	27814040	0	0.00	0.00
e202309	t_presence_history	5725500	1088969849	190.00	99.00
e202309	t_sensor_history	2182286	10	0.00	0.00
public	__digdag_status	0	137	0	100.00
public	a_proximity_sum	0	0	0	0
public	a_stay_time	0	0	0	0
public	b_attendance_group	36747	7	0.00	0.00
public	b_attendance_hour	588736	154	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	273552	24	0.00	0.00
public	b_check_in_hour	4073094	528	0.00	0.00
public	b_proximity_group	4054537	15	0.00	0.00
public	b_proximity_info	816830	0	0.00	0.00
public	b_seat_reserve	56459	6	0.00	0.00
public	b_seat_reserve_hour	1038859	132	0.00	0.00
public	b_usage	65878	6	0.00	0.00
public	b_usage_hour	1201387	132	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	5	5	1.00	50.00
public	m_auth	0	0	0	0
public	m_category	21	11	0.00	34.00
public	m_exb	88	327	3.00	78.00
public	m_favorite	1744	111	0.00	5.00
public	m_feature	0	0	0	0
public	m_group	86	77	0.00	47.00
public	m_holiday	450	0	0.00	0.00
public	m_lob	19	15	0.00	44.00
public	m_location	88	236	2.00	72.00
public	m_notify_template	2	0	0.00	0.00
public	m_outside	2	1	0.00	33.00
public	m_pot	374	16448	43.00	97.00
public	m_pot_profile	18	29	1.00	61.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	5	7496	1499.00	99.00
public	m_setting_log	282	7308	25.00	96.00
public	m_site	0	0	0	0
public	m_tenant	0	0	0	0
public	m_tx	181	45820	253.00	99.00
public	m_user	88	266	3.00	75.00
public	m_zone	53	454	8.00	89.00
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	44	176	4.00	80.00
public	r_pot_auth	0	4	0	100.00
public	r_pot_category	8	56	7.00	87.00
public	r_pot_group	140	464990	3321.00	99.00
public	r_pot_tx	135	199	1.00	59.00
public	r_pot_user	65	93	1.00	58.00
public	r_role_feature	0	1	0	100.00
public	r_tenant_feature	5	6	1.00	54.00
public	r_tx_sensor	0	0	0	0
public	r_user_region	65	293	4.00	81.00
public	r_user_site	26	49	1.00	65.00
public	r_zone_category	26	3	0.00	10.00
public	t_attendance	24446	24416	0.00	49.00
public	t_general	0	2	0	100.00
public	t_mobile_device_history	5537	0	0.00	0.00
public	t_news	0	0	0	0
public	t_notify_history	29135	8282	0.00	22.00
public	t_operation_log	141806	57	0.00	0.00
public	t_plan	290678	366585	1.00	55.00
public	t_plan_detail	336376	310406	0.00	47.00
public	t_plan_sync	180	71210	395.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	6482	2084335	321.00	99.00		2023-09-27 12:42:01.866282+00
public	t_sensor_history	0	0	0	0
public	t_terminal	1400	11678	8.00	89.00
public	t_terminal_log	300204	0	0.00	0.00
public	w_arrival_notify	0	34	0	100.00
public	w_latest_position	135	1722168	12756.00	99.00
public	w_latest_presence	19716	21775993	1104.00	99.00	2023-09-27 12:42:14.28608+00	2023-09-27 12:42:14.329146+00
public	w_latest_sensor	0	100999	0	100.00
public	w_lock	10	0	0.00	0.00
public	w_master_update	0	333	0	100.00
public	w_plan_with_detail	290677	649673	2.00	69.00

back