explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ueLK

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

GroupAggregate (cost=10,681,222.28..10,685,567.98 rows=27,161 width=89) (actual rows= loops=)

  • Group Key: u2."Date", u2."AccountID", u2."Service", u2."Cost_Family
2. 0.000 0.000 ↓ 0.0

Sort (cost=10,681,222.28..10,681,901.30 rows=271,606 width=89) (actual rows= loops=)

  • Sort Key: u2."Date", u2."AccountID", u2."Service", u2."Cost_Family
3. 0.000 0.000 ↓ 0.0

Subquery Scan on u2 (cost=10,601,075.41..10,642,781.77 rows=271,606 width=89) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Finalize GroupAggregate (cost=10,601,075.41..10,640,065.71 rows=271,606 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
5. 0.000 0.000 ↓ 0.0

Gather Merge (cost=10,601,075.41..10,631,262.23 rows=231,450 width=77) (actual rows= loops=)

  • Workers Planned: 2
6. 0.000 0.000 ↓ 0.0

Partial GroupAggregate (cost=10,600,075.38..10,603,547.13 rows=115,725 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
7. 0.000 0.000 ↓ 0.0

Sort (cost=10,600,075.38..10,600,364.69 rows=115,725 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
8. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on aws_cost_and_usage (cost=0.00..10,585,197.71 rows=115,725 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[])) AND (date(line_item_usage_start_date) >= '2020-03-02'::date) AND (date(line_item_usage_start_date) <= '2020-03-04'::date))