explain.depesz.com

PostgreSQL's explain analyze made readable

Result: muAf

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

Limit (cost=12,681,732.70..12,681,736.41 rows=10 width=166) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Subquery Scan on spotservice_intrim (cost=12,681,732.70..14,748,925.91 rows=5,571,820 width=166) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Finalize GroupAggregate (cost=12,681,732.70..14,693,207.71 rows=5,571,820 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
4. 0.000 0.000 ↓ 0.0

Gather Merge (cost=12,681,732.70..14,219,603.01 rows=11,143,640 width=112) (actual rows= loops=)

  • Workers Planned: 2
5. 0.000 0.000 ↓ 0.0

Partial GroupAggregate (cost=12,680,732.68..12,932,350.43 rows=5,571,820 width=112) (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
6. 0.000 0.000 ↓ 0.0

Sort (cost=12,680,732.68..12,700,322.63 rows=7,835,982 width=112) (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
7. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on aws_cost_and_usage (cost=0.00..10,417,501.81 rows=7,835,982 width=112) (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))