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	311924	0	0.00	0.00
e202404	a_stay_time	201881	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	2658494	0	0.00	0.00
e202404	t_presence_history	36016706	4437977	0.00	10.00	2024-04-27 00:30:22.530613+00	2024-04-27 00:38:33.26573+00
e202404	t_sensor_history	77615	0	0.00	0.00
public	__digdag_status	0	0	0	0
public	a_proximity_sum	0	0	0	0
public	a_stay_time	0	0	0	0
public	del_b_attendance_group	0	0	0	0
public	del_b_attendance_hour	0	0	0	0
public	del_b_check_in	0	0	0	0
public	del_b_check_in_hour	0	0	0	0
public	del_b_proximity_group	0	0	0	0
public	del_b_proximity_info	0	0	0	0
public	del_b_seat_reserve	0	0	0	0
public	del_b_seat_reserve_hour	0	0	0	0
public	del_b_usage	0	0	0	0
public	del_b_usage_hour	0	0	0	0
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	2	2	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	2	4	2.00	66.00
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	17	398	23.00	95.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	320	0	100.00
public	m_setting_log	320	0	0.00	0.00
public	m_site	0	0	0	0
public	m_tenant	0	0	0	0
public	m_tx	1	4	4.00	80.00
public	m_user	0	1	0	100.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	0	0	0	0
public	r_pot_auth	0	0	0	0
public	r_pot_category	6625	0	0.00	0.00	2024-04-26 20:24:20.316036+00	2024-04-26 20:01:41.289212+00
public	r_pot_group	94555	9002	0.00	8.00	2024-04-26 23:01:27.98177+00	2024-04-27 00:31:32.775783+00
public	r_pot_tx	0	4	0	100.00
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	35	1943	55.00	98.00
public	t_general	0	0	0	0
public	t_mobile_device_history	105	0	0.00	0.00
public	t_news	0	0	0	0
public	t_notify_history	223	4081	18.00	94.00
public	t_operation_log	1441	18921	13.00	92.00
public	t_plan	1150	70595	61.00	98.00
public	t_plan_detail	1662	208750	125.00	99.00
public	t_plan_sync	43873	4317	0.00	8.00	2024-04-27 00:32:33.039387+00	2024-04-27 00:31:32.998819+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	91635	10072	0.00	9.00	2024-04-27 00:49:35.910517+00	2024-04-27 00:49:36.379727+00
public	t_sensor_history	0	0	0	0
public	t_terminal	43340	6414	0.00	12.00		2024-04-26 21:59:50.733343+00
public	t_terminal_log	6815	0	0.00	0.00
public	w_arrival_notify	0	0	0	0
public	w_latest_position	47870	7733	0.00	13.00	2024-04-27 00:45:43.732357+00	2024-04-27 00:49:37.492787+00
public	w_latest_presence	184894	41196	0.00	18.00	2024-04-27 00:48:38.406552+00	2024-04-27 00:49:37.348362+00
public	w_latest_sensor	443	19	0.00	4.00	2024-04-27 00:49:33.266182+00	2024-04-27 00:49:34.288255+00
public	w_lock	2	0	0.00	0.00
public	w_master_update	0	41	0	100.00
public	w_migration	0	0	0	0
public	w_plan_with_detail	1150	78978	68.00	98.00

back