explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FV9V

Settings
# exclusive inclusive rows x rows loops node
1. 0.056 1,587.561 ↑ 1.0 1 1

Aggregate (cost=6,782.18..6,782.19 rows=1 width=8) (actual time=1,587.560..1,587.561 rows=1 loops=1)

2. 126.256 1,587.505 ↓ 72.0 72 1

Nested Loop (cost=0.85..6,782.17 rows=1 width=16) (actual time=1,218.907..1,587.505 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.056 14.573 ↓ 121.0 121 1

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

4. 14.517 14.517 ↓ 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,184.67 rows=1 width=16) (actual time=0.015..14.517 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. 113.982 1,446.676 ↓ 3.5 13,239 121

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

6. 1,332.694 1,332.694 ↓ 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.014 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.499 ms
Execution time : 1,587.600 ms