Postgres 11

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 * 
from json_to_record('{"reach": 240, "spend": 3.34, "clicks": 10, "frequency": 1.0375}') 
as x(reach int, spend numeric, clicks int, frequency numeric)

reach
spend
clicks
frequency

240
3.34
10
1.0375

SELECT 1

create table facebook (metrics json);

CREATE TABLE

insert into facebook(metrics)
values ('{"cpc": 0.765125, "cpm": 9.955878, "cpp": 10.295625, "ctr": 1.30121, "reach": 366004, "spend": 3768.24, "clicks": 4925, "frequency": 1.034125, "unique_ctr": 1.188512, "auction_bid": 0, "impressions": 378494, "actions.post": 142, "unique_clicks": 4350, "actions.comment": 31, "full_view_reach": 0, "dda_countby_convs": 0, "actions.link_click": 4372, "actions.video_view": 97471, "inline_link_clicks": 4372, "actions.omni_search": 30, "unique_actions.post": 138, "actions.omni_purchase": 182, "actions.post_reaction": 723, "cost_per_unique_click": 0.866262, "full_view_impressions": 0, "inline_link_click_ctr": 1.155104, "inline_post_engagement": 8372, "unique_actions.comment": 31, "unique_link_clicks_ctr": 1.139332, "website_ctr.link_click": 1.155104, "actions.page_engagement": 103464, "actions.post_engagement": 103464, "auction_competitiveness": 0, "actions.add_payment_info": 149, "actions.omni_add_to_cart": 414, "action_values.omni_search": 0, "actions.landing_page_view": 3976, "actions.omni_view_content": 4595, "cost_per_action_type.post": 26.536901, "unique_actions.link_click": 4170, "unique_actions.video_view": 95776, "unique_inline_link_clicks": 4170, "auction_max_competitor_bid": 0, "cost_per_inline_link_click": 0.861903, "unique_actions.omni_search": 21, "action_values.omni_purchase": 3955.73, "purchase_roas.omni_purchase": 1.049755, "cost_per_action_type.comment": 121.556129, "cost_per_thruplay.video_view": 0.120245, "unique_actions.omni_purchase": 181, "unique_actions.post_reaction": 719, "unique_inline_link_click_ctr": 1.139332, "video_play_actions.video_view": 342431, "action_values.add_payment_info": 3968.82, "action_values.omni_add_to_cart": 7819.51, "outbound_clicks.outbound_click": 4372, "unique_actions.page_engagement": 96544, "unique_actions.post_engagement": 96544, "action_values.omni_view_content": 86948.24, "actions.omni_initiated_checkout": 537, "cost_per_action_type.link_click": 0.861903, "cost_per_action_type.video_view": 0.03866, "cost_per_inline_post_engagement": 0.4501, "unique_actions.add_payment_info": 147, "unique_actions.omni_add_to_cart": 359, "cost_per_action_type.omni_search": 125.608, "unique_actions.landing_page_view": 3788, "unique_actions.omni_view_content": 3798, "cost_per_unique_inline_link_click": 0.903655, "instant_experience_clicks_to_open": 0, "unique_actions.offsite_conversion": 3808, "cost_per_action_type.omni_purchase": 20.704615, "cost_per_action_type.post_reaction": 5.21195, "instant_experience_clicks_to_start": 0, "outbound_clicks_ctr.outbound_click": 1.155104, "actions.onsite_conversion.post_save": 725, "video_play_curve_actions.video_view": [100, 75, 39, 29, 25, 22, 20, 18, 17, 16, 15, 14, 13, 12, 10, 9, 7, 6, 4, 0, 0, 0], "cost_per_action_type.page_engagement": 0.036421, "cost_per_action_type.post_engagement": 0.036421, "video_p25_watched_actions.video_view": 54120, "video_p50_watched_actions.video_view": 27279, "video_p75_watched_actions.video_view": 18364, "video_p95_watched_actions.video_view": 10512, "action_values.omni_initiated_checkout": 11009.33, "cost_per_action_type.add_payment_info": 25.290201, "cost_per_action_type.omni_add_to_cart": 9.102029, "unique_outbound_clicks.outbound_click": 4332, "video_p100_watched_actions.video_view": 9398, "cost_per_action_type.landing_page_view": 0.947746, "cost_per_action_type.omni_view_content": 0.820074, "cost_per_outbound_click.outbound_click": 0.861903, "cost_per_unique_action_type.link_click": 0.903655, "cost_per_unique_action_type.video_view": 0.039344, "unique_actions.omni_initiated_checkout": 502, "cost_per_unique_action_type.omni_search": 179.44, "video_30_sec_watched_actions.video_view": 14251, "cost_per_unique_action_type.omni_purchase": 20.819006, "unique_outbound_clicks_ctr.outbound_click": 1.183594, "video_avg_time_watched_actions.video_view": 5, "video_thruplay_watched_actions.video_view": 31338, "actions.offsite_conversion.fb_pixel_search": 30, "unique_actions.onsite_conversion.post_save": 725, "cost_per_unique_action_type.page_engagement": 0.039031, "cost_per_unique_action_type.post_engagement": 0.039031, "actions.offsite_conversion.fb_pixel_purchase": 182, "cost_per_action_type.omni_initiated_checkout": 7.017207, "cost_per_unique_action_type.add_payment_info": 25.634286, "cost_per_unique_action_type.omni_add_to_cart": 10.49649, "cost_per_unique_action_type.landing_page_view": 0.994784, "cost_per_unique_action_type.omni_view_content": 0.992164, "cost_per_unique_outbound_click.outbound_click": 0.869862, "actions.offsite_conversion.fb_pixel_add_to_cart": 414, "actions.offsite_conversion.fb_pixel_view_content": 4595, "cost_per_action_type.onsite_conversion.post_save": 5.197572, "actions.offsite_conversion.custom.361400681142876": 182, "unique_actions.offsite_conversion.fb_pixel_search": 21, "action_values.offsite_conversion.fb_pixel_purchase": 3955.73, "cost_per_unique_action_type.omni_initiated_checkout": 7.506454, "unique_actions.offsite_conversion.fb_pixel_purchase": 181, "actions.offsite_conversion.fb_pixel_add_payment_info": 149, "action_values.offsite_conversion.fb_pixel_add_to_cart": 7819.51, "actions.offsite_conversion.fb_pixel_initiate_checkout": 537, "action_values.offsite_conversion.fb_pixel_view_content": 86948.24, "unique_actions.offsite_conversion.fb_pixel_add_to_cart": 359, "action_values.offsite_conversion.custom.361400681142876": 3955.73, "cost_per_action_type.offsite_conversion.fb_pixel_search": 125.608, "cost_per_unique_action_type.onsite_conversion.post_save": 5.197572, "unique_actions.offsite_conversion.fb_pixel_view_content": 3798, "cost_per_action_type.offsite_conversion.fb_pixel_purchase": 20.704615, "action_values.offsite_conversion.fb_pixel_add_payment_info": 3968.82, "website_purchase_roas.offsite_conversion.fb_pixel_purchase": 1.049755, "action_values.offsite_conversion.fb_pixel_initiate_checkout": 11009.33, "unique_actions.offsite_conversion.fb_pixel_add_payment_info": 147, "cost_per_action_type.offsite_conversion.fb_pixel_add_to_cart": 9.102029, "unique_actions.offsite_conversion.fb_pixel_initiate_checkout": 502, "cost_per_action_type.offsite_conversion.fb_pixel_view_content": 0.820074, "cost_per_action_type.offsite_conversion.custom.361400681142876": 20.704615, "cost_per_action_type.offsite_conversion.fb_pixel_add_payment_info": 25.290201, "cost_per_action_type.offsite_conversion.fb_pixel_initiate_checkout": 7.017207}')

