SELECT psut.relname,
     last_autovacuum::date,
     pg_class.reltuples::bigint AS n_tup,
     n_tup_ins,
     n_dead_tup,
     n_live_tup,
     pg_class.reltuples::bigint/n_tup_ins ::int diff,
     current_date
 FROM pg_stat_user_tables psut
 JOIN pg_class on psut.relid = pg_class.oid
 WHERE n_tup_ins > 0
 ORDER BY n_dead_tup desc
 LIMIT 1;


  relname    | last_autovacuum |    n_tup     | n_tup_ins  | n_dead_tup |  n_live_tup  | diff |    date
-------------------------------------+-----------------+--------------+------------+------------+-----------
 transfers   |  2018-01-29     | 165248892928 | 1616281352 |   26834278 | 165235471748 |  102 | 2018-01-30

vacuum analyze verbose transfers;

INFO:  vacuuming "public.transfers"
INFO:  scanned index "transfers_shop_idx" to remove 27834278 row versions
DETAIL:  CPU 0.57s/20.97u sec elapsed 21.72 sec.
INFO:  scanned index "transfers_pkey" to remove 27834278 row versions
DETAIL:  CPU 0.26s/6.00u sec elapsed 8.81 sec.
INFO:  "transfers": removed 27834278 row versions in 230972 pages
DETAIL:  CPU 0.01s/1.08u sec elapsed 1.18 sec.
INFO:  index "transfers_shop_idx" now contains 0 row versions in 120735 pages
DETAIL:  27832314 index row versions were removed.
120281 index pages have been deleted, 23986 are currently reusable.
CPU 0.00s/0.00u sec elapsed 0.00 sec.
INFO:  index "transfers_pkey" now contains 0 row versions in 95287 pages
DETAIL:  27834022 index row versions were removed.
95016 index pages have been deleted, 18968 are currently reusable.
CPU 0.00s/0.00u sec elapsed 0.00 sec.
INFO:  "transfers": found 13483310 removable, 0 nonremovable row versions in 230972 out of 230972 pages
DETAIL:  0 dead row versions cannot be removed yet.
There were 0 unused item pointers.
0 pages are entirely empty.
CPU 1.05s/29.60u sec elapsed 33.47 sec.
INFO:  "transfers": truncated 230972 to 0 pages
DETAIL:  CPU 0.37s/0.35u sec elapsed 0.74 sec.
INFO:  analyzing "public.transfers"
INFO:  "transfers": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows

Query returned successfully with no result in 34.3 secs.

ANALYZE transfers
INFO:  analyzing "public.transfers"
INFO:  "transfers": scanned 3000 of 230972 pages, containing 0 live rows and 27834278  dead rows; очень много estimated total rows