explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jRGY

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

XN Hash Right Join DS_DIST_BOTH (cost=200,116,461.54..1,138,317,090,721,205.75 rows=83,225,509,348 width=214) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

XN Subquery Scan d1 (cost=11,173.64..10,419,124,182.02 rows=773,845,411 width=196) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

XN Hash Join DS_BCAST_INNER (cost=11,173.64..10,411,385,727.91 rows=773,845,411 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=11,132.43..11,132.43 rows=7,462 width=45) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

XN Hash Join DS_DIST_ALL_NONE (cost=7,262.13..11,132.43 rows=7,462 width=45) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

XN Hash Join DS_DIST_ALL_NONE (cost=7,256.39..10,481.99 rows=25,337 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.33..6,303.33 rows=381,215 width=58) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

XN Seq Scan on pdc_gpn_map (cost=0.00..6,303.33 rows=381,215 width=58) (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=183,366,359.26..183,366,359.26 rows=2,231,857,152 width=44) (actual rows= loops=)

16. 0.000 0.000 ↓ 0.0

XN Nested Loop DS_BCAST_INNER (cost=13,869.02..183,366,359.26 rows=2,231,857,152 width=44) (actual rows= loops=)

17. 0.000 0.000 ↓ 0.0

XN Nested Loop DS_BCAST_INNER (cost=6,951.71..69,602,298.91 rows=7,749,504 width=30) (actual rows= loops=)

18. 0.000 0.000 ↓ 0.0

XN Seq Scan on time_series_1546945143191 (cost=0.00..357.12 rows=35,712 width=8) (actual rows= loops=)

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

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

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

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