explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xy0

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

Aggregate (cost=10,546,835.78..10,546,835.79 rows=1 width=8) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Finalize GroupAggregate (cost=10,533,066.50..10,545,687.13 rows=91,892 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=10,533,066.50..10,543,225.21 rows=77,150 width=104) (actual rows= loops=)

  • Workers Planned: 2
4. 0.000 0.000 ↓ 0.0

Partial GroupAggregate (cost=10,532,066.48..10,533,320.17 rows=38,575 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=10,532,066.48..10,532,162.92 rows=38,575 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,527,017.45 rows=38,575 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) AND (date(line_item_usage_start_date) = '2020-03-02'::date))