explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xhf1

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

Limit (cost=33,486.79..33,486.91 rows=1 width=248) (never executed)

2. 0.000 0.000 ↓ 0.0

Gather Merge (cost=33,486.67..33,486.91 rows=2 width=248) (never executed)

  • Workers Planned: 2
3. 0.000 0.000 ↓ 0.0

Sort (cost=32,486.65..32,486.65 rows=1 width=248) (never executed)

  • Sort Key: organization_esg.org_name
4. 0.000 0.000 ↓ 0.0

Nested Loop (cost=30,980.82..32,486.64 rows=1 width=248) (never executed)

5. 0.000 0.000 ↓ 0.0

Nested Loop (cost=30,980.4..32,260.58 rows=1 width=218) (never executed)

6. 0.000 0.000 ↓ 0.0

Merge Join (cost=30,979.84..31,279.76 rows=121 width=222) (never executed)

7. 0.000 0.000 ↓ 0.0

Sort (cost=13,381.84..13,411.02 rows=11,672 width=200) (never executed)

  • Sort Key: organization_esg.org_id, organization_esg.hash
8. 0.000 0.000 ↓ 0.0

Index Scan using organization_esg_profile_id_uindex on organization_esg organization_esg (cost=0.56..12,593.35 rows=11,672 width=200) (never executed)

  • Index Cond: (profile_id = 'CLARITY_DEFAULT'::text)
  • Filter: ((master_score_version = '1.0.0'::text) AND (issuer_type = 'company'::text))
9. 0.000 0.000 ↓ 0.0

Sort (cost=17,596.96..17,667.7 rows=28,297 width=53) (never executed)

  • Sort Key: organization_esg_metric_relevance.org_id, organization_esg_metric_relevance.hash
10. 0.000 0.000 ↓ 0.0

Index Scan using organization_esg_metric_relevance_profile_id_uindex on organization_esg_metric_relevance organization_esg_metric_relevance (cost=0.56..15,504.63 rows=28,297 width=53) (never executed)

  • Index Cond: (profile_id = 'CLARITY_DEFAULT'::text)
  • Filter: (master_score_version = '1.0.0'::text)
11. 0.000 0.000 ↓ 0.0

Index Scan using organization_esg_metric_score_profile_id_org_id_uindex on organization_esg_metric_score organization_esg_metric_score (cost=0.56..8.1 rows=1 width=59) (never executed)

  • Index Cond: ((profile_id = 'CLARITY_DEFAULT'::text) AND (org_id = organization_esg.org_id))
  • Filter: ((master_score_version = '1.0.0'::text) AND (organization_esg.hash = hash))
12. 0.000 0.000 ↓ 0.0

Index Scan using organization_exposures_pkey on organization_exposures exp_agrochemical_products_part (cost=0.41..226.05 rows=1 width=38) (never executed)

  • Index Cond: ((organization_esg.org_id = org_id) AND (exposure_id = 'AGROCHEMICAL_PRODUCTS_PART'::text))