search cancel

APM Database PostgreSQL Partition is Full


Article ID: 198227


Updated On:


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


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?


Release : 10.7.0

Component : APM Agents




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

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

3. APM PostgreSQL Database Utilization Details