root@buero ~ $ time query "SELECT count(*) FROM hst_sales_report"
838949

real    1m4.239s
user    0m0.028s
sys     0m0.020s


backoffice_db=# analyze verbose hst_sales_report;
INFO:  analyzing "public.hst_sales_report"
INFO:  "hst_sales_report": scanned 3000 of 165504 pages, containing 14606 live rows and 2274 dead rows; 3000 rows in sample, 805784 estimated total rows
ANALYZE
backoffice_db=# vacuum verbose hst_sales_report;
INFO:  vacuuming "public.hst_sales_report"
INFO:  index "hst_sales_report_id_key" now contains 838998 row versions in 20157 pages
DETAIL:  95180 index row versions were removed.
14622 index pages have been deleted, 14260 are currently reusable.
CPU 0.25s/0.14u sec elapsed 821.15 sec.
INFO:  index "hst_sales_report_business_day_idx" now contains 839131 row versions in 14834 pages
DETAIL:  95180 index row versions were removed.
11202 index pages have been deleted, 10936 are currently reusable.
CPU 0.15s/0.14u sec elapsed 634.59 sec.
INFO:  index "hst_sales_report_id_operator_order_idx" now contains 839266 row versions in 18799 pages
DETAIL:  95180 index row versions were removed.
13185 index pages have been deleted, 12866 are currently reusable.
CPU 0.20s/0.22u sec elapsed 840.27 sec.
INFO:  index "hst_sales_report_id_operator_final_idx" now contains 839503 row versions in 18124 pages
DETAIL:  95180 index row versions were removed.
14348 index pages have been deleted, 14045 are currently reusable.
CPU 0.16s/0.20u sec elapsed 668.68 sec.
INFO:  "hst_sales_report": removed 95180 row versions in 3680 pages
DETAIL:  CPU 0.18s/0.03u sec elapsed 311.23 sec.
INFO:  "hst_sales_report": found 95180 removable, 838954 nonremovable row versions in 165504 pages
DETAIL:  3 dead row versions cannot be removed yet.
There were 3765223 unused item pointers.
0 pages are entirely empty.
CPU 0.99s/0.75u sec elapsed 6632.37 sec.
INFO:  vacuuming "pg_toast.pg_toast_16716"
INFO:  index "pg_toast_16716_index" now contains 0 row versions in 1 pages
DETAIL:  0 index pages have been deleted, 0 are currently reusable.
CPU 0.00s/0.00u sec elapsed 0.13 sec.
INFO:  "pg_toast_16716": found 0 removable, 0 nonremovable row versions in 0 pages
DETAIL:  0 dead row versions cannot be removed yet.
There were 0 unused item pointers.
0 pages are entirely empty.
CPU 0.00s/0.00u sec elapsed 0.14 sec.
VACUUM
backoffice_db=# 


root@buero ~ $ time query "SELECT count(*) FROM hst_sales_report"
839053

real    2m29.978s
user    0m0.040s
sys     0m0.020s
root@buero ~ $ 