explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QasT

Settings
# exclusive inclusive rows x rows loops node
1. 2,590.089 33,619.599 ↓ 3,258.0 3,258 1

Nested Loop (cost=0.85..6,233.93 rows=1 width=16) (actual time=8,865.342..33,619.599 rows=3,258 loops=1)

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

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

3. 23.009 23.009 ↓ 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=16) (actual time=0.016..23.009 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
4. 2,256.856 31,005.184 ↓ 3.5 13,239 2,954

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

5. 28,748.328 28,748.328 ↓ 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.732 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))
Planning time : 0.511 ms
Execution time : 33,620.727 ms