Index Scan
using other_events_6135259_pim_evdef_ffffd51eee24_idx on other_events_6135259 events_1
(cost=0.13..8.59
rows=11
width=1,024)
(actual
time=0.214..0.677
rows=5
loops=1)
Planning time
:
36.255 ms
Execution time
:
1.832ms
QUERY PLAN
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Result (cost=0.00..8.80 rows=12 width=60) (actual time=0.224..1.800 rows=5 loops=1)
-> Append (cost=0.00..8.65 rows=12 width=943) (actual time=0.221..0.687 rows=5 loops=1)
-> Seq Scan on events_6135259 events (cost=0.00..0.00 rows=1 width=56) (actual time=0.007..0.007 rows=0 loops=1)
Filter: ((user_id >= '(1404198904,0)'::app_user_id) AND (user_id <= '(1404198904,9007199254740991)'::app_user_id) AND ((data ->> 'object'::text) IS NULL) AND ((data ->> 'type'::text) = 'click'::text) AND ((data ->> 'library'::text) = 'web'::text) AND ((((data ->> 'domain'::text) = 'www.redacted.ca'::text) AND ((data ->> 'path'::text) = '/l/pricing/'::text) AND ((data ->> 'hierarchy'::text) ~~ '%[href=#pp];%|%[type=button];%'::text)) OR (strpos((data ->> 'hierarchy'::text), '[data-heap-id=up_to_100_tab_view_click];'::text) <> 0) OR (strpos((data ->> 'hierarchy'::text), '[data-heap-id=up_to_250_tab_view_click];'::text) <> 0) OR (strpos((data ->> 'hierarchy'::text), '[data-heap-id=unlimited_tab_view_click];'::text) <> 0)))
-> Index Scan using other_events_6135259_pim_evdef_ffffd51eee24_idx on other_events_6135259 events_1 (cost=0.13..8.59 rows=11 width=1024) (actual time=0.214..0.677 rows=5 loops=1)
Planning Time: 36.255 ms
Execution Time: 1.832 ms
(7 rows)