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?.
2 rows affected
2 rows affected
4 rows affected
8 rows affected
work_day | associate_name | job_description | average_daily_goal | worked_hours |
---|---|---|---|---|
2017-07-01 | Alice Cooper | Cleaning windows | 5.00 | 5.00 |
2017-07-01 | Alice Cooper | Dish whashing | 1.00 | 0.70 |
2017-07-01 | Bob Geldorf | Cleaning windows | 3.00 | 3.00 |
2017-07-01 | Bob Geldorf | Dish whashing | 0.50 | 1.00 |
2017-07-02 | Alice Cooper | Cleaning windows | 5.00 | 3.00 |
2017-07-02 | Alice Cooper | Dish whashing | 1.00 | 0.80 |
2017-07-02 | Bob Geldorf | Cleaning windows | 3.00 | 2.00 |
2017-07-02 | Bob Geldorf | Dish whashing | 0.50 | 1.30 |
associate_name | job_description | average_daily_goal | average_worked_hours |
---|---|---|---|
Alice Cooper | Cleaning windows | 5.00 | 4.00 |
Alice Cooper | Dish whashing | 1.00 | 0.75 |
Bob Geldorf | Cleaning windows | 3.00 | 2.50 |
Bob Geldorf | Dish whashing | 0.50 | 1.15 |