explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vCQ

Settings
# exclusive inclusive rows x rows loops node
1. 0.010 7.219 ↓ 1.3 85 1

Subquery Scan on max_scr (cost=5,916.40..5,920.07 rows=67 width=16) (actual time=6.802..7.219 rows=85 loops=1)

2. 2.255 7.209 ↓ 1.3 85 1

HashAggregate (cost=5,916.40..5,919.40 rows=67 width=48) (actual time=6.801..7.209 rows=85 loops=1)

  • Group Key: stats_page_view.user_id
  • Filter: (avg(stats_page_view.max_scroll) >= '60'::numeric)
  • Rows Removed by Filter: 572
3. 0.653 4.954 ↑ 1.1 6,667 1

Append (cost=0.00..5,880.48 rows=7,183 width=20) (actual time=0.032..4.954 rows=6,667 loops=1)

4. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on stats_page_view (cost=0.00..0.00 rows=1 width=20) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: ((created_at >= '2019-04-04 00:00:00+00'::timestamp with time zone) AND (property_id = 1))
5. 0.006 0.006 ↓ 0.0 0 1

Index Scan using _hyper_3_14_chunk_idx_pageview_property_id_and_created_at on _hyper_3_14_chunk (cost=0.29..1.74 rows=1 width=20) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((property_id = 1) AND (created_at >= '2019-04-04 00:00:00+00'::timestamp with time zone))
6. 0.004 0.004 ↓ 0.0 0 1

Index Scan using _hyper_3_10_chunk_idx_pageview_property_id_and_created_at on _hyper_3_10_chunk (cost=0.29..1.74 rows=1 width=20) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((property_id = 1) AND (created_at >= '2019-04-04 00:00:00+00'::timestamp with time zone))
7. 0.004 0.004 ↓ 0.0 0 1

Index Scan using _hyper_3_18_chunk_idx_pageview_property_id_and_created_at on _hyper_3_18_chunk (cost=0.28..1.74 rows=1 width=20) (actual time=0.003..0.004 rows=0 loops=1)

  • Index Cond: ((property_id = 1) AND (created_at >= '2019-04-04 00:00:00+00'::timestamp with time zone))
8. 4.276 4.276 ↑ 1.1 6,667 1

Index Scan using _hyper_3_3_chunk_idx_pageview_property_id_and_created_at on _hyper_3_3_chunk (cost=0.42..5,837.60 rows=7,178 width=20) (actual time=0.015..4.276 rows=6,667 loops=1)

  • Index Cond: ((property_id = 1) AND (created_at >= '2019-04-04 00:00:00+00'::timestamp with time zone))
9. 0.008 0.008 ↓ 0.0 0 1

Index Scan using _hyper_3_7_chunk_idx_pageview_property_id_and_created_at on _hyper_3_7_chunk (cost=0.28..1.74 rows=1 width=20) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((property_id = 1) AND (created_at >= '2019-04-04 00:00:00+00'::timestamp with time zone))
Planning time : 0.522 ms
Execution time : 7.281 ms