APM Database PostgreSQL Partition is Full

book

Article ID: 198227

calendar_today

Updated On:

Products

CA Application Performance Management Agent (APM / Wily / Introscope) CA Application Performance Management (APM / Wily / Introscope) INTROSCOPE DX Application Performance Management

Issue/Introduction



The APM Database PostgreSQL partition is full and  cannot start the Postgres DB.

The database has grown from about 24GB to 100GB in a couple of weeks.

How can I find out why it grew so quickly and reduce its size?


Cause

investigating

Environment

Release : 10.7.0

Component : APM Agents

Resolution

Moved some files out of the DB partition to get the DB started.

Dropped a couple of the oldest appmap_states tables to make enough space for the analyze commands to run.

Ran the 3 vacuum full analyze commands and that reduced the DB size from 96 GB down to 35 GB.

Now able to start PostgreSQL

Additional Information

1. General Guidance to cleaning up APM Database for appmap tables

https://knowledge.broadcom.com/external/article?articleId=143000

2. How to purge or reduce the size of a Postgresql APM database and optimize CEM data retention.

https://knowledge.broadcom.com/external/article?articleId=9486

3. APM PostgreSQL Database Utilization Details

https://knowledge.broadcom.com/external/article?articleId=190074