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?.
14 rows affected
34 rows affected
company_identifier user_identifier model prediction
company_a user2 model_a 0.33
company_a user1 model_a 0.5
company_a user2 model_b 0.27
company_a user1 model_b 0.6
company_a user2 model_c 0.75
company_a user1 model_c 0.3
company_b user2 model_a 0.35
company_b user1 model_a 0.36
company_b user3 model_a 0.32
company_b user3 model_b 0.51
company_b user1 model_b 0.67
company_b user2 model_b 0.56
company_b user2 model_c 0.54
company_b user1 model_c 0.84
company_identifier user_identifier created_at pageview_current_url_type
company_a user1 null PAGE_TYPE_A
company_a user1 null PAGE_TYPE_B
company_a user1 null PAGE_TYPE_C
company_a user1 null PAGE_TYPE_B
company_a user1 null PAGE_TYPE_A
company_a user1 null PAGE_TYPE_B
company_a user1 null PAGE_TYPE_B
company_a user1 null BUYSUCCESS
company_a user2 null PAGE_TYPE_D
company_a user2 null PAGE_TYPE_F
company_a user2 null PAGE_TYPE_H
company_a user2 null PAGE_TYPE_A
company_a user2 null PAGE_TYPE_B
company_a user2 null BUYSUCCESS
company_a user2 null BUYSUCCESS
company_a user2 null BUYSUCCESS
company_b user1 null PAGE_TYPE_A
company_b user1 null PAGE_TYPE_B
company_b user1 null PAGE_TYPE_C
company_b user1 null PAGE_TYPE_B
company_b user1 null PAGE_TYPE_A
company_b user1 null PAGE_TYPE_B
company_b user1 null PAGE_TYPE_B
company_b user1 null BUYSUCCESS
company_b user2 null PAGE_TYPE_D
company_b user2 null PAGE_TYPE_F
company_b user2 null PAGE_TYPE_H
company_b user2 null PAGE_TYPE_A
company_b user2 null PAGE_TYPE_B
company_b user3 null PAGE_TYPE_D
company_b user3 null PAGE_TYPE_F
company_b user3 null PAGE_TYPE_H
company_b user3 null BUYSUCCESS
company_b user3 null PAGE_TYPE_B
company_identifier model segment segment_users really_bought
company_a model_a 0.3-0.4 1 3
company_a model_a 0.4-0.5 1 1
company_a model_a 0.5-0.6 1 1
company_a model_b 0.2-0.3 1 3
company_a model_b 0.6-0.7 1 1
company_a model_c 0.3-0.4 1 1
company_a model_c 0.7-0.8 1 3
company_b model_a 0.3-0.4 3 2
company_b model_b 0.5-0.6 2 1
company_b model_b 0.6-0.7 1 1
company_b model_c 0.5-0.6 1 0
company_b model_c 0.8-0.9 1 1