# AWX DB size not decreasing

**URL:** <https://forum.ansible.com/t/awx-db-size-not-decreasing/5058>\
**Category:** Get Help\
**Tags:** awx\
**Created:** [April 22, 2024, 3:54am UTC](https://forum.ansible.com/t/awx-db-size-not-decreasing/5058 "2024-04-22T03:54:24Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![vibhor\_agarwalin](https://avatars.discourse-cdn.com/v4/letter/v/bb73d2/32.png) [@vibhor\_agarwalin](https://forum.ansible.com/u/vibhor_agarwalin)\
**Post date:** [April 22, 2024, 3:54am UTC](https://forum.ansible.com/t/awx-db-size-not-decreasing/5058/1 "2024-04-22T03:54:24Z")

</div>

Hello Folks,

Upgraded our AWX 15.0.1 to 23.9.0.  
It was a fresh install with DB migrated separately.

After cleaning up lots of data, the size of DB isn’t decreasing.  
See both autovacuum & track\_counts are on.

psql -U awx  
psql (13.14 (Debian 13.14-1.pgdg120+2))  
Type “help” for help.

## awx=# awx=# show autovacuum; autovacuum

on  
(1 row)

## awx=# show track\_counts; track\_counts

on  
(1 row)

Manually changed these settings in “postgresql.conf” as well and restarted AWX.  
DB size still remains same even after a week.

Request assistance to figure out the anomaly.