Post
FollowWhat to check if your snapshot seems not be progressing
When you have a snapshot which is not progressing, you can find information on what action it might be doing by checking on the following:
- run the following query in a query window in pgadmin to provide the list of queries that are active on the database to see if one is related to the snapshot you are running
select query from pg_stat_activity where state !='idle'
- check the dss_history table on the central and local databases to see what the last actions done were. You can use this query in the query window in pgadmin to see the last 100 items in reverse order:
select * from dss_history order by history_id desc limit 100;
See this TKB page for further information: https://doc.castsoftware.com/display/TG/CMS+Snapshot+Analysis+-+Compute+Snapshot+-+Performance+issue
Please sign in to leave a comment.