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?.
10 rows affected
id | username | person | tweets | followers | following | likes | created_at |
---|---|---|---|---|---|---|---|
3fa34100-d688-4051-a687-ec49d05e7212 | renok | null | 110 | 6 | 0 | 0 | 2020-10-10 |
bab9ceb9-2770-49ea-8489-77e5d763a223 | Lydia_C | test user2 | 515 | 1301 | 1852 | 1677 | 2020-10-10 |
4649077a-9188-4821-a1ec-3b38608ea44a | Kingston_Sav | null | 2730 | 1087 | 1082 | 1339 | 2020-10-10 |
eef80836-e140-4adc-9598-8b612ab1825b | TP_s | null | 1835 | 998 | 956 | 1832 | 2020-10-10 |
fd3ff8c7-0994-40b6-abe0-915368ab9ae5 | DKSnr4 | null | 580 | 268 | 705 | 703 | 2020-10-10 |
3fa34100-d688-4051-a687-ec49d05e7212 | renok | null | 119 | 6 | 0 | 0 | 2020-10-12 |
bab9ceb9-2770-49ea-8489-77e5d763a223 | Lydia_C | test user2 | 516 | 1301 | 1852 | 1687 | 2020-10-12 |
4649077a-9188-4821-a1ec-3b38608ea44a | Kingston_Sav | null | 2737 | 1090 | 1084 | 1342 | 2020-10-12 |
eef80836-e140-4adc-9598-8b612ab1825b | TP_s | null | 1833 | 998 | 957 | 1837 | 2020-10-12 |
fd3ff8c7-0994-40b6-abe0-915368ab9ae5 | DKSnr4 | null | 570 | 268 | 700 | 703 | 2020-10-12 |
id | username | person | tweets | followers | following | likes | created_at | prev_followers | gain |
---|---|---|---|---|---|---|---|---|---|
4649077a-9188-4821-a1ec-3b38608ea44a | Kingston_Sav | null | 2737 | 1090 | 1084 | 1342 | 2020-10-12 | 1087 | 3 |