paste #FW7
:
normalized=# \d other_events_6135259_pim_evdef_ffffd51eee24_idx
Index "public.other_events_6135259_pim_evdef_ffffd51eee24_idx"
Column | Type | Key? | Definition
---------+-------------+------+------------
time | bigint | yes | "time"
user_id | app_user_id | yes | user_id
btree, for table "public.other_events_6135259", predicate (user_id <= '(1404198904,9007199254740991)'::app_user_id AND user_id >= '(1404198904,0)'::app_user_id AND ((data ->> 'type'::text) = 'click'::text AND (data ->> 'domain'::text) = 'www.redacted.ca'::text AND (data ->> 'path'::text) = '/l/pricing/'::text AND (data ->> 'library'::text) = 'web'::text AND (data ->> 'hierarchy'::text) ~~ '%[href=#pp];%|%[type=button];%'::text AND (data ->> 'object'::text) IS NULL OR (data ->> 'type'::text) = 'click'::text AND (data ->> 'library'::text) = 'web'::text AND strpos(data ->> 'hierarchy'::text, '[data-heap-id=unlimited_tab_view_click];'::text) <> 0 AND (data ->> 'object'::text) IS NULL OR (data ->> 'type'::text) = 'click'::text AND (data ->> 'library'::text) = 'web'::text AND strpos(data ->> 'hierarchy'::text, '[data-heap-id=up_to_100_tab_view_click];'::text) <> 0 AND (data ->> 'object'::text) IS NULL OR (data ->> 'type'::text) = 'click'::text AND (data ->> 'library'::text) = 'web'::text AND strpos(data ->> 'hierarchy'::text, '[data-heap-id=up_to_250_tab_view_click];'::text) <> 0 AND (data ->> 'object'::text) IS NULL))
normalized = # \d other_events_6135259_pim_evdef_ffffd51eee24_idx
INDEX "public.other_events_6135259_pim_evdef_ffffd51eee24_idx" COLUMN | TYPE | KEY ? | Definition
---------+-------------+------+------------
time | bigint | yes | "time" user_id | app_user_id | yes | user_id btree, FOR TABLE "public.other_events_6135259", predicate (user_id <= '(1404198904,9007199254740991)'::app_user_id AND user_id >= '(1404198904,0)'::app_user_id AND ((data ->> 'type'::text) = 'click'::text AND (data ->> 'domain'::text) = 'www.redacted.ca'::text AND (data ->> 'path'::text) = '/l/pricing/'::text AND (data ->> 'library'::text) = 'web'::text AND (data ->> 'hierarchy'::text) ~~ '%[href=#pp];%|%[type=button];%'::text AND (data ->> 'object'::text) IS NULL OR (data ->> 'type'::text) = 'click'::text AND (data ->> 'library'::text) = 'web'::text AND strpos(data ->> 'hierarchy'::text, '[data-heap-id=unlimited_tab_view_click];'::text) <> 0 AND (data ->> 'object'::text) IS NULL OR (data ->> 'type'::text) = 'click'::text AND (data ->> 'library'::text) = 'web'::text AND strpos(data ->> 'hierarchy'::text, '[data-heap-id=up_to_100_tab_view_click];'::text) <> 0 AND (data ->> 'object'::text) IS NULL OR (data ->> 'type'::text) = 'click'::text AND (data ->> 'library'::text) = 'web'::text AND strpos(data ->> 'hierarchy'::text, '[data-heap-id=up_to_250_tab_view_click];'::text) <> 0 AND (data ->> 'object'::text) IS NULL))
-- Formatted by pgFormatter::Beautify