The only time swapping should be a concern would be
- All existing memory is consumed and we are relying on swap memory.
- Performance degradation is observed.
If you observe swapping and observe either of the above, contact Broadcom Support and note this Article ID (391683) in the problem description.
For more information, see Creating and managing Broadcom support cases .
When opening the case, please include the following information:
- From the affected nodes at the time of the issue:
- vmstat 3 100
- free -h
- free
- top
- SSH into the affected node.Connect to the database with 'sudo -u postgres psql vcloud;' and check for postgres related activities/processes:
select pid,query,query_start, state, backend_start, now() - pg_stat_activity.query_start from pg_stat_activity WHERE backend_xmin IS NOT NULL OR backend_xid IS NOT NULL ORDER BY greatest(age(backend_xmin), age(backend_xid)) DESC LIMIT 20;
- Run the following queries once and share the output.
SELECT pid, now() - pg_stat_activity.query_start AS duration," + "query, state "
+ "FROM pg_stat_activity "
+ "WHERE (now() - pg_stat_activity.query_start) > interval '5 minutes'
SELECT pid, now() - pg_stat_activity.query_start AS duration," + "query, state "
+ "FROM pg_stat_activity "
+ "WHERE (now() - pg_stat_activity.query_start) > interval '2 minutes'"
SELECT pid, now() - pg_stat_activity.query_start AS duration," + "query, state "
+ "FROM pg_stat_activity "
+ "WHERE (now() - pg_stat_activity.query_start) > interval '1 minutes'"
- Collect the logs as per the article.