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?.
SELECT 1
SELECT 5
ERROR: function json_to_recordset(jsonb) does not exist LINE 14: json_to_recordset(my_json ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.
home | away | scoring_type_id | periods_id | bet_types | outcomes | param | value |
---|---|---|---|---|---|---|---|
team1 | team2 | 1 | 1 | 1 | 1 | null | 1.85 |
team1 | team2 | 1 | 1 | 1 | 2 | null | 6.50 |
team1 | team2 | 1 | 1 | 1 | 3 | null | 3.85 |
team1 | team2 | 1 | 1 | 2 | 1 | 8.5 | 1.9 |
team1 | team2 | 1 | 1 | 2 | 2 | 8.5 | 1.9 |
SELECT 5
jsonb_pretty | n | jsonb_pretty | e_key | jsonb_pretty | periods_id | jsonb_pretty | p2_key | jsonb_pretty | scoring_type_id | jsonb_pretty | s2_key | jsonb_pretty | bet_type_id | jsonb_pretty | param | outcomes | value |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
[ { "away": "team2", "home": "team1", "odds": { "periods": { "1": { "scoring_types": { "1": { "bet_types": { "1": { "param": null, "outcomes": { "1": 1.85, "2": 6.50, "3": 3.85 } }, "2": { "param": 8.5, "outcomes": { "1": 1.9, "2": 1.9 } } } } } } } } } ] |
1 | { "away": "team2", "home": "team1", "odds": { "periods": { "1": { "scoring_types": { "1": { "bet_types": { "1": { "param": null, "outcomes": { "1": 1.85, "2": 6.50, "3": 3.85 } }, "2": { "param": 8.5, "outcomes": { "1": 1.9, "2": 1.9 } } } } } } } } } |
periods | { "1": { "scoring_types": { "1": { "bet_types": { "1": { "param": null, "outcomes": { "1": 1.85, "2": 6.50, "3": 3.85 } }, "2": { "param": 8.5, "outcomes": { "1": 1.9, "2": 1.9 } } } } } } } |
1 | { "scoring_types": { "1": { "bet_types": { "1": { "param": null, "outcomes": { "1": 1.85, "2": 6.50, "3": 3.85 } }, "2": { "param": 8.5, "outcomes": { "1": 1.9, "2": 1.9 } } } } } } |
scoring_types | { "1": { "bet_types": { "1": { "param": null, "outcomes": { "1": 1.85, "2": 6.50, "3": 3.85 } }, "2": { "param": 8.5, "outcomes": { "1": 1.9, "2": 1.9 } } } } } |
1 | { "bet_types": { "1": { "param": null, "outcomes": { "1": 1.85, "2": 6.50, "3": 3.85 } }, "2": { "param": 8.5, "outcomes": { "1": 1.9, "2": 1.9 } } } } |
bet_types | { "1": { "param": null, "outcomes": { "1": 1.85, "2": 6.50, "3": 3.85 } }, "2": { "param": 8.5, "outcomes": { "1": 1.9, "2": 1.9 } } } |
1 | { "param": null, "outcomes": { "1": 1.85, "2": 6.50, "3": 3.85 } } |
null | 1 | 1.85 |
[ { "away": "team2", "home": "team1", "odds": { "periods": { "1": { "scoring_types": { "1": { "bet_types": { "1": { "param": null, "outcomes": { "1": 1.85, "2": 6.50, "3": 3.85 } }, "2": { "param": 8.5, "outcomes": { "1": 1.9, "2": 1.9 } } } } } } } } } ] |
1 | { "away": "team2", "home": "team1", "odds": { "periods": { "1": { "scoring_types": { "1": { "bet_types": { "1": { "param": null, "outcomes": { "1": 1.85, "2": 6.50, "3": 3.85 } }, "2": { "param": 8.5, "outcomes": { "1": 1.9, "2": 1.9 } } } } } } } } } |
periods | { "1": { "scoring_types": { "1": { "bet_types": { "1": { "param": null, "outcomes": { "1": 1.85, "2": 6.50, "3": 3.85 } }, "2": { "param": 8.5, "outcomes": { "1": 1.9, "2": 1.9 } } } } } } } |
1 | { "scoring_types": { "1": { "bet_types": { "1": { "param": null, "outcomes": { "1": 1.85, "2": 6.50, "3": 3.85 } }, "2": { "param": 8.5, "outcomes": { "1": 1.9, "2": 1.9 } } } } } } |
scoring_types | { "1": { "bet_types": { "1": { "param": null, "outcomes": { "1": 1.85, "2": 6.50, "3": 3.85 } }, "2": { "param": 8.5, "outcomes": { "1": 1.9, "2": 1.9 } } } } } |
1 | { "bet_types": { "1": { "param": null, "outcomes": { "1": 1.85, "2": 6.50, "3": 3.85 } }, "2": { "param": 8.5, "outcomes": { "1": 1.9, "2": 1.9 } } } } |
bet_types | { "1": { "param": null, "outcomes": { "1": 1.85, "2": 6.50, "3": 3.85 } }, "2": { "param": 8.5, "outcomes": { "1": 1.9, "2": 1.9 } } } |
1 | { "param": null, "outcomes": { "1": 1.85, "2": 6.50, "3": 3.85 } } |
null | 2 | 6.50 |
[ { "away": "team2", "home": "team1", "odds": { "periods": { "1": { "scoring_types": { "1": { "bet_types": { "1": { "param": null, "outcomes": { "1": 1.85, "2": 6.50, "3": 3.85 } }, "2": { "param": 8.5, "outcomes": { "1": 1.9, "2": 1.9 } } } } } } } } } ] |
1 | { "away": "team2", "home": "team1", "odds": { "periods": { "1": { "scoring_types": { "1": { "bet_types": { "1": { "param": null, "outcomes": { "1": 1.85, "2": 6.50, "3": 3.85 } }, "2": { "param": 8.5, "outcomes": { "1": 1.9, "2": 1.9 } } } } } } } } } |
periods | { "1": { "scoring_types": { "1": { "bet_types": { "1": { "param": null, "outcomes": { "1": 1.85, "2": 6.50, "3": 3.85 } }, "2": { "param": 8.5, "outcomes": { "1": 1.9, "2": 1.9 } } } } } } } |
1 | { "scoring_types": { "1": { "bet_types": { "1": { "param": null, "outcomes": { "1": 1.85, "2": 6.50, "3": 3.85 } }, "2": { "param": 8.5, "outcomes": { "1": 1.9, "2": 1.9 } } } } } } |
scoring_types | { "1": { "bet_types": { "1": { "param": null, "outcomes": { "1": 1.85, "2": 6.50, "3": 3.85 } }, "2": { "param": 8.5, "outcomes": { "1": 1.9, "2": 1.9 } } } } } |
1 | { "bet_types": { "1": { "param": null, "outcomes": { "1": 1.85, "2": 6.50, "3": 3.85 } }, "2": { "param": 8.5, "outcomes": { "1": 1.9, "2": 1.9 } } } } |
bet_types | { "1": { "param": null, "outcomes": { "1": 1.85, "2": 6.50, "3": 3.85 } }, "2": { "param": 8.5, "outcomes": { "1": 1.9, "2": 1.9 } } } |
1 | { "param": null, "outcomes": { "1": 1.85, "2": 6.50, "3": 3.85 } } |
null | 3 | 3.85 |
[ { "away": "team2", "home": "team1", "odds": { "periods": { "1": { "scoring_types": { "1": { "bet_types": { "1": { "param": null, "outcomes": { "1": 1.85, "2": 6.50, "3": 3.85 } }, "2": { "param": 8.5, "outcomes": { "1": 1.9, "2": 1.9 } } } } } } } } } ] |
1 | { "away": "team2", "home": "team1", "odds": { "periods": { "1": { "scoring_types": { "1": { "bet_types": { "1": { "param": null, "outcomes": { "1": 1.85, "2": 6.50, "3": 3.85 } }, "2": { "param": 8.5, "outcomes": { "1": 1.9, "2": 1.9 } } } } } } } } } |
periods | { "1": { "scoring_types": { "1": { "bet_types": { "1": { "param": null, "outcomes": { "1": 1.85, "2": 6.50, "3": 3.85 } }, "2": { "param": 8.5, "outcomes": { "1": 1.9, "2": 1.9 } } } } } } } |
1 | { "scoring_types": { "1": { "bet_types": { "1": { "param": null, "outcomes": { "1": 1.85, "2": 6.50, "3": 3.85 } }, "2": { "param": 8.5, "outcomes": { "1": 1.9, "2": 1.9 } } } } } } |
scoring_types | { "1": { "bet_types": { "1": { "param": null, "outcomes": { "1": 1.85, "2": 6.50, "3": 3.85 } }, "2": { "param": 8.5, "outcomes": { "1": 1.9, "2": 1.9 } } } } } |
1 | { "bet_types": { "1": { "param": null, "outcomes": { "1": 1.85, "2": 6.50, "3": 3.85 } }, "2": { "param": 8.5, "outcomes": { "1": 1.9, "2": 1.9 } } } } |
bet_types | { "1": { "param": null, "outcomes": { "1": 1.85, "2": 6.50, "3": 3.85 } }, "2": { "param": 8.5, "outcomes": { "1": 1.9, "2": 1.9 } } } |
2 | { "param": 8.5, "outcomes": { "1": 1.9, "2": 1.9 } } |
8.5 | 1 | 1.9 |
[ { "away": "team2", "home": "team1", "odds": { "periods": { "1": { "scoring_types": { "1": { "bet_types": { "1": { "param": null, "outcomes": { "1": 1.85, "2": 6.50, "3": 3.85 } }, "2": { "param": 8.5, "outcomes": { "1": 1.9, "2": 1.9 } } } } } } } } } ] |
1 | { "away": "team2", "home": "team1", "odds": { "periods": { "1": { "scoring_types": { "1": { "bet_types": { "1": { "param": null, "outcomes": { "1": 1.85, "2": 6.50, "3": 3.85 } }, "2": { "param": 8.5, "outcomes": { "1": 1.9, "2": 1.9 } } } } } } } } } |
periods | { "1": { "scoring_types": { "1": { "bet_types": { "1": { "param": null, "outcomes": { "1": 1.85, "2": 6.50, "3": 3.85 } }, "2": { "param": 8.5, "outcomes": { "1": 1.9, "2": 1.9 } } } } } } } |
1 | { "scoring_types": { "1": { "bet_types": { "1": { "param": null, "outcomes": { "1": 1.85, "2": 6.50, "3": 3.85 } }, "2": { "param": 8.5, "outcomes": { "1": 1.9, "2": 1.9 } } } } } } |
scoring_types | { "1": { "bet_types": { "1": { "param": null, "outcomes": { "1": 1.85, "2": 6.50, "3": 3.85 } }, "2": { "param": 8.5, "outcomes": { "1": 1.9, "2": 1.9 } } } } } |
1 | { "bet_types": { "1": { "param": null, "outcomes": { "1": 1.85, "2": 6.50, "3": 3.85 } }, "2": { "param": 8.5, "outcomes": { "1": 1.9, "2": 1.9 } } } } |
bet_types | { "1": { "param": null, "outcomes": { "1": 1.85, "2": 6.50, "3": 3.85 } }, "2": { "param": 8.5, "outcomes": { "1": 1.9, "2": 1.9 } } } |
2 | { "param": 8.5, "outcomes": { "1": 1.9, "2": 1.9 } } |
8.5 | 2 | 1.9 |
SELECT 5