explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8o9

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

Unique (cost=1,779,031.08..1,800,273.69 rows=708,087 width=997) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Sort (cost=1,779,031.08..1,780,801.30 rows=708,087 width=997) (actual rows= loops=)

  • Sort Key: sd.clndr_month_start_dt, sd.clndr_month_end_dt, sd.coach_expert_id, em.agent_id, em.expert_first_name, em.expert_last_name, sd.client, sd.subclient, sd.metric, (sum(sd.metric_numerator)), (sum(sd.metric_denominator))
3. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=1,055,246.45..1,090,650.80 rows=708,087 width=997) (actual rows= loops=)

  • Group Key: sd.clndr_month_start_dt, sd.clndr_month_end_dt, sd.coach_expert_id, em.agent_id, em.expert_first_name, em.expert_last_name, sd.client, sd.subclient, sd.metric
4. 0.000 0.000 ↓ 0.0

Sort (cost=1,055,246.45..1,057,016.67 rows=708,087 width=973) (actual rows= loops=)

  • Sort Key: sd.clndr_month_start_dt, sd.clndr_month_end_dt, sd.coach_expert_id, em.agent_id, em.expert_first_name, em.expert_last_name, sd.client, sd.subclient, sd.metric
5. 0.000 0.000 ↓ 0.0

Hash Join (cost=2,921.17..381,384.17 rows=708,087 width=973) (actual rows= loops=)

  • Hash Cond: ((sd.coach_expert_id)::text = (em.expert_id)::text)
6. 0.000 0.000 ↓ 0.0

Seq Scan on source_data sd (cost=0.00..366,127.84 rows=1,401,143 width=944) (actual rows= loops=)

  • Filter: (coach_expert_id IS NOT NULL)
7. 0.000 0.000 ↓ 0.0

Hash (cost=2,425.95..2,425.95 rows=39,618 width=36) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Seq Scan on expert_master em (cost=0.00..2,425.95 rows=39,618 width=36) (actual rows= loops=)

  • Filter: (agent_id IS NOT NULL)