Adding a CHECK constraint doesn't improve performance of ATTACH PARTITION on postgres table
I can only reproduce this if mess_201811.loadedtime is nullable, in which case it has to be scanned for NULL values upon attachment.  If the column is NOT NULL, then the scan upon attachment is skipped.