explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wvgp

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 12,330.886 ↑ 66.7 3 1

Finalize GroupAggregate (cost=315,709.74..315,760.91 rows=200 width=16) (actual time=12,330.881..12,330.886 rows=3 loops=1)

  • Group Key: (date_trunc('week'::text, i.created_at))
2. 27.690 12,346.226 ↑ 44.4 9 1

Gather Merge (cost=315,709.74..315,756.41 rows=400 width=16) (actual time=12,330.871..12,346.226 rows=9 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 0.035 12,318.536 ↑ 66.7 3 3 / 3

Sort (cost=314,709.72..314,710.22 rows=200 width=16) (actual time=12,318.535..12,318.536 rows=3 loops=3)

  • Sort Key: (date_trunc('week'::text, i.created_at))
  • Sort Method: quicksort Memory: 25kB
  • Worker 0: Sort Method: quicksort Memory: 25kB
  • Worker 1: Sort Method: quicksort Memory: 25kB
4. 364.219 12,318.501 ↑ 66.7 3 3 / 3

Partial HashAggregate (cost=314,699.58..314,702.08 rows=200 width=16) (actual time=12,318.499..12,318.501 rows=3 loops=3)

  • Group Key: date_trunc('week'::text, i.created_at)
5. 648.236 11,954.282 ↑ 1.3 1,743,385 3 / 3

Result (cost=0.00..303,237.95 rows=2,292,326 width=24) (actual time=0.098..11,954.282 rows=1,743,385 loops=3)

6. 147.423 11,306.046 ↑ 1.3 1,743,385 3 / 3

Parallel Append (cost=0.00..274,583.87 rows=2,292,326 width=24) (actual time=0.094..11,306.046 rows=1,743,385 loops=3)

7. 0.054 0.054 ↓ 0.0 0 1 / 3

Parallel Index Scan Backward using _hyper_1_12_chunk_stats_impression_created_at_idx on _hyper_1_12_chunk i (cost=0.14..1.16 rows=1 width=24) (actual time=0.161..0.161 rows=0 loops=1)

  • Index Cond: (created_at >= '2020-01-01 00:00:00+00'::timestamp with time zone)
  • Filter: (property_id = 2)
8. 11,158.569 11,158.569 ↑ 1.3 1,743,385 3 / 3

Parallel Seq Scan on _hyper_1_17_chunk i_1 (cost=0.00..263,121.08 rows=2,292,325 width=24) (actual time=0.039..11,158.569 rows=1,743,385 loops=3)

  • Filter: ((created_at >= '2020-01-01 00:00:00+00'::timestamp with time zone) AND (property_id = 2))
  • Rows Removed by Filter: 126524
Planning time : 0.369 ms
Execution time : 12,346.295 ms