add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
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