Database grows too large
Opened this issue · 0 comments
maxg commented
Right now in 6.031/sp17, queries from here:
relation | size
----------------------------------------------------------------+--------
public.all_computed_username_key_ts_value_penalty_applied_key | 131 MB
public.raw_data_username_key_ts_agent_key | 127 MB
public.raw_data_pkey | 121 MB
public.all_computed_key_gist | 116 MB
public.raw_data_key_gist | 111 MB
public.raw_data | 104 MB
public.all_computed | 97 MB
public.current_computed_key_gist | 67 MB
public.all_data_username_key_ts_value_penalty_applied_agent_key | 67 MB
public.current_computed_pkey | 60 MB
public.all_data | 50 MB
public.current_data_pkey | 39 MB
public.current_data_key_gist | 35 MB
public.current_computed | 27 MB
public.current_data | 16 MB
relation | total_size
-------------------------+------------
public.raw_data | 463 MB
public.all_computed | 344 MB
public.current_computed | 155 MB
public.all_data | 117 MB
public.current_data | 90 MB
public.keys | 1424 kB
table_name | row_estimate | total_bytes | index_bytes | toast_bytes | table_bytes | total | index | toast | table
------------------+--------------+-------------+-------------+-------------+-------------+------------+------------+------------+------------
raw_data | 443750 | 485941248 | 376750080 | 8192 | 109182976 | 463 MB | 359 MB | 8192 bytes | 104 MB
all_computed | 473243 | 360923136 | 259448832 | 8192 | 101466112 | 344 MB | 247 MB | 8192 bytes | 97 MB
current_computed | 118875 | 162127872 | 133513216 | 8192 | 28606464 | 155 MB | 127 MB | 8192 bytes | 27 MB
all_data | 227682 | 122822656 | 70541312 | 8192 | 52273152 | 117 MB | 67 MB | 8192 bytes | 50 MB
current_data | 69912 | 94560256 | 77864960 | 8192 | 16687104 | 90 MB | 74 MB | 8192 bytes | 16 MB