explain.depesz.com

PostgreSQL's explain analyze made readable

Result: L9HT

Settings
# exclusive inclusive rows x rows loops node
1. 5.667 139.820 ↑ 1.0 1 1

Aggregate (cost=78,730.99..78,731.00 rows=1 width=8) (actual time=139.819..139.820 rows=1 loops=1)

2. 18.602 134.153 ↓ 7.9 82,298 1

Hash Join (cost=8,325.16..78,600.23 rows=10,461 width=75) (actual time=13.448..134.153 rows=82,298 loops=1)

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

Custom Scan (ConstraintAwareAppend) (cost=0.43..69,874.02 rows=79,164 width=43) (actual time=0.024..102.159 rows=82,399 loops=1)

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

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

5. 59.798 59.798 ↓ 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=44) (actual time=0.023..59.798 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. 32.107 32.107 ↓ 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=40) (actual time=0.022..32.107 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.521 13.392 ↑ 1.0 8,131 1

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

  • Buckets: 16384 Batches: 1 Memory Usage: 574kB
8. 0.833 11.871 ↑ 1.0 8,131 1

Custom Scan (ConstraintAwareAppend) (cost=0.43..8,218.50 rows=8,498 width=24) (actual time=0.011..11.871 rows=8,131 loops=1)

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

Append (cost=0.43..8,218.50 rows=8,498 width=24) (actual time=0.011..11.038 rows=8,131 loops=1)

10. 6.012 6.012 ↑ 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=24) (actual time=0.010..6.012 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. 4.555 4.555 ↑ 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=24) (actual time=0.016..4.555 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.909 ms
Execution time : 139.971 ms