By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Help with an interesting Postgres question: Why isn't an Index Only Scan used on a partition accessed via the parent table?.
22 rows affected
app_id | earliest_review | total_ct |
---|---|---|
3 | 2020-08-02 | 6 |
2 | 2020-08-03 | 6 |
1 | 2020-08-01 | 10 |
generate_series |
---|
2020-08-01 |
2020-08-02 |
2020-08-03 |
2020-08-04 |
2020-08-05 |
2020-08-06 |
2020-08-07 |
review_window_start | total_ct | apps |
---|---|---|
2020-08-01 | 10 | {1} |
2020-08-02 | 6 | {3,2} |
2020-08-03 | 6 | {2} |
2020-08-04 | null | null |
2020-08-05 | null | null |
2020-08-06 | null | null |
2020-08-07 | null | null |
review_window_start | total_ct | apps |
---|---|---|
2020-08-01 | 10 | {1} |
2020-08-02 | 6 | {3,2} |
2020-08-03 | 6 | {2} |
2020-08-04 | null | null |
2020-08-05 | null | null |
2020-08-06 | null | null |
2020-08-07 | null | null |