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
2 rows affected
id | username | person | tweets | followers | following | likes | created_at | rnk | prev_followers | gain |
---|---|---|---|---|---|---|---|---|---|---|
4649077a-9188-4821-a1ec-3b38608ea44a | Kingston_Sav | null | 2737 | 1090 | 1084 | 1342 | 2020-10-12 | 1 | 1087 | 3 |
id | username | person | tweets | followers | following | likes | created_at | rnk | prev_followers | gain |
---|---|---|---|---|---|---|---|---|---|---|
5649077a-9188-4821-a1ec-3b38608ea44a | Kingston_Sav2 | null | 2737 | 2090 | 1084 | 1342 | 2020-10-12 | 1 | 2087 | 3 |
4649077a-9188-4821-a1ec-3b38608ea44a | Kingston_Sav | null | 2737 | 1090 | 1084 | 1342 | 2020-10-12 | 1 | 1087 | 3 |