explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mH7a

Settings
# exclusive inclusive rows x rows loops node
1. 0.053 1,693.990 ↑ 1.0 1 1

Aggregate (cost=6,689.61..6,689.62 rows=1 width=8) (actual time=1,693.990..1,693.990 rows=1 loops=1)

2. 124.221 1,693.937 ↓ 72.0 72 1

Nested Loop (cost=0.85..6,689.60 rows=1 width=16) (actual time=1,215.244..1,693.937 rows=72 loops=1)

  • Join Filter: (_hyper_3_52_chunk.session_id = _hyper_2_51_chunk.id)
  • Rows Removed by Join Filter: 1601847
3. 0.060 11.236 ↓ 121.0 121 1

Append (cost=0.42..3,092.10 rows=1 width=16) (actual time=0.016..11.236 rows=121 loops=1)

4. 11.176 11.176 ↓ 121.0 121 1

Index Scan using _hyper_2_51_chunk_tmp_session_property_id_and_created_at on _hyper_2_51_chunk (cost=0.42..3,092.09 rows=1 width=16) (actual time=0.015..11.176 rows=121 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) AND (site_id = 168))
  • Rows Removed by Filter: 12164
5. 114.950 1,558.480 ↓ 3.5 13,239 121

Append (cost=0.43..3,550.58 rows=3,754 width=32) (actual time=0.011..12.880 rows=13,239 loops=121)

6. 1,443.530 1,443.530 ↓ 3.5 13,239 121

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.011..11.930 rows=13,239 loops=121)

  • 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.525 ms
Execution time : 1,694.027 ms