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 |