explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 96gT

Settings
# exclusive inclusive rows x rows loops node
1. 5.544 123.689 ↑ 1.0 1 1

Aggregate (cost=78,626.38..78,626.39 rows=1 width=8) (actual time=123.689..123.689 rows=1 loops=1)

2. 16.953 118.145 ↓ 7.9 82,298 1

Hash Join (cost=8,325.16..78,600.23 rows=10,461 width=0) (actual time=11.385..118.145 rows=82,298 loops=1)

  • Hash Cond: (p.session_id = s.id)
3. 5.311 89.863 ↓ 1.0 82,399 1

Custom Scan (ConstraintAwareAppend) (cost=0.43..69,874.02 rows=79,164 width=16) (actual time=0.025..89.863 rows=82,399 loops=1)

  • Hypertable: stats_page_view
  • Chunks left after exclusion: 2
4. 4.901 84.552 ↓ 1.0 82,399 1

Append (cost=0.43..69,874.02 rows=79,164 width=16) (actual time=0.024..84.552 rows=82,399 loops=1)

5. 51.608 51.608 ↓ 1.0 53,414 1

Index Scan using _hyper_3_92_chunk_tmp_pageview_property_id_and_created_at on _hyper_3_92_chunk p_1 (cost=0.43..45,051.76 rows=51,270 width=16) (actual time=0.024..51.608 rows=53,414 loops=1)

  • Index Cond: ((property_id = 52) AND (created_at >= '2019-10-20 00:00:00+00'::timestamp with time zone) AND (created_at < CURRENT_DATE))
6. 28.043 28.043 ↓ 1.0 28,985 1

Index Scan using _hyper_3_52_chunk_tmp_pageview_property_id_and_created_at on _hyper_3_52_chunk p_2 (cost=0.43..24,426.44 rows=27,894 width=16) (actual time=0.023..28.043 rows=28,985 loops=1)

  • Index Cond: ((property_id = 52) AND (created_at >= '2019-10-20 00:00:00+00'::timestamp with time zone) AND (created_at < CURRENT_DATE))
7. 1.298 11.329 ↑ 1.0 8,131 1

Hash (cost=8,218.50..8,218.50 rows=8,498 width=16) (actual time=11.329..11.329 rows=8,131 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 510kB
8. 0.737 10.031 ↑ 1.0 8,131 1

Custom Scan (ConstraintAwareAppend) (cost=0.43..8,218.50 rows=8,498 width=16) (actual time=0.012..10.031 rows=8,131 loops=1)

  • Hypertable: stats_session
  • Chunks left after exclusion: 2
9. 0.476 9.294 ↑ 1.0 8,131 1

Append (cost=0.43..8,218.50 rows=8,498 width=16) (actual time=0.012..9.294 rows=8,131 loops=1)

10. 5.048 5.048 ↑ 1.0 4,658 1

Index Scan using _hyper_2_89_chunk_tmp_session_property_id_and_created_at on _hyper_2_89_chunk s_1 (cost=0.43..4,561.76 rows=4,716 width=16) (actual time=0.011..5.048 rows=4,658 loops=1)

  • Index Cond: ((property_id = 52) AND (created_at >= '2019-10-20 00:00:00+00'::timestamp with time zone) AND (created_at < CURRENT_DATE))
11. 3.770 3.770 ↑ 1.1 3,473 1

Index Scan using _hyper_2_51_chunk_tmp_session_property_id_and_created_at on _hyper_2_51_chunk s_2 (cost=0.43..3,614.25 rows=3,782 width=16) (actual time=0.012..3.770 rows=3,473 loops=1)

  • Index Cond: ((property_id = 52) AND (created_at >= '2019-10-20 00:00:00+00'::timestamp with time zone) AND (created_at < CURRENT_DATE))
Planning time : 0.870 ms
Execution time : 123.846 ms