looking at the R92 release notes, i think we were affected by that bug mentioned in the article below and probably what is causing some issues for me now as well.
dev=> SELECT * FROM atomic.manifest WHERE etl_tstamp BETWEEN ‘2017-07-27’ AND ‘2017-09-29’ AND shredded_cardinality = 0;
etl_tstamp | commit_tstamp | event_count | shredded_cardinality
-------------------------±---------------------------±------------±---------------------
2017-08-08 19:03:24.783 | 2017-08-08 21:56:40.57218 | 673279 | 0
2017-08-08 19:03:24.783 | 2017-08-08 23:20:50.459025 | 1346558 | 0
2017-08-08 19:03:24.783 | 2017-08-09 15:12:48.290994 | 2019837 | 0
2017-09-13 00:07:13.448 | 2017-09-13 13:49:03.065501 | 16718 | 0
2017-09-13 00:07:13.448 | 2017-09-13 14:23:31.142434 | 25077 | 0
2017-09-13 00:07:13.448 | 2017-09-13 14:39:53.088461 | 33436 | 0
2017-09-13 00:07:13.448 | 2017-09-13 15:22:49.999815 | 41795 | 0
2017-09-13 00:07:13.448 | 2017-09-13 15:38:42.900336 | 50154 | 0
2017-09-13 00:07:13.448 | 2017-09-13 15:51:55.204104 | 58513 | 0
2017-09-28 14:07:04.974 | 2017-09-28 17:27:55.663084 | 142461 | 0
2017-09-28 14:07:04.974 | 2017-09-28 17:53:53.1087 | 284922 | 0
(11 rows)