INSERT 0 1

insert into facebook(metrics)
values ('{"cpc": 0.633893, "cpm": 7.976774, "cpp": 8.099786, "ctr": 1.258379, "reach": 451328, "spend": 3655.66, "clicks": 5767, "frequency": 1.015421, "unique_ctr": 1.154814, "auction_bid": 0, "impressions": 458288, "actions.post": 147, "unique_clicks": 5212, "actions.comment": 39, "full_view_reach": 0, "dda_countby_convs": 0, "actions.link_click": 5266, "actions.video_view": 122408, "inline_link_clicks": 5266, "actions.omni_search": 33, "unique_actions.post": 146, "actions.omni_purchase": 244, "actions.post_reaction": 873, "cost_per_unique_click": 0.701393, "full_view_impressions": 0, "inline_link_click_ctr": 1.149059, "inline_post_engagement": 9341, "unique_actions.comment": 38, "unique_link_clicks_ctr": 1.118477, "website_ctr.link_click": 1.149059, "actions.page_engagement": 129498, "actions.post_engagement": 129498, "auction_competitiveness": 0, "actions.add_payment_info": 160, "actions.omni_add_to_cart": 400, "action_values.omni_search": 0, "actions.landing_page_view": 4777, "actions.omni_view_content": 5456, "cost_per_action_type.post": 24.868435, "unique_actions.link_click": 5048, "unique_actions.video_view": 117248, "unique_inline_link_clicks": 5048, "auction_max_competitor_bid": 0, "cost_per_inline_link_click": 0.694201, "unique_actions.omni_search": 27, "action_values.omni_purchase": 5200.13, "purchase_roas.omni_purchase": 1.422487, "cost_per_action_type.comment": 93.734872, "cost_per_thruplay.video_view": 0.091177, "unique_actions.omni_purchase": 240, "unique_actions.post_reaction": 871, "unique_inline_link_click_ctr": 1.118477, "video_play_actions.video_view": 420379, "action_values.add_payment_info": 4105.81, "action_values.omni_add_to_cart": 7574.52, "outbound_clicks.outbound_click": 5266, "unique_actions.page_engagement": 118528, "unique_actions.post_engagement": 118528, "action_values.omni_view_content": 103171.9, "actions.omni_initiated_checkout": 658, "cost_per_action_type.link_click": 0.694201, "cost_per_action_type.video_view": 0.029865, "cost_per_inline_post_engagement": 0.391356, "unique_actions.add_payment_info": 155, "unique_actions.omni_add_to_cart": 343, "cost_per_action_type.omni_search": 110.777576, "unique_actions.landing_page_view": 4588, "unique_actions.omni_view_content": 4636, "cost_per_unique_inline_link_click": 0.72418, "instant_experience_clicks_to_open": 0, "unique_actions.offsite_conversion": 4648, "cost_per_action_type.omni_purchase": 14.982213, "cost_per_action_type.post_reaction": 4.187469, "instant_experience_clicks_to_start": 0, "outbound_clicks_ctr.outbound_click": 1.149059, "actions.onsite_conversion.post_save": 765, "video_play_curve_actions.video_view": [100, 75, 39, 29, 25, 23, 21, 19, 18, 16, 15, 14, 13, 12, 11, 10, 8, 6, 4, 0, 0, 0], "cost_per_action_type.page_engagement": 0.028229, "cost_per_action_type.post_engagement": 0.028229, "video_p25_watched_actions.video_view": 69294, "video_p50_watched_actions.video_view": 34883, "video_p75_watched_actions.video_view": 23593, "video_p95_watched_actions.video_view": 13403, "action_values.omni_initiated_checkout": 13316.26, "cost_per_action_type.add_payment_info": 22.847875, "cost_per_action_type.omni_add_to_cart": 9.13915, "unique_outbound_clicks.outbound_click": 5164, "video_p100_watched_actions.video_view": 11939, "cost_per_action_type.landing_page_view": 0.765263, "cost_per_action_type.omni_view_content": 0.670026, "cost_per_outbound_click.outbound_click": 0.694201, "cost_per_unique_action_type.link_click": 0.72418, "cost_per_unique_action_type.video_view": 0.031179, "unique_actions.omni_initiated_checkout": 616, "cost_per_unique_action_type.omni_search": 135.394815, "video_30_sec_watched_actions.video_view": 18307, "cost_per_unique_action_type.omni_purchase": 15.231917, "unique_outbound_clicks_ctr.outbound_click": 1.144179, "video_avg_time_watched_actions.video_view": 5, "video_thruplay_watched_actions.video_view": 40094, "actions.offsite_conversion.fb_pixel_search": 33, "unique_actions.onsite_conversion.post_save": 759, "cost_per_unique_action_type.page_engagement": 0.030842, "cost_per_unique_action_type.post_engagement": 0.030842, "actions.offsite_conversion.fb_pixel_purchase": 244, "cost_per_action_type.omni_initiated_checkout": 5.555714, "cost_per_unique_action_type.add_payment_info": 23.584903, "cost_per_unique_action_type.omni_add_to_cart": 10.657901, "cost_per_unique_action_type.landing_page_view": 0.796787, "cost_per_unique_action_type.omni_view_content": 0.788538, "cost_per_unique_outbound_click.outbound_click": 0.707912, "actions.offsite_conversion.fb_pixel_add_to_cart": 400, "actions.offsite_conversion.fb_pixel_view_content": 5456, "cost_per_action_type.onsite_conversion.post_save": 4.778641, "actions.offsite_conversion.custom.361400681142876": 244, "unique_actions.offsite_conversion.fb_pixel_search": 27, "action_values.offsite_conversion.fb_pixel_purchase": 5200.13, "cost_per_unique_action_type.omni_initiated_checkout": 5.934513, "unique_actions.offsite_conversion.fb_pixel_purchase": 240, "actions.offsite_conversion.fb_pixel_add_payment_info": 160, "action_values.offsite_conversion.fb_pixel_add_to_cart": 7574.52, "actions.offsite_conversion.fb_pixel_initiate_checkout": 658, "action_values.offsite_conversion.fb_pixel_view_content": 103171.9, "unique_actions.offsite_conversion.fb_pixel_add_to_cart": 343, "action_values.offsite_conversion.custom.361400681142876": 5200.13, "cost_per_action_type.offsite_conversion.fb_pixel_search": 110.777576, "cost_per_unique_action_type.onsite_conversion.post_save": 4.816416, "unique_actions.offsite_conversion.fb_pixel_view_content": 4636, "cost_per_action_type.offsite_conversion.fb_pixel_purchase": 14.982213, "action_values.offsite_conversion.fb_pixel_add_payment_info": 4105.81, "website_purchase_roas.offsite_conversion.fb_pixel_purchase": 1.422487, "action_values.offsite_conversion.fb_pixel_initiate_checkout": 13316.26, "unique_actions.offsite_conversion.fb_pixel_add_payment_info": 155, "cost_per_action_type.offsite_conversion.fb_pixel_add_to_cart": 9.13915, "unique_actions.offsite_conversion.fb_pixel_initiate_checkout": 616, "cost_per_action_type.offsite_conversion.fb_pixel_view_content": 0.670026, "cost_per_action_type.offsite_conversion.custom.361400681142876": 14.982213, "cost_per_action_type.offsite_conversion.fb_pixel_add_payment_info": 22.847875, "cost_per_action_type.offsite_conversion.fb_pixel_initiate_checkout": 5.555714}')

