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?.
21 rows affected
id device_id fuel fillup
1 19 100 t
2 19 97 f
3 19 100 f
4 19 96 f
5 19 94 f
6 19 66 f
7 19 33 f
8 19 31 f
9 19 30 f
10 19 10 f
11 19 6 f
12 19 5 f
13 19 6 f
14 19 100 t
15 19 99 f
16 19 98 f
17 19 100 f
18 19 99 f
19 19 97 f
20 19 96 f
21 19 90 f
id device_id fuel fillup tank
1 19 100 t 1
2 19 97 f 1
3 19 100 f 1
4 19 96 f 1
5 19 94 f 1
6 19 66 f 1
7 19 33 f 1
8 19 31 f 1
9 19 30 f 1
10 19 10 f 1
11 19 6 f 1
12 19 5 f 1
13 19 6 f 1
14 19 100 t 2
15 19 99 f 2
16 19 98 f 2
17 19 100 f 2
18 19 99 f 2
19 19 97 f 2
20 19 96 f 2
21 19 90 f 2
id device_id fuel fillup tank
1 19 100 t 1
2 19 97 f 1
3 19 100 f 1
4 19 96 f 1
5 19 94 f 1
6 19 66 f 1
7 19 33 f 1
8 19 31 f 1
9 19 30 f 1
10 19 10 f 1
11 19 6 f 1
12 19 5 f 1
13 19 6 f 1