explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FUAX

Settings
# exclusive inclusive rows x rows loops node
1. 48.486 33,680.464 ↓ 3,258.0 3,258 1

Nested Loop Left Join (cost=0.85..6,243.63 rows=1 width=48) (actual time=9,032.667..33,680.464 rows=3,258 loops=1)

  • Join Filter: (site.id = _hyper_2_51_chunk.site_id)
  • Rows Removed by Join Filter: 362067
2. 2,593.287 33,596.140 ↓ 3,258.0 3,258 1

Nested Loop (cost=0.85..6,233.93 rows=1 width=20) (actual time=9,032.634..33,596.140 rows=3,258 loops=1)

  • Join Filter: (_hyper_3_52_chunk.session_id = _hyper_2_51_chunk.id)
  • Rows Removed by Join Filter: 39104748
3. 1.267 24.255 ↓ 2,954.0 2,954 1

Append (cost=0.42..2,636.43 rows=1 width=20) (actual time=0.016..24.255 rows=2,954 loops=1)

4. 22.988 22.988 ↓ 2,954.0 2,954 1

Index Scan using _hyper_2_51_chunk_tmp_session_property_id_and_created_at on _hyper_2_51_chunk (cost=0.42..2,636.42 rows=1 width=20) (actual time=0.015..22.988 rows=2,954 loops=1)

  • Index Cond: ((property_id = 95) AND (created_at >= '2019-11-02 23:00:00+00'::timestamp with time zone) AND (created_at <= '2019-11-10 22:59:59+00'::timestamp with time zone))
  • Filter: ((campaign_id = 79) AND (((geo_country_code)::text = 'CH'::text) OR ((geo_country_code)::text = 'IT'::text) OR ((geo_country_code)::text = 'DE'::text) OR ((geo_country_code)::text = 'FR'::text)) AND ((site_id = 168) OR (site_id = 169) OR (site_id = 170) OR (site_id = 171) OR (site_id = 172) OR (site_id = 173) OR (site_id = 167) OR (site_id = 226) OR (site_id = 227)))
  • Rows Removed by Filter: 9331
5. 2,286.396 30,978.598 ↓ 3.5 13,239 2,954

Append (cost=0.43..3,550.58 rows=3,754 width=32) (actual time=0.010..10.487 rows=13,239 loops=2,954)

6. 28,692.202 28,692.202 ↓ 3.5 13,239 2,954

Index Scan using _hyper_3_52_chunk_tmp_pageview_property_id_and_created_at on _hyper_3_52_chunk (cost=0.43..3,531.81 rows=3,754 width=32) (actual time=0.009..9.713 rows=13,239 loops=2,954)

  • Index Cond: ((property_id = 95) AND (created_at >= '2019-11-03 23:00:00+00'::timestamp with time zone) AND (created_at <= '2019-11-10 22:59:59+00'::timestamp with time zone))
7. 35.838 35.838 ↑ 1.9 112 3,258

Seq Scan on site (cost=0.00..7.09 rows=209 width=14) (actual time=0.002..0.011 rows=112 loops=3,258)

Planning time : 0.613 ms
Execution time : 33,681.267 ms