INSERT 0 1

select * from facebook

metrics

{"cpc": 0.765125, "cpm": 9.955878, "cpp": 10.295625, "ctr": 1.30121, "reach": 366004, "spend": 3768.24, "clicks": 4925, "frequency": 1.034125, "unique_ctr": 1.188512, "auction_bid": 0, "impressions": 378494, "actions.post": 142, "unique_clicks": 4350, "actions.comment": 31, "full_view_reach": 0, "dda_countby_convs": 0, "actions.link_click": 4372, "actions.video_view": 97471, "inline_link_clicks": 4372, "actions.omni_search": 30, "unique_actions.post": 138, "actions.omni_purchase": 182, "actions.post_reaction": 723, "cost_per_unique_click": 0.866262, "full_view_impressions": 0, "inline_link_click_ctr": 1.155104, "inline_post_engagement": 8372, "unique_actions.comment": 31, "unique_link_clicks_ctr": 1.139332, "website_ctr.link_click": 1.155104, "actions.page_engagement": 103464, "actions.post_engagement": 103464, "auction_competitiveness": 0, "actions.add_payment_info": 149, "actions.omni_add_to_cart": 414, "action_values.omni_search": 0, "actions.landing_page_view": 3976, "actions.omni_view_content": 4595, "cost_per_action_type.post": 26.536901, "unique_actions.link_click": 4170, "unique_actions.video_view": 95776, "unique_inline_link_clicks": 4170, "auction_max_competitor_bid": 0, "cost_per_inline_link_click": 0.861903, "unique_actions.omni_search": 21, "action_values.omni_purchase": 3955.73, "purchase_roas.omni_purchase": 1.049755, "cost_per_action_type.comment": 121.556129, "cost_per_thruplay.video_view": 0.120245, "unique_actions.omni_purchase": 181, "unique_actions.post_reaction": 719, "unique_inline_link_click_ctr": 1.139332, "video_play_actions.video_view": 342431, "action_values.add_payment_info": 3968.82, "action_values.omni_add_to_cart": 7819.51, "outbound_clicks.outbound_click": 4372, "unique_actions.page_engagement": 96544, "unique_actions.post_engagement": 96544, "action_values.omni_view_content": 86948.24, "actions.omni_initiated_checkout": 537, "cost_per_action_type.link_click": 0.861903, "cost_per_action_type.video_view": 0.03866, "cost_per_inline_post_engagement": 0.4501, "unique_actions.add_payment_info": 147, "unique_actions.omni_add_to_cart": 359, "cost_per_action_type.omni_search": 125.608, "unique_actions.landing_page_view": 3788, "unique_actions.omni_view_content": 3798, "cost_per_unique_inline_link_click": 0.903655, "instant_experience_clicks_to_open": 0, "unique_actions.offsite_conversion": 3808, "cost_per_action_type.omni_purchase": 20.704615, "cost_per_action_type.post_reaction": 5.21195, "instant_experience_clicks_to_start": 0, "outbound_clicks_ctr.outbound_click": 1.155104, "actions.onsite_conversion.post_save": 725, "video_play_curve_actions.video_view": [100, 75, 39, 29, 25, 22, 20, 18, 17, 16, 15, 14, 13, 12, 10, 9, 7, 6, 4, 0, 0, 0], "cost_per_action_type.page_engagement": 0.036421, "cost_per_action_type.post_engagement": 0.036421, "video_p25_watched_actions.video_view": 54120, "video_p50_watched_actions.video_view": 27279, "video_p75_watched_actions.video_view": 18364, "video_p95_watched_actions.video_view": 10512, "action_values.omni_initiated_checkout": 11009.33, "cost_per_action_type.add_payment_info": 25.290201, "cost_per_action_type.omni_add_to_cart": 9.102029, "unique_outbound_clicks.outbound_click": 4332, "video_p100_watched_actions.video_view": 9398, "cost_per_action_type.landing_page_view": 0.947746, "cost_per_action_type.omni_view_content": 0.820074, "cost_per_outbound_click.outbound_click": 0.861903, "cost_per_unique_action_type.link_click": 0.903655, "cost_per_unique_action_type.video_view": 0.039344, "unique_actions.omni_initiated_checkout": 502, "cost_per_unique_action_type.omni_search": 179.44, "video_30_sec_watched_actions.video_view": 14251, "cost_per_unique_action_type.omni_purchase": 20.819006, "unique_outbound_clicks_ctr.outbound_click": 1.183594, "video_avg_time_watched_actions.video_view": 5, "video_thruplay_watched_actions.video_view": 31338, "actions.offsite_conversion.fb_pixel_search": 30, "unique_actions.onsite_conversion.post_save": 725, "cost_per_unique_action_type.page_engagement": 0.039031, "cost_per_unique_action_type.post_engagement": 0.039031, "actions.offsite_conversion.fb_pixel_purchase": 182, "cost_per_action_type.omni_initiated_checkout": 7.017207, "cost_per_unique_action_type.add_payment_info": 25.634286, "cost_per_unique_action_type.omni_add_to_cart": 10.49649, "cost_per_unique_action_type.landing_page_view": 0.994784, "cost_per_unique_action_type.omni_view_content": 0.992164, "cost_per_unique_outbound_click.outbound_click": 0.869862, "actions.offsite_conversion.fb_pixel_add_to_cart": 414, "actions.offsite_conversion.fb_pixel_view_content": 4595, "cost_per_action_type.onsite_conversion.post_save": 5.197572, "actions.offsite_conversion.custom.361400681142876": 182, "unique_actions.offsite_conversion.fb_pixel_search": 21, "action_values.offsite_conversion.fb_pixel_purchase": 3955.73, "cost_per_unique_action_type.omni_initiated_checkout": 7.506454, "unique_actions.offsite_conversion.fb_pixel_purchase": 181, "actions.offsite_conversion.fb_pixel_add_payment_info": 149, "action_values.offsite_conversion.fb_pixel_add_to_cart": 7819.51, "actions.offsite_conversion.fb_pixel_initiate_checkout": 537, "action_values.offsite_conversion.fb_pixel_view_content": 86948.24, "unique_actions.offsite_conversion.fb_pixel_add_to_cart": 359, "action_values.offsite_conversion.custom.361400681142876": 3955.73, "cost_per_action_type.offsite_conversion.fb_pixel_search": 125.608, "cost_per_unique_action_type.onsite_conversion.post_save": 5.197572, "unique_actions.offsite_conversion.fb_pixel_view_content": 3798, "cost_per_action_type.offsite_conversion.fb_pixel_purchase": 20.704615, "action_values.offsite_conversion.fb_pixel_add_payment_info": 3968.82, "website_purchase_roas.offsite_conversion.fb_pixel_purchase": 1.049755, "action_values.offsite_conversion.fb_pixel_initiate_checkout": 11009.33, "unique_actions.offsite_conversion.fb_pixel_add_payment_info": 147, "cost_per_action_type.offsite_conversion.fb_pixel_add_to_cart": 9.102029, "unique_actions.offsite_conversion.fb_pixel_initiate_checkout": 502, "cost_per_action_type.offsite_conversion.fb_pixel_view_content": 0.820074, "cost_per_action_type.offsite_conversion.custom.361400681142876": 20.704615, "cost_per_action_type.offsite_conversion.fb_pixel_add_payment_info": 25.290201, "cost_per_action_type.offsite_conversion.fb_pixel_initiate_checkout": 7.017207}

