08 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
e202503	a_proximity_sum	0	0	0	0
e202503	a_stay_time	0	0	0	0
e202503	t_position_history	0	0	0	0
e202503	t_presence_history	4208279	0	0.00	0.00	2025-05-19 17:25:06.198119+00
e202503	t_sensor_history	0	0	0	0
e202504	a_proximity_sum	0	0	0	0
e202504	a_stay_time	0	0	0	0
e202504	t_position_history	0	0	0	0
e202504	t_presence_history	0	0	0	0
e202504	t_sensor_history	0	0	0	0
e202505	a_proximity_sum	4704	0	0.00	0.00
e202505	a_stay_time	11859	0	0.00	0.00
e202505	t_position_history	486992	0	0.00	0.00
e202505	t_presence_history	2217965	208946	0.00	8.00	2025-05-20 01:37:52.306431+00	2025-05-20 01:42:29.583738+00
e202505	t_sensor_history	14581	0	0.00	0.00
public	__digdag_status	0	6	0	100.00
public	a_attendance_sum	0	0	0	0
public	a_plan_actual	164	0	0.00	0.00
public	a_proximity_sum	0	0	0	0
public	a_stay_time	0	0	0	0
public	area_history	0	0	0	0
public	b_attendance_group	1118	0	0.00	0.00
public	b_attendance_hour	18541	0	0.00	0.00
public	b_attendance_pot	2599	0	0.00	0.00
public	b_attendance_pot_hour	40470	0	0.00	0.00
public	b_check_in	5261	0	0.00	0.00
public	b_check_in_hour	94434	0	0.00	0.00
public	b_check_in_pot	920	0	0.00	0.00
public	b_check_in_pot_hour	21225	0	0.00	0.00
public	b_proximity_group	78815	0	0.00	0.00
public	b_proximity_info	283220	0	0.00	0.00
public	b_seat_reserve	2376	0	0.00	0.00
public	b_seat_reserve_hour	47648	0	0.00	0.00
public	b_usage	2819	0	0.00	0.00
public	b_usage_hour	54323	0	0.00	0.00
public	m_area	0	0	0	0
public	m_auth	0	0	0	0
public	m_category	0	0	0	0
public	m_env	0	0	0	0
public	m_exb	0	0	0	0
public	m_favorite	6	6	1.00	50.00
public	m_favorite_group	10	0	0.00	0.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	47	19	0.00	28.00
public	m_lob_log	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_personal_setting	13811	917	0.00	6.00	2025-05-20 00:02:42.619477+00	2025-05-20 01:32:27.144694+00
public	m_pot	27228	3339	0.00	10.00		2025-05-20 00:10:41.619735+00
public	m_pot_profile	3547	225	0.00	5.00		2025-05-20 01:18:13.141156+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	0	66	0	100.00
public	m_setting_log	66	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	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	468	108	0.00	18.00
public	t_general	0	0	0	0
public	t_mobile_device_history	44	0	0.00	0.00
public	t_mobile_status_history	0	0	0	0
public	t_news	0	0	0	0
public	t_notify_history	362	110	0.00	23.00
public	t_operation_log	2970	1	0.00	0.00
public	t_plan	4386	26246	5.00	85.00
public	t_plan_cancel_history	48	2	0.00	4.00
public	t_plan_detail	3770	54824	14.00	93.00
public	t_plan_new	0	0	0	0
public	t_plan_sync	0	2121	0	100.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	13665	26101	1.00	65.00	2025-05-20 01:42:31.943832+00	2025-05-20 01:42:32.006686+00
public	t_sensor_history	0	0	0	0
public	t_terminal	3	492	164.00	99.00
public	t_terminal_log	3062	0	0.00	0.00
public	w_arrival_notify	0	1	0	100.00
public	w_latest_mobile_device	1	23	23.00	95.00
public	w_latest_mobile_status	5644	1014	0.00	15.00		2025-05-20 01:20:26.978529+00
public	w_latest_position	13025	10960	0.00	45.00	2025-05-20 01:42:31.433024+00	2025-05-20 01:42:31.468196+00
public	w_latest_presence	18535	85593	4.00	82.00	2025-05-20 01:42:32.198693+00	2025-05-20 01:42:32.343854+00
public	w_latest_sensor	113	120	1.00	51.00	2025-05-20 01:41:27.234146+00	2025-05-20 01:42:31.405047+00
public	w_lock	0	0	0	0
public	w_master_update	16	22	1.00	57.00	2025-05-20 00:52:24.296955+00	2025-05-20 00:51:24.263611+00
public	w_plan_sync_retry	0	0	0	0
public	w_plan_with_detail	4386	26222	5.00	85.00
public	w_plan_with_detail_new	0	0	0	0

back