Comment by postila

This is one of the interesting optimizations that DBMS should do automatically but it doesn't.

https://github.com/NikolayS/postgres_dba -- this toolset includes a version of report (see report a1) which analyses all tables in your database and shows opportunities to optimize.