explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NGS2

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

Sort (cost=2,769,920.62..2,769,920.69 rows=28 width=104) (actual rows= loops=)

  • Sort Key: (count(gl_global_40m.gl_business_unit_code)) DESC
2. 0.000 0.000 ↓ 0.0

HashAggregate (cost=2,769,919.67..2,769,919.95 rows=28 width=104) (actual rows= loops=)

  • Group Key: ('local'::text), gl_global_40m.gl_local_amount_currency, gl_global_40m.gl_business_unit_code, (count(gl_global_40m.gl_business_unit_code))
3. 0.000 0.000 ↓ 0.0

Append (cost=1,384,954.31..2,769,919.39 rows=28 width=104) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Finalize GroupAggregate (cost=1,384,954.31..1,384,962.45 rows=21 width=56) (actual rows= loops=)

  • Group Key: gl_global_40m.gl_local_amount_currency, gl_global_40m.gl_business_unit_code
5. 0.000 0.000 ↓ 0.0

Gather Merge (cost=1,384,954.31..1,384,961.77 rows=63 width=24) (actual rows= loops=)

  • Workers Planned: 3
6. 0.000 0.000 ↓ 0.0

Sort (cost=1,383,954.27..1,383,954.32 rows=21 width=24) (actual rows= loops=)

  • Sort Key: gl_global_40m.gl_local_amount_currency, gl_global_40m.gl_business_unit_code
7. 0.000 0.000 ↓ 0.0

Partial HashAggregate (cost=1,383,953.60..1,383,953.81 rows=21 width=24) (actual rows= loops=)

  • Group Key: gl_global_40m.gl_local_amount_currency, gl_global_40m.gl_business_unit_code
8. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on gl_global_40m (cost=0.00..1,285,449.20 rows=13,133,920 width=16) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Finalize GroupAggregate (cost=1,384,953.81..1,384,956.52 rows=7 width=56) (actual rows= loops=)

  • Group Key: gl_global_40m_1.gl_reporting_amount_currency, gl_global_40m_1.gl_business_unit_code
10. 0.000 0.000 ↓ 0.0

Gather Merge (cost=1,384,953.81..1,384,956.29 rows=21 width=24) (actual rows= loops=)

  • Workers Planned: 3
11. 0.000 0.000 ↓ 0.0

Sort (cost=1,383,953.77..1,383,953.79 rows=7 width=24) (actual rows= loops=)

  • Sort Key: gl_global_40m_1.gl_reporting_amount_currency, gl_global_40m_1.gl_business_unit_code
12. 0.000 0.000 ↓ 0.0

Partial HashAggregate (cost=1,383,953.60..1,383,953.67 rows=7 width=24) (actual rows= loops=)

  • Group Key: gl_global_40m_1.gl_reporting_amount_currency, gl_global_40m_1.gl_business_unit_code
13. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on gl_global_40m gl_global_40m_1 (cost=0.00..1,285,449.20 rows=13,133,920 width=16) (actual rows= loops=)