HTML
SOURCE
QUERY
REFORMATTED QUERY
STATS

#	exclusive	inclusive	rows x	rows	loops	node
1.	0.044	2,701,302.133	↑ 2.4	5	1	→ Result (cost=0.00..8.60 rows=12 width=60) (actual time=2,628,079.863..2,701,302.133 rows=5 loops=1)
2.	0.008	2,701,302.089	↑ 2.4	5	1	→ Append (cost=0.00..8.45 rows=12 width=943) (actual time=2,628,079.860..2,701,302.089 rows=5 loops=1)
3.	0.005	0.005	↓ 0.0	0	1	→ Seq Scan on events_6135259 events (cost=0.00..0.00 rows=1 width=56) (actual time=0.005..0.005 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)))
4.	2,701,302.076	2,701,302.076	↑ 2.2	5 - 33,824,307	1	→ Index Scan using other_events_6135259_pim_evdef_4a32b0e4548c_idx on other_events_6135259 events_1 (cost=0.56..8.39 rows=11 width=1,024) (actual time=2,628,079.853..2,701,302.076 rows=5 loops=1) Filter: ((((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)) Rows Removed by Filter: 33,824,307

Planning time	:	64.386 ms
Execution time	:	2,701,302.472 ms

                          QUERY PLAN                                                                                                                                                                                                                                                                                                                                                                                 
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Result  (cost=0.00..8.60 rows=12 width=60) (actual time=2628079.863..2701302.133 rows=5 loops=1)
   ->  Append  (cost=0.00..8.45 rows=12 width=943) (actual time=2628079.860..2701302.089 rows=5 loops=1)
         ->  Seq Scan on events_6135259 events  (cost=0.00..0.00 rows=1 width=56) (actual time=0.005..0.005 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_4a32b0e4548c_idx on other_events_6135259 events_1  (cost=0.56..8.39 rows=11 width=1024) (actual time=2628079.853..2701302.076 rows=5 loops=1)
               Filter: ((((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))
               Rows Removed by Filter: 33824307
 Planning Time: 64.386 ms
 Execution Time: 2701302.472 ms
(9 rows)

 SELECT events.user_id,
  events."time",
  1                                                         AS event,
  (events.data operator(pg_catalog.->>) 'session_id'::text) AS session_id
  FROM   PUBLIC.events_6135259 events
  WHERE  ((
  events.user_id operator(PUBLIC.>=) '(1404198904,0)'::PUBLIC.app_user_id)
  AND    (
  events.user_id operator(PUBLIC.<=) '(1404198904,9007199254740991)'::PUBLIC.app_user_id)
  AND    ((((
  events.data operator(pg_catalog.->>) 'object'::text) IS NULL)
  AND    ((
  events.data operator(pg_catalog.->>) 'domain'::text) operator(pg_catalog.=) 'www.redacted.ca'::text)
  AND    ((
  events.data operator(pg_catalog.->>) 'path'::text) operator(pg_catalog.=) '/l/pricing/'::text)
  AND    ((
  events.data operator(pg_catalog.->>) 'type'::text) operator(pg_catalog.=) 'click'::text)
  AND    ((
  events.data operator(pg_catalog.->>) 'hierarchy'::text) operator(pg_catalog.~~) '%[href=#pp];%|%[type=button];%'::text)
  AND    ((
  events.data operator(pg_catalog.->>) 'library'::text) operator(pg_catalog.=) 'web'::text))
  OR     (((
  events.data operator(pg_catalog.->>) 'object'::text) IS NULL)
  AND    ((
  events.data operator(pg_catalog.->>) 'type'::text) operator(pg_catalog.=) 'click'::text)
  AND    (
  strpos((events.data operator(pg_catalog.->>) 'hierarchy'::text), '[data-heap-id=up_to_100_tab_view_click];'::text) operator(pg_catalog.<>) 0)
  AND    ((
  events.data operator(pg_catalog.->>) 'library'::text) operator(pg_catalog.=) 'web'::text))
  OR     (((
  events.data operator(pg_catalog.->>) 'object'::text) IS NULL)
  AND    ((
  events.data operator(pg_catalog.->>) 'type'::text) operator(pg_catalog.=) 'click'::text)
  AND    (
  strpos((events.data operator(pg_catalog.->>) 'hierarchy'::text), '[data-heap-id=up_to_250_tab_view_click];'::text) operator(pg_catalog.<>) 0)
  AND    ((
  events.data operator(pg_catalog.->>) 'library'::text) operator(pg_catalog.=) 'web'::text))
  OR     (((
  events.data operator(pg_catalog.->>) 'object'::text) IS NULL)
  AND    ((
  events.data operator(pg_catalog.->>) 'type'::text) operator(pg_catalog.=) 'click'::text)
  AND    (
  strpos((events.data operator(pg_catalog.->>) 'hierarchy'::text), '[data-heap-id=unlimited_tab_view_click];'::text) operator(pg_catalog.<>) 0)
  AND    ((
  events.data operator(pg_catalog.->>) 'library'::text) operator(pg_catalog.=) 'web'::text))));

SELECT
    events.user_id,
    events.time,
    1 AS event,
    events.data OPERATOR( pg_catalog.->> ) 'session_id'::text AS session_id
FROM
    public.events_6135259 AS events
WHERE
    events.user_id OPERATOR( public.>= ) '(1404198904,0)'::public.app_user_id AND
    events.user_id OPERATOR( public.<= ) '(1404198904,9007199254740991)'::public.app_user_id AND
    (
        (
            events.data OPERATOR( pg_catalog.->> ) 'object'::text IS NULL AND
            ( events.data OPERATOR( pg_catalog.->> ) 'domain'::text ) OPERATOR( pg_catalog.= ) 'www.redacted.ca'::text AND
            ( events.data OPERATOR( pg_catalog.->> ) 'path'::text ) OPERATOR( pg_catalog.= ) '/l/pricing/'::text AND
            ( events.data OPERATOR( pg_catalog.->> ) 'type'::text ) OPERATOR( pg_catalog.= ) 'click'::text AND
            ( events.data OPERATOR( pg_catalog.->> ) 'hierarchy'::text ) OPERATOR( pg_catalog.~~ ) '%[href=#pp];%|%[type=button];%'::text AND
            ( events.data OPERATOR( pg_catalog.->> ) 'library'::text ) OPERATOR( pg_catalog.= ) 'web'::text
        ) OR
        (
            events.data OPERATOR( pg_catalog.->> ) 'object'::text IS NULL AND
            ( events.data OPERATOR( pg_catalog.->> ) 'type'::text ) OPERATOR( pg_catalog.= ) 'click'::text AND
            strpos(
                events.data OPERATOR( pg_catalog.->> ) 'hierarchy'::text,
                '[data-heap-id=up_to_100_tab_view_click];'::text
            ) OPERATOR( pg_catalog.<> ) 0 AND
            ( events.data OPERATOR( pg_catalog.->> ) 'library'::text ) OPERATOR( pg_catalog.= ) 'web'::text
        ) OR
        (
            events.data OPERATOR( pg_catalog.->> ) 'object'::text IS NULL AND
            ( events.data OPERATOR( pg_catalog.->> ) 'type'::text ) OPERATOR( pg_catalog.= ) 'click'::text AND
            strpos(
                events.data OPERATOR( pg_catalog.->> ) 'hierarchy'::text,
                '[data-heap-id=up_to_250_tab_view_click];'::text
            ) OPERATOR( pg_catalog.<> ) 0 AND
            ( events.data OPERATOR( pg_catalog.->> ) 'library'::text ) OPERATOR( pg_catalog.= ) 'web'::text
        ) OR
        (
            events.data OPERATOR( pg_catalog.->> ) 'object'::text IS NULL AND
            ( events.data OPERATOR( pg_catalog.->> ) 'type'::text ) OPERATOR( pg_catalog.= ) 'click'::text AND
            strpos(
                events.data OPERATOR( pg_catalog.->> ) 'hierarchy'::text,
                '[data-heap-id=unlimited_tab_view_click];'::text
            ) OPERATOR( pg_catalog.<> ) 0 AND
            ( events.data OPERATOR( pg_catalog.->> ) 'library'::text ) OPERATOR( pg_catalog.= ) 'web'::text
        )
    );
-- Formatted by Pg::SQL::PrettyPrinter

Per node type stats

node type	count	sum of times	% of query
Append	1	0.008 ms	0.0 %
Index Scan	1	2,701,302.076 ms	100.0 %
Result	1	0.044 ms	0.0 %
Seq Scan	1	0.005 ms	0.0 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
events_6135259	1	0.005 ms	0.0 %
Seq Scan	1	0.005 ms	100.0 %
other_events_6135259	1	2,701,302.076 ms	100.0 %
Index Scan	1	2,701,302.076 ms	100.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: D0qq : Slow plan

Color mode:

Visible columns:

Per node type stats

Per table stats