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?.
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