explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8UVr : Optimization for: plan #jXH

Settings

Optimization path:

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

WindowAgg (cost=28,147,998.01..36,922,810.67 rows=22,844,768 width=84) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Finalize GroupAggregate (cost=28,147,998.01..35,837,684.19 rows=22,844,768 width=48) (actual rows= loops=)

  • Group Key: advertiser_id, (date_trunc('month'::text, (activity_date)::timestamp with time zone))
3. 0.000 0.000 ↓ 0.0

Gather Merge (cost=28,147,998.01..34,524,110.03 rows=45,689,536 width=48) (actual rows= loops=)

  • Workers Planned: 2
4. 0.000 0.000 ↓ 0.0

Partial GroupAggregate (cost=28,146,997.98..29,249,403.88 rows=22,844,768 width=48) (actual rows= loops=)

  • Group Key: advertiser_id, (date_trunc('month'::text, (activity_date)::timestamp with time zone))
5. 0.000 0.000 ↓ 0.0

Sort (cost=28,146,997.98..28,208,429.76 rows=24,572,710 width=22) (actual rows= loops=)

  • Sort Key: advertiser_id, (date_trunc('month'::text, (activity_date)::timestamp with time zone))
6. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on rev_ds_global_revenue_and_credit t1 (cost=0.00..24,770,677.31 rows=24,572,710 width=22) (actual rows= loops=)

  • Filter: ((activity_date >= '2018-06-01'::date) AND ((billing_country)::text = ANY ('{US,GB,IE,IT,CA,AU,MX,FR,DE,NL,IN}'::text[])))