explain.depesz.com

PostgreSQL's explain analyze made readable

Result: C2uU

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 6,456.793 ↑ 33.3 6 1

Finalize GroupAggregate (cost=909,781.98..909,833.15 rows=200 width=16) (actual time=6,456.785..6,456.793 rows=6 loops=1)

  • Group Key: (date_trunc('week'::text, i_1.created_at))
2. 125.111 6,576.852 ↑ 25.0 16 1

Gather Merge (cost=909,781.98..909,828.65 rows=400 width=16) (actual time=6,456.778..6,576.852 rows=16 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 0.036 6,451.741 ↑ 40.0 5 3 / 3

Sort (cost=908,781.95..908,782.45 rows=200 width=16) (actual time=6,451.741..6,451.741 rows=5 loops=3)

  • Sort Key: (date_trunc('week'::text, i_1.created_at))
  • Sort Method: quicksort Memory: 25kB
  • Worker 0: Sort Method: quicksort Memory: 25kB
  • Worker 1: Sort Method: quicksort Memory: 25kB
4. 648.574 6,451.705 ↑ 40.0 5 3 / 3

Partial HashAggregate (cost=908,771.81..908,774.31 rows=200 width=16) (actual time=6,451.703..6,451.705 rows=5 loops=3)

  • Group Key: date_trunc('week'::text, i_1.created_at)
5. 1,210.853 5,803.131 ↑ 1.1 2,643,762 3 / 3

Result (cost=0.00..894,549.09 rows=2,844,543 width=24) (actual time=1.512..5,803.131 rows=2,643,762 loops=3)

6. 265.994 4,592.278 ↑ 1.1 2,643,762 3 / 3

Parallel Append (cost=0.00..858,992.31 rows=2,844,543 width=24) (actual time=1.508..4,592.278 rows=2,643,762 loops=3)

7. 535.552 535.552 ↓ 15.4 1,520,072 1 / 3

Parallel Index Scan Backward using _hyper_1_97_chunk_stats_impression_created_at_idx on _hyper_1_97_chunk i_1 (cost=0.43..74,812.93 rows=98,882 width=24) (actual time=4.451..1,606.656 rows=1,520,072 loops=1)

  • Index Cond: (created_at >= '2020-01-01 00:00:00+00'::timestamp with time zone)
  • Filter: (property_id = 151)
  • Rows Removed by Filter: 137603
8. 3,790.732 3,790.732 ↑ 1.3 2,137,072 3 / 3

Parallel Seq Scan on _hyper_1_100_chunk i (cost=0.00..769,956.66 rows=2,745,661 width=24) (actual time=0.062..3,790.732 rows=2,137,072 loops=3)

  • Filter: ((created_at >= '2020-01-01 00:00:00+00'::timestamp with time zone) AND (property_id = 151))
  • Rows Removed by Filter: 3277811
Planning time : 0.463 ms
Execution time : 6,576.935 ms