Thanks. I can’t check indexes currently, but aow_processed is large. I’ve been reading through this thread and will see if we can improve the situation.
The Prune Database job is not active - I assume it would be good practice to get that activated.
Is there any way to check left over entries in process_record? Does this relate to the job_queue table?
| TableName | RowCount | TotalSpaceKB | UsedSpaceKB |
|---|---|---|---|
| aow_processed | 9,339,577 | 5,016,224 | 5,014,704 |
| securitygroups_records | 2,591,262 | 1,769,024 | 1,768,688 |
| leads_cstm | 868,806 | 812,816 | 812,552 |
| leads | 868,770 | 1,401,904 | 1,398,680 |
| email_addr_bean_rel | 480,772 | 170,696 | 169,808 |
| email_addresses | 447,125 | 173,512 | 172,632 |
| leads_audit | 195,709 | 63,344 | 62,864 |
| aow_processed_aow_actions | 161,703 | 156,848 | 156,656 |
| job_queue | 125,103 | 246,496 | 246,224 |
| calls_leads | 74,122 | 83,368 | 83,120 |