{"cpc": 0.633893, "cpm": 7.976774, "cpp": 8.099786, "ctr": 1.258379, "reach": 451328, "spend": 3655.66, "clicks": 5767, "frequency": 1.015421, "unique_ctr": 1.154814, "auction_bid": 0, "impressions": 458288, "actions.post": 147, "unique_clicks": 5212, "actions.comment": 39, "full_view_reach": 0, "dda_countby_convs": 0, "actions.link_click": 5266, "actions.video_view": 122408, "inline_link_clicks": 5266, "actions.omni_search": 33, "unique_actions.post": 146, "actions.omni_purchase": 244, "actions.post_reaction": 873, "cost_per_unique_click": 0.701393, "full_view_impressions": 0, "inline_link_click_ctr": 1.149059, "inline_post_engagement": 9341, "unique_actions.comment": 38, "unique_link_clicks_ctr": 1.118477, "website_ctr.link_click": 1.149059, "actions.page_engagement": 129498, "actions.post_engagement": 129498, "auction_competitiveness": 0, "actions.add_payment_info": 160, "actions.omni_add_to_cart": 400, "action_values.omni_search": 0, "actions.landing_page_view": 4777, "actions.omni_view_content": 5456, "cost_per_action_type.post": 24.868435, "unique_actions.link_click": 5048, "unique_actions.video_view": 117248, "unique_inline_link_clicks": 5048, "auction_max_competitor_bid": 0, "cost_per_inline_link_click": 0.694201, "unique_actions.omni_search": 27, "action_values.omni_purchase": 5200.13, "purchase_roas.omni_purchase": 1.422487, "cost_per_action_type.comment": 93.734872, "cost_per_thruplay.video_view": 0.091177, "unique_actions.omni_purchase": 240, "unique_actions.post_reaction": 871, "unique_inline_link_click_ctr": 1.118477, "video_play_actions.video_view": 420379, "action_values.add_payment_info": 4105.81, "action_values.omni_add_to_cart": 7574.52, "outbound_clicks.outbound_click": 5266, "unique_actions.page_engagement": 118528, "unique_actions.post_engagement": 118528, "action_values.omni_view_content": 103171.9, "actions.omni_initiated_checkout": 658, "cost_per_action_type.link_click": 0.694201, "cost_per_action_type.video_view": 0.029865, "cost_per_inline_post_engagement": 0.391356, "unique_actions.add_payment_info": 155, "unique_actions.omni_add_to_cart": 343, "cost_per_action_type.omni_search": 110.777576, "unique_actions.landing_page_view": 4588, "unique_actions.omni_view_content": 4636, "cost_per_unique_inline_link_click": 0.72418, "instant_experience_clicks_to_open": 0, "unique_actions.offsite_conversion": 4648, "cost_per_action_type.omni_purchase": 14.982213, "cost_per_action_type.post_reaction": 4.187469, "instant_experience_clicks_to_start": 0, "outbound_clicks_ctr.outbound_click": 1.149059, "actions.onsite_conversion.post_save": 765, "video_play_curve_actions.video_view": [100, 75, 39, 29, 25, 23, 21, 19, 18, 16, 15, 14, 13, 12, 11, 10, 8, 6, 4, 0, 0, 0], "cost_per_action_type.page_engagement": 0.028229, "cost_per_action_type.post_engagement": 0.028229, "video_p25_watched_actions.video_view": 69294, "video_p50_watched_actions.video_view": 34883, "video_p75_watched_actions.video_view": 23593, "video_p95_watched_actions.video_view": 13403, "action_values.omni_initiated_checkout": 13316.26, "cost_per_action_type.add_payment_info": 22.847875, "cost_per_action_type.omni_add_to_cart": 9.13915, "unique_outbound_clicks.outbound_click": 5164, "video_p100_watched_actions.video_view": 11939, "cost_per_action_type.landing_page_view": 0.765263, "cost_per_action_type.omni_view_content": 0.670026, "cost_per_outbound_click.outbound_click": 0.694201, "cost_per_unique_action_type.link_click": 0.72418, "cost_per_unique_action_type.video_view": 0.031179, "unique_actions.omni_initiated_checkout": 616, "cost_per_unique_action_type.omni_search": 135.394815, "video_30_sec_watched_actions.video_view": 18307, "cost_per_unique_action_type.omni_purchase": 15.231917, "unique_outbound_clicks_ctr.outbound_click": 1.144179, "video_avg_time_watched_actions.video_view": 5, "video_thruplay_watched_actions.video_view": 40094, "actions.offsite_conversion.fb_pixel_search": 33, "unique_actions.onsite_conversion.post_save": 759, "cost_per_unique_action_type.page_engagement": 0.030842, "cost_per_unique_action_type.post_engagement": 0.030842, "actions.offsite_conversion.fb_pixel_purchase": 244, "cost_per_action_type.omni_initiated_checkout": 5.555714, "cost_per_unique_action_type.add_payment_info": 23.584903, "cost_per_unique_action_type.omni_add_to_cart": 10.657901, "cost_per_unique_action_type.landing_page_view": 0.796787, "cost_per_unique_action_type.omni_view_content": 0.788538, "cost_per_unique_outbound_click.outbound_click": 0.707912, "actions.offsite_conversion.fb_pixel_add_to_cart": 400, "actions.offsite_conversion.fb_pixel_view_content": 5456, "cost_per_action_type.onsite_conversion.post_save": 4.778641, "actions.offsite_conversion.custom.361400681142876": 244, "unique_actions.offsite_conversion.fb_pixel_search": 27, "action_values.offsite_conversion.fb_pixel_purchase": 5200.13, "cost_per_unique_action_type.omni_initiated_checkout": 5.934513, "unique_actions.offsite_conversion.fb_pixel_purchase": 240, "actions.offsite_conversion.fb_pixel_add_payment_info": 160, "action_values.offsite_conversion.fb_pixel_add_to_cart": 7574.52, "actions.offsite_conversion.fb_pixel_initiate_checkout": 658, "action_values.offsite_conversion.fb_pixel_view_content": 103171.9, "unique_actions.offsite_conversion.fb_pixel_add_to_cart": 343, "action_values.offsite_conversion.custom.361400681142876": 5200.13, "cost_per_action_type.offsite_conversion.fb_pixel_search": 110.777576, "cost_per_unique_action_type.onsite_conversion.post_save": 4.816416, "unique_actions.offsite_conversion.fb_pixel_view_content": 4636, "cost_per_action_type.offsite_conversion.fb_pixel_purchase": 14.982213, "action_values.offsite_conversion.fb_pixel_add_payment_info": 4105.81, "website_purchase_roas.offsite_conversion.fb_pixel_purchase": 1.422487, "action_values.offsite_conversion.fb_pixel_initiate_checkout": 13316.26, "unique_actions.offsite_conversion.fb_pixel_add_payment_info": 155, "cost_per_action_type.offsite_conversion.fb_pixel_add_to_cart": 9.13915, "unique_actions.offsite_conversion.fb_pixel_initiate_checkout": 616, "cost_per_action_type.offsite_conversion.fb_pixel_view_content": 0.670026, "cost_per_action_type.offsite_conversion.custom.361400681142876": 14.982213, "cost_per_action_type.offsite_conversion.fb_pixel_add_payment_info": 22.847875, "cost_per_action_type.offsite_conversion.fb_pixel_initiate_checkout": 5.555714}

SELECT 2

select * 
from json_to_record(select * from facebook)

ERROR:  syntax error at or near "select"
LINE 2: from json_to_record(select * from facebook)
                            ^