explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FBGH

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

Subquery Scan on spotservice_intrim (cost=12,639,069.20..14,674,336.01 rows=5,485,767 width=166) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Finalize GroupAggregate (cost=12,639,069.20..14,619,478.34 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,639,069.20..14,153,188.15 rows=10,971,534 width=112) (actual rows= loops=)

  • Workers Planned: 2
4. 0.000 0.000 ↓ 0.0

Partial GroupAggregate (cost=12,638,069.17..12,885,800.87 rows=5,485,767 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
5. 0.000 0.000 ↓ 0.0

Sort (cost=12,638,069.17..12,657,356.58 rows=7,714,961 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
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=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))