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/