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?.
CREATE TABLE
INSERT 0 7
levelindex | boqitemname | sitename |
---|---|---|
1 | First things first | null |
1.1 | First of first things | null |
1.1.1 | Clamp | null |
1.1.1.1 | Hand Clamp | null |
1.1.1.2 | Door Clamp | null |
1.1.2 | Switches | null |
1.1.2.1 | Two way switch | null |
SELECT 7
UPDATE 7
levelindex | boqitemname | sitename |
---|---|---|
1 | First things first | null |
1.1 | First of first things | First things first |
1.1.1 | Clamp | First of first things |
1.1.1.1 | Hand Clamp | Clamp |
1.1.1.2 | Door Clamp | Clamp |
1.1.2 | Switches | First of first things |
1.1.2.1 | Two way switch | Switches |
SELECT 7
UPDATE 7
levelindex | boqitemname | sitename |
---|---|---|
1 | First things first | First things first |
1.1 | First of first things | First things first |
1.1.1 | Clamp | First of first things |
1.1.1.1 | Hand Clamp | Clamp |
1.1.1.2 | Door Clamp | Clamp |
1.1.2 | Switches | First of first things |
1.1.2.1 | Two way switch | Switches |
SELECT 7