Adrian Klaver schrieb am 07.04.2018 um 00:02:
Is there a way to identify the list of statements that have to rewrite the table.https://www.postgresql.org/docs/10/static/sql-altertable.html Notes"Adding a column with a DEFAULT clause or changing the type of an existing column will require the entire table and its indexes to be rewritten.
Note that this will change with Postgres 11 https://www.depesz.com/2018/04/04/waiting-for-postgresql-11-fast-alter-table-add-column-with-a-non-null-default/
