Use SQL to Find Missing Numbers and Gaps in Sequence of Numbers like Identity Column
postgresql - Filling Postgres table gaps with oldest available value - Stack Overflow
Automatic ID Generation in PostgreSQL with Node.js and Sequelize | YugabyteDB
Visualizing PostgreSQL Vacuum Progress · Dave Pacheco's Blog
PostgreSQL: interpolate missing value - Database Administrators Stack Exchange
Data boundaries: Finding gaps, islands, and more
Using Sequences in database systems - Database Tips
LOCF and Linear Imputation with PostgreSQL | joy of data
Check Gaps
GitHub - singularsyntax/postgres-timeseries: An extension for PostgreSQL adding a time series data type and support functions implemented on top of LOs (large objects)