Database Table side check

back

schema	table	live_tupple	dead_tupple	ratio_of_dead_to_each_live	percent_of_dead	last_autovacuum_at	last_autoanalyze_at
e202402	a_proximity_sum	0	0	0	0
e202402	a_stay_time	0	0	0	0
e202402	l_position_history	0	0	0	0
e202402	l_proximity_sum	0	0	0	0
e202402	l_stay_time	0	0	0	0
e202402	t_position_history	0	0	0	0
e202402	t_presence_history	0	0	0	0
e202402	t_sensor_history	0	0	0	0
e202403	a_proximity_sum	0	0	0	0
e202403	a_stay_time	0	0	0	0
e202403	l_position_history	0	0	0	0
e202403	l_proximity_sum	0	0	0	0
e202403	l_stay_time	0	0	0	0
e202403	t_position_history	0	0	0	0
e202403	t_presence_history	0	0	0	0
e202403	t_sensor_history	0	0	0	0
e202404	a_proximity_sum	19648	0	0.00	0.00
e202404	a_stay_time	30952	0	0.00	0.00
e202404	l_position_history	0	0	0	0
e202404	l_proximity_sum	0	0	0	0
e202404	l_stay_time	0	0	0	0
e202404	t_position_history	241126	0	0.00	0.00
e202404	t_presence_history	6421210	504621	0.00	7.00	2024-04-27 01:39:00.189585+00	2024-04-27 01:46:20.598516+00
e202404	t_sensor_history	15706	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	324	878	2.00	73.00
public	b_attendance_hour	5083	13521	2.00	72.00
public	b_attendance_pot	0	0	0	0
public	b_attendance_pot_hour	0	0	0	0
public	b_check_in	2076	7956	3.00	79.00
public	b_check_in_hour	33989	116368	3.00	77.00
public	b_check_in_pot	0	0	0	0
public	b_check_in_pot_hour	0	0	0	0
public	b_proximity_group	78	115186	1476.00	99.00
public	b_proximity_info	60900	8834	0.00	12.00
public	b_seat_reserve	601	1634	2.00	73.00
public	b_seat_reserve_hour	12377	29417	2.00	70.00
public	b_usage	849	1634	1.00	65.00
public	b_usage_hour	16133	29417	1.00	64.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	1	1	1.00	50.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	23691	3558	0.00	13.00		2024-04-27 00:10:16.820743+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	92	0	100.00
public	m_setting_log	92	0	0.00	0.00
public	m_site	0	0	0	0
public	m_tenant	0	0	0	0
public	m_tx	0	0	0	0
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	11366	1137	0.00	9.00	2024-04-26 23:12:49.112823+00	2024-04-26 23:33:37.854576+00
public	r_pot_tx	0	0	0	0
public	r_pot_user	0	0	0	0
public	r_provider_tenant	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_ai_history	0	0	0	0
public	t_attendance	2	773	386.00	99.00
public	t_general	0	0	0	0
public	t_mobile_device_history	6	0	0.00	0.00
public	t_news	0	0	0	0
public	t_notify_history	15	546	36.00	97.00
public	t_operation_log	257	4627	18.00	94.00
public	t_plan	239	9901	41.00	97.00
public	t_plan_detail	486	10320	21.00	95.00
public	t_plan_sync	16460	1162	0.00	6.00	2024-04-26 23:33:34.392462+00	2024-04-26 23:33:34.646502+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	5598	3138	0.00	35.00	2024-04-27 01:50:21.939395+00	2024-04-27 01:50:21.963352+00
public	t_sensor_history	0	0	0	0
public	t_terminal	13748	2074	0.00	13.00		2024-04-27 00:07:17.236012+00
public	t_terminal_log	3537	0	0.00	0.00
public	w_arrival_notify	0	0	0	0
public	w_latest_position	10771	1659	0.00	13.00	2024-04-27 01:42:19.691879+00	2024-04-27 01:48:19.98843+00
public	w_latest_presence	17178	34090	1.00	66.00	2024-04-27 01:50:22.094143+00	2024-04-27 01:50:22.227158+00
public	w_latest_sensor	113	66	0.00	36.00	2024-04-27 01:49:19.969056+00	2024-04-27 01:50:21.857196+00
public	w_lock	0	0	0	0
public	w_master_update	0	11	0	100.00
public	w_plan_with_detail	235	10158	43.00	97.00

back