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
e202405	a_proximity_sum	0	0	0	0
e202405	a_stay_time	0	0	0	0
e202405	l_position_history	0	0	0	0
e202405	l_proximity_sum	0	0	0	0
e202405	l_stay_time	0	0	0	0
e202405	t_position_history	0	0	0	0
e202405	t_presence_history	0	0	0	0
e202405	t_sensor_history	0	0	0	0
e202406	a_proximity_sum	0	0	0	0
e202406	a_stay_time	0	0	0	0
e202406	l_position_history	0	0	0	0
e202406	l_proximity_sum	0	0	0	0
e202406	l_stay_time	0	0	0	0
e202406	t_position_history	0	0	0	0
e202406	t_presence_history	0	18048	0	100.00
e202406	t_sensor_history	0	0	0	0
e202407	a_proximity_sum	291760	0	0.00	0.00
e202407	a_stay_time	29554	0	0.00	0.00
e202407	l_position_history	0	0	0	0
e202407	l_proximity_sum	0	0	0	0
e202407	l_stay_time	0	0	0	0
e202407	t_position_history	953721	0	0.00	0.00
e202407	t_presence_history	4157434	654460	0.00	13.00	2024-07-24 00:36:24.239562+00	2024-07-24 01:15:11.211786+00
e202407	t_sensor_history	158219	0	0.00	0.00
public	__digdag_status	0	3	0	100.00
public	a_attendance_sum	0	0	0	0
public	a_proximity_sum	0	0	0	0
public	a_stay_time	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	0	0	0	0
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	0	6	0	100.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	23	0	100.00
public	m_setting_log	20	36	1.00	64.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	0	0	0	0
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	19	3	0.00	13.00
public	t_general	0	0	0	0
public	t_mobile_device_history	0	0	0	0
public	t_news	0	0	0	0
public	t_notify_history	0	20	0	100.00
public	t_operation_log	118	330	2.00	73.00
public	t_plan	6095	76983	12.00	92.00
public	t_plan_detail	3139014	242931	0.00	7.00		2024-07-24 00:15:57.672587+00
public	t_plan_sync	22265	353	0.00	1.00	2024-07-23 23:09:51.2533+00	2024-07-23 23:09:51.438032+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	21784	4338	0.00	16.00	2024-07-24 01:15:09.625957+00	2024-07-24 01:15:09.75995+00
public	t_sensor_history	0	0	0	0
public	t_terminal	42	42	1.00	50.00		2024-07-24 00:22:57.128866+00
public	w_arrival_notify	0	0	0	0
public	w_latest_position	3140	10525	3.00	77.00	2024-07-24 01:15:02.26436+00	2024-07-24 01:15:02.512907+00
public	w_latest_presence	17592	45834	2.00	72.00	2024-07-24 01:15:02.684655+00	2024-07-24 01:15:04.135041+00
public	w_latest_sensor	1589	378	0.00	19.00	2024-07-24 01:10:02.18481+00	2024-07-24 01:15:02.205789+00
public	w_lock	0	0	0	0
public	w_master_update	0	2	0	100.00
public	w_migration	0	0	0	0
public	w_plan_with_detail	6095	60441	9.00	90.00

back