How to update record's GB size in table Physical Table Stats

[hacktd]

Recently I have discovered that there is a table which stores instance tables physical memory. I want to remove some records in sys_attachment to see the results but the value in field Table in GB size doesn't update. Is there any scheduled jobs related to this table ?

[Weird]

I read an article hear some month or so ago which mentioned that physical table stats were broken atm and aren't updating correctly. I haven't been monitoring those, but seems like it still hasn't been fixed then.

[hacktd · Accepted solution]

Oh, I see so there is an problem with the physical table stats. Based on your information about the error I also found some clues to my problem which is there is an default plugin which is called Stats for Physical Tables. Inside that plugin there is sys_job record named "Physical Table Stat Gatherer" and this record is used in table sys_trigger table. The job I mentioned on the post is run daily at 1:00:00 (America/Los_Angeles). I think this resolved my problem now. Thanks @Weird ! Below here is what I have found.

Plugin: https://INSTANCE_NAME.service-now.com/now/nav/ui/classic/params/target/v_plugin_list.do%3Fsysparm_qu...

sys_trigger job: https://INSTANCE_NAME.service-now.com/sys_trigger_list.do?sysparm_query=job_id.nameSTARTSWITHPhysica...

[abhishek_s]

I see this in the Washington DC Patch 1  Release Notes -

Problem	Short description	Description	Steps to reproduce
Database Persistence - Data Management PRB1719831	Database footprint or sys_physical_table_stats don't display the correct table size	The row details for table_name aren't equal to storage_alias in the sys_storage_table_alias table.	Create a test table with over 40 characters. Verify that it's aliased in sys_storage_table_alias. Add some records to the test table. Run the sys_trigger for Physical Table Stats Gatherer. Observe that the value isn't updated in the sys_physical_table_stats table.