Stats about ORSANCO data
min and max times
| Type | Timestamp | Human Readable format |
|---|---|---|
| min | 1258304400 | Sunday, November 15, 2009 5:00:00 PM GMT |
| max | 1610384400 | Monday, January 11, 2021 5:00:00 PM GMT |
Other stats about the data
- Time for inserting the 10 yr history in postgres → 16 hours
- Time for creating the daily table from 10 yr history → 3 hours
- Size of the entire 10 year SQL Dump → ~10 GB
- Size of the entire 10 year database → 58 GB
Database sizes
