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 12.7 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.3.1 20191121 (Red Hat 8.3.1-5), 64-bit |
10 rows affected
10 rows affected
5 rows affected
10 rows affected
10 rows affected
camera_id | btrim | title | exid | created_at | from_date | to_date | embed_code | file_name | frames | url | public | status | type | extra | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
siskm-guhev | fintocci@its.jnj.com | FRANCESCO INTOCCIA | Sparks Building, Newcastle - Time-lapse, July 2020 | spark-kyzrq | 2020-07-28 16:25:33.449623+01 | 2020-07-28 16:25:33.449425+01 | 2020-07-28 16:25:33.449425+01 | null | null | 0 | https://vimeo.com/442398703/ec9450b8e0 | null | 2 | url | null |
siskm-guhev | fintocci@its.jnj.com | FRANCESCO INTOCCIA | 2018-09-26T10:00:04.000Z | 201809-27xn | 2018-11-27 16:05:01.813853+00 | 2018-09-26 10:00:04+01 | 2018-09-26 10:00:04+01 | null | 201809-27xn.jpeg | 0 | null | null | 2 | edit | null |
siskm-guhev | fintocci@its.jnj.com | FRANCESCO INTOCCIA | Concrete Pour | concre-r6ys | 2017-04-05 15:46:38+01 | 2017-04-05 14:25:05+01 | 2017-04-05 14:55:05+01 | null | null | 840 | null | f | 2 | clip | null |
stens-wjcyf | paul.braham@hse.ie | Paul Braham | 2016-11-06 BWLiffeyCruises 1200-1230 | 201611-luw8 | 2016-11-23 09:36:32+00 | 2016-11-06 12:00:00+00 | 2016-11-06 12:30:00+00 | null | null | 897 | null | f | 2 | clip | null |
stens-wjcyf | fintocci@its.jnj.com | FRANCESCO INTOCCIA | joe clip | joecli-kvpw | 2017-04-20 00:02:35+01 | 2017-04-19 16:10:00+01 | 2017-04-19 16:40:00+01 | null | null | 799 | null | null | 2 | clip | null |
dslrf-bxtgj | fintocci@its.jnj.com | FRANCESCO INTOCCIA | Bartra - Loughshinny Time-lapse, October 2018 | bartra-bnm5 | 2018-10-15 14:49:51.783621+01 | 2018-10-15 13:49:52+01 | 2018-10-15 13:49:52+01 | null | null | 0 | https://vimeo.com/294316497 | null | 2 | url | null |
dslrf-bxtgj | paul.braham@hse.ie | Paul Braham | Joe's Clip | joescl-pgfl | 2017-04-21 10:23:47+01 | 2017-04-19 16:40:00+01 | 2017-04-19 17:10:00+01 | null | null | 542 | null | null | 2 | clip | null |
norma-cfnbk | fintocci@its.jnj.com | FRANCESCO INTOCCIA | 2019-02-01T10:13:47.000Z | 201902-htu9 | 2019-02-01 10:14:56+00 | 2019-02-01 10:13:47+00 | 2019-02-01 10:13:47+00 | null | 201902-htu9.jpeg | 0 | null | null | 2 | edit | null |
jubil-tjlmk | paul.braham@hse.ie | Paul Braham | Joe's clip | joescl-fv4u | 2017-04-21 10:25:13+01 | 2017-04-19 16:10:00+01 | 2017-04-19 16:40:00+01 | null | null | 799 | null | null | 2 | clip | null |
jubil-tjlmk | lrahilly@meicltd.com | Liam Rahilly | Extract | extrac-png8 | 2017-04-18 09:50:42+01 | 2017-04-12 17:25:00+01 | 2017-04-12 17:40:00+01 | null | null | 853 | null | f | 2 | clip | null |
siskm-guhev | rkirrane@deniswilliams.ie | Reuben Kirrane | Long Ponds | longp-mvxla | 2017-05-18 08:16:13+01 | 2016-08-29 00:00:00+01 | 2016-08-29 23:59:59+01 | null | null | null | null | null | 3 | null | {"id":798} |
stens-wjcyf | b.borowiak@waterman-moylan.ie | Bartosz Borowiak | Basement Today | basem-hfmjp | 2019-01-22 11:49:46.333172+00 | 2019-01-22 10:00:00+00 | 2019-01-22 11:00:00+00 | null | null | null | null | null | 6 | null | null |
dslrf-bxtgj | paul.braham@hse.ie | Paul Braham | 3PP | 3pp-cloxd | 2017-05-18 08:16:12+01 | 1900-01-01 08:00:00+00 | 8888-12-31 19:00:00+00 | null | null | null | null | null | 3 | null | {"id":717} |
norma-cfnbk | fintocci@its.jnj.com | FRANCESCO INTOCCIA | Digital HUb | digit-rgblx | 2017-05-18 08:16:10+01 | 1900-01-01 06:00:00+00 | 8888-12-31 19:00:00+00 | null | null | null | null | null | 3 | null | {"id":260} |
jubil-tjlmk | rkirrane@deniswilliams.ie | Reuben Kirrane | Demo | demo-jvnzg | 2017-05-18 08:16:10+01 | 1900-01-01 00:00:00+00 | 8888-12-31 23:59:59+00 | null | null | null | null | null | 3 | null | {"id":559} |
siskm-guhev | rkirrane@deniswilliams.ie | Reuben Kirrane | compa-kycgmav | Compare: 1st Nov to 5th Apr | 2019-04-08 14:54:03.809314+01 | 2018-11-01 10:11:04+00 | 2019-04-05 11:04:02+01 | <div id='evercam-compare'></div><script src='https://dash.evercam.io/assets/evercam_compare.js' class='south-ragcn 2018-11-01-10_11_04 2019-04-05-11_04_02 compa-kycgmav autoplay'></script> | null | null | null | t | 1 | null | null |
siskm-guhev | fintocci@its.jnj.com | FRANCESCO INTOCCIA | compa-momncjm | Compare: 11th Oct to 19th Nov | 2018-11-19 15:28:52.359459+00 | 2018-10-11 11:10:51+01 | 2018-11-19 15:26:56+00 | <div id='evercam-compare'></div><script src='https://dash.evercam.io/assets/evercam_compare.js' class='leins-ugxco 2018-10-11-11_10_51 2018-11-19-15_26_56 compa-momncjm autoplay'></script> | null | null | null | t | 1 | null | null |
siskm-guhev | rkirrane@deniswilliams.ie | Reuben Kirrane | compa-tjhacxd | Compare: 23rd Jan to 27th Oct | 2018-10-29 05:56:52.67979+00 | 2018-01-23 13:37:55+00 | 2018-10-27 12:07:22+01 | <div id='evercam-compare'></div><script src='https://dash.evercam.io/assets/evercam_compare.js' class='scotc-rpfbq 2018-01-23-13_37_55 2018-10-27-12_07_22 compa-tjhacxd autoplay'></script> | null | null | null | t | 1 | null | null |
siskm-guhev | rkirrane@deniswilliams.ie | Reuben Kirrane | compa-ylxwctg | Compare: 8th Sep to 29th Oct | 2018-10-29 05:52:09.659566+00 | 2017-09-08 14:35:25+01 | 2018-10-29 05:51:47+00 | <div id='evercam-compare'></div><script src='https://dash.evercam.io/assets/evercam_compare.js' class='iaaco-auftq 2017-09-08-14_35_25 2018-10-29-05_51_47 compa-ylxwctg autoplay'></script> | null | null | null | t | 1 | null | null |
stens-wjcyf | paul.braham@hse.ie | Paul Braham | compa-kdxjbhh | Compare: 4th Dec to 14th Dec | 2018-12-14 22:25:00.735079+00 | 2018-12-04 16:30:03+00 | 2018-12-14 16:12:04+00 | <div id='evercam-compare'></div><script src='https://dash.evercam.io/assets/evercam_compare.js' class='still-bojft 2018-12-04-16_30_03 2018-12-14-16_12_04 compa-kdxjbhh autoplay'></script> | null | null | null | t | 1 | null | null |
stens-wjcyf | paul.braham@hse.ie | Paul Braham | compa-vztxtjc | Compare: 18th Jul to 1st Nov | 2018-11-15 10:03:24.85408+00 | 2015-07-18 15:07:00+01 | 2018-11-01 00:05:43+00 | <div id='evercam-compare'></div><script src='https://dash.evercam.io/assets/evercam_compare.js' class='bennett 2015-07-18-15_07_00 2018-11-01-00_05_43 compa-vztxtjc autoplay'></script> | null | null | null | t | 1 | null | null |
stens-wjcyf | b.borowiak@waterman-moylan.ie | Bartosz Borowiak | test-hroqe | test | 2018-01-17 11:08:19.845168+00 | 2017-06-21 13:20:55+01 | 2018-01-17 10:27:58+00 | <div id='evercam-compare'></div><script src='https://dash.evercam.io/assets/evercam_compare.js' class='point-iytnz 2017-06-21-13_20_55 2018-01-17-10_27_58 test-hroqe autoplay'></script> | null | null | null | t | 1 | null | null |
dslrf-bxtgj | rkirrane@deniswilliams.ie | Reuben Kirrane | compa-ltafnon | Compare: 26th Jul to 29th Oct | 2018-10-29 05:53:39.989565+00 | 2018-07-26 14:23:00+01 | 2018-10-29 05:37:00+00 | <div id='evercam-compare'></div><script src='https://dash.evercam.io/assets/evercam_compare.js' class='crome-tidcz 2018-07-26-14_23_00 2018-10-29-05_37_00 compa-ltafnon autoplay'></script> | null | null | null | t | 1 | null | null |
norma-cfnbk | fintocci@its.jnj.com | FRANCESCO INTOCCIA | itsac-ihtlze | Its a compare | 2020-01-01 08:46:23.172885+00 | 2016-03-19 05:21:12+00 | 2020-01-01 08:45:34+00 | <div id='evercam-compare'></div><script src='https://dash2.evercam.io/evercam_compare.js' class='gpocam 2016-03-19-05_21_12 2020-01-01-08_45_34 itsac-ihtlze autoplay'></script> | null | null | null | t | 1 | null | null |
norma-cfnbk | lrahilly@meicltd.com | Liam Rahilly | compa-cockhyp | Compare: 11th Jan to 19th Dec | 2018-12-19 14:13:35.856163+00 | 2018-01-11 14:36:19+00 | 2018-12-19 14:12:09+00 | <div id='evercam-compare'></div><script src='https://dash.evercam.io/assets/evercam_compare.js' class='mscpi-pkjwh 2018-01-11-14_36_19 2018-12-19-14_12_09 compa-cockhyp autoplay'></script> | null | null | null | t | 1 | null | null |