explain.depesz.com

PostgreSQL's explain analyze made readable

Result: u2qF

Settings

Optimization(s) for this plan:

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

Aggregate (cost=14,397,654.18..14,397,654.19 rows=1 width=8) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Finalize GroupAggregate (cost=12,559,962.20..14,329,082.10 rows=5,485,767 width=212) (actual rows= loops=)

  • Group Key: aws_cost_and_usage.resource_tags_user_costing_family, aws_cost_and_usage.line_item_usage_start_date, aws_cost_and_usage.resource_tags_user_app_name, aws_cost_and_usage.product_servicecode, aws_cost_and_usage.line_item_usage_type, aws_cost_and_usage.resource_tags_user_env, aws_cost_and_usage.line_item_usage_account_id
3. 0.000 0.000 ↓ 0.0

Gather Merge (cost=12,559,962.20..14,054,793.75 rows=10,971,534 width=104) (actual rows= loops=)

  • Workers Planned: 2
4. 0.000 0.000 ↓ 0.0

Partial GroupAggregate (cost=12,558,962.17..12,787,406.47 rows=5,485,767 width=104) (actual rows= loops=)

  • Group Key: aws_cost_and_usage.resource_tags_user_costing_family, aws_cost_and_usage.line_item_usage_start_date, aws_cost_and_usage.resource_tags_user_app_name, aws_cost_and_usage.product_servicecode, aws_cost_and_usage.line_item_usage_type, aws_cost_and_usage.resource_tags_user_env, aws_cost_and_usage.line_item_usage_account_id
5. 0.000 0.000 ↓ 0.0

Sort (cost=12,558,962.17..12,578,249.58 rows=7,714,961 width=104) (actual rows= loops=)

  • Sort Key: aws_cost_and_usage.resource_tags_user_costing_family, aws_cost_and_usage.line_item_usage_start_date, aws_cost_and_usage.resource_tags_user_app_name, aws_cost_and_usage.product_servicecode, aws_cost_and_usage.line_item_usage_type, aws_cost_and_usage.resource_tags_user_env, aws_cost_and_usage.line_item_usage_account_id
6. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on aws_cost_and_usage (cost=0.00..10,410,656.94 rows=7,714,961 width=104) (actual rows= loops=)

  • Filter: ((line_item_line_item_type = ANY ('{DiscountedUsage,Usage,SavingsPlanCoveredUsage}'::text[])) AND (date(line_item_usage_start_date) >= '2019-01-01'::date))