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?.
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