explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Xfvl

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

Limit (cost=16,269,816.64..16,269,820.68 rows=10 width=126) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Subquery Scan on unifiedframecost (cost=16,269,816.64..18,524,757.30 rows=5,585,305 width=126) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Finalize GroupAggregate (cost=16,269,816.64..18,468,904.25 rows=5,585,305 width=145) (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.resource_tags_user_env, aws_cost_and_usage.line_item_usage_account_id
4. 0.000 0.000 ↓ 0.0

Gather Merge (cost=16,269,816.64..18,077,932.90 rows=11,170,610 width=77) (actual rows= loops=)

  • Workers Planned: 2
5. 0.000 0.000 ↓ 0.0

Partial GroupAggregate (cost=16,268,816.62..16,787,567.31 rows=5,585,305 width=77) (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.resource_tags_user_env, aws_cost_and_usage.line_item_usage_account_id
6. 0.000 0.000 ↓ 0.0

Sort (cost=16,268,816.62..16,326,678.82 rows=23,144,882 width=77) (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.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,352,476.68 rows=23,144,882 width=77) (actual rows= loops=)

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