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	791550	0	0.00	0.00	2024-07-25 18:04:07.226684+00	2024-07-25 18:04:07.733844+00
e202406	t_sensor_history	0	0	0	0
e202407	a_proximity_sum	7043817	0	0.00	0.00		2024-07-24 16:07:47.246876+00
e202407	a_stay_time	549605	0	0.00	0.00		2024-07-24 16:01:46.817234+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	48603221	0	0.00	0.00		2024-07-25 12:10:22.362128+00
e202407	t_presence_history	4653017	743338	0.00	13.00	2024-07-26 00:20:15.898078+00	2024-07-26 00:48:44.068673+00
e202407	t_sensor_history	6650769	69	0.00	0.00		2024-07-25 16:03:29.023945+00
public	__digdag_status	1	6	6.00	85.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	25	0	100.00
public	m_auth	0	0	0	0
public	m_category	0	0	0	0
public	m_exb	0	0	0	0
public	m_favorite	3	8	2.00	72.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	1	0	0.00	0.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	20	38	1.00	65.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	202	26	0.00	11.00	2024-07-25 08:35:02.776967+00	2024-07-25 08:34:07.455023+00
public	m_setting_log	20	108	5.00	84.00
public	m_site	0	0	0	0
public	m_tenant	0	0	0	0
public	m_tx	2	0	0.00	0.00
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	6	6	1.00	50.00
public	r_pot_category	0	0	0	0
public	r_pot_group	3	4	1.00	57.00
public	r_pot_tx	5	4	0.00	44.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	217	47	0.00	17.00
public	t_general	0	0	0	0
public	t_mobile_device_history	8	0	0.00	0.00
public	t_news	0	0	0	0
public	t_notify_history	0	65	0	100.00
public	t_operation_log	198	1101	5.00	84.00
public	t_plan	1478327	184923	0.00	11.00	2024-07-24 03:31:58.600783+00	2024-07-25 08:01:10.397504+00
public	t_plan_detail	3151349	519114	0.00	14.00		2024-07-26 00:09:37.83157+00
public	t_plan_sync	34727	1692	0.00	4.00	2024-07-25 23:05:28.434105+00	2024-07-25 23:02:28.435831+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	21610	4334	0.00	16.00	2024-07-26 01:14:42.632803+00	2024-07-26 01:14:42.736058+00
public	t_sensor_history	0	0	0	0
public	t_terminal	42	35	0.00	45.00	2024-07-24 15:29:46.295271+00	2024-07-26 00:26:42.010242+00
public	w_arrival_notify	0	0	0	0
public	w_latest_position	3142	28338	9.00	90.00	2024-07-26 01:14:36.768325+00	2024-07-26 01:14:37.012669+00
public	w_latest_presence	19493	272852	13.00	93.00	2024-07-26 01:14:37.103725+00	2024-07-26 01:14:37.956248+00
public	w_latest_sensor	1589	449	0.00	22.00	2024-07-26 01:12:36.636534+00	2024-07-26 01:13:36.749773+00
public	w_lock	0	0	0	0
public	w_master_update	0	45	0	100.00
public	w_migration	0	0	0	0
public	w_plan_with_detail	1480814	269414	0.00	15.00		2024-07-25 08:01:22.133502+00

back