explain.depesz.com

PostgreSQL's explain analyze made readable

Result: suLZ

Settings
# exclusive inclusive rows x rows loops node
1. 0.094 26.763 ↑ 1.0 1 1

Aggregate (cost=6,649.14..6,649.15 rows=1 width=8) (actual time=26.762..26.763 rows=1 loops=1)

2. 2.055 26.669 ↓ 1,553.0 1,553 1

Hash Join (cost=3,084.90..6,649.13 rows=1 width=16) (actual time=11.811..26.669 rows=1,553 loops=1)

  • Hash Cond: (_hyper_3_52_chunk.session_id = _hyper_2_51_chunk.id)
3. 0.779 12.892 ↓ 3.5 13,239 1

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

4. 12.113 12.113 ↓ 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..12.113 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))
5. 0.546 11.722 ↓ 90.2 1,263 1

Hash (cost=3,084.29..3,084.29 rows=14 width=16) (actual time=11.722..11.722 rows=1,263 loops=1)

  • Buckets: 2048 (originally 1024) Batches: 1 (originally 1) Memory Usage: 76kB
6. 0.086 11.176 ↓ 90.2 1,263 1

Append (cost=0.42..3,084.29 rows=14 width=16) (actual time=0.013..11.176 rows=1,263 loops=1)

7. 11.090 11.090 ↓ 90.2 1,263 1

Index Scan using _hyper_2_51_chunk_tmp_session_property_id_and_created_at on _hyper_2_51_chunk (cost=0.42..3,084.22 rows=14 width=16) (actual time=0.013..11.090 rows=1,263 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))
  • Rows Removed by Filter: 11022
Planning time : 0.474 ms
Execution time : 26.803 ms