explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7MVB

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 5,276.198 ↑ 28.6 7 1

Finalize GroupAggregate (cost=319,948.68..319,999.85 rows=200 width=16) (actual time=5,276.192..5,276.198 rows=7 loops=1)

  • Group Key: (date_trunc('week'::text, i_1.created_at))
2. 41.045 5,297.925 ↑ 33.3 12 1

Gather Merge (cost=319,948.68..319,995.35 rows=400 width=16) (actual time=5,276.183..5,297.925 rows=12 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 0.040 5,256.880 ↑ 50.0 4 3 / 3

Sort (cost=318,948.66..318,949.16 rows=200 width=16) (actual time=5,256.879..5,256.880 rows=4 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. 814.430 5,256.840 ↑ 50.0 4 3 / 3

Partial HashAggregate (cost=318,938.51..318,941.01 rows=200 width=16) (actual time=5,256.839..5,256.840 rows=4 loops=3)

  • Group Key: date_trunc('week'::text, i_1.created_at)
5. 1,514.166 4,442.410 ↑ 1.3 1,892,887 3 / 3

Result (cost=0.00..307,107.97 rows=2,366,109 width=24) (actual time=0.028..4,442.410 rows=1,892,887 loops=3)

6. 317.185 2,928.244 ↑ 1.3 1,892,887 3 / 3

Parallel Append (cost=0.00..277,531.60 rows=2,366,109 width=24) (actual time=0.024..2,928.244 rows=1,892,887 loops=3)

7. 2,383.762 2,383.762 ↑ 1.3 1,743,246 3 / 3

Parallel Seq Scan on _hyper_1_17_chunk i_1 (cost=0.00..244,789.87 rows=2,179,058 width=24) (actual time=0.059..2,383.762 rows=1,743,246 loops=3)

  • Filter: ((created_at >= '2019-10-31 00:00:00+00'::timestamp with time zone) AND (property_id = 2))
8. 227.260 227.260 ↓ 1.2 224,380 2 / 3

Parallel Seq Scan on _hyper_1_7_chunk i_2 (cost=0.00..20,902.74 rows=186,983 width=24) (actual time=0.014..340.890 rows=224,380 loops=2)

  • Filter: ((created_at >= '2019-10-31 00:00:00+00'::timestamp with time zone) AND (property_id = 2))
9. 0.037 0.037 ↓ 1.7 164 1 / 3

Parallel Seq Scan on _hyper_1_12_chunk i (cost=0.00..8.45 rows=96 width=24) (actual time=0.011..0.111 rows=164 loops=1)

  • Filter: ((created_at >= '2019-10-31 00:00:00+00'::timestamp with time zone) AND (property_id = 2))
Planning time : 0.478 ms
Execution time : 5,297.990 ms