explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tq4n

Settings
# exclusive inclusive rows x rows loops node
1. 0.085 664.677 ↓ 9.5 635 1

Subquery Scan on max_scr (cost=19,059.76..19,112.10 rows=67 width=16) (actual time=639.709..664.677 rows=635 loops=1)

2. 10.577 664.592 ↓ 9.5 635 1

Finalize GroupAggregate (cost=19,059.76..19,111.43 rows=67 width=48) (actual time=639.708..664.592 rows=635 loops=1)

  • Group Key: _hyper_3_3_chunk.user_id
  • Filter: (avg(_hyper_3_3_chunk.max_scroll) >= '60'::numeric)
  • Rows Removed by Filter: 13171
3. 11.943 654.015 ↓ 34.5 13,806 1

Gather Merge (cost=19,059.76..19,106.43 rows=400 width=48) (actual time=639.683..654.015 rows=13,806 loops=1)

  • Workers Planned: 2
  • Workers Launched: 0
4. 7.955 642.072 ↓ 69.0 13,806 1

Sort (cost=18,059.73..18,060.23 rows=200 width=48) (actual time=639.326..642.072 rows=13,806 loops=1)

  • Sort Key: _hyper_3_3_chunk.user_id
  • Sort Method: quicksort Memory: 2326kB
5. 186.944 634.117 ↓ 69.0 13,806 1

Partial HashAggregate (cost=18,050.09..18,052.09 rows=200 width=48) (actual time=623.499..634.117 rows=13,806 loops=1)

  • Group Key: _hyper_3_3_chunk.user_id
6. 34.018 447.173 ↓ 2.4 345,360 1

Parallel Append (cost=0.00..17,327.93 rows=144,432 width=20) (actual time=0.008..447.173 rows=345,360 loops=1)

7. 394.425 394.425 ↓ 2.4 317,760 1

Parallel Index Scan using _hyper_3_3_chunk_stats_page_view_created_at_idx on _hyper_3_3_chunk (cost=0.42..15,589.83 rows=132,931 width=20) (actual time=0.019..394.425 rows=317,760 loops=1)

  • Index Cond: (created_at >= '2019-04-04 00:00:00+00'::timestamp with time zone)
8. 2.853 2.853 ↓ 1.7 9,110 1

Parallel Seq Scan on _hyper_3_14_chunk (cost=0.00..334.99 rows=5,359 width=20) (actual time=0.005..2.853 rows=9,110 loops=1)

  • Filter: (created_at >= '2019-04-04 00:00:00+00'::timestamp with time zone)
9. 12.861 12.861 ↓ 1.7 8,921 1

Parallel Seq Scan on _hyper_3_10_chunk (cost=0.00..328.60 rows=5,248 width=20) (actual time=0.004..12.861 rows=8,921 loops=1)

  • Filter: (created_at >= '2019-04-04 00:00:00+00'::timestamp with time zone)
10. 1.915 1.915 ↓ 1.7 6,150 1

Parallel Seq Scan on _hyper_3_18_chunk (cost=0.00..226.22 rows=3,618 width=20) (actual time=0.003..1.915 rows=6,150 loops=1)

  • Filter: (created_at >= '2019-04-04 00:00:00+00'::timestamp with time zone)
11. 1.100 1.100 ↓ 1.7 3,419 1

Parallel Seq Scan on _hyper_3_7_chunk (cost=0.00..126.14 rows=2,011 width=20) (actual time=0.006..1.100 rows=3,419 loops=1)

  • Filter: (created_at >= '2019-04-04 00:00:00+00'::timestamp with time zone)
12. 0.001 0.001 ↓ 0.0 0 1

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

  • Filter: (created_at >= '2019-04-04 00:00:00+00'::timestamp with time zone)
Planning time : 0.453 ms
Execution time : 665.108 ms