explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mfbU

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

XN Hash Right Join DS_DIST_BOTH (cost=141,146,943.75..204,506,916,457,316.78 rows=457,526,842 width=214) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

XN Subquery Scan d1 (cost=10,889.35..10,688,974,675.34 rows=759,623,697 width=196) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

XN Hash Join DS_BCAST_INNER (cost=10,889.35..10,681,378,438.37 rows=759,623,697 width=169) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

XN Hash Left Join DS_BCAST_INNER (cost=3.90..1,203,454,508.95 rows=10,365,448,505 width=332) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

XN Hash (cost=3.12..3.12 rows=312 width=29) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

XN Seq Scan on uom_cnvs_map uom (cost=0.00..3.12 rows=312 width=29) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

XN Hash (cost=10,847.58..10,847.58 rows=7,574 width=45) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

XN Hash Join DS_DIST_ALL_NONE (cost=7,268.45..10,847.58 rows=7,574 width=45) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

XN Hash Join DS_DIST_ALL_NONE (cost=7,262.72..10,188.06 rows=25,691 width=45) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

XN Seq Scan on dim_kpi_v2 k (cost=0.02..7.50 rows=217 width=22) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

XN Hash (cost=6,303.45..6,303.45 rows=383,697 width=57) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

XN Seq Scan on pdc_gpn_map (cost=0.00..6,303.45 rows=383,697 width=57) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

XN Hash (cost=5.02..5.02 rows=288 width=10) (actual rows= loops=)

14. 0.000 0.000 ↓ 0.0

XN Seq Scan on dim_unit u (cost=0.02..5.02 rows=288 width=10) (actual rows= loops=)

15. 0.000 0.000 ↓ 0.0

XN Hash (cost=140,438,599.03..140,438,599.03 rows=92,994,048 width=44) (actual rows= loops=)

16. 0.000 0.000 ↓ 0.0

XN Nested Loop DS_BCAST_INNER (cost=6,951.73..140,438,599.03 rows=92,994,048 width=44) (actual rows= loops=)

17. 0.000 0.000 ↓ 0.0

XN Nested Loop DS_BCAST_INNER (cost=0.02..69,131,766.36 rows=428,544 width=22) (actual rows= loops=)

18. 0.000 0.000 ↓ 0.0

XN Seq Scan on time_series_1547027809527 (cost=0.00..14.88 rows=1,488 width=8) (actual rows= loops=)

19. 0.000 0.000 ↓ 0.0

XN Seq Scan on dim_unit u (cost=0.02..5.02 rows=288 width=14) (actual rows= loops=)

20. 0.000 0.000 ↓ 0.0

XN Seq Scan PartitionInfo of ida_eap_prd_tbl_hist.pdc_snsr_wts wts (cost=0.00..20.00 rows=1 width=63) (actual rows= loops=)

21. 0.000 0.000 ↓ 0.0

XN S3 Query Scan wts (cost=0.00..275,000,000.00 rows=10,000,000,000 width=244) (actual rows= loops=)

22. 0.000 0.000 ↓ 0.0

XN Seq Scan on dim_kpi_v2 k (cost=0.02..7.50 rows=217 width=22) (actual rows= loops=)