explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 0XS

Settings
# exclusive inclusive rows x rows loops node
1. 0.673 36,250.081 ↑ 1.6 567 1

Finalize GroupAggregate (cost=360,251.69..360,278.57 rows=896 width=12) (actual time=36,249.055..36,250.081 rows=567 loops=1)

  • Group Key: ss.store_key, c.weekday
2. 1.133 36,249.408 ↑ 1.1 1,693 1

Sort (cost=360,251.69..360,256.17 rows=1,792 width=12) (actual time=36,249.050..36,249.408 rows=1,693 loops=1)

  • Sort Key: ss.store_key, c.weekday
  • Sort Method: quicksort Memory: 128kB
3. 14.990 36,248.275 ↑ 1.1 1,693 1

Gather (cost=359,966.69..360,154.85 rows=1,792 width=12) (actual time=36,243.856..36,248.275 rows=1,693 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
4. 6,091.027 36,233.285 ↑ 1.6 564 3

Partial HashAggregate (cost=358,966.69..358,975.65 rows=896 width=12) (actual time=36,231.956..36,233.285 rows=564 loops=3)

  • Group Key: ss.store_key, c.weekday
5. 8,858.283 30,142.258 ↓ 1.0 6,216,876 3

Hash Left Join (cost=70.76..312,641.40 rows=6,176,706 width=6) (actual time=1.598..30,142.258 rows=6,216,876 loops=3)

  • Hash Cond: (ss.date_key = c.date_key)
6. 9,906.433 21,282.702 ↓ 1.0 6,216,876 3

Hash Join (cost=9.44..296,334.88 rows=6,176,706 width=8) (actual time=0.293..21,282.702 rows=6,216,876 loops=3)

  • Hash Cond: (ss.store_key = st.store_key)
7. 11,376.193 11,376.193 ↑ 1.3 7,808,535 3

Parallel Seq Scan on stock_sales ss (cost=0.00..269,855.20 rows=9,760,720 width=8) (actual time=0.200..11,376.193 rows=7,808,535 loops=3)

8. 0.027 0.076 ↑ 1.0 81 3

Hash (cost=8.43..8.43 rows=81 width=2) (actual time=0.076..0.076 rows=81 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
9. 0.049 0.049 ↑ 1.0 81 3

Seq Scan on stores st (cost=0.00..8.43 rows=81 width=2) (actual time=0.010..0.049 rows=81 loops=3)

  • Filter: (store_status = 'open_store'::text)
  • Rows Removed by Filter: 33
10. 0.657 1.273 ↑ 1.0 2,192 3

Hash (cost=33.92..33.92 rows=2,192 width=6) (actual time=1.273..1.273 rows=2,192 loops=3)

  • Buckets: 4096 Batches: 1 Memory Usage: 118kB
11. 0.616 0.616 ↑ 1.0 2,192 3

Seq Scan on calendar c (cost=0.00..33.92 rows=2,192 width=6) (actual time=0.008..0.616 rows=2,192 loops=3)