explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KwmX

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

XN Hash Right Join DS_DIST_BOTH (cost=146,276,184.49..216,465,060,736,710.44 rows=457,224,804 width=214) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

XN Hash (cost=144,172,930.30..144,172,930.30 rows=278,982,144 width=44) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

XN Nested Loop DS_BCAST_INNER (cost=13,869.02..144,172,930.30 rows=278,982,144 width=44) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

XN Nested Loop DS_BCAST_INNER (cost=6,951.71..69,466,370.11 rows=968,688 width=30) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

XN Seq Scan on time_series_1547029253931 (cost=0.00..44.64 rows=4,464 width=8) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

XN Hash Join DS_BCAST_INNER (cost=10,888.11..10,678,577,168.62 rows=759,122,229 width=169) (actual rows= loops=)

7. 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=)

8. 0.000 0.000 ↓ 0.0

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

9. 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=)

10. 0.000 0.000 ↓ 0.0

XN Hash (cost=10,846.37..10,846.37 rows=7,569 width=45) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

XN Hash Join DS_DIST_ALL_NONE (cost=7,267.84..10,846.37 rows=7,569 width=45) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

XN Hash Join DS_DIST_ALL_NONE (cost=7,262.10..10,187.28 rows=25,674 width=45) (actual rows= loops=)

13. 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=)

14. 0.000 0.000 ↓ 0.0

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

15. 0.000 0.000 ↓ 0.0

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

16. 0.000 0.000 ↓ 0.0

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

17. 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=)

18. 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=)

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=)