Performance slow or single action suddenly slow for PosgreSQL (SAAS, GCP)
search cancel

Performance slow or single action suddenly slow for PosgreSQL (SAAS, GCP)

book

Article ID: 260459

calendar_today

Updated On:

Products

Clarity PPM SaaS

Issue/Introduction

Clarity is processing much slower than usual, or there is a single action that was fast before and suddenly it takes a lot longer for the same view and amount of records. For example, Staffing Grid - the same view returned within 5 seconds previously and is over 1 min now.

This issue is being faced by all users across Clarity.

Environment

Release : Any

Resolution

GCP / SaaS customers contact Broadcom support for assistance.

  1. Check the database schema to find any queries that are stuck in idle/processing for a long time
  2. Remove those queries in working with the DBA
  3. Perform pg_repack on the most bloated tables 
  4. If a single query is slow, perform pg_repack on the major tables involved 
  5. Services restart may also be necessary in some cases or caches flush
Powered by Wolken Software