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?.
version
PostgreSQL 14.1 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-4), 64-bit
1 rows affected
order_id cust_id status
1 25 no products
order_status_from_order_product_status
no products
19 rows affected
order_id cust_id status
10 41 no products
1 25 pending
2 30 pending
3 25 in progress
4 47 complete
5 40 complete
6 1 in progress
7 32 complete
8 10 pending
9 49 pending
ord_prod_id order_id prod_id status
1 1 20 complete
2 1 50 in progress
3 1 75 pending
4 2 20 in progress
5 2 57 in progress
6 2 48 pending
7 3 25 complete
8 3 18 in progress
9 3 6 complete
10 4 22 complete
11 4 18 complete
12 4 64 complete
13 5 20 complete
14 6 82 in progress
15 7 13 complete
16 8 103 complete
17 8 63 pending
18 8 12 complete
19 9 12 pending
cdc_order_id operation cdc_tstz order_id old_order_status new_order_status
1 INSERT 2022-01-31 01:04:10.922488+00 1 null no products
2 INSERT 2022-01-31 01:04:10.923407+00 2 null no products
3 INSERT 2022-01-31 01:04:10.923459+00 3 null no products
4 INSERT 2022-01-31 01:04:10.923509+00 4 null no products
5 INSERT 2022-01-31 01:04:10.923546+00 5 null no products
6 INSERT 2022-01-31 01:04:10.923604+00 6 null no products
7 INSERT 2022-01-31 01:04:10.923629+00 7 null no products
8 INSERT 2022-01-31 01:04:10.923647+00 8 null no products
9 INSERT 2022-01-31 01:04:10.923663+00 9 null no products
10 INSERT 2022-01-31 01:04:10.92368+00 10 null no products
11 UPDATE 2022-01-31 01:04:10.928958+00 1 no products pending
12 UPDATE 2022-01-31 01:04:10.930203+00 2 no products pending
13 UPDATE 2022-01-31 01:04:10.931317+00 3 no products in progress
14 UPDATE 2022-01-31 01:04:10.932198+00 4 no products complete
15 UPDATE 2022-01-31 01:04:10.933079+00 5 no products complete
16 UPDATE 2022-01-31 01:04:10.933382+00 6 no products in progress
17 UPDATE 2022-01-31 01:04:10.933703+00 7 no products complete
18 UPDATE 2022-01-31 01:04:10.934008+00 8 no products pending
19 UPDATE 2022-01-31 01:04:10.934912+00 9 no products pending
1 rows affected
order_id cust_id status
3 25 complete
1 rows affected
order_id cust_id status
4 47 pending
1 rows affected
order_id cust_id status
8 10 complete
1 rows affected
order_id cust_id status
9 49 no products
1 rows affected
order_id cust_id status
4 47 complete
5 40 pending
cdc_order_id operation cdc_tstz order_id old_order_status new_order_status
1 INSERT 2022-01-31 01:04:10.922488+00 1 null no products
11 UPDATE 2022-01-31 01:04:10.928958+00 1 no products pending
2 INSERT 2022-01-31 01:04:10.923407+00 2 null no products
12 UPDATE 2022-01-31 01:04:10.930203+00 2 no products pending
3 INSERT 2022-01-31 01:04:10.923459+00 3 null no products
13 UPDATE 2022-01-31 01:04:10.931317+00 3 no products in progress
20 UPDATE 2022-01-31 01:04:10.93928+00 3 in progress complete
4 INSERT 2022-01-31 01:04:10.923509+00 4 null no products
14 UPDATE 2022-01-31 01:04:10.932198+00 4 no products complete
21 UPDATE 2022-01-31 01:04:10.940166+00 4 complete pending
24 UPDATE 2022-01-31 01:04:10.94443+00 4 pending complete
5 INSERT 2022-01-31 01:04:10.923546+00 5 null no products
15 UPDATE 2022-01-31 01:04:10.933079+00 5 no products complete
25 UPDATE 2022-01-31 01:04:10.945152+00 5 complete pending
6 INSERT 2022-01-31 01:04:10.923604+00 6 null no products
16 UPDATE 2022-01-31 01:04:10.933382+00 6 no products in progress
7 INSERT 2022-01-31 01:04:10.923629+00 7 null no products
17 UPDATE 2022-01-31 01:04:10.933703+00 7 no products complete
8 INSERT 2022-01-31 01:04:10.923647+00 8 null no products
18 UPDATE 2022-01-31 01:04:10.934008+00 8 no products pending
22 UPDATE 2022-01-31 01:04:10.941114+00 8 pending complete
9 INSERT 2022-01-31 01:04:10.923663+00 9 null no products
19 UPDATE 2022-01-31 01:04:10.934912+00 9 no products pending
23 UPDATE 2022-01-31 01:04:10.942046+00 9 pending no products
10 INSERT 2022-01-31 01:04:10.92368+00 10 null no products