explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bBlj

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 252,916.193 ↑ 1.0 1 1

Finalize Aggregate (cost=2,779,579.74..2,779,579.74 rows=1 width=8) (actual time=252,916.193..252,916.193 rows=1 loops=1)

2. 45.901 252,918.182 ↓ 1.5 3 1

Gather (cost=2,779,579.54..2,779,579.74 rows=2 width=8) (actual time=252,914.863..252,918.182 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 1,160.464 252,872.281 ↑ 1.0 1 3

Partial Aggregate (cost=2,778,579.54..2,778,579.54 rows=1 width=8) (actual time=252,872.281..252,872.281 rows=1 loops=3)

4. 6,109.715 251,711.817 ↑ 1.3 7,403,339 3

Hash Join (cost=477.51..2,773,948.77 rows=9,261,529 width=0) (actual time=7.617..251,711.817 rows=7,403,339 loops=3)

  • Hash Cond: (order_data.product_sk = prod.product_sk)
5. 245,594.780 245,594.780 ↑ 1.3 7,403,339 3

Parallel Seq Scan on b_sf_order_df_t order_data (cost=0.00..2,738,740.53 rows=9,261,529 width=5) (actual time=0.063..245,594.780 rows=7,403,339 loops=3)

  • Filter: ((order_placed_date >= '2018-12-01 00:00:00'::timestamp without time zone) AND (order_placed_date <= '2018-12-31 23:59:59'::timestamp without time zone))
  • Rows Removed by Filter: 8107567
6. 3.381 7.322 ↑ 1.0 9,924 3

Hash (cost=442.77..442.77 rows=9,924 width=5) (actual time=7.322..7.322 rows=9,924 loops=3)

  • Buckets: 16384 Batches: 1 Memory Usage: 487kB
7. 3.941 3.941 ↑ 1.0 9,924 3

Seq Scan on pg_cmdm_product_d prod (cost=0.00..442.77 rows=9,924 width=5) (actual time=0.021..3.941 rows=9,924 loops=3)