explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Zb6E

Settings
# exclusive inclusive rows x rows loops node
1. 24.219 1,047.418 ↑ 54,279,040.5 14,089 1

Nested Loop (cost=0.00..9,488,493,244.76 rows=764,737,400,939 width=136) (actual time=0.303..1,047.418 rows=14,089 loops=1)

  • Join Filter: (((stats_session.property_id = 1) AND (stats_page_view.property_id = 1) AND (stats_event.property_id = 1) AND (stats_session.created_at >= '2019-04-01 00:00:00+00'::timestamp with time zone) AND (stats_session.created_at <= '2019-04-02 23:59:59+00'::timestamp with time zone) AND (stats_page_view.created_at >= '2019-04-01 00:00:00+00'::timestamp with time zone) AND (stats_page_view.created_at <= '2019-04-02 23:59:59+00'::timestamp with time zone) AND (stats_event.created_at >= '2019-04-01 00:00:00+00'::timestamp with time zone) AND (stats_event.created_at <= '2019-04-02 23:59:59+00'::timestamp with time zone) AND ((stats_session.campaign_id)::numeric >= '1'::numeric)) OR (((stats_event."values" ->> 'scrollTriggerValue'::text))::numeric <= '100'::numeric))
2. 0.827 980.932 ↑ 241,246.9 14,089 1

Nested Loop (cost=0.00..977,788.76 rows=3,398,927,303 width=112) (actual time=0.280..980.932 rows=14,089 loops=1)

3. 1.425 923.749 ↑ 107.2 14,089 1

Append (cost=0.00..251,443.19 rows=1,510,631 width=80) (actual time=0.260..923.749 rows=14,089 loops=1)

4. 0.004 0.004 ↓ 0.0 0 1

Seq Scan on stats_event (cost=0.00..0.00 rows=1 width=80) (actual time=0.004..0.004 rows=0 loops=1)

  • Filter: (((property_id = 1) AND (created_at >= '2019-04-01 00:00:00+00'::timestamp with time zone) AND (created_at <= '2019-04-02 23:59:59+00'::timestamp with time zone)) OR ((("values" ->> 'scrollTriggerValue'::text))::numeric <= '100'::numeric))
5. 922.320 922.320 ↑ 107.2 14,089 1

Seq Scan on _hyper_5_4_chunk (cost=0.00..243,890.03 rows=1,510,630 width=80) (actual time=0.255..922.320 rows=14,089 loops=1)

  • Filter: (((property_id = 1) AND (created_at >= '2019-04-01 00:00:00+00'::timestamp with time zone) AND (created_at <= '2019-04-02 23:59:59+00'::timestamp with time zone)) OR ((("values" ->> 'scrollTriggerValue'::text))::numeric <= '100'::numeric))
  • Rows Removed by Filter: 4485910
6. 28.178 56.356 ↑ 2.0 1 14,089

Append (cost=0.00..0.46 rows=2 width=48) (actual time=0.003..0.004 rows=1 loops=14,089)

7. 0.000 0.000 ↓ 0.0 0 14,089

Seq Scan on stats_page_view (cost=0.00..0.00 rows=1 width=48) (actual time=0.000..0.000 rows=0 loops=14,089)

  • Filter: (stats_event.page_view_id = id)
8. 28.178 28.178 ↑ 1.0 1 14,089

Index Scan using "3_3_stats_page_view_id" on _hyper_3_3_chunk (cost=0.42..0.45 rows=1 width=48) (actual time=0.002..0.002 rows=1 loops=14,089)

  • Index Cond: (id = stats_event.page_view_id)
9. 14.089 42.267 ↑ 2.0 1 14,089

Append (cost=0.00..0.45 rows=2 width=56) (actual time=0.003..0.003 rows=1 loops=14,089)

10. 0.000 0.000 ↓ 0.0 0 14,089

Seq Scan on stats_session (cost=0.00..0.00 rows=1 width=266) (actual time=0.000..0.000 rows=0 loops=14,089)

  • Filter: (stats_page_view.session_id = id)
11. 28.178 28.178 ↑ 1.0 1 14,089

Index Scan using "2_2_stats_session_id" on _hyper_2_2_chunk (cost=0.41..0.44 rows=1 width=56) (actual time=0.002..0.002 rows=1 loops=14,089)

  • Index Cond: (id = stats_page_view.session_id)