Run vacuum and analyze on the insert only tables

Issue

Many of the tables for report stream are insert only and have never been vacuumed or had analyze ran against them. This has resulted in the stats being extremely off and results in non-optimal query plans getting generated.

Resolution

Run vacuum and analyze on all the tables that never had it run.

select relname
from pg_stat_user_tables
where last_analyze is null;

Tables as of writing this ticket in rough priority order if this needs to get broken up

report_lineage
item_lineage
report_file
action
covid_result_metadata
setting
flyway_schema_history
task
county_lat_long
email_schedule
jti_cache
lookup_table_version
lookup_table_row
action_log
temp_action
temp
temp_vt_resubmissions
elr_result_metadata
today_actions
sender_ips
october_actions
vw_livd_table
temp_patient_demographics
patient_gender
sender
state

CDCgov / prime-devops

Run vacuum and analyze on the insert only tables #90

Issue

Resolution