explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DbpH

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

Explicit Redistribute Motion 588:588 (slice5; segments: 588) (cost=147,751.87..14,687,700,716.44 rows=2,123,109 width=2,758) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=147,751.87..14,687,700,716.44 rows=2,123,109 width=2,758) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Broadcast Motion 588:588 (slice4; segments: 588) (cost=146,840.23..419,256.01 rows=45,830 width=6) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=146,840.23..149,321.97 rows=78 width=6) (actual rows= loops=)

  • Hash Cond: disposition."Project Number"::text = tbl_csat_profile_c.project_number::text
5. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=7,074.89..8,915.18 rows=47 width=12) (actual rows= loops=)

  • Hash Cond: disposition."Project Number"::text = tbl_csat_deployment_ids_ext.project_number::text
6. 0.000 0.000 ↓ 0.0

Redistribute Motion 588:588 (slice1; segments: 588) (cost=0.00..1,429.20 rows=47 width=10) (actual rows= loops=)

  • Hash Key: disposition."Project Number"::text
7. 0.000 0.000 ↓ 0.0

Seq Scan on tbl_csat_sds_deploy_disposition_ext disposition (cost=0.00..884.40 rows=47 width=10) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Hash (cost=5,395.22..5,395.22 rows=229 width=11) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Redistribute Motion 588:588 (slice2; segments: 588) (cost=0.00..5,395.22 rows=229 width=11) (actual rows= loops=)

  • Hash Key: tbl_csat_deployment_ids_ext.project_number::text
10. 0.000 0.000 ↓ 0.0

Seq Scan on tbl_csat_deployment_ids_ext (cost=0.00..2,707.74 rows=229 width=11) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Hash (cost=129,702.88..129,702.88 rows=1,370 width=14) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Redistribute Motion 588:588 (slice3; segments: 588) (cost=0.00..129,702.88 rows=1,370 width=14) (actual rows= loops=)

  • Hash Key: tbl_csat_profile_c.project_number::text
13. 0.000 0.000 ↓ 0.0

Seq Scan on tbl_csat_profile_c (cost=0.00..113,602.96 rows=1,370 width=14) (actual rows= loops=)

14. 0.000 0.000 ↓ 0.0

Materialize (cost=911.64..1,184.04 rows=47 width=2,752) (actual rows= loops=)

  • -> Seq Scan on tbl_csat_sds_deploy_disposition_ext (cost=0.00..884.40 rows=47 width=2,752)Optimizer status: legacy query optimizer