New: generate-series

nmd (25)in missing-data • 7 years ago
Finding missing data in a table for a certain period of time with PostgreSQL
At my work, there is a system that inserts data into the DB hourly. From time to time some data is missing randomly, for example, 2 hours of a day in January, 10 hours in February, 24 hours in May…
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Disagreement on rewards
Fraud or plagiarism
Hate speech or trolling
Miscategorized content or spam

Submit
$0.00
2

Finding missing data in a table for a certain period of time with PostgreSQL