Jira tables too large

[Int_20h]

I have about 1600 tickets in Jira but my database size is 30Gb. Top-10 tables are:

relation | size
public.clusteredjob_jrk_idx | 12 GB
public.rundetails | 7863 MB
public.clusteredjob_nextrun_idx | 6590 MB
public.pk_rundetails | 3264 MB
public.clusteredjob | 3127 MB
public.rundetails_starttime_idx | 2527 MB
public.AO_733371_EVENT_PARAMETER | 17 MB
public.index_ao_733371_eve1423945899 | 10 MB
public.index_ao_733371_eve704112384 | 4040 kB
public.AO_733371_EVENT_PARAMETER_pkey | 4040 kB


What the hell is going on? How can I reduce database size?

[Robert Dzido _Almarise_]

Looks there is an issue with space managment. Most of objects you listed are indexes. You shall reindex database or rebuild indexes depending on your database type.

If you can't to it, there is option to export Jira database to zip file then restore it back.

[Int_20h]

Unfortunately re-indexing in Jira didn't help. Will try to backup and restore database tomorrow.