explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mMNp

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Limit (cost=65,479,554.59..65,479,556.35 rows=10 width=86) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=65,479,554.59..68,649,116.44 rows=17,983,330 width=86) (actual rows= loops=)

  • Group Key: (CASE WHEN ((iss_brnd_cd)::text = ANY ('{PINK,VSS,VSD,VSB}'::text[])) THEN 'VS'::text WHEN ((iss_brnd_cd)::text = ANY ('{BBW,BBWC,BBWD}'::text[])) THEN 'BBW'::text ELSE NULL::text END), rcv_loc_num, itm_sku_num, ("left"(to_char((fiscal_week)::timestamp with time zone, 'YYYY-MM-DD'::text), 7))
3. 0.000 0.000 ↓ 0.0

Sort (cost=65,479,554.59..65,929,137.83 rows=179,833,296 width=86) (actual rows= loops=)

  • Sort Key: (CASE WHEN ((iss_brnd_cd)::text = ANY ('{PINK,VSS,VSD,VSB}'::text[])) THEN 'VS'::text WHEN ((iss_brnd_cd)::text = ANY ('{BBW,BBWC,BBWD}'::text[])) THEN 'BBW'::text ELSE NULL::text END), rcv_loc_num, itm_sku_num, ("left"(to_char((fiscal_week)::timestamp with time zone, 'YYYY-MM-DD'::text), 7))
4. 0.000 0.000 ↓ 0.0

Seq Scan on dc_outflows_all_fy_18 rec (cost=0.00..6,401,309.02 rows=179,833,296 width=86) (actual rows= loops=)