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?.
22 rows affected
112 rows affected
50 rows affected
| id | studyId | siteId | statusType | statusFrom | statusTo | first_contact |
|---|---|---|---|---|---|---|
| INIT1-000001 | INIT1 | Test1 | INCOMPLETE | 2021-12-13 16:31:03.189717+00 | 2021-12-13 16:31:21.469405+00 | null |
| INIT1-000001 | INIT1 | Test1 | PENDING_CALLCENTER | 2021-12-13 16:31:21.469405+00 | 2021-12-14 08:13:12.3024+00 | 2021-12-13 16:31:36.122+00 |
| INIT1-000001 | INIT1 | Test1 | PENDING_SITE | 2021-12-14 08:13:12.3024+00 | 2022-01-19 15:39:16.108381+00 | 2021-12-14 08:13:56.466+00 |
| INIT1-000001 | INIT1 | Test1 | REJECTED_SITE | 2022-01-19 15:39:16.108381+00 | 2022-01-19 15:44:45.111142+00 | null |
| INIT1-000001 | INIT1 | Test1 | PENDING_SITE | 2022-01-19 15:44:45.111142+00 | 2022-01-19 16:04:55.314211+00 | null |
| INIT1-000001 | INIT1 | Test1 | REJECTED_SITE | 2022-01-19 16:04:55.314211+00 | 2022-01-19 16:06:27.358012+00 | null |
| INIT1-000001 | INIT1 | Test1 | PENDING_SITE | 2022-01-19 16:06:27.358012+00 | null | null |
| INIT1-000002 | INIT1 | Test1 | INCOMPLETE | 2022-01-12 18:48:21.773155+00 | 2022-01-12 18:49:23.248733+00 | null |
| INIT1-000002 | INIT1 | Test1 | PENDING_CALLCENTER | 2022-01-12 18:49:23.248733+00 | 2022-01-19 10:01:04.333633+00 | 2022-01-12 18:55:35.937+00 |
| INIT1-000002 | INIT1 | Test1 | REJECTED_CALLCENTER | 2022-01-19 10:01:04.333633+00 | 2022-01-19 10:01:44.798912+00 | null |
| INIT1-000002 | INIT1 | Test1 | PENDING_CALLCENTER | 2022-01-19 10:01:44.798912+00 | 2022-01-19 10:14:14.280248+00 | null |
| INIT1-000002 | INIT1 | Test1 | REJECTED_CALLCENTER | 2022-01-19 10:14:14.280248+00 | 2022-01-19 10:16:21.766518+00 | null |
| INIT1-000002 | INIT1 | Test1 | PENDING_CALLCENTER | 2022-01-19 10:16:21.766518+00 | 2022-01-19 10:18:21.040117+00 | null |
| INIT1-000002 | INIT1 | Test1 | PENDING_SITE | 2022-01-19 10:18:21.040117+00 | 2022-01-19 15:36:46.062001+00 | null |
| INIT1-000002 | INIT1 | Test1 | PENDING_CALLCENTER | 2022-01-19 15:36:46.062001+00 | null | null |
| INIT1-000003 | INIT1 | Test1 | INCOMPLETE | 2022-02-14 12:48:06.885073+00 | null | null |
| INIT1-000004 | INIT1 | Test1 | INCOMPLETE | 2022-02-14 12:48:54.11342+00 | null | null |
| INIT1-000005 | INIT1 | Test1 | INCOMPLETE | 2022-02-14 12:49:16.929879+00 | 2022-02-14 12:50:01.595741+00 | null |
| INIT1-000005 | INIT1 | Test1 | PENDING_CALLCENTER | 2022-02-14 12:50:01.595741+00 | null | null |
| INIT1-000006 | INIT1 | Test1 | INCOMPLETE | 2022-02-15 14:12:55.286955+00 | 2022-02-15 14:17:03.013145+00 | null |
| INIT1-000006 | INIT1 | Test1 | PENDING_CALLCENTER | 2022-02-15 14:17:03.013145+00 | null | null |
| INIT1-000007 | INIT1 | Test1 | INCOMPLETE | 2022-02-15 14:20:00.066733+00 | 2022-02-15 14:20:16.810911+00 | null |
| INIT1-000007 | INIT1 | Test1 | PENDING_CALLCENTER | 2022-02-15 14:20:16.810911+00 | null | null |
| INIT1-000008 | INIT1 | Test1 | INCOMPLETE | 2022-02-15 14:55:33.688575+00 | 2022-02-15 14:55:46.27229+00 | null |
| INIT1-000008 | INIT1 | Test1 | PENDING_CALLCENTER | 2022-02-15 14:55:46.27229+00 | null | null |
| INIT1-000009 | INIT1 | Test1 | INCOMPLETE | 2022-02-15 14:57:13.513819+00 | 2022-02-15 14:57:21.696746+00 | null |
| INIT1-000009 | INIT1 | Test1 | PENDING_CALLCENTER | 2022-02-15 14:57:21.696746+00 | null | null |
| INIT1-000010 | INIT1 | Test1 | INCOMPLETE | 2022-02-15 14:57:43.604089+00 | 2022-02-15 14:57:55.990336+00 | null |
| INIT1-000010 | INIT1 | Test1 | PENDING_CALLCENTER | 2022-02-15 14:57:55.990336+00 | null | null |
| INIT1-000011 | INIT1 | Test1 | INCOMPLETE | 2022-02-16 12:24:48.753726+00 | 2022-02-16 12:25:06.072666+00 | null |
| INIT1-000011 | INIT1 | Test1 | PENDING_CALLCENTER | 2022-02-16 12:25:06.072666+00 | null | null |
| INIT1-000012 | INIT1 | Test1 | INCOMPLETE | 2022-02-16 14:27:35.881027+00 | 2022-02-16 14:28:01.190789+00 | null |
| INIT1-000012 | INIT1 | Test1 | PENDING_CALLCENTER | 2022-02-16 14:28:01.190789+00 | null | null |
| INIT1-000013 | INIT1 | Test1 | INCOMPLETE | 2022-02-16 14:37:52.570706+00 | 2022-02-16 14:38:01.321945+00 | null |
| INIT1-000013 | INIT1 | Test1 | PENDING_CALLCENTER | 2022-02-16 14:38:01.321945+00 | null | null |
| INIT1-000014 | INIT1 | Test1 | INCOMPLETE | 2022-02-16 14:41:57.202717+00 | 2022-02-16 14:42:10.359291+00 | null |
| INIT1-000014 | INIT1 | Test1 | PENDING_CALLCENTER | 2022-02-16 14:42:10.359291+00 | null | null |
| INIT1-000015 | INIT1 | Test1 | INCOMPLETE | 2022-02-17 08:35:49.104398+00 | 2022-02-17 08:36:01.861429+00 | null |
| INIT1-000015 | INIT1 | Test1 | PENDING_CALLCENTER | 2022-02-17 08:36:01.861429+00 | null | null |
| INIT1-000016 | INIT1 | Test1 | INCOMPLETE | 2022-02-17 08:40:15.165769+00 | 2022-02-17 08:40:29.150307+00 | null |
| INIT1-000016 | INIT1 | Test1 | PENDING_CALLCENTER | 2022-02-17 08:40:29.150307+00 | null | null |
| INIT1-000017 | INIT1 | Test1 | INCOMPLETE | 2022-02-17 09:23:43.080548+00 | 2022-02-17 09:23:51.703684+00 | null |
| INIT1-000017 | INIT1 | Test1 | PENDING_CALLCENTER | 2022-02-17 09:23:51.703684+00 | null | null |
| INIT1-000018 | INIT1 | Test1 | INCOMPLETE | 2022-02-17 09:24:14.544276+00 | 2022-02-17 09:24:28.590407+00 | null |
| INIT1-000018 | INIT1 | Test1 | PENDING_CALLCENTER | 2022-02-17 09:24:28.590407+00 | null | null |
| INIT1-000019 | INIT1 | Test1 | INCOMPLETE | 2022-02-21 12:19:37.205188+00 | 2022-02-21 12:19:47.823267+00 | null |
| INIT1-000019 | INIT1 | Test1 | PENDING_CALLCENTER | 2022-02-21 12:19:47.823267+00 | null | null |