paste #u26
:
normalized=# \d other_events_6135259_pim_evdef_4a32b0e4548c_idx
Index "public.other_events_6135259_pim_evdef_4a32b0e4548c_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 ((data ->> 'type'::text) = 'click'::text AND (data ->> 'library'::text) = 'web'::text AND user_id <= '(1404198904,9007199254740991)'::app_user_id AND user_id >= '(1404198904,0)'::app_user_id AND (data ->> 'object'::text) IS NULL)
normalized = # \d other_events_6135259_pim_evdef_4a32b0e4548c_idx
INDEX "public.other_events_6135259_pim_evdef_4a32b0e4548c_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 ((data ->> 'type'::text) = 'click'::text AND (data ->> 'library'::text) = 'web'::text AND user_id <= '(1404198904,9007199254740991)'::app_user_id AND user_id >= '(1404198904,0)'::app_user_id AND (data ->> 'object'::text) IS NULL)
-- Formatted by pgFormatter::Beautify