explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QW7B

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

GroupAggregate (cost=62,210,341,724.59..62,211,132,961.47 rows=786,647 width=37) (actual rows= loops=)

  • Group Key: calculation.guid
  • Filter: (max(category.category2_guid_cnt) <> count(DISTINCT service.category_guid))
2. 0.000 0.000 ↓ 0.0

Sort (cost=62,210,341,724.59..62,210,537,063.18 rows=78,135,438 width=82) (actual rows= loops=)

  • Sort Key: calculation.guid
3. 0.000 0.000 ↓ 0.0

Gather (cost=10,001,692,581.68..62,195,825,342.29 rows=78,135,438 width=82) (actual rows= loops=)

  • Workers Planned: 2
4. 0.000 0.000 ↓ 0.0

Parallel Hash Left Join (cost=10,001,691,581.68..62,188,010,798.49 rows=32,556,432 width=82) (actual rows= loops=)

  • Hash Cond: ((line2.service_type)::text = (service.service_type)::text)
  • Join Filter: ((service.category_guid)::text = ANY ((category.category2_guid_arr)::text[]))
5. 0.000 0.000 ↓ 0.0

Hash Join (cost=1,051,622.97..2,555,827.15 rows=1,990,927 width=86) (actual rows= loops=)

  • Hash Cond: ((calculation.compensation_guid)::text = (category.compensation_guid)::text)
6. 0.000 0.000 ↓ 0.0

Parallel Hash Join (cost=466,868.49..1,906,783.28 rows=1,101,858 width=83) (actual rows= loops=)

  • Hash Cond: ((line2.calculation_guid)::text = (calculation.guid)::text)
7. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on msp_compensation_calculation_line2 line2 (cost=0.00..1,347,862.06 rows=23,323,106 width=46) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Parallel Hash (cost=462,750.78..462,750.78 rows=329,417 width=74) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on msp_compensation_calculation calculation (cost=0.00..462,750.78 rows=329,417 width=74) (actual rows= loops=)

  • Filter: ((period_from <= '2018-12-31'::date) AND (period_to >= '2018-01-01'::date) AND ((status)::text = 'PUBLISHED'::text))
10. 0.000 0.000 ↓ 0.0

Hash (cost=522,701.83..522,701.83 rows=2,462,852 width=77) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Subquery Scan on category (cost=441,199.75..522,701.83 rows=2,462,852 width=77) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=441,199.75..498,073.31 rows=2,462,852 width=77) (actual rows= loops=)

  • Group Key: category_1.compensation_guid
13. 0.000 0.000 ↓ 0.0

Sort (cost=441,199.75..447,721.73 rows=2,608,791 width=74) (actual rows= loops=)

  • Sort Key: category_1.compensation_guid
14. 0.000 0.000 ↓ 0.0

Seq Scan on tmp_category_comp_2018 category_1 (cost=0.00..96,928.50 rows=2,608,791 width=74) (actual rows= loops=)

  • Filter: ((category_compensation_type)::text = 'ACTUAL'::text)
15. 0.000 0.000 ↓ 0.0

Parallel Hash (cost=418,326.65..418,326.65 rows=10,410,565 width=46) (actual rows= loops=)

16. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on msp_compensation_category_services2 service (cost=0.00..418,326.65 rows=10,410,565 width=46) (actual rows= loops=)