explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wtlh

Settings
# exclusive inclusive rows x rows loops node
1. 5.466 65.624 ↓ 3,258.0 3,258 1

Hash Join (cost=2,578.92..6,143.16 rows=1 width=16) (actual time=37.531..65.624 rows=3,258 loops=1)

  • Hash Cond: (_hyper_3_52_chunk.session_id = _hyper_2_51_chunk.id)
2. 0.750 22.668 ↓ 3.5 13,239 1

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

3. 21.918 21.918 ↓ 3.5 13,239 1

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..21.918 rows=13,239 loops=1)

  • 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))
4. 3.993 37.490 ↓ 246.2 2,954 1

Hash (cost=2,578.34..2,578.34 rows=12 width=16) (actual time=37.489..37.490 rows=2,954 loops=1)

  • Buckets: 4096 (originally 1024) Batches: 1 (originally 1) Memory Usage: 171kB
5. 0.182 33.497 ↓ 246.2 2,954 1

Append (cost=0.42..2,578.34 rows=12 width=16) (actual time=0.014..33.497 rows=2,954 loops=1)

6. 33.315 33.315 ↓ 246.2 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,578.28 rows=12 width=16) (actual time=0.014..33.315 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)))
  • Rows Removed by Filter: 9331
Planning time : 0.478 ms
Execution time : 65.758